Hiring: Senior PostgreSQL DBA & Engineer
Location: 100% Remote (EST/CST time zones only)
Pay Rate: Up to $85/hour on C2C
Duration: 6-month Contract-to-Hire
Experience : 15 - 18 years
Eligibility : US Citizen only
Interview : Virtual Interview
Job Description :
Must Haves
5+ years of hands-on PostgreSQL development and database administration and engineering experience in enterprise-scale environments.
Strong expertise in database design and data modeling, including logical/physical modeling, schema design, normalization/denormalization, partitioning, and scalability.
Advanced SQL and PL/pgSQL development skills, including stored procedures, views, materialized views, CTEs, window functions, and query optimization.
Experience with performance tuning and troubleshooting, including indexing strategies (B-Tree, GIN, GiST, BRIN, Hash), VACUUM optimization, statistics management, and execution plan analysis.
Knowledge of high availability and disaster recovery, including replication, failover, backup/recovery, read replicas, and scaling strategies.
Experience building and supporting ETL/ELT pipelines, Kafka integrations, CDC, and real-time/batch data processing.
Proficiency in at least one programming language such as Python, Java, or Bash, with experience supporting APIs and microservices.
Hands-on experience with cloud database platforms such as AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL.
Strong understanding of data security and governance, including RBAC, encryption, auditing, PHI/PII protection, and compliance requirements.
Day-to-Day
Design, develop, and maintain enterprise PostgreSQL databases and scalable data models.
Write, optimize, and troubleshoot complex SQL and PL/pgSQL code to support business applications and reporting.
Monitor and tune database performance, resolve bottlenecks, and implement indexing and optimization strategies.
Manage database availability, replication, backups, recovery processes, and disaster recovery planning.
Build and support ETL/ELT pipelines and data integrations using Kafka, CDC, and other integration frameworks.
Collaborate with application development teams to support APIs, microservices, and cloud-native solutions.
Implement and maintain security controls, governance standards, and compliance requirements.
Support cloud database environments and infrastructure automation initiatives.
Partner with stakeholders to troubleshoot issues, improve data quality, and ensure reliable database operations.