Postgres DBA - India - Cartney

Description

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 6+ years of experience working as a PostgreSQL Database Administrator or similar role in a production environment.
• Proficiency in PostgreSQL database administration, including installation, configuration, and performance tuning.
• Strong SQL skills and experience with database performance optimization techniques.
• Familiarity with database security principles and best practices.
• Experience with database backup and recovery solutions, such as pg_dump and PITR (Point-in-Time Recovery).

Responsibilities:

• Install, configure, and maintain PostgreSQL database software and related tools.
• Monitor and optimize database performance, including query tuning, indexing, and resource utilization.
• Implement and enforce database security policies and procedures to protect data integrity and confidentiality.
• Develop and maintain backup and recovery strategies to minimize downtime and data loss.
• Troubleshoot database issues and coordinate resolution with internal teams and external vendors as needed.
• Collaborate with software developers to design efficient database schemas and optimize SQL queries.
• Perform routine database maintenance tasks, such as software upgrades, patching, and system health checks.