Senior Database Administrator (PostGres
Location
Springfield, VA | United States
Job description
Senior Database Administrator (PostGres)
Onsite | Springfield, VA | 5 Days a Week
Active TS/SCI Clearance Required
Summary
Our client has been a leading enterprise Content Services Platform (CSP) to Federal, Civilian and DoD agencies since 1995. Furthermore, Knowvation® (formerly ArchivalWare™), their CSP application, has been in production since 2003. They are best known for providing knowledge management, geospatial, and declassification solutions. They also help with digitization, system integration, application installation/configuration, content loading/organization, training, staff augmentation, and ongoing support services.
Responsibilities
Our client is looking for a Senior Database Administrator to join their team! The DBA will have advanced knowledge of relational database design, Postgres features and utilities, strong tuning and optimization skills, exceptional communication skills, and the ability to manage multiple development and production database environments.
- Designing, planning, implementing, testing, and administering multiple databases, including security, access, and documentation
- Manage and administer complex information technology systems to ensure system design and operation meets business needs
- Provides guidance and experience on a project or program, serves as a team leader, and performs analysis of issues and risks
- Perform daily administrative tasks, including backup/recovery, performance optimization, space management, DB health, monitoring event logs, and troubleshooting to maintain multiple databases in support of client needs
- Proactively monitor database performance and troubleshoot issues
- Work cross-functionally with our engineers, developers, and user base to optimize queries, fix performance bottlenecks, improve existing schemas, and design new ones
- Create and maintain change control and testing processes
- Conduct research and make recommendations on products, services, protocols, and standards, planning for future growth of our data assets
- Writing automation to provision and manage PostgreSQL on Kubernetes
- Create and maintain SQL scripts for data extraction, migration, and maintenance
- Review development and deployment processes related to databases and identify areas of improvement
- Create and maintain documentation, troubleshooting playbooks, testing failover and recovery plans
Requirements
- 5+ years and bachelor’s degree in computer science, Engineering, or a related technical discipline, or the equivalent combination of education, technical certifications or training, or work/military experience
- PostgreSQL DBA experience (or other similar database administration experience)
- Exceptional SQL development and performance tuning skills
- Expertise with Postgres system metrics and optimization strategies
- Familiarity with system level metrics and practical use of common Linux utilities
- Master of one of the following scripting languages: Python, Perl, Bash
- Exceptional communication skills to interact with not only the customer, but the development and operations teams
Preferred Requirements
- Certified Oracle DB, MySQL and/or SQL
- Proficient in Linux, to include installation and daily use as a development environment.
- Experience with Linux and Git
Education/Certification Requirements
- A Bachelor's degree in computer science, Engineering, or a related technical discipline, or the equivalent combination of education, technical certifications or training, or work/military experience is required
Clearance Requirements
- Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; an active TS/SCI clearance is required.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
--------------
About Us
Northern Virginia-based Precision Solutions is an expert in staffing solutions for companies of any size that open the door to new opportunities and seek outstanding talent. We pride ourselves on being versatile enough to tailor our relationships to the needs of each individual client, being agile in the fast-paced marketplace, and being precise in meeting the needs of any company.
Equal Opportunity Employer Statement
Precision Solutions is an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
Job tags
Salary
