Database Administrator

Koniag Government Services; Mechanicsburg (Cumberland County); On-site; USD 110,000 - 125,000; Full time

Job summary

Koniag Tech and Infrastructure Solutions, LLC, a Koniag Government Services company, is seeking a Database Administrator to support KTIS and our government customer in Mechanicburg, PA. The role involves designing and implementing databases, security, backups, data modeling and CI/CD automation.

You will collaborate with developers, optimize performance, and ensure data integrity through testing and documentation, while migrating and managing data across environments.

Qualifications

• Minimum 3 years of experience in modern database design and development.
• Experience with SQL Server and PostgreSQL.
• Experience with Azure and cloud-native architectures.
• Knowledge of database security, backups, and disaster recovery.
• Proficiency in scripting for automation (PowerShell, Bash, Python).

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, such as authentication, authorization and access controls ensuring compliance.
• Optimize database performance, including indexing, caching and query optimization.
• Maintain up-to-date documentation of database design, development and implementation to include entity-relationship diagrams and data flow diagrams.
• Develop and execute database test plans, including unit testing, integration testing 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/applications, ensuring agreements are formally documented with the interfacing system/application.
• Support production outages, as required
• Provide support to the development of the release packages
• Create and update work items in the designated tool
• Participate in internal review/change boards
• Conduct quality audits of products, perform causative research on errors, and provide corrective action.

Skills

SQL Server

PostgreSQL

Data Modeling

Backup & Recovery

Database Security

CI/CD

Scripting: PowerShell

Automation

Cloud-native architectures

Agile

Tools

Azure

PowerShell

Bash

Python

Git

CI/CD tooling

Job description

Koniag Tech and Infrastructure Solutions, LLC, a Koniag Government Services company , is seeking a Database Administrator to support KTIS and our government customer in Mechanicburg, PA.

Roles and 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, such as authentication, authorization and access controls ensuring compliance.

• Optimize database performance, including indexing, caching and query optimization.

• Maintain up-to-date documentation of database design, development and implementation to include entity-relationship diagrams and data flow diagrams.

• Develop and execute database test plans, including unit testing, integration testing 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/applications, ensuring agreements are formally documented with the interfacing system/application.

• Support production outages, as required

• Provide support to the development of the release packages

• Create and update work items in the designated tool

• Participate in internal review/change boards

• Conduct quality audits of products, perform causative research on errors, and provide corrective action.

Requirements:

• Technical knowledge in Navy or DoD supply processes and interfaces.

• Minimum of 2 years of college/technical knowledge and 3 years of work experience in modern database design and development.

• Minimum 2 years of college/technical knowledge and 3 years of work experience with Azure

• DevOps, Microsoft O365, Microsoft Teams, Excel, Visio and Outlook applications.

• Minimum of 3 years of experience in Agile concepts and principles and experience participating in Agile teams.

• Minimum of 3 years of knowledge and experience in one or more of the following

• SQL Server and other popular DBMS like PostgreSQ

• Use of SQL for data manipulation, querying, and management

• Database optimization to include indexing, query optimization and hardware configurations

• Backup and recovery procedures to protect data integrity

• Implementing database security policies, including encryption, access controls, and auditing

• Proficiency in scripting languages like Bash, PowerShell, or Python for automation tasks

• Migrate, import, and manage data

• Develop test plans and coordinate testing

• Data Modeling

• At least one year of experience with:

• Cloud-native architectures

• Infrastructure as Code (IaC)

• Configuration as Code (CaC)

• 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.

• The ability to adapt to new technologies and database platforms.

• Security+ Certification

Our Equal Employment Opportunity Policy

The company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment.

The company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website, please get in touch with Heaven Wood via e-mail at [e-mail] or by calling 703-488-9377 to request accommodations.

Koniag Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions, Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag, we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical, professional, and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers, employees, and native communities. For more information, please visit www.koniag-gs.com.

Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352

Job Details

Job Family Databases and Data Warehousing

Job Function Database Administrator

Pay Type Salary

Hiring Min Rate 110,000 USD

Hiring Max Rate 125,000 USD