Postgres Database Administrator

1 month ago


Mumbai, India Zycus Full time

Global Delivery- Mumbai***

**About Us**
Zycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P software with the revolutionary Merlin AI Suite. Merlin AI takes over the tactical tasks and empowers procurement and AP officers to focus on strategic projects; offers data-driven actionable insights for quicker and smarter decisions, and its conversational AI offers a B2C type user-experience to the end-users.

Zycus helps enterprises drive real savings, reduce risks, and boost compliance, and its seamless, intuitive, and easy-to-use user interface ensures high adoption and value across the organization.

Start your #CognitiveProcurement journey with us, as you are #MeantforMore
- Zycus is looking out for
- **Database Administrator** having expertise in
- **PostgreSQL Database solutions** including, database installation, configuration, performance tuning, troubleshooting, and backups, monitoring and enhancements.
- **Responsibilities**:

- The DBA will be responsible for handling operational tasks including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases along with other DBMS technology stack.
- Architect and enhance the setup for different workloads to optimal performance.
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime.
- Problem analysis and solution implementation
- Undertake database upgrades, migrations and other administrative projects.
- Responsible for database performance review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Responsible for regular backups and recovery of databases.
- Responsible for regular maintenance of databases and proactive remediation of database operational problems.
- Responsible for Query tuning and preventative maintenance.
- Undergo cross training for other DBMS implementations.

**Job Requirement**

**Requirements**:

- 3-5 years of relevant experience in PostgreSQL required
- Experience as DBA in high-load, large-sized production DB
- Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
- Must have knowledge of AWS Cloud
- Good Knowledge of pg-badger and other report analysis
- Experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster).
- Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks
- Should be able to work and lead projects to closure, independently
- Must have strong knowledge of Linux operating systems
- Strong understanding of command line and server administration.
- Knowledge of shell scripting (e.g., Bash, Perl).
- Experience in Performance tuning
- Excellent communication and presentation skills with the ability to communicate at all levels of the organization.
- Exceptional problem-solving skills
- Keen to learn new technology with enthusiasm and analytical thinking
- Ability to work within a team environment. Self-starter and ability to perform work with mínimal supervisory direction
- Excellent analytical and communication skills
- Familiar with ITIL process of change management and incident management process.
- Experience with Unix/Linux including basic commands and basic shell scripting.
- Open to work on other DBMS technologies and up-skill respectively.

**Why You Should Join Zycus?**
- **Cloud Product Company**: We are a Cloud SaaS Company and our products are created by using the latest technologies like ML and AI. Our UI is in Angular JS and we are developing our mobile apps using React.
- **A Market Leader**: Zycus is recognized by Gartner (world’s leading market research analyst) as a Leader in Procurement Software Suites.
- **Move between Roles**: We believe that change leads to growth and therefore we allow our employees to shift careers and move to different roles and functions within the organization
- **Get a Global Exposure**: You get to work and deal with our global customers.
- **Create an Impact**: Zycus gives you the environment to create an impact on the product and transform your ideas into reality. Even our junior engineers get the opportunity to work on different product features.

**About Us**
- Zycus is a pioneer in Cognitive Procurement software and has



  • Mumbai, India LRN Corporation Full time

    **Position**: AWS Postgres Database Administrator **Location: Mumbai - India** **About LRN** Do you want to use your engineering expertise to help people around the world do the right thing? Join us at LRN to be a part of a global company where you can make an impact. LRN is a SaaS based e-Learning provider with a presence across US, EMEA, APAC and...


  • Mumbai, India Taggd Full time

    Database Administrator Exp req : 4+ Years Location : Mumbai, Andheri East Skills : DBA Admin with Mysql and MongoDB or MySql wirh Postgres or Casendra Notice : Max 30 days **Salary**: Up to ₹2,000,000.00 per year Schedule: - Day shift


  • Mumbai, India SS Consultancy Pvt Ltd Full time

    **Position**: PostGres SQL DBA **Qualification**: B. Tech / B. E in CS/IT/EE or MCA; with 4 years of IT experience & certifications like OCA- DBA/OCPDBA/MCDBA Location 1. Experience in administering production databases on ongoing basis to ensure smooth functioning 2. Should have worked on **PostGres** and least 1 more database namely **Oracle 9i, 10g,...


  • Mumbai, India Change Leader Full time

    **JOB DESCRIPTION** **OpenSource Database Administrator / OpenSource Database Administrator SME** **Experience:8- 15 y **rs **Locations**:Mumbai **Primary Skills**: **Postgres SQL 10, 11, 13, 14.** **MYSQL 5.5, 5.6, 5.7 ,8** **Mongo DB 3, 4, 6** 8+ years of experience as a OpenSource DBA or similar role **Position Responsibilities** Sr. Key...


  • Mumbai, India IBM Full time

    **Introduction** At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's...


  • Mumbai, India Change Leader Full time

    **JOB DESCRIPTION** **OpenSource Database Administrator OR DBA (SME)** **Experience**:8- 15 yrs **Location**:Mumbai **Primary Skills**: - Postgres SQL 10, 11, 13, 14. - MYSQL 5.5, 5.6, 5.7 ,8 - Mongo DB 3, 4, 6 - **8+ years **of experience as a OpenSource DBA or similar role - Certification in one or more DB systems. **Desired Skills &...


  • Mumbai, India Smart Work Consultants Full time

    **Role**:Database Administrator** **Location**: Andheri, Mumbai 1. Analyze and Recommend Database Improvements. 2. Analyze impact of Database Changes to the Business 3. Backup and Restore Data, comfortable working with production servers 4. Understanding of popular Database Management Software (SQL) 5. Work Closely with Development Teams with Regards...


  • Mumbai, India Prashmo Infotech Solutions Full time

    Database Administrator **Work mode : work from office** **Location - Mumbai** **Experience : 1-3 years** **Type: Permanent Position** **Education**:B.E(Any stream) / B.Tech **Role**:Database Administrator** 1. Analyze and Recommend Database Improvements. 2. Analyze impact of Database Changes to the Business 3. Backup and Restore Data, comfortable...


  • Mumbai, India EDB Full time

    A Little About UsInnovative, collaborative minds wanted. The world loves Postgres. We envision a world where organizations thrive by harnessing the full power of Postgres, the world’s fastest growing and most loved and used open source database. Our mission is to enable data teams everywhere to harness the full power of Postgres, whether on premises or in...


  • Mumbai, Maharashtra, India NTT Full time

    NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future.In today's 'iNTTerconnected' world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our clients solve some of...


  • Mumbai, India Technology Next Full time

    **Database Administrator** **Experience **:5 years **Job Type **:Remote/ Full-time The DB Expert will be responsible for investigating performance issues on customer databases and devising solutions, refactoring SQL code to improve performance, and reviewing proposed SQL schema and code changes. **Responsibilities**: - Administering databases hosted on...


  • Mumbai, India Atlas Corp Full time

    The Atlas Corp. and Seaspan teams are goal-driven and share a high-performance culture, focusing on building services offerings to become a leading asset manager. Seaspan provides many of the world's major shipping lines with alternatives to vessel ownership by offering long-term leases on large, modern containerships combined with industry leading ship...


  • mumbai, India BDO in India Full time

    Requirements5+ years of experience in open-source database administration and maintenance.Experienced in database installation and Configuration.Experience in Managing database schema, disk space, storage, user roles.Strong knowledge of DBMS Concept.Good knowledge of relation database, specifically PostgreSQL, PL/SQL.Proficiency in Database Design,...


  • Mumbai, India Atlas Corp Full time

    The Atlas Corp. and Seaspan teams are goal-driven and share a high-performance culture, focusing on building services offerings to become a leading asset manager. Seaspan provides many of the world's major shipping lines with alternatives to vessel ownership by offering long-term leases on large, modern containerships combined with industry leading ship...


  • mumbai, India Atlas Corp Full time

    The Atlas Corp. and Seaspan teams are goal-driven and share a high-performance culture, focusing on building services offerings to become a leading asset manager. Seaspan provides many of the world's major shipping lines with alternatives to vessel ownership by offering long-term leases on large, modern containerships combined with industry leading ship...


  • Mumbai, India Corphive Full time

    Key Accountabilities DB Administration for Postgres Database Domain, and maintain higher uptime &manage Oracle, MS SQL and other Databases with respective support team. Manage BAU activities like backup, capacity management, DB PerformanceTuning etc. and project activities like installation, migration etc. Manage of vendors (onsite/Offshore) infra...


  • Mumbai, India Corphive Full time

    Key Accountabilities DB Administration for Postgres Database Domain, and maintain higher uptime &manage Oracle, MS SQL and other Databases with respective support team. Manage BAU activities like backup, capacity management, DB PerformanceTuning etc. and project activities like installation, migration etc. Manage of vendors (onsite/Offshore) infra...


  • mumbai, India Corphive Full time

    Key Accountabilities  DB Administration for Postgres Database Domain, and maintain higher uptime & manage Oracle, MS SQL and other Databases with respective support team.  Manage BAU activities like backup, capacity management, DB Performance Tuning etc. and project activities like installation, migration etc.  Manage of vendors (onsite/Offshore)...


  • Mumbai, Maharashtra, India NTT Full time

    NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our clients solve...


  • Mumbai, India IDFC FIRST Bank Full time

    Job Description Job Title - Database Administrator Place of work - Mumbai **Business**: Information Technology **Function/ Department**: Information Technology **Job Purpose**: Operate & maintain database administration tasks including performance tuning, troubleshooting and resolving database issues. **Roles & Responsibilities**: 10+ years of hands-on...