Database Administrator

Koniag Government Services, LLC•Mechanicsburg, PA

2d•$110,000 - $125,000

About The Position

Koniag Tech and Infrastructure Solutions, LLC, a Koniag Government Services company, is seeking a Database Administrator to support KTIS and a government customer in Mechanicsburg, Pennsylvania. The role designs, develops, secures, tests, optimizes, and manages databases and data, and supports database deployment, integration, release, and production operations. The position may be filled before the posted deadline, and interested candidates are encouraged to apply as soon as possible.

Requirements

Technical knowledge of Navy or DoD supply processes and interfaces.
At least two years of college or technical knowledge and three years of work experience in modern database design and development.
At least two years of college or technical knowledge and three years of work experience with Azure DevOps, Microsoft O365, Microsoft Teams, Excel, Visio, and Outlook.
At least three years of experience with Agile concepts and principles and participating in Agile teams.
At least three years of knowledge and experience in one or more of the following: SQL Server or other popular DBMS such as PostgreSQL; SQL for data manipulation, querying, and management; database optimization, including indexing, query optimization, and hardware configurations; backup and recovery procedures; database security policies, including encryption, access controls, and auditing; scripting languages such as Bash, PowerShell, or Python for automation; data migration, import, and management; developing test plans and coordinating testing; or data modeling.
At least one year of experience with cloud-native architectures, Infrastructure as Code (IaC), Configuration as Code (CaC), and Platform as a Service (PaaS).
Strong analytical skills to analyze database performance and identify bottlenecks.
Meticulous attention to detail to ensure data accuracy and integrity.
Effective communication skills to interact with stakeholders and technical teams.
Ability to adapt to new technologies and database platforms.
Security+ certification.

Responsibilities

Design and implement databases to meet application requirements.
Develop and implement database objects such as stored procedures, functions, and triggers.
Create and maintain data models to ensure data consistency and integrity.
Implement database security measures, including authentication, authorization, and access controls, ensuring compliance.
Optimize database performance through indexing, caching, and query optimization.
Maintain documentation of database design, development, and implementation, including entity-relationship diagrams and data flow diagrams.
Develop and execute database test plans, including unit, integration, and performance testing.
Collaborate with application developers to ensure database designs meet application requirements.
Develop and implement backup and recovery plans to ensure data integrity and availability.
Migrate, import, and manage data.
Develop test plans and coordinate database testing.
Manage database instances, including creation, configuration, and deletion.
Identify and leverage the enterprise-wide version control system.
Automate builds, testing, and deployments within CI/CD pipelines while enforcing security and quality standards, including version control.
Identify, define, or modify interfaces with other systems or applications, ensuring agreements are formally documented with the interfacing system or application.
Support production outages as required.
Support development of release packages.
Create and update work items in the designated tool.
Participate in internal review and change boards.
Conduct product quality audits, research causes of errors, and provide corrective action.