Senior PostgreSQL DBA/Database Architect

Title: Senior PostgreSQL DBA/Database Architect
Location: Woodlawn, MD (5 days per week onsite)
Will need to obtain Public Trust.
Duration: 2 Years
MOI: Video then Onsite
VISA: USC GC
End Client: Leidos/SSA

---------------------------JOB DESCRIPTION---------------------------

ABOUT THE ROLE:
Need a hands-on Senior PostgreSQL DBA/Database Architect with strong AWS RDS experience who has personally owned production PostgreSQL environments, including performance tuning, complex SQL, HA/DR, backup/recovery, data modeling, monitoring and patching. PostgreSQL + AWS RDS are the two skills I don't want you compromising on.
Description:
Key Required Skills: Experience with PostgreSQL, SQL, Database management, Data Modelling, Data Analysis, Splunk and Server Patching

Position Description:
• Managing, maintaining, securing, monitoring and optimizing PostgreSQL databases to ensure high availability and performance.
• Database monitoring and health check
• Backup and recovery management
• Database installation, updates and configuration
• Write complex SQL queries for data analysis, transformation, and reporting.
• Optimize queries, manage caching, clustering, and leveraging auto-scaling to handle workloads.
• Architect scalable, high-performance, and secure database solutions.
• Integrate databases with other AWS services such as Lambda, S3, EC2, and Glue.
• Utilize AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.
• Design backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).
• Ensure compliance with SSA security, privacy, and data management policies.
• Provide guidance/support to other junior/mid-level developers.
• All other duties as assigned or directed.

Detailed Skills Requirements Foundation for Success (Basic Qualifications)
• 10+ years as a Database Admin/Architect
• Factors To Help You Shine (Required Skills)?
• Selected candidate must be able to obtain and maintain a public trust clearance
• Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week
• Master's and 5+ years of experience, Bachelor's and 7+ years of experience or 13+ years in lieu of a degree
• Skilled in PostgreSQL database management, data modeling, normalization, and schema design.
• Advanced skills in writing complex SQL queries for data analysis, transformation, and reporting.
• Skilled in designing backup, disaster recovery, high availability, and failover solutions (Multi-AZ, 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 modelling
• Experience with Server patching
• Experience with Splunk
• AWS Experience:
• Proven ability to architect scalable, high-performance, and secure database solutions, with proficiency in query optimization, indexing, caching, and performance tuning using AWS tools.
• Experienced in integrating databases with other AWS services such as Lambda, S3, EC2, and Glue.
• Adept at securing AWS clusters, managing IAM roles, implementing encryption, and monitoring jobs using AWS tools (CloudWatch, CloudTrail).

How To Stand Out From The Crowd (Desired Skills)?
• 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.
• Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)
• Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
• Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
• 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.