SQL Server Database Administrator (Fed Gov)

RESPEC; EE. UU.; A distancia; USD 110.000 - 150.000; Jornada completa

Descripción de la vacante

RESPEC is seeking a hands-on Senior SQL Server Database Administrator / Windows Systems Administrator to support the NPIRS environment in the United States. You will manage SQL Server databases and Windows servers across development, test, and production environments, ensuring security, performance, and data integrity.

The role requires SDLC adherence, collaboration with cross-functional teams, and the ability to troubleshoot across database, OS, and application layers.

Formación

• Experience administering Microsoft SQL Server using SSMS.
• Install, configure, migrate, secure, and maintain SQL Server instances.
• Provision and administer Windows servers, including patching, monitoring, and troubleshooting.
• Proficiency in T-SQL with stored procedures and query performance tuning.
• Experience developing or maintaining SSIS packages and supporting SSRS reporting environments.
• Knowledge of backup, recovery, high availability, and disaster recovery practices.
• Experience using SDLC processes across development, test, and production environments.
• Ability to diagnose issues across database, operating system, and application-support layers.
• Strong communication and collaboration skills; ability to obtain government security clearance if required.
• Preferred: VMware administration experience.

Responsabilidades

• 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.
• Follow SDLC and change-control processes across environments.
• Collaborate with developers and vendors to resolve issues and implement changes.
• Maintain documentation for system configurations and recovery procedures.
• Provide technical support across database, Windows Server, and virtualization environments.

Conocimientos

SQL Server

SSMS

T-SQL

SSIS

SSRS

Windows Server

VMware

Backup & DR

High availability

Security & access

SDLC

NIST guidelines

PowerShell

Herramientas

SSMS

PowerShell

SQL Server Agent

VMware

Descripción del empleo

Company Description

Big challenges need bold thinkers.

If you're someone who sees problems as opportunities, you'll thrive here. RESPEC is 100% employee-owned, which means we take ownership of every challenge. Here, your ideas drive real solutions. Since 1969, we've tackled complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability.

At RESPEC, you'll work alongside clients to take on critical problems. Depending on your expertise, you might design infrastructure in remote locations, develop renewable energy solutions for global projects, or apply data-driven technology to improve mining and water systems.

We bring deep technical knowledge, real-world experience, and a commitment to work that matters. If you're looking for a place where your contributions have real impact, you'll fit right in.

We do not accept unsolicited resumes from third-party recruiters.

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.

The ideal candidate will have working knowledge of NIST guidelines applicable to SQL Server and Windows Server administration, follow established SDLC processes, and be able to troubleshoot across database, server, and application support layers.

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

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.

Qualifications

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 Qualifications:

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