Microsoft SQL Server DBA

Job Title: Microsoft SQL Server DBA

Location: Pittsburgh, PA (Hybrid)

Citizenship Requirement: U.S. Citizenship Required

Employment Type: Full-Time

Schedule: Shifts and On call

Experience: Multiple customer experience in an MSP space

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 customers 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. In addition, this role needs deep ETL and data movement experience.

You will be required to collaborate with internal teams and external clients to ensure optimal database performance, security, and uptime.

Role Description

This is a full-time role for a Microsoft SQL Server DBA at DataStrike. The DBA will be responsible for managing and maintaining SQL Server databases, including tasks such as database administration, replication, database design, and troubleshooting. This hybrid role is located in Pittsburgh, PA, allowing for some work-from-home flexibility.

Key Responsibilities:

• Manage and administer Microsoft SQL Server databases in production and non-production environments for multiple clients.
• Deep experience with data movement and SSIS and working in a datamart environment.
• Configure and maintain high availability solutions, including Always On Availability Groups, Database Mirroring, Clustering, Merge Replication, 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:

• 10 years of experience in SQL Server database administration, with a proven track record of managing complex, high-availability environments.
• Experience working in multi-client, managed service provider (MSP) 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.
• Deep knowledge in SSIS and data transformation capabilities.
• Strong understanding of database architecture and design principles.
• 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
• Strong experience 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!