SQLWatchmen is looking to solve the problem of supporting customers' production and dev SQL servers with best-in-class MS SQL Server support and unrivaled customer service.
Requirements
- Advanced technical and T-SQL programming skills
- Experience with MS SQL Server performance tuning
- Knowledge of high availability and disaster recovery strategies (Clusters, Mirroring, AlwaysOn, Replication, Log Shipping)
- Experience with SSIS and SSRS
- SQL programming skills
- Experience with Replication and data warehouses/ODS systems using SQL Server Replication, SSIS, SSAS, and T-SQL scripting
- Some experience with PostgreSQL
Responsibilities
- Proactive Monitoring: Keep an eye on SQL Servers and resolve issues via the ticketing system (CW PSA) before they escalate.
- Technical Expertise: Showcase advanced technical and T-SQL programming skills.
- Performance Tuning: Fine-tune indexes and rework queries for optimal performance.
- HA/DR Strategies: Develop, maintain, and monitor high availability and disaster recovery strategies (Clusters, Mirroring, AlwaysOn, Replication, Log Shipping).
- Security: Ensure data and access to SQL Server are secure.
- SSIS: Use SSIS to import data, write calculation Stored Procedures/Views, and export data back out.
- SSRS: Work with business stakeholders to create and maintain reports in SSRS using relational & SSAS data sources.
Other
- Detail-oriented with the ability to stay focused and productive working in a fully remote environment
- Desire to work efficiently and in a consistent manner to improve customer satisfaction and attainment of team metrics
- Ability to communicate with both the team and customers
- Willing to travel for assigned training and periodic company meetings
- Candidates must be legally authorized to work in the U.S. without employer sponsorship
