SQL Server Database Administrator (Fed Gov)

RESPEC•Albuquerque, NM

18d

About The Position

RESPEC is seeking a hands-on Senior SQL Server Database Administrator / Windows Systems Administrator to support the NPIRS environment. The role is suited to a technical generalist who can manage both SQL Server databases and Windows servers across approximately 60 development, test, and production servers. Responsibilities span database and server installation, configuration, migration, security, monitoring, maintenance, data integration, reporting, virtualization, backup and recovery, availability, performance, and data integrity. The administrator will follow established SDLC and change-control processes, apply working knowledge of relevant NIST guidelines, and troubleshoot across database, server, and application-support layers. The position includes administering SQL Server and Windows Server environments; supporting VMware infrastructure; developing and maintaining SSIS packages, T-SQL, and SSRS reports; managing scheduled jobs and backups; executing recovery procedures; and maintaining technical, operational, and change-management documentation. The employee will collaborate with developers, technical teams, management, and vendors to resolve issues and implement changes. RESPEC is a 100% employee-owned company working in energy transition, infrastructure resilience, digital transformation, and sustainability. The job posting states that the employee must be able to obtain and maintain the government security clearance and/or suitability determination required for the position.

Requirements

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.
Ability to obtain and maintain the government security clearance and/or suitability determination required for the position.

Nice To Haves

Experience administering VMware virtual server environments.
Experience supporting highly available SQL Server environments, including clustering or Always On availability groups.
Experience with data warehouse design, data modeling, replication, and database consolidation.
Experience using PowerShell to support administrative tasks.
Experience supporting healthcare reporting systems or federal information technology environments.
Familiarity with application virtualization and ITIL-based service management practices.

Responsibilities

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.
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.
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.
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.
Provide technical support across database, Windows Server, virtualization, and application environments.
Maintain working knowledge of NIST guidelines.