SQL Server Database Administrator (Fed Gov)

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 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.
• Experience supporting healthcare reporting systems or federal information technology environments.
• Familiarity with application virtualization and ITIL-based service management practices.

Additional Information :

Featured benefits:

• Flexible Work Schedules
• Paid Parental Leave
• 401(k) & ESOP (with company match up to 4%)
• Professional Development and Training
• Tuition Reimbursement
• Employee Assistance Program
• Medical/Dental/Vision Insurance Plans

All your information will be kept confidential according to EEO guidelines.

Remote Work :

Yes

Employment Type :

Full-time