PostegreSQL Database Administrator

Job Title: Experienced PostgreSQL Database Administrator (DBA)

Location: DLF IT Park ,Chennai Office

Shift Timings - 1:30p.m to 10:30p.m

Work Mode - Work from Office

Responsibilities:

• Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.
• Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting.
• Deploy and maintain database infrastructure on both on-premises servers and AWS cloud platforms, utilizing best practices for scalability, reliability, and cost-efficiency.
• Collaborate with cross-functional teams to design, implement, and optimize database architectures to meet business requirements and performance goals.
• Implement and maintain disaster recovery solutions, including backup strategies, replication, and failover procedures, for both on-premises and AWS deployments.
• Automate routine DBA tasks and workflows using scripting languages.
• Ensure compliance with security policies, regulatory requirements, and industry best practices for database operations and data protection.
• Monitor and response to DB alerts from monitoring tools and command center team.
• Monitor database performance and capacity utilization, proactively identifying and resolving issues to maintain optimal performance and scalability.
• Provide trend analysis to executive management to help them taking informed decisions regarding resource management.
• Lead, monitor and provide guidance to junior DBA.
• Collaborate with cross-functional teams to ensure smooth integration of databases with other systems and applications.
• Perform database capacity planning and trend analysis.
• Apply changes to the database following strict procedures of Change management policies and protocol.

Must Have:

• Experience with PostgreSQL database, Enterprise Failover Manager (EFM), Postgres Enterprise Manager (PEM) and PGBACKREST on Linux servers.
• Proficiency in end-to-end architecture of PostgreSQL database, including database design, development, administrate of large-scale database, OLTP and analytical data structures (logical and physical design)
• Experience managing PostgreSQL databases in AWS RDS and/or EC2 environments.
• Proficiency in PostgreSQL troubleshooting, performance tuning, SQL Tuning, access management and security setup, health monitoring and maintenance, PL/PGSQL (triggers, functions, ….)
• Experience in designing, implementing, and monitoring disaster recovery (DR) solutions for PostgreSQL databases including Backup and restore, Point-in-Time-Recovery (PITR), on-site/offsite replication.
• Experience managing Amazon RDS implementation of PostgreSQL.
• Experience in database and data migration from on-premises to cloud.
• Experience in creating Linux shell scripts.

Nice To Have:

• Experience with Connection Management using options such as LDAP, Kerberos in PostgreSQL.
• Familiarity with managing version control and deployment processes, specifically within Amazon RDS and on-premises server environments.
• Experience with database automation and orchestration tools such as Jenkins and Ansible.
• Solid understanding of database security best practices and compliance standards.
• Provision, manage, deploy, monitor and benchmarking statistics in OpenShift environment.
• Experience with latest PG community contribution modules/projects.
• Experience with other database technologies (e.g., MySQL, Oracle, MongoDB).
• Familiarity with containerization technologies such as Docker and Kubernetes.
• Knowledge of DevOps practices and principles.

Preferred Qualification:

• Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
• Proven experience as a PostgreSQL Database Administrator, with at least 5-7 years of hands-on experience.
• Ability to work effectively in a fast-paced environment and manage multiple priorities.
• Excellent communication and collaboration skills, with a strong customer service orientation.
• PostgreSQL certification (e.g., Certified PostgreSQL Associate/Professional) is a plus.

If you're a skilled PostgreSQL DBA looking for an exciting opportunity to work with cutting-edge technologies and contribute to the success of a dynamic team, we'd love to hear from you. Apply now and join us on our journey to innovate and transform the world of technology.

You can share your resume with rohini.gadepalli@cbts.com mentioning

Current CTC

Expected CTC

Notice Period

Total / Relevant Exp