SQL Database Administrator

Job Description:

• Manage SQL Server databases on-premises and in Azure cloud environments (IaaS/PaaS)
• Recommend short-term and long-term strategic plans for database infrastructure
• Define and propose policies, procedures, and maintenance plans for DBMS resource administration
• Configure and maintain database servers and processes
• Monitor system health and performance
• Ensure high levels of performance, availability, sustainability, and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide 24x7 support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours
• Participate in an off-hours production support call rotation

Requirements:

• 7+ years of experience as a SQL Server DBA
• SSIS, SSAS, and SSRS administration
• Experience with Performance Tuning and Optimization
• Database stored procedure, trigger, and index creation and tuning
• Experience with backups, restores and recovery models
• Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience supporting a development team in a production environment
• Strong troubleshooting with SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, and Query Store
• Failover Clustering (Always On: FCI & AG) design and configuration
• High-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect via Ethernet
• Minimum internet speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use)
• Experience with Azure SQL, preferred
• Experience with Foglight, Redgate, and other SQL Server 3rd party tools, preferred
• Certifications are a plus

Benefits:

• 401(k)
• Dental insurance
• Disability insurance
• Employee discounts
• Health insurance
• Life insurance
• Paid time off
• 12 paid holidays per year
• Paid training
• Referral program
• Vision insurance
• Referral bonuses