Database Admin Architect
About The Position
The Database Admin Architect manages, maintains, secures, monitors, and optimizes PostgreSQL databases to ensure high availability and performance. Responsibilities include database monitoring and health checks, backup and recovery management, and database installation, updates, and configuration. The role writes complex SQL queries for data analysis, transformation, and reporting, and optimizes queries, caching, clustering, and auto-scaling to handle workloads. The position architects scalable, high-performance, secure database solutions and integrates databases with AWS services such as Lambda, S3, EC2, and Glue. It applies AWS security best practices, including IAM, encryption, VPC, and security groups, and meets compliance requirements for data storage. The role designs backup, disaster recovery, high-availability, and failover solutions, including Multi-AZ and read replicas, and ensures compliance with SSA security, privacy, and data management policies. It 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.
- Ability to architect scalable, high-performance, and secure database solutions, with 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, MD, five days a 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 of and ability to apply quality techniques and practices, including automated unit testing, Test Driven Design/Development, performance analysis, and continuous integration.
- Ability to contribute 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 skills for working with cross-functional teams, including data scientists, analysts, and business stakeholders.
- Ability to translate technical concepts into non-technical terms for 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.
- Conduct 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 such as 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
