Senior Cloud Database Systems Engineer (SQL Server)

Pennsylvania

2 days ago

Job Description

Company Overview

UnityTec is an SBA-certified Woman-Owned Small Business (WOSB) delivering high-impact professional and technical services to government agencies. With deep expertise in Industrial and Enterprise Systems Modernization, FIAR (Financial Improvement and Audit Readiness), Industrial Facility Transformation, Program and Project Management, Enterprise Support and Consulting, and Advanced Analytics, we empower organizations to modernize operations and advance mission priorities. Our disciplined approach—grounded in dedicated talent, proactive planning, rigorous quality assurance, agile methodologies, cost-effective delivery, and uncompromising ethics—positions UnityTec as a trusted partner committed to achieving measurable, enduring results for our clients.

Job Overview

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

UnityTec is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Numbers & Facts

Location	Pennsylvania
Website	http://unitytec.com/index.html

Skills

Access Controlunmatched
Agile Programming Methodologiesunmatched
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Application Serversunmatched
Authenticationunmatched
Business Continuity Planning (BCP)unmatched
Business Performance Managementunmatched
Business Supportunmatched
Capacity Managementunmatched
Cloud Computingunmatched
CompTIA Security+unmatched
Computer Securityunmatched
Consultingunmatched
Corrective Actionunmatched
Cryptographyunmatched
Data Managementunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Analysisunmatched
Database Architectureunmatched
Database Designunmatched
Database Programmingunmatched
Database Replicationunmatched
Database Technologyunmatched
Database Triggersunmatched
Digital Certificatesunmatched
Disaster Recoveryunmatched
DoD Clearanceunmatched
DoD Directive 8140unmatched
DoD Directive 8570unmatched
Engineeringunmatched
Enterprise Applicationsunmatched
Entity Relationship Diagram (ERD)unmatched
Event Managementunmatched
Failoverunmatched
Financial Auditunmatched
Governmentunmatched
High Availabilityunmatched
IAT - Information Assurance Technicalunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
Infrastructure as a Service (IaaS)unmatched
Internet Securityunmatched
Knowledge Transferunmatched
LDAP (Lightweight Directory Access Protocol)unmatched
Leadershipunmatched
MCSA - Microsoft Certified Systems Administratorunmatched
Maintain Complianceunmatched
Mentoringunmatched
Microsoft Infrastructureunmatched
Microsoft SQL Serverunmatched
Microsoft SQL Server DBA (Database Administration)unmatched
Microsoft Transact-SQL (T-SQL)unmatched
Microsoft Windows Azureunmatched
Negotiation Skillsunmatched
Operating Systemsunmatched
Operational Strategyunmatched
Operational Supportunmatched
Operations Processesunmatched
Oracle Databaseunmatched
Performance Engineeringunmatched
Performance Tuning/Optimizationunmatched
Platform as a Service (PaaS)unmatched
Problem Solving Skillsunmatched
Process Flowunmatched
Professional Servicesunmatched
Project Planningunmatched
Project/Program Managementunmatched
Quality Assurance Methodologyunmatched
Query Optimizationunmatched
Regulationsunmatched
Regulatory Requirementsunmatched
Replication and Remote Mirroringunmatched
Requirements Managementunmatched
Research & Development (R&D)unmatched
Resource Utilizationunmatched
Risk Managementunmatched
Root Cause Analysisunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Secret Clearanceunmatched
Security Auditingunmatched
Security Monitoringunmatched
Server Supportunmatched
Small Businessunmatched
Software Administrationunmatched
Stored Proceduresunmatched
Systems Administration/Managementunmatched
Systems Analysisunmatched
Systems Engineeringunmatched
Technical Leadershipunmatched
Technical Researchunmatched
Technical Supportunmatched
Technical Writingunmatched
Technical/Engineering Designunmatched
Testingunmatched
Testing Serversunmatched
United States Citizenunmatched
United States Department of Defense (DoD)unmatched
Validation Planunmatched
Validation Testingunmatched
Windows PowerShellunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder