Senior Database Engineer at OSC Edge in Fort Knox, Kentucky

Job Description:

As the Senior Database Engineer, the individual will play a pivotal role in overseeing and optimizing diverse database systems, ensuring peak performance, robust security, and high availability. In this role, the Senior Database Engineer primary responsibility will involve the proficient management of Databases. In addition, the Senior Database Engineer will build, support, administer, and sustain a clustered-server database platform hosted in an enterprise IT environment. The Engineer will provide technical support for incident response, service degradations, outages, and other service interruptions. Investigate hardware and software problems related to the database-hosting infrastructure and perform corrective actions.

Responsibilities

• Architects, designs, engineers, and documents database servers and associated infrastructure in clustered, stand-alone, and/or appliance-hosted configurations, which fulfill mission requirements, service specifications, and cyber security mandates

• Implements robust backup, restoration, and disaster recovery strategies

• Monitors, fine-tunes, and optimizes database performance for minimal downtime and maximum efficiency

• Establishes and enforce stringent database security protocols and access controls

• Collaborates closely with application development teams to design and optimize database schemas

• Offers expertise in writing, tuning, and troubleshooting complex SQL queries, stored procedures, and ETL processes

• Executes and oversees data migration initiatives when required

• Develops and executes data migration strategies when necessary

• Develops and maintains advanced automation scripts for streamlined database provisioning and management

• Enhances monitoring and alerting systems to proactively identify and resolve database issues

• Spearheads scalability and high availability efforts for Azure SQL, Cosmos DB, Synapse Analytics, and other cloud-based databases

• Efficiently manages cloud resources and optimize cost-effectiveness

• Maintains comprehensive documentation detailing database configurations, procedures, and best practices

• Generates performance and usage reports to support informed decision-making

• Drives problem resolution and root cause analysis across the technology stack

• Participates in the resolution of database availability, capacity, and performance issues

• Contributes to ongoing improvement of internal processes and SQL Server tools

• Participates in infrastructure and organizational initiatives across multiple IT disciplines

• Sustains fleet of physical and virtual database-hosting servers running a mix of operating systems (Open Systems and Windows Systems) in multiple network environments

• Performs daily operations, onsite support, and on-call support for all aspects of database architecture, database platforms, and database management software

• Works with original equipment manufacturers and/or third-party vendors to resolve performance degradations and outages

• Supports and participates in projects relating to the move of systems and services to modernized hosting environments and Cloud capabilities; provide expert advice on configuring database systems to meet the environment and boundary requirements, and customize services to meet new performance goals

• Performs other tasks as required by Vencedor and the Government contracting office

Required Qualifications/Education and Experience

• Must possess and maintain Secret clearance and be eligible to obtain a Top-Secret clearance

• Must possess a CompTIA Security+ certification

• Minimum 8 or more years of experience with designing, building, and managing databases

• Proficiency in managing a diverse range of databases, including SAP ASE, ORACLE, Microsoft SQL Server, Azure SQL, and Azure Data Factory

• Ability to translate customer requirements into database structure

• Strong grasp of advanced database security practices

• Possession of excellent oral and written communication skills

• Experience building and maintaining Content Management Platforms

• Mastery of scripting languages (e.g., PowerShell, Python) for automation

• Experience with creating and formulating workflows

Equal Employment Opportunity/M/F/disability/protected veteran status

PI256008277