Database Administrator

Koniag Government Services•Mechanicsburg, PA

1d•Onsite

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 position designs, implements, secures, optimizes, tests, and maintains databases and database objects, while supporting data modeling, migrations, backups, recovery, and database instances. It also contributes to CI/CD automation, release packages, system interfaces, production support, work-item management, change-board reviews, and quality audits. The role calls for experience with modern database design and development, Agile teams, SQL Server or other database management systems, and relevant Microsoft and Azure DevOps tools. The successful candidate will bring technical knowledge of Navy or DoD supply processes and interfaces, database security and performance practices, scripting and automation skills, and at least one year of experience with cloud-native architectures and related infrastructure and platform concepts. Security+ certification is required. The employer offers competitive compensation and benefits including medical, dental, and vision insurance, a 401(k) retirement plan, paid time off, paid parental leave, life and disability insurance, flexible spending accounts, commuter benefits, and tuition reimbursement. The role is located in Mechanicsburg, PA. The position may be filled before the posted deadline, and interested candidates are encouraged to apply promptly.

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 participation in Agile teams.
At least three years of knowledge and experience in one or more of the following: SQL Server or another 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 with Bash, PowerShell, or Python for automation; data migration, importing, and management; test-plan development and test coordination; 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 for interacting 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, including 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, and ensure compliance.
Optimize database performance, including 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 and ensure 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 quality audits of products, research causes of errors, and provide corrective action.