PostgreSQL DBA

TATA Consulting Services • Framingham, MA

27d • $90,000 - $120,000

About The Position

Extensive hands-on experience with PostgreSQL (v11 and above). Database installation, configuration, and upgrades on Linux/Unix platforms. High Availability (HA) setup using streaming replication, Patroni, repmgr, etc. Backup and recovery strategies using tools like pgBackRest, Barman. Performance tuning and query optimization. Strong knowledge of PL/pgSQL scripting and automation. Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana). Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit). Disaster Recovery planning and execution. Capacity planning and data growth forecasting. Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL). Good communication skills with both technical and management teams.

Requirements

• Extensive hands-on experience with PostgreSQL (v11 and above).
• Database installation, configuration, and upgrades on Linux/Unix platforms.
• High Availability (HA) setup using streaming replication, Patroni, repmgr, etc.
• Backup and recovery strategies using tools like pgBackRest, Barman.
• Performance tuning and query optimization.
• Strong knowledge of PL/pgSQL scripting and automation.
• Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana).
• Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit).
• Disaster Recovery planning and execution.
• Capacity planning and data growth forecasting.
• Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL).
• Good communication skills with both technical and management teams.

Nice To Haves

• Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB).
• Experience with Kubernetes & PostgreSQL operators (e.g., Zalando, Crunchy).
• Knowledge of Infrastructure as Code (Terraform, Ansible).
• Experience with CI/CD pipelines for database changes
• Experience with Databases (Oracle, DB2 & SQL server).
• Exposure to PostgreSQL clustering and sharding.
• Understanding of logical replication and change data capture (CDC).
• Knowledge of network monitoring and tools
• Excellent stakeholder management and cross-functional collaboration
• Certifications (Optional but Preferred): AWS Certified Database - Specialty

Responsibilities

• Database Architecture & Design: Design and maintain complex PostgreSQL database schemas.
• Performance Tuning & Optimization: Advanced query tuning and index optimization. Analyze and resolve slow queries using EXPLAIN, ANALYZE, and pg_stat views.
• Backup and Recovery: Implement and manage high-availability backup strategies. Test and document disaster recovery procedures.
• Replication and High Availability: Set up and maintain replication (physical/logical). Experience with HA tools like Patroni, repmgr, or Pgpool-II.
• Security Management: Implement role-based access controls, SSL/TLS, and audit logging. Monitor for vulnerabilities and apply patches.
• Monitoring & Maintenance: Perform routine health checks and maintenance tasks (VACUUM, REINDEX, ANALYZE).
• Upgrades & Migrations: Plan and execute PostgreSQL version upgrades with minimal downtime. Experience migrating from on-prem to cloud (AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP).

Benefits

• Disc retionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Ma ternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commute r Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees