Senior Database Administrator - Tier 2

SQLWatchmen, Inc.

14h • Remote

About The Position

Are you ready to take your SQL skills to the next level? Join SQLWatchmen as a Senior Database Administrator - Tier 2 and become a key player in our fully remote team! You'll be at the forefront of supporting customers’ production and dev SQL servers and supporting and guiding Tier 1 DBAs. This role is perfect for someone who thrives on diagnosing technical issues, has a passion for performance tuning, enjoys being part of an on-call rotation, and loves communicating with both the team and customers.
Who We Are:
At SQLWatchmen, we pride ourselves on delivering best-in-class MS SQL Server support with unrivaled customer service. With over 17 years in the business, our CEO and founder's passion for MS SQL Server spans more than two decades. We are deeply committed to our culture and seek employees and customers who resonate with our core values:
Be A Partner
Stay Curious
Take Ownership
Help First
Find Joy in the Work
If these values speak to you, we want to hear from you!
Our DBA Team:
Join our dynamic, fully remote small team of seasoned professionals with a current average of over 22y experience each in MS SQL Server. Some of us have earned the SQLSkills Black Belt certification and you’ll have the chance to achieve this prestigious certification too!

Requirements

• A well-rounded, self-motivated MS SQL Server Database Administrator with 10+ years of experience who desires to supercharge their SQL skills and grow to be a top-tier expert in MS SQL Server performance tuning.
• Detail-oriented with the ability to stay focused and productive working in a fully remote environment.
• You desire to work efficiently and in a consistent manner to improve customer satisfaction and attainment of team metrics.
• You enjoy helping PEOPLE improve their SQL servers. We are SQL consultants. If you don’t like talking and helping people, you will not like working here.
• You have a savage curiosity about learning SQL and how it behaves in different environments. If you learn rapidly and eagerly, you will love it here.

Nice To Haves

• PostgreSQL Enthusiasm is a Plus: Have some experience with PostgreSQL and a desire to dive deeper.

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 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.
• 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.
• Administrative Tasks: Enter time and expenses in ConnectWise PSA, attend scheduled meetings, and complete training materials in a timely manner.

Benefits

• Comprehensive medical coverage (no dental or vision).
• 2% company match 401(k).
• Nine paid holidays each year and 120 hours of PTO per year.
• Extensive MS SQL and PostgreSQL training.
• Exposure to diverse MS SQL Server environments with opportunities to advance your skillset.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed