SQL Server Database Administrator (Fed Gov)

Respecinc; United States; On-site; USD 110,000 - 160,000; Full time

Job summary

RESPEC is seeking a hands-on Senior SQL Server Database Administrator and Windows Systems Administrator to support the NPIRS environment. This role combines database and OS administration across development, test, and production, ideal for a technical generalist.

You will install, configure, migrate, secure, monitor, and maintain SQL Server databases and Windows servers, manage backups, disaster recovery, and ensure data integrity, performance, and availability across roughly 60 servers.

Qualifications

• Experience administering Microsoft SQL Server databases using SSMS.
• Experience installing, configuring, migrating, securing, and maintaining SQL Server instances.
• Experience administering Windows servers, including provisioning, patching, monitoring, and troubleshooting.
• Proficiency in T-SQL and performance tuning of queries and objects.
• Experience developing or maintaining SSIS packages and supporting SSRS reporting.
• Knowledge of backup, recovery, DR, security, and data integrity.
• Ability to operate in multiple environments using SDLC processes.
• Strong communication, documentation, and collaboration skills.
• Ability to obtain Government security clearance or suitability.

Responsibilities

• Install, configure, maintain, patch, and migrate SQL Server databases.
• Administer SQL Server environments using SSMS; monitor performance and security.
• Manage backups, high availability, and disaster recovery processes.
• Support data integration, reporting, and data warehouse environments.
• Administer Windows servers and VMware virtualization; patch and troubleshoot.
• Coordinate changes to ensure application availability and functionality.
• Document configurations, processes, and change management workflows.
• Collaborate with developers and vendors to resolve issues.

Skills

SQL Server

SSMS

T-SQL

SSIS

SSRS

Windows Server

VMware

Job description

RESPEC is seeking a hands‑on Senior SQL Server Database Administrator / Windows Systems Administrator to support the NPIRS environment. This position is ideal for a technical generalist with experience managing both SQL Server databases and Windows servers.

The role supports approximately 60 servers across development, test, and production environments. Responsibilities include installing, configuring, migrating, securing, monitoring, and maintaining SQL Server databases and Windows servers, as well as supporting data integration, reporting, virtual servers, backup, disaster recovery, system availability, performance, and data integrity.

Key Responsibilities

SQL Server and Database Administration

• Install, configure, maintain, patch, and migrate Microsoft SQL Server databases.
• Administer and troubleshoot SQL Server environments using SSMS.
• Monitor and optimize database performance, health, and integrity.
• Manage database security, user access, roles, and permissions.
• Maintain backup, recovery, high availability, and disaster recovery processes.
• Optimize queries, indexes, stored procedures, and other database objects.
• Support database design, data modeling, integration, replication, and migration.
• Troubleshoot SQL Server alerts and Agent jobs.
• Maintain technical, change management, and operational documentation.

Windows Server and Virtualization Administration

• Provision, configure, maintain, and troubleshoot Windows servers across development, test, and production environments.
• Perform server patching, maintenance, testing, and issue resolution.
• Monitor system logs, alerts, and operational reports to identify and resolve issues.
• Administer physical and virtual server environments, including VMware infrastructure.
• Coordinate server and database changes to support application availability and functionality.
• Schedule and maintain full, differential, and transaction log backups.
• Execute recovery procedures during system outages.
• Maintain change management documentation, workflows, and standard operating procedures.

Data Integration, Development, and Reporting

• Develop, maintain, and troubleshoot SSIS packages for data integration and transformation.
• Write and troubleshoot T‑SQL, stored procedures, and triggers.
• Support SSRS report development, scheduling, access, and security.
• Maintain SQL Server Agent jobs and scheduled database processes.
• Support staging and data warehouse environments, including data validation and troubleshooting.
• Use Microsoft BI and development tools, including Business Intelligence Development Studio and Visual Studio.

Operational Support and Collaboration

• Follow established SDLC and change-control processes across development, test, and production environments.
• Collaborate with developers, technical teams, management, and vendors to resolve issues and implement changes.
• Maintain documentation for system configurations, database processes, maintenance, and recovery procedures.
• Provide technical support across database, Windows Server, virtualization, and application environments.
• Maintain working knowledge of NIST guidelines.
• Provide technical support across database, Windows Server, virtualization, and application environments.

Here’s a more concise, job‑posting-friendly version that preserves the technical requirements:

• Develop, maintain, and troubleshoot SSIS packages for data integration and transformation.
• Write and troubleshoot T‑SQL, stored procedures, and triggers.
• Support SSRS report development, scheduling, access, and security.
• Maintain SQL Server Agent jobs and scheduled database processes.
• Support staging and data warehouse environments, including data validation and troubleshooting.

Required Qualifications:

• Demonstrated experience administering Microsoft SQL Server databases using SSMS.
• Experience installing, configuring, migrating, securing, and maintaining SQL Server instances and databases.
• Experience administering Windows servers, including provisioning, patching, monitoring, and troubleshooting.
• Proficiency in T‑SQL and experience working with stored procedures, database objects, and query performance tuning.
• Experience developing or maintaining SSIS packages and supporting SSRS reporting environments.
• Knowledge of database security, data integrity, backup and recovery, and disaster recovery practices.
• Experience supporting separate development, test, and production environments using established SDLC processes.
• Ability to diagnose issues across database, operating system, and application‑support layers.
• Strong communication, documentation, problem‑solving, and collaboration skills.
• Must have the ability to obtain and maintain the Government security clearance and/or suitability determination required for the position.

Preferred Q