Postgre SQL DBA

PostgreSQL DBA

Key Responsibilities

• Administer, monitor, and support PostgreSQL databases across development, testing, and production environments.
• Perform database installation, configuration, upgrades, patching, backup, recovery, and disaster recovery planning.
• Troubleshoot performance issues, optimize queries, indexing, and execution plans.
• Manage PostgreSQL databases in Linux environments using command-line tools.
• Implement and support replication, high availability, and disaster recovery solutions.
• Support database migrations, modernization initiatives, and cloud adoption projects.
• Develop and maintain SQL, Bash, or Python scripts for automation and database administration.
• Collaborate with Development, Infrastructure, and DevOps teams on deployments, releases, and performance improvements.
• Monitor database health, capacity, security, and operational compliance.

Required Skills & Experience

• 8+ years of experience in Database Administration and SQL Development.
• Strong hands-on experience with

  PostgreSQL Administration

  in Linux environments.
• Good understanding of

  SQL Server Administration

  and database migration projects.
• Expertise in performance tuning, query optimization, indexing, backup/recovery, and troubleshooting.
• Experience with PostgreSQL replication, HA/DR solutions, and production support.
• Proficiency in SQL, stored procedures, functions, views, and triggers.
• Experience with AWS RDS, Aurora PostgreSQL, or other cloud-managed database platforms.
• Hands-on experience with Bash, Python, or automation scripting.

Preferred Skills

• Experience with SQL Server to PostgreSQL migrations.
• Exposure to CI/CD, database deployment tools, and version control systems.
• Familiarity with Flyway, Liquibase, Alembic, or similar migration tools.
• Experience in AWS, Azure, or GCP environments.

Ideal Candidate Profile

• Strong

  PostgreSQL + Linux

  foundation with extensive command-line experience.
• Blend of DBA operations and database development expertise.
• Experience supporting mission-critical production environments.
• Strong troubleshooting, analytical, and problem-solving skills.
• Ability to work independently and collaborate across teams.

Interested Candidates can share their resumes to ekta.srivastava@programmers.ai