Summary
Responsibilities
- 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
- 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
- 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
- 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.