Job OverviewWe are seeking a
Senior Cloud Database Systems Engineer (SQL Server) to join our team. You will design, implement, secure, and sustain mission-critical Oracle and Microsoft SQL Server environments across on-premises, Azure, and AWS infrastructure. You will lead database modernization, high availability, disaster recovery, performance optimization, security, and technical documentation activities supporting DoD/Federal enterprise systems. This is an onsite position available in New Cumberland, PA.
Responsibilities include, but are not limited to:Database Engineering, Architecture, and Lifecycle Management- Provision, install, configure, operate, maintain, and enhance enterprise database infrastructure, including associated servers, operating systems, software, and supporting components.
- Design and implement Oracle and Microsoft SQL Server database solutions that meet operational, application, scalability, availability, and regulatory requirements.
- Perform database architecture and administration activities, including schema design, database configuration, replication, capacity planning, and lifecycle management.
- Conduct systems analysis to assess requirements, identify improvement opportunities, and recommend technical solutions that improve data management, performance, and operational efficiency.
- Support the planning and implementation of database and application-server technologies supporting major business initiatives.
Cloud Database Implementation and Modernization- Develop, optimize, and administer SQL Server database solutions hosted on Microsoft Azure Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Azure Managed Instance environments.
- Implement and manage Azure-native capabilities for scalability, high availability, security, monitoring, and operational resilience.
- Administer AWS database environments, including provisioning, configuration, optimization, security hardening, and availability management.
- Evaluate emerging database, cloud, and infrastructure technologies through technical research and development activities; recommend practical innovations that improve enterprise services.
Performance Engineering and Advanced SQL Development- Develop, troubleshoot, and optimize complex T-SQL queries, stored procedures, triggers, functions, and other database code supporting enterprise applications.
- Conduct database performance tuning using query optimization, execution-plan analysis, indexing strategies, partitioning, DBCC commands, and resource-utilization analysis.
- Monitor database health and performance using SQL Server Profiler, Extended Events, Dynamic Management Views, system logs, and related diagnostic tools.
- Perform root-cause analysis of database incidents, performance bottlenecks, and recurring operational issues; implement sustainable corrective and preventive actions.
- Create and maintain PowerShell automation scripts for server administration, database operations, monitoring, and data acquisition.
High Availability, Replication, Backup, and Disaster Recovery- Design, implement, manage, and test SQL Server high-availability, failover, replication, and data-protection solutions.
- Configure and maintain Failover Cluster Instances and other high-availability technologies to ensure database continuity and rapid recovery.
- Establish and sustain backup, restoration, retention, and recovery processes that support operational and mission requirements.
- Serve as a disaster recovery and Continuity of Operations (COOP) subject-matter resource, including recovery planning, validation, testing, and improvement.
- Ensure database services meet established recovery, resilience, availability, and failover objectives.
Database Security, Encryption, and Authentication- Implement database security controls that protect sensitive information and maintain compliance with DoD, Federal, and organizational requirements.
- Configure and manage data-encryption capabilities, including Transparent Data Encryption (TDE), Always Encrypted, and column-level encryption for data at rest and in transit.
- Support secure LDAP and certificate-based authentication mechanisms for database access and enterprise integration.
- Administer database access controls, security configurations, audit capabilities, and related procedures to reduce risk and safeguard mission data.
- Ensure systems, operating procedures, and technical configurations conform to applicable security, regulatory, and organizational standards.
Documentation, Technical Communication, and Stakeholder Engagement- Produce and maintain clear, accurate technical documentation, including database schemas, data dictionaries, entity-relationship diagrams, configuration baselines, process flows, project plans, test plans, and test results.
- Communicate complex technical concepts, risks, designs, and operational issues effectively to technical teams, program leadership, customers, and other stakeholders.
- Provide regular status reporting on project scope, objectives, milestones, dependencies, technical risks, and operational outcomes.
- Translate business and mission requirements into actionable technical designs and implementation plans.
Technical Leadership, Project Delivery, and Mentoring- Lead or support the initiation, planning, execution, monitoring, control, and delivery of large-scale database and infrastructure projects.
- Provide hands-on technical guidance, mentoring, and knowledge transfer to database administrators, systems engineers, and project team members.
- Coordinate with application teams, infrastructure teams, cybersecurity personnel, and program leadership to deliver integrated, supportable database solutions.
- Support technical negotiations, implementation planning, and decision-making for large technology initiatives aligned to organizational business objectives.
Required Qualifications:- Must have a DoD 8570 IAT Level II certification (e.g. Security+, CySA+).
- Must have a SQL focused certification (e.g. MCSA SQL 2016 DBA, Microsoft Azure DBA Associate, or higher)
- A minimum of five (5) years of overall engineering experience.
- A minimum of five (5) years of SQL Server database administration and analysis support experience.
- A minimum of five (5) years of experience supporting DoD or Federal IT systems.
- Demonstrated experience as a Database Architect, Replication Expert, Database Encryption Expert, LDAP/Certificate Authentication Expert, Disaster Recovery/COOP Expert, Database Security Expert, and High Availability Expert.
Preferred Qualifications:- A bachelor's degree in a related field of study.
Clearance Requirements:- Must be a U.S. citizen.
- Must possess a DoD current Secret clearance.
