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

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

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

• Oversee backup, recovery, high availability, and disaster recovery processes.

• Optimize queries, indexes, stored procedures, and database objects.

• Assist with database design, data modeling, integration, replication, and migration.

• Troubleshoot SQL Server alerts and 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 server and database modifications to ensure application availability and functionality.

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

• Execute recovery protocols during system outages.

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

• Maintain SQL Server Agent jobs and scheduled database processes.

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

• Adhere to established SDLC and change-control processes.

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

• Maintain technical, operational, configuration, maintenance, and recovery documentation.

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

• Maintain a working knowledge of NIST guidelines.

⛳️ Requirements

• Proven experience administering Microsoft SQL Server databases using SSMS.

• Experience in 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 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 best practices.

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

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

• Capability to obtain and maintain the Government security clearance and/or suitability determination required for the position.

• Experience administering VMware virtual server environments is preferred.

• Experience supporting high availability SQL Server environments, including clustering or Always On availability groups is preferred.

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

• Familiarity with using PowerShell for administrative tasks is preferred.

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

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

🏝️ Benefits

• 100% employee-owned company.

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

• Remote work availability.