View all jobs

Senior Cloud Database Systems Engineer (SQL Server)

  • New Cumberland, PA
  • Information Technology
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.