PostgreSQL Database Administrator with Security Clearance

A1C Partners

Ashburn, VA

Apply

JOB DETAILS

SKILLS

Access Control, Amazon Relational Database Service (RDS), Amazon Web Services (AWS), Analysis Skills, Architectural Services, Automation, Bash Scripting, Cloud Architecture, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Cryptography, Data Entry, Data Modeling, Data Partitioning, Database Administration, Database Analysis, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Replication, Database Technology, Detail Oriented, Government Regulations, Identify Issues, Information/Data Security (InfoSec), Mentoring, Multitasking, Network Support, Operations Management, Performance Management, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, Regulatory Compliance, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Security Clearance, Software Administration, Software Development, Source Code/Configuration Management (SCM), Systems Maintenance, Team Player, Top Secret Clearance, Training/Teaching

LOCATION

Ashburn, VA

POSTED

1 day ago

Functional Title – PostgreSQL Database Administrator
Location: Hybrid/Remote - Ashburn, VA
Clearance Level Must Be Able to Obtain: Public Trust
Onsite: Must be in Ashburn office twice a week.

JOB DESCRIPTION:
We are seeking a skilled PostgreSQL Database Administrator to join our team. The ideal candidate will specialize in PostgreSQL (RDS), bringing expertise in deployment, administration, query tuning, and database monitoring. This role requires a proactive professional capable of managing database operations, optimizing performance, and supporting application development teams. Responsibilities: • Database Administration: Configure and administer managed PostgreSQL instances in the AWS environment. Maintain database security policies, including role-based access control and data encryption. • Query Tuning and Optimization: Analyze and optimize SQL queries for performance improvement, particularly on large tables. Work with development teams to review and enhance database-related code. • Monitoring and Alerts: Set up and monitor Dynatrace alerts to ensure database reliability and availability. Investigate and resolve performance issues identified through monitoring tools or reported by users. • Automation and Deployment: Develop and implement database automation scripts for routine tasks such as deployments, scaling, and maintenance. Assist in Continuous Integration/Continuous Deployment (CI/CD) processes for database updates. • System Health and Troubleshooting: Proactively monitor database health and resolve capacity or connectivity issues. Conduct root-cause analysis for database incidents and implement preventive measures. • Database Design and Support: Provide input on data modeling and schema design for new and existing applications. Collaborate with developers and data engineers to ensure efficient data access patterns. • Documentation and Best Practices: Create and maintain detailed documentation of database environments, procedures, and standards. Enforce database best practices and policies. • Training and Guidance: Act as a technical mentor to junior team members. Provide training to application developers and other stakeholders on database-related topics. Qualifications:
Required Skills: • Extensive experience with PostgreSQL, including deployment, maintenance, and optimization. • Strong knowledge of database tuning, query optimization, and indexing strategies. • Experience with database monitoring tools, particularly Dynatrace or similar platforms. • Proficiency in scripting languages (e.g., Python, Bash) for database automation. • Understanding of cloud database architectures and services, such as AWS RDS. • Familiarity with CI/CD pipelines and database version control. • Excellent troubleshooting and problem-solving skills.
Preferred Skills: • Experience with Postgres GIS queries using the PostGIS addon. • Knowledge of ETL pipelines and data warehouse architecture. • Familiarity with analytics/modeling tools. • Exposure to data replication and sharding strategies. • Knowledge of government regulatory compliance standards.
Soft Skills: • Strong communication and collaboration skills for working with cross-functional teams. • Ability to manage multiple priorities in a fast-paced environment. • Attention to detail and a commitment to delivering high-quality results. EDUCATION AND EXPERIENCE: • Bachelors and five (5) years or more experience; Masters and three (3) years or more experience; PhD and 0 years related experience • Certifications such as AWS Certified Database - Specialty, PostgreSQL DBA Certification, or similar are a plus.
BI Requirement • Current holder of a DHS Public Trust clearance or the ability to obtain one. • Note: Employment will be contingent upon having/obtaining a DHS Public Trust clearance prior to starting. • TS clearance would expedite hiring process.

About the Company

A1C Partners

Resume Resources

Free Resume Templates Free Resume Builder