Principal Database Administrator

*** US Citizens or Green Card Holder Only. No C2C or 3rd Parties *** SummaryThe Ash Group is hiring a Principal Database Administrator (24676) for our client, a municipal government providing essential public services like public safety and community development. This is a fulltime position working remotely in CO (must be located in CO and be willing to come in as needed in Aurora). We are offering a salary 120-125K based on skill set. Role DetailsCompensation: 120-125K based on skill setBenefits: Medical, dental, vision, and direct primary care benefits. After six months of employment, enjoy a 4% matched 401(k) plan with immediate 100% vesting.Location: Remote in CO (Must be located in CO and be able to come to office as needed in Aurora) What You’ll Be DoingPrimary support for all lines of business Microsoft SQL Server instances, including all upgrades and migrations to new versions when necessary. Provides support as required for other databases.???Administers production SQL Server Reporting Services, Integration Services, and SQL Agent Jobs.Responsible for the configuration and management of production SQL Server (Always on Availability groups/Mirroring/Replication), ensuring a highly available SQL Server production environment.Assist with the deployment of SQL products and services in development and COTS application deployment as required.Ensure all database servers are backed up and tested to meet the business’s Recovery Point Objectives (RPO).Performs database services such as job processing, tuning, archiving, and installing upgrades to test and production database environments.Co-Lead the future implementation of Business Intelligence, Data Lakes, Data Warehouses, Business Analytics, as resources and funds allow.Responsible for ensuring that the SQL Server environment meets established security requirements.This position may serve as the lead on specific projects or initiatives. What We’re Looking For5 years of experience as a Database Administrator of Microsoft SQL Server 2008 or higher is requiredMust have 2 years of Windows Server administration, including experience in Web application implementation in a Microsoft SQL Server environment.Expert-level proficiency with Microsoft SQL Server (2016–2022), including Always On Availability Groups, Failover Cluster Instances, replication, log shipping, Query Store, DMVs, and Extended Events.Advanced T-SQL development, including stored procedures, views, functions, triggers, and performance-optimized schema design.Strong capability in performance tuning using execution plans, indexing strategies, memory/IO optimization, and system-level diagnostics.