Senior MS SQL Database Administrator SQL Developer Tier 2

Responsibilities:

• Proactive Monitoring: 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.
• Technical Expertise: Showcase your advanced technical and T-SQL programming skills.
• Performance Tuning: Fine-tune indexes and rework complex 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.
• SQL Programming: Demonstrate advanced technical and programming skills.
• Replication: Design, implement, and maintain data warehouses/ODS systems using SQL Server Replication, SSIS, SSAS, and T-SQL scripting.
• On-Call Rotation: Participate in the on-call rotation (PagerDuty) for emergency coverage. When on-call, respond to text messages within 1 hour.
• Communication: Keep the team and customers informed about incident progress, changes, and outages.
• Travel: Willing to travel for assigned training and periodic company meetings. Travel duration can vary and last up to 5 business days.
• PostgreSQL Enthusiasm: Have some experience with PostgreSQL and a desire to dive deeper.
• Administrative Tasks: Enter time and expenses in ConnectWise, attend scheduled meetings, and complete training materials in a timely manner.

Skills:

• Detail-oriented
• Self-motivated
• Savage curiosity about learning SQL
• Efficient and consistent
• Excellent communication skills

Qualifications:

• Over 10 years of experience as an MS SQL Server Database Administrator
• Legally authorized to work in the U.S. without employer sponsorship

Benefits:

• 💼 401(k) matching
• 🏥 Health insurance
• 🌴 Paid time off

Company Values:

• Be A Partner
• Stay Curious
• Take Ownership
• Help First
• Find Joy in the Work

Company Culture:

• Remote position
• Fully remote team
• CEO and founder with over 20 years of experience
• Commitment to core values

Application:

If you're excited about this opportunity and our core values resonate with you, apply now and tell us why you'd be a great fit for SQLWatchmen!