SQLWatchmen, Inc. ยท 1 week ago
Senior MS SQL Database Administrator SQL Developer Tier 2
United States
Full-time
Remote
Senior Level, Lead/Staff
10+ years expSQLWatchmen, Inc. is a company that prides itself on delivering best-in-class MS SQL Server support with unrivaled customer service. The Senior MS SQL Database Administrator/SQL Developer - Tier 2 role involves supporting customers' production and development SQL servers, guiding Tier 1 DBAs, and ensuring optimal SQL server performance.
ConsultingDatabaseInformation Technology
No H1B
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
Qualification
Required
Over 10 years of experience as an MS SQL Server Database Administrator
Proactive Monitoring: Keep an eye on SQL Servers and resolve issues via the ticketing system (CW PSA) before they escalate
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
Communication: Keep the team and customers informed about incident progress, changes, and outages
Willing to travel for assigned training and periodic company meetings
Candidates must be legally authorized to work in the U.S. without employer sponsorship
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
Enjoy helping PEOPLE improve their SQL servers
Have a savage curiosity about learning SQL and how it behaves in different environments
Preferred
Experience with PostgreSQL and a desire to dive deeper
Benefits
401(k) matching
Health insurance
Paid time off
Comprehensive medical coverage (no dental or vision)
401(k) Match: 2% company match
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
Company
SQLWatchmen, Inc.
We are a Managed Services Provider (MSP) for database administration only.
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Jim Murphy
CEO, Event Speaker
Company data provided by crunchbase