SQLWatchmen is looking for a Senior MS SQL Database Administrator/SQL Developer to support customers' production and dev SQL servers and guide Tier 1 DBAs. The role aims to resolve technical issues, ensure optimal performance, and maintain high availability and security of SQL server environments.
Requirements
- Advanced technical and T-SQL programming skills.
- Fine-tune indexes and rework queries for optimal performance.
- Develop, maintain, and monitor high availability and disaster recovery strategies (Clusters, Mirroring, AlwaysOn, Replication, Log Shipping).
- Ensure data and access to SQL Server are secure.
- Use SSIS to import data, write calculation Stored Procedures/Views, and export data back out.
- Work with business stakeholders to create and maintain reports in SSRS using relational & SSAS data sources.
- Design, implement, and maintain data warehouses/ODS systems using SQL Server Replication, SSIS, SSAS, and T-SQL scripting.
Responsibilities
- Keep an eye on SQL Servers and resolve issues via the ticketing system (CW PSA) before they escalate. Escalate tickets to Tier 3 support when necessary.
- Showcase your advanced technical and T-SQL programming skills.
- Fine-tune indexes and rework queries for optimal performance.
- Develop, maintain, and monitor high availability and disaster recovery strategies (Clusters, Mirroring, AlwaysOn, Replication, Log Shipping).
- Ensure data and access to SQL Server are secure.
- Use SSIS to import data, write calculation Stored Procedures/Views, and export data back out.
- Work with business stakeholders to create and maintain reports in SSRS using relational & SSAS data sources.
Other
- Participate in the on-call rotation (PagerDuty) for emergency coverage. When on-call, respond to text messages within 1 hour.
- Keep the team and customers informed about incident progress, changes, and outages.
- Willing to travel for assigned training and periodic company meetings. Travel duration can vary and last up to 5 business days.
- Have some experience with PostgreSQL and a desire to dive deeper.
- Enter time and expenses in ConnectWise, attend scheduled meetings, and complete training materials in a timely manner.
