Database Administrator Architect | Woodlawn, MD - Onsite | Contract W2 only
About The Position
The Database Administrator Architect supports a federal humanitarian program by ensuring the reliability, security, and performance of large-scale PostgreSQL environments that power mission-critical operations. The role is onsite in Woodlawn, Maryland, five days per week, Monday through Friday, under a 12-month W2 contract. The person hired must be able to obtain and maintain a Public Trust clearance. The role manages and optimizes PostgreSQL databases, designs scalable and secure database solutions, and integrates PostgreSQL with AWS services. It includes database monitoring and tuning, maintenance and patching, complex SQL work, backup and disaster recovery planning, high availability and failover, and compliance with federal security, privacy, and data-management policies. The architect also provides guidance and support to junior and mid-level developers and performs additional duties as assigned.
Requirements
- 10+ years of experience as a Database Administrator or Architect.
- A master's degree plus 5 years of experience, a bachelor's degree plus 7 years of experience, or 13+ years of experience in lieu of a degree.
- Ability to obtain and maintain a Public Trust clearance.
- Ability to work onsite in Woodlawn, Maryland, Monday through Friday.
- Experience with PostgreSQL database management, data modeling, normalization, and schema design.
- Advanced SQL skills for analysis, transformation, and reporting.
- Experience with backup, disaster recovery, high availability, and failover, including multi-AZ and read replicas.
- Experience with database architecture, configuration, installation, backup, and recovery.
- Experience with AWS RDS PostgreSQL or similar cloud PostgreSQL platforms.
- Experience with server patching and Splunk.
- Experience with AWS performance tuning, indexing, caching, and optimization.
- Experience integrating AWS services, including Lambda, S3, EC2, and Glue.
- Knowledge of IAM, encryption, CloudWatch, and CloudTrail.
Nice To Haves
- Leadership in requirements gathering, solution design, and implementation.
- Linux scripting for ETL automation and data migration.
- Experience with automated testing, TDD, CI/CD, and performance analysis.
- Architectural road-mapping and tactical planning skills.
- Federal or public-sector experience.
- Strong communication skills, including the ability to translate stakeholder needs.
- Ability to manage multiple priorities and deadlines.
- Detail-oriented, consistent, and error-free execution.
Responsibilities
- Manage, maintain, secure, monitor, and optimize PostgreSQL databases for high availability and performance.
- Perform database monitoring, health checks, and performance tuning.
- Oversee database installation, configuration, updates, and server patching.
- Write and optimize complex SQL queries for analysis, transformation, and reporting.
- Architect scalable, secure, high-performance database solutions.
- Integrate PostgreSQL with AWS services, including Lambda, S3, EC2, and Glue.
- Apply AWS security best practices, including IAM, encryption, VPC, and security groups.
- Design and implement backup, disaster recovery, high availability, and failover strategies, including multi-AZ and read replicas.
- Ensure compliance with federal security, privacy, and data-management policies.
- Provide guidance and support to junior and mid-level developers.
- Perform additional duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
