Database Administrator

Database Administrator Specialist Key Skills Required: PostgreSQL (Primary): Advanced DBA, performance tuning, upgrades, patching MongoDB: Platform ownership/support AWS: Aurora Postgres, RDS, cloud DB services Automation: Python/Bash, Ansible, Lambda, IaC (CloudFormation + Terraform) Migration: Legacy (brownfield) to Cloud (gold) Monitoring/Optimization: Performance, alerting, vulnerability remediation Role Expectations: Senior Tech Lead–level candidate 80% hands-on engineering / 20% leadership & design Lead DB engineering from ground up (not app-embedded DBA) Drive automation & self-service initiatives (Q2/Q3 focus) Jira (engineering work) + ServiceNow (ops/tickets) Team Info: Team size: 6 engineers Existing 1 Tech Lead (overloaded) need additional Tech Lead Team mostly in McLean; some presence in Plano On-Call: 24/7 support Rotation: 1 week/month Infra alerts, app team issues, major incident support Job Description: 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: Client is seeking an experienced Technical Lead with a strong background in PostgreSQL to join client 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 plus years of hands-on experience with PostgreSQL and MongoDB database systems, with at least 2 plus 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. 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. Note: *Please include the following at the top of each candidate resume Resumes without completed templates and/or vetting questions will not be considered. Responses to vetting questions are to be provided directly from the candidates. * Location: Plano, Texas or McLean, VA – Fully onsite TriOptus LLC