Responsibilities
- Design, deploy, maintain, and optimize SQL Server environments hosted on Azure
- Administer and support a large fleet of production SQL Server instances
- Diagnosing and resolving complex database and application performance issues
- Perform database upgrades, patching, backups, restores, and disaster recovery
- Support data extracts, data scrubbing, and maintenance activities
- Deploy and configure customer environments and application components
- Partner with Engineering and Support teams to resolve advanced application issues in Windows, IIS, and SQL Server environments
- Drive automation initiatives, including: Infrastructure scalability improvements
- Drive automation initiatives, including: Performance tuning and optimization
- Drive automation initiatives, including: Elimination of manual operational processes
- Utilize AI-driven and advanced analytics tools to enhance database development, proactively detect issues, monitor and optimize performance, and improve operational efficiency
- Serve as a technical escalation point and mentor for support team members
- Develop deep expertise in application provisioning, deployment, and ongoing support
- Track, document, and proactively manage customer issues using ticketing systems
- Communicate effectively with stakeholders at all levels of the organization
- Operate independently while owning outcomes end-to-end
Requirements
- Bachelor’s degree in computer science or related field (or equivalent experience)
- 5+ years of Windows Server (2019+) administration
- 5+ years of SQL Server (2019+) administration and database design
- 5+ years of T-SQL development, including stored procedures and database design
- 5+ years of SQL Server performance tuning and optimization
- 5+ years supporting and optimizing SQL Server 2019 clusters on an Azure VM
- 5+ years supporting web applications in an n-tier architecture
- Experience supporting production systems in Azure-hosted environments
- Experience in APM (Application Performance Monitoring), such as Azure Monitor, Datadog, New Relic, etc.
- Strong analytical, troubleshooting, and problem-solving skills
- Excellent written and verbal communication skills
Nice to Have
- Experience with automation and scripting (PowerShell, Python, ARM, Terraform, etc.)
- Experience working with APIs and application integrations
- Healthcare or HIPAA-regulated environmental experience
- Prior experience in customer-facing technical roles
Benefits
- Remote work
- Travel expected 3-4 times per year for company-sponsored events
- Medical, dental, vision, life, and disability insurance
- 401K retirement plan; flexible spending and health savings account
- 15 days of paid time off + additional front-loaded personal days
- 14 company-recognized holidays + paid volunteer days
- up to 8 weeks of paid parental leave + 10 weeks of paid bonding leave
- LGBTQ+ Health Services
- Pet insurance
- Check out more of our benefits here: https://www.mcg.com/about/careers/benefits/
Additional Information
- Occasional travel required (1–3 trips per year) for team or company-sponsored events
- Remote work with periodic in-person engagements
- Committed to diversity and equal opportunity
- Equal Employment Opportunity (EEO) employer
- Welcomes qualified applicants regardless of race, religion, nationality, gender, sexual orientation, gender identity, age, marital status, veteran status, disability, pregnancy, parental status, genetic information, or political affiliation
- Provides accommodations upon request
- It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment
