Postgres DBA

Job Title:

Job Location: NYC, NY Duration: 6+ Months

Key Responsibilities
Design, implement, and maintain PostgreSQL databases, including schema design, indexing strategies, query optimization, logical/physical replication, hot standby failover, and load balancing.
Develop and execute backup and recovery strategies, including pg_dump, pg_basebackup, WAL archiving, point-in-time recovery (PITR), and disaster recovery planning.
Monitor and optimize database performance, resource utilization, and storage growth using pg_stat_statements, EXPLAIN ANALYZE, pg_top, and PrometheGrafana dashboards; proactively troubleshoot performance bottlenecks.
Ensure database security through role-based access control (RBAC), audit logging with pgaudit, and compliance with regulatory standards.
Implement high availability (HA) and disaster recovery (DR) solutions using Patroni, streaming replication, synchronoasynchronous replication, and failover orchestration.
Plan and execute database version upgrades and apply security or performance patches with minimal downtime, ensuring data integrity and compatibility checks.
Collaborate with application teams, BI developers, and ETL engineers to support data pipelines, optimizing queries, and workflow performance.
Implement monitoring and alerting solutions using Prometheus, Grafana, Zabbix, or Nagios to track database health, query latency, and resource usage.
Manage database user accounts, roles, and privileges to enforce security policies and regulatory compliance, including sudo/OS-level permissions for critical operations.
Conduct capacity planning, workload forecasting, and index/partition tuning to handle anticipated growth and high-concurrency workloads.
Automate database maintenance tasks using Python, Bash, or Ansible scripts, including schema migrations, routine checks, and patch deployment.
Document procedures, configurations, operational runbooks, and PostgreSQL best practices for team knowledge sharing.
Mentor and guide team members on PostgreSQL internals, replication setups, and performance tuning techniques.
Evaluate and recommend new database tools, extensions (like TimescaleDB, pg_stat_statements), and best practices to improve efficiency, scalability, and resilience.

Education and Experience
Bachelor s degree in Computer Engineering, Electrical Engineering, Information Technology, or a related technical field.
4-7 years of experience in database administration and operations.
Experience participating in or leading incident response and postmortem analysis processes.
Previous exposure to hybrid environments integrating on-premise data centers with public or private cloud platforms is desirable.
Experienced PostgreSQL Database Administrator managing production and non-production PostgreSQL environments.
Skilled in backup and recovery, replication, performance tuning, and high availability.
Proven ability to troubleshoot critical issues, automate DBA tasks, and ensure database reliability.
Expertise
4+ years of hands-on PostgreSQL administration experience.
Strong SQL and PL/pgSQL expertise; experience with database optimization and indexing.
Hands-on experience with backup, recovery, and HA solutions.
Strong proficiency in Linux and Debian environments.
Proficiency in scripting for database automation.
Excellent analytical, problem-solving, and troubleshooting skills.
Strong communication skills for cross-team collaboration.
Understanding of Oracle and MySQL databases is a plus, but not mandatory.

About AgreeYa:
AgreeYa is a global systems integrator delivering a competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,800+ professionals across offices. AgreeYa works with 550+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public Sector, Pharma & Biotech, Retail, Client, and others.

Equal Opportunity:
AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics.