What are the responsibilities and job description for the Immediate opening: Lead Database Administrator (Lead DBA) – PostgreSQL & AWS Cloud position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Montek System, is seeking the following. Apply via Dice today!
Job Title: Lead Database Administrator (Lead DBA) – PostgreSQL & AWS Cloud
Plano, TX (4 days a week) Immediate opening
Long Term Contract
Job Summary
We are seeking an experienced Lead DBA with strong expertise in PostgreSQL (including EDB) and AWS cloud platforms. The ideal candidate will lead database architecture, administration, performance optimization, and cloud migration initiatives across hybrid environments (on-premises and AWS). This role requires deep technical skills, leadership capabilities, and a proactive approach to reliability, security, and cost optimization.
Key Responsibilities
Leadership & Strategy
Job Title: Lead Database Administrator (Lead DBA) – PostgreSQL & AWS Cloud
Plano, TX (4 days a week) Immediate opening
Long Term Contract
Job Summary
We are seeking an experienced Lead DBA with strong expertise in PostgreSQL (including EDB) and AWS cloud platforms. The ideal candidate will lead database architecture, administration, performance optimization, and cloud migration initiatives across hybrid environments (on-premises and AWS). This role requires deep technical skills, leadership capabilities, and a proactive approach to reliability, security, and cost optimization.
Key Responsibilities
Leadership & Strategy
- Lead and mentor a team of DBAs, providing technical guidance and best practices.
- Define database standards, governance, and operational procedures.
- Collaborate with application, DevOps, and cloud teams to align database strategies with business goals.
- Drive continuous improvement in database performance, scalability, and reliability.
- Manage and support PostgreSQL databases across on-premises (EDB) and AWS environments.
- Perform database provisioning, configuration, patching, upgrades, and decommissioning.
- Ensure high availability using replication, clustering, and failover mechanisms.
- Implement backup and recovery strategies, including disaster recovery planning and testing.
- Administer and optimize Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL environments.
- Design and manage cloud-native database architectures for scalability and resilience.
- Monitor database performance using AWS-native tools and third-party solutions.
- Automate deployments and operations using Infrastructure as Code (IaC) tools.
- Work with AWS Services like RDS Global Cluster, EC2, S3, VPC, IAM, KMS, etc.
- Analyze and tune database performance.
- Implement proactive monitoring and alerting mechanisms.
- Identify bottlenecks and recommend improvements for high-throughput systems.
- Optimize AWS database costs.
- Monitor usage patterns and recommend cost-saving strategies without compromising performance.
- Implement automation to reduce manual overhead and operational expenses.
- Enforce database security best practices, including access control, encryption, and auditing.
- Ensure compliance with organizational and regulatory standards.
- Manage roles, privileges, and data protection strategies.
- Plan and execute migrations from on-premises PostgreSQL (EDB) to AWS (RDS/Aurora).
- Support heterogeneous and homogeneous migration strategies.
- Validate data integrity and performance post-migration.
- 12 years of experience as a DBA, with at least 5 years in a lead role.
- Strong expertise in PostgreSQL and EDB Postgres Advanced Server.
- Hands-on experience with:
- Amazon RDS for PostgreSQL
- Amazon Aurora PostgreSQL
- EC2, S3, VPC, Lambda
- Deep understanding of:
- High availability (replication, failover)
- Backup & recovery strategies
- Performance tuning and query optimization
- Experience with automation/scripting (Shell, Python, or similar).
- Knowledge of Infrastructure as Code tools (Terraform preferred, CloudFormation).
- Strong understanding of database security and compliance.
- AWS certifications (e.g., AWS Certified Solutions Architect, Database Specialty).
- Experience with monitoring tools (CloudWatch, Datadog, etc.).
- Familiarity with DevOps practices and CI/CD pipelines.
- Experience handling large-scale, mission-critical production environments.
- Strong leadership and team management abilities.
- Excellent problem-solving and analytical skills.
- Effective communication with both technical and non-technical stakeholders.
- Ability to manage multiple priorities in a fast-paced environment.