Microsoft SQL Server DBA

• Job Title: Microsoft SQL Server DBA
• Location: Pittsburgh, PA (Hybrid)
• Employment Type: Full-Time
• Citizenship Requirement: U.S. Citizenship Required
• Schedule: Shifts and On call

Company Overview:

DataStrike is the industry leader in 100% onshore database, cloud and business intelligence managed services - enabling companies to harness IT changes as a catalyst for growth. With a network of highly specialized experts, strategic partnerships with the world's biggest technology providers and a platform-agnostic approach, DataStrike provides innovative solutions and practical guidance to accelerate digital transformation initiatives and drive better business outcomes for small- to mid-sized businesses. Founded in 2008, the company maintains more than 200 clients across North America and is headquartered in Pittsburgh, PA. To learn more about DataStrike's services and capabilities, please visit datastrike.com.

Job Overview:

As a Microsoft SQL Server DBA, you will be responsible for managing, maintaining, and optimizing SQL Server databases across diverse customer environments. This role requires extensive experience in database administration, particularly in high availability (HA) environments, SQL Azure, and Always On configurations. You will be required to collaborate with internal teams and external clients to ensure optimal database performance, security, and uptime.

Key Responsibilities:

• Manage and administer Microsoft SQL Server databases in production and non-production environments for multiple clients.
• Configure and maintain high availability solutions, including Always On Availability Groups, Database Mirroring, Clustering, and Log Shipping.
• Provide support for SQL Azure environments and manage cloud-based SQL Server solutions.
• Design, implement, and optimize database backup and recovery solutions.
• Perform database performance tuning and optimization, including query optimization, indexing strategies, and resource allocation.
• Troubleshoot and resolve database issues, including replication and connectivity problems.
• Implement and enforce security policies for database access and user management.
• Collaborate with other teams to implement changes, patches, and updates to ensure database health and performance.
• Ensure database compliance with industry standards and best practices.
• Provide on-call support for database issues as part of a rotating schedule.
• Work closely with customers to understand their requirements and deliver appropriate database solutions.
• Prepare and maintain detailed documentation for database environments, processes, and procedures.
• Assist in migration projects and database upgrades, including the transition to SQL Azure.

Required Qualifications:

• 8-10 years of experience in SQL Server database administration, with a proven track record of managing complex, high-availability environments.
• Extensive experience with SQL Server Always On Availability Groups, Database Mirroring, Failover Clustering, and SQL Azure.
• Deep knowledge of performance tuning, database optimization, and disaster recovery solutions for SQL Server.
• Expertise in database security, backup and recovery strategies, and troubleshooting techniques.
• Strong understanding of database architecture and design principles.
• Experience working in multi-client, managed service provider (MSP) environments.
• Proficient with T-SQL, PowerShell scripting, and other automation tools.
• Excellent communication skills with the ability to collaborate with technical teams and non-technical stakeholders.
• Ability to work effectively in a hybrid team environment.

Preferred Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field
• MAP (Microsoft Assessment and Planning) experience is a plus
• Microsoft SQL Server certifications preferred
• Familiarity with cloud technologies, particularly Azure services, and cloud migration strategies

Why Join Us:

• Competitive salary and benefits package.
• Hybrid work schedule with flexibility.
• Opportunity to work with a diverse range of customers and technologies.
• Collaborative and innovative work environment.
• Continuous professional development and certification opportunities.
• If you have the skills and experience we're looking for and you're ready to take on a challenging and rewarding role, we encourage you to apply today!

Job Type: Full-time

Pay: $100,000.00 - $120,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Paid time off
• Professional development assistance
• Vision insurance

Schedule:

• 8 hour shift
• On call

Work Location: Hybrid remote in Warrendale, PA 15086

Salary : $100,000 - $120,000