Current jobs related to PostgreSQl DBA - Chennai, Tamil Nadu - CMS Computers


  • Chennai, Tamil Nadu, India beBeeDatabase Full time ₹ 1,50,00,000 - ₹ 2,02,50,000

    We are seeking a skilled professional to assume the role of Freelance PostgreSQL Database Administrator.This is a remote, long-term contract position that requires expertise in database architecture, high availability, and optimization in enterprise environments.The ideal candidate will have a solid background in PostgreSQL, Cloud SQL (MySQL), and advanced...

  • Postgre DBA

    4 weeks ago


    Chennai, Tamil Nadu, India First Job Consulting Private Limited Full time

    Job DescriptionClient- ProdaptLocation- ChennaiExperience- 7+ yearsPosition: Postgres DBA with on prem and RDS/AWS instances administration experienceRole and responsibility:Postgres:- Knowledge on PostgreSQL Installation, configuration and troubleshooting replication tools- Troubleshoot issues involving Unix levels command- Fix issues related to Backup and...


  • Chennai, Tamil Nadu, India The Cophil Full time

    Senior PostgreSQL Database AdministratorLocation : Chennai, IndiaEmployment Type : Full-timeExperience Required : 7+ YearsJob Summary :We are seeking a highly skilled and experienced Senior PostgreSQL Database Administrator to join our dynamic team in Chennai. The ideal candidate will possess over 7 years of hands-on experience with PostgreSQL, demonstrating...


  • Chennai, Tamil Nadu, India Best Infosystems Ltd. Full time

    Cloud DB Engineer ( MYSQL DBA )_ Chennai_WFO (5 Day)_Shift: 24*7Role: MYSQL DBA - Lead Engineer (Cloud DB Engineer ( MYSQL DBA ))Location: ChennaiWork Experience: 15+ yearsMode: WFO (5 Day)Shift: 24*7Key Skills: MYSQL DBA, PostgreSQL, SQL Server, AWS RDS aurora.Job Description:Mandate Skill :- Strong technical expertise on SQL, NoSQL and databases like...


  • Chennai, Tamil Nadu, India Best Infosystems Ltd. Full time

    Cloud DB Engineer ( MYSQL DBA )_ Chennai_WFO (5 Day)_Shift: 24*7Role: MYSQL DBA - Lead Engineer (Cloud DB Engineer ( MYSQL DBA ))Location: ChennaiWork Experience: 15+ years Mode: WFO (5 Day)Shift: 24*7Key Skills: MYSQL DBA, PostgreSQL, SQL Server, AWS RDS aurora.Job Description:Mandate Skill : Strong technical expertise on SQL, NoSQL and databases like...

  • Dba

    4 weeks ago


    Chennai, Tamil Nadu, India Tanla Platforms Full time

    Job DescriptionKey Deliverables:1. Manage and maintain MySQL, PostgreSQL, MongoDB, and other database systems ensuring optimal performance and security.2. Develop scripts for data movement, archiving, purging, and backup/recovery strategies.3. Monitor database health using leading tools and perform tuning, replication, and access control.4. Provide support...

  • Progress DBA

    3 days ago


    Chennai, Tamil Nadu, India Bahwan Cybertek Group Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Description:Responsibilities:Database Administration:Manage and support Production, QA, and Development environments for PostgreSQL and Progress 4GL databases. Monitor and manage database backups and ensure proper data growth management. Refresh Dev, Test, and Preprod environments by syncing them with the Live environment. Tune database performance by...


  • Chennai, Tamil Nadu, India Vertus Enterprises Inc. dba CMIT Solutions, JCMCH Full time

    Company DescriptionVertus Solutions dba CMIT Solutions NYNJ (vertussolution.com) offers proactive and dependable technology and data solutions to businesses with 24/7 mission critical operations. Its comprehensive technology and security solutions enable clients to grow their business and protect from security threats, accidental damages and errors.Role...


  • Chennai, Tamil Nadu, India OptiSol Business Solutions Full time

    Role: DataOps Engineer – Database AdministrationLocation: Chennai/Madurai (Hybrid)Experience : 3–7 yearsWe are looking for a skilled and proactive DataOps Engineer with strong expertise in Database Administration (DBA) to join our team. The ideal candidate should have a solid understanding of modern data infrastructure, SQL Server internals, and...


  • Chennai, Tamil Nadu, India TransUnion Full time US$ 1,50,000 - US$ 2,00,000 per year

    TransUnion's Job Applicant Privacy NoticeWhat We'll Bring:We are seeking a Lead Database Engineer to join our DevOps organization. This role is ideal for a seasoned Oracle expert who thrives in complex, mature environments and is passionate about modernization and operational excellence. You will play a critical role in maintaining the health of our on-prem...

PostgreSQl DBA

4 weeks ago


Chennai, Tamil Nadu, India CMS Computers Full time
Job Description

Job Description

- Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQLdatabases.
- Develop SQL reports that meet client expectations for the application (used by custom application).
- Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
- Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
- Studied and stayed current on features and functionality of PostgreSQL.
- Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
- Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
- Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.
- Ability to proactively identify, troubleshoot and resolve live database systems issues.
- Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
- Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
- Ability to thrive in a fast-paced, deadline-sensitive environment.
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
- Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
- Experience in code migration, database change management through various stages of development life cycle.
- Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
- Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios / relevant tools
- Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
- Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
- Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
- Installing and Configuring PostgreSQL from source or packages on Linux machines.
- Experience designing database structures, indexes, views, partitioning.
- Implementing backup and recovery (Logical and Online).
- Setup and maintenance of postgreSql master-slave clusters utilizing streaming replication
- Cross-datacenter disaster recovery and backup architecture
- Performing schema management, database sizing, maintaining privileges.
- Data migration while upgrading database versions.
- Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
- Scheduled maintenance activities to vacuum, analyze to improve the query response time.
- Maintaining custom vacuum strategies at table and db level.