Database Admin Architect
About The Position
The Database Admin Architect manages, maintains, secures, monitors, and optimizes PostgreSQL databases to ensure high availability and performance. The role includes database health monitoring, backup and recovery, installation, updates, configuration, and writing complex SQL for data analysis, transformation, and reporting. It also involves query optimization, caching, clustering, and auto-scaling to manage workloads. The architect designs scalable, high-performance, secure database solutions and integrates databases with AWS services such as Lambda, S3, EC2, and Glue. Responsibilities include applying AWS security practices and compliance requirements, designing backup, disaster recovery, high availability, and failover solutions, and ensuring compliance with SSA security, privacy, and data management policies. The position also provides guidance and support to junior- and mid-level developers and performs other duties as assigned or directed. This is a 100% onsite position in Woodlawn, Maryland, five days per week. The selected candidate must be able to obtain and maintain a public trust clearance.
Requirements
- Master's degree and 5+ years of experience, bachelor's degree and 7+ years of experience, or 13+ years of experience in lieu of a degree.
- 10+ years of experience as a Database Administrator/Architect.
- Skilled in PostgreSQL database management, data modeling, normalization, and schema design.
- Advanced skills writing complex SQL queries for data analysis, transformation, and reporting.
- Skilled in designing backup, disaster recovery, high availability, and failover solutions, including Multi-AZ and read replicas.
- Strong experience with database architecture, configuration, installation, backup, and recovery.
- Experience with AWS RDS PostgreSQL or other cloud PostgreSQL platforms.
- Strong experience with logical and physical data modeling.
- Experience with server patching.
- Experience with Splunk.
- Proven ability to architect scalable, high-performance, and secure database solutions.
- Proficiency in query optimization, indexing, caching, and performance tuning using AWS tools.
- Experience integrating databases with AWS services such as Lambda, S3, EC2, and Glue.
- Ability to secure AWS clusters, manage IAM roles, implement encryption, and monitor jobs using AWS tools such as CloudWatch and CloudTrail.
- Must be able to obtain and maintain a public trust clearance.
- Must be willing to work onsite in Woodlawn, Maryland, five days per week.
Nice To Haves
- Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
- Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
- Understanding and application of quality techniques and practices, including automated unit testing, Test Driven Design/Development, performance analysis, and continuous integration.
- Ability to contribute to architectural tactical thinking, information solutions, and road maps to drive architectural recommendations.
- Detail-oriented approach and commitment to completing repetitive production-like tasks on time and without errors.
- Prior experience working in a federal agency or public sector environment.
- Effective communication with cross-functional teams, including data scientists, analysts, and business stakeholders.
- Ability to explain technical concepts in non-technical terms to business stakeholders.
- Ability to manage multiple projects, prioritize tasks, and deliver within deadlines.
Responsibilities
- Manage, maintain, secure, monitor, and optimize PostgreSQL databases for high availability and performance.
- Perform database monitoring and health checks.
- Manage database backup and recovery.
- Install, update, and configure databases.
- Write complex SQL queries for data analysis, transformation, and reporting.
- Optimize queries and manage caching, clustering, and auto-scaling to handle workloads.
- Architect scalable, high-performance, and secure database solutions.
- Integrate databases with AWS services, including Lambda, S3, EC2, and Glue.
- Apply AWS security best practices, including IAM, encryption, VPC, and security groups, and meet data-storage compliance requirements.
- Design backup, disaster recovery, high availability, and failover solutions, including Multi-AZ and read replicas.
- Ensure compliance with SSA security, privacy, and data management policies.
- Provide guidance and support to junior- and mid-level developers.
- Perform other duties as assigned or directed.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
