Postgres Database Administrator Specialist

Title : PostgreSQL Technical Lead

Location : Plano, Texas or McLean, VA – Fully onsite

Assignment Type : months possible extension

About :

• Can design, develop, implement and maintain database systems to support business needs
• Experience in : -Database creation and maintenance -Database testing -Problem resolution Management of database integration activities.
• Expertise as database engineer / administrator for any of the relational database management systems : MongoDB and PostgreSQL

Must Have Qualifications :

Must have strong PostgreSQL expertise, including advanced database administration with some exposure to MongoDB. The ideal candidate has prior tech lead experience and hands on AWS / Cloud database experience.

Summary :

We are seeking an experienced Technical Lead with a strong background in PostgreSQL to join our dynamic team. The ideal candidate will possess expertise in database architecture, design, development, and optimization, as well as hands-on experience with cloud-native database solutions. This role is responsible for leading technical initiatives, ensuring optimal database performance, and guiding migration strategies across complex environments. The position requires a deep understanding of PostgreSQL and MongoDB systems, AWS ecosystem automation tools, and best practices for high availability, security, and compliance.

Key Responsibilities

• PostgreSQL and MongoDB Architecture & Best Practices : o Design, implement, and optimize PostgreSQL and MongoDB databases for scalability, reliability, and performance.

o Apply advanced knowledge of PostgreSQL and MongoDB architecture, including query planning, indexing, partitioning, and replication.

o Establish and enforce best practices for database design, normalization, and data integrity.

o Deploy and manage PostgreSQL and MongoDB clusters, focusing on high availability, global databases, and disaster recovery strategies.

o Utilize AWS storage management and monitoring tools to ensure optimal database health and performance.

o Implement performance and cost optimization strategies within the environment.

• Database Administration & Optimization :

o Monitor and tune database performance, including query optimization and resource allocation.

o Perform regular backup and recovery operations, ensuring data integrity and compliance with security standards.

o Oversee access management, security controls, and regulatory compliance for all database systems.

• Migration Planning and Execution :

o Lead end-to-end database migration projects, including planning, execution, and post-migration validation.

o Ensure data integrity verification and minimal downtime during migration processes.

• Technical Leadership :

o Mentor and guide junior database engineers and developers.

o Collaborate with cross-functional teams to align database strategies with business objectives.

o Document technical solutions, operational procedures, and best practices for ongoing reference.

Required Skills and Experience

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• years of hands-on experience with PostgreSQL and MongoDB database systems, with at least + years in a technical leadership capacity.
• In-depth understanding of PostgreSQL and MongoDB architecture, including query optimization, indexing, and partitioning.
• Proven experience designing, developing, and optimizing databases for high performance and reliability.
• Extensive experience with AWS including management, monitoring, high availability, and global databases.
• Familiarity with AWS automation tools such as CloudFormation and Terraform for infrastructure management.
• Strong troubleshooting and problem-solving skills in database environments.
• Demonstrated experience with database administration : performance monitoring, backup / recovery, tuning, query optimization, data integrity, security, compliance, and access management. • Successful track record of planning and executing database migrations

Preferred Qualifications

• Professional certifications in PostgreSQL, MongoDB, or AWS.
• Experience migrating databases from legacy systems to cloud-native solutions.
• Knowledge of additional AWS services (, Lambda, EC, S) and their integration with database platforms.
• Experience implementing database automation and infrastructure as code practices.

EEO :