Database Admin Architect

Experience: 16+ Years Overall, Including 10+ Years in Database Administration/Architecture Clearance: Must be able to obtain and maintain Public Trust Clearance Candidate Requirement: Local Candidates Only, We are seeking an experienced Database Admin Architect to design, manage, secure, monitor, and optimize PostgreSQL databases. The ideal candidate will have extensive experience in database architecture, AWS cloud services, performance tuning, data modeling, and enterprise database administration., Manage, maintain, secure, monitor, and optimize PostgreSQL databases to ensure high availability and performance. Perform database installation, configuration, upgrades, health checks, backup, and recovery. Develop complex SQL queries for data analysis, transformation, and reporting. Design scalable, secure, and high-performance database architectures. Optimize queries, indexing, caching, clustering, and database performance. Design and implement disaster recovery, high availability, and failover solutions, including Multi-AZ and read replicas. Integrate databases with AWS services such as RDS, Lambda, S3, EC2, and Glue. Implement AWS security best practices, including IAM, encryption, VPC, and security groups. Monitor database performance, logs, and operational events using Splunk and AWS monitoring tools. Perform server patching and maintain secure database environments. Develop Linux scripts to automate ETL processes and data migration jobs. Provide technical guidance to junior and mid-level team members. Collaborate with cross-functional teams and communicate technical solutions to business stakeholders.

Strong hands-on experience with PostgreSQL database administration and architecture. Advanced SQL query development and performance optimization. Expertise in database modeling, normalization, and schema design. Experience with AWS RDS PostgreSQL or other cloud PostgreSQL platforms. Strong knowledge of database installation, configuration, backup, recovery, and disaster recovery. Experience with logical and physical data modeling. Hands-on experience with server patching and Splunk. Experience with AWS services, including Lambda, S3, EC2, Glue, CloudWatch, and CloudTrail. Knowledge of AWS security, IAM roles, encryption, and compliance requirements. Linux scripting experience for ETL automation and data migration. Strong troubleshooting, technical leadership, communication, and problem-solving skills. Prior federal or public-sector experience is preferred. Education and Experience Requirements: Master’s degree with 5+ years of experience, or Bachelor’s degree with 7+ years of experience, or 13+ years of experience in lieu of a degree. Candidates must also meet the stated overall experience requirements of 16+ years, including 10+ years in Database Administration/Architecture.