PostgreSQL DBA :: Onsite :: W2 Position

Job Title: Database Administrator Specialist

Duration: 10+ Months

Location: Plano, TX /McLean, VA (Onsite)

Interview: 1^st Virtual and 2^nd round In-person

Need local candidates.

Manager Notes:

Call Notes:     

• Responsible for management of cloud data base they use Postgres and MongoDB Looking for a
• Sr Candidate Tech lead level Team does Operational and engineering work.
• Upgrades, patching and ticketing platform.
• Team does have older environment and does migration from old to new.
• Legacy to cloud migration experience is helpful. Need to drive team key initiatives.
• Hands on data base engineering and technical leadership role.
• Familiar with automation on operational data base. Scripting infrastructure as code
• Should have experience performance, optimization, administration
• Automate operational database, alerting, monitoring, Infrastructure as code experience is added advantage
• Bash /python /ansible for automation scripting
• 80% hands-on 20% leadership

Job Description:

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.
• 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

PostgreSQL Technical Lead

Seeking a Technical Lead with Advanced PostgreSQL and MongoDB Expertise

Job 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:
• Design, implement, and optimize PostgreSQL and MongoDB databases for scalability, reliability, and performance.
• Apply advanced knowledge of PostgreSQL and MongoDB architecture, including query planning, indexing, partitioning, and replication.
• Establish and enforce best practices for database design, normalization, and data integrity.
• Deploy and manage PostgreSQL and MongoDB clusters, focusing on high availability, global databases, and disaster recovery strategies.
• Utilize AWS storage management and monitoring tools to ensure optimal database health and performance.
• Implement performance and cost optimization strategies within the environment.

Database Administration & Optimization:

• Monitor and tune database performance, including query optimization and resource allocation.
• Perform regular backup and recovery operations, ensuring data integrity and compliance with security standards.
• Oversee access management, security controls, and regulatory compliance for all database systems.

Migration Planning and Execution:

• Lead end-to-end database migration projects, including planning, execution, and post-migration validation.
• Ensure data integrity verification and minimal downtime during migration processes.

Technical Leadership:

• Mentor and guide junior database engineers and developers.
• Collaborate with cross-functional teams to align database strategies with business objectives.
• 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.
• 8+ years of hands-on experience with PostgreSQL and MongoDB database systems, with at least 2+ 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 (e.g., Lambda, EC2, S3) and their integration with database platforms.
• Experience implementing database automation and infrastructure as code practices.