Essential Duties & Responsibilities
Design, implement, monitor, and maintain database platforms with a primary focus on Microsoft SQL Server (2016/2019/2022) and Windows Server (2019/2022) environments.
Manage high-availability and disaster-recovery solutions including clustering, Always On Availability Groups, database mirroring, log shipping, replication topologies, fail-over testing, RTO/RPO alignment and patch/update lifecycles.
Campaign for performance excellence: leveraging wait-stats, Query Store, index/plan management, baselining, extended events/trace, and third-party tools such as Redgate SQL Monitor and/or SolarWinds Database Performance Analyzer.
Implement and test backup/restore strategies utilizing native and third-party tools and off-site storage (e.g., Azure Blob).
Operate in a hybrid deployment footprint: on-premises, cloud (e.g., Azure SQL Database, Amazon RDS), and interconnected environments.
Participate in change-management and incident-management frameworks: create and follow runbooks, coordinate with CABs, execute audit-ready reporting, operate under regulated compliance (HIPAA-equivalent) standards.
Collaborate with application teams, data engineering and infrastructure teams as a true team player: providing input on schema design, query optimization, and database health.
Stay current with other database flavors (e.g., MySQL, MongoDB, PostgreSQL) – while SQL Server remains the primary focus.
On-call rotation: respond to database incidents, perform root-cause analysis, document and implement corrective/ preventive actions.
Qualifications
Minimum of 5 years of hands-on experience as a DBA, with significant focus on SQL Server administration (including HA/DR deployment in production).
Deep experience with SQL Server high-availability/disaster-recovery technologies: Always On Availability Groups, clustering, mirroring, log shipping, replication.
Proven track record troubleshooting, maintaining and improving performance in enterprise-grade environments based on SLAs.
Familiar with performance diagnostics (wait stats, Query Store, execution plans, etc.).
Experience working in regulated environments (healthcare, finance or equivalent) with formal change-management, incident-management and audit processes.
Additional Information
ELLKAY is committed to fostering a collaborative and high-performance work environment that supports innovation, teamwork, and professional growth. Most roles are designed to operate from our office locations to encourage effective collaboration and engagement across teams. Any alternative work arrangements may be considered at the company’s discretion based on role requirements and business needs. For more information about our company, please visit www.ELLKAY.com. ELLKAY is a Smoke-Free Workplace.
ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.