SQL Server Database Administrator – Fed Gov

This is a fully remote position, open to applicants in New Mexico.

📋 Description

• Install, configure, maintain, patch, and migrate Microsoft SQL Server databases.

• Administer and troubleshoot SQL Server environments using SQL Server Management Studio (SSMS).

• Monitor and enhance database performance, health, and integrity.

• Manage database security, user access, roles, and permissions effectively.

• Maintain processes for backup, recovery, high availability, and disaster recovery.

• Optimize queries, indexes, stored procedures, and other database components.

• Support database design, data modeling, integration, replication, and migration efforts.

• Resolve SQL Server alerts and manage SQL Agent jobs.

• Provision, configure, maintain, patch, monitor, and troubleshoot Windows servers across development, testing, and production environments.

• Administer both physical and virtual server environments, including VMware infrastructure.

• Coordinate changes to servers and databases to ensure application availability and functionality.

• Schedule and manage full, differential, and transaction log backups.

• Implement recovery procedures during system outages.

• Develop, maintain, and troubleshoot SQL Server Integration Services (SSIS) packages for data integration and transformation.

• Write and debug T-SQL, stored procedures, and triggers.

• Assist with SQL Server Reporting Services (SSRS) report development, scheduling, access, and security.

• Oversee SQL Server Agent jobs and scheduled database tasks.

• Support staging and data warehouse environments, including data validation and troubleshooting.

• Adhere to established Software Development Life Cycle (SDLC) and change-control processes.

• Collaborate with developers, technical teams, management, and vendors to address issues and implement changes.

• Maintain documentation on technical processes, change management, operations, system configuration, database processes, maintenance, and recovery procedures.

• Provide technical support across database, Windows Server, virtualization, and application environments.

⛳️ Requirements

• Proven experience in administering Microsoft SQL Server databases using SSMS.

• Experience in installing, configuring, migrating, securing, and maintaining SQL Server instances and databases.

• Familiarity with administering Windows servers, including provisioning, patching, monitoring, and troubleshooting.

• Proficient in T-SQL with experience in working with stored procedures, database objects, and query performance optimization.

• Experience in developing or maintaining SSIS packages and supporting SSRS reporting environments.

• Knowledge of database security, data integrity, backup and recovery, and disaster recovery practices.

• Experience in supporting separate development, testing, and production environments using established SDLC processes.

• Ability to diagnose issues across database, operating system, and application support layers.

• Experience in administering VMware virtual server environments.

• Experience in supporting highly available SQL Server environments, including clustering or Always On availability groups.

• Experience with data warehouse design, data modeling, replication, and database consolidation.

• Proficient with PowerShell for administrative tasks.

• Experience in supporting healthcare reporting systems or federal information technology environments.

• Familiarity with application virtualization and ITIL-based service management practices.

• Working knowledge of NIST guidelines relevant to SQL Server and Windows Server administration.

• Strong communication, documentation, problem-solving, and collaboration skills.

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

• 100% employee-owned company.