Main Street DBAs is hiring a
Senior SQL Database Administrator

Summary

The job is for a Senior-level SQL Server DBA providing operational database management tasks with flexibility to work from home. The role requires 5+ years of experience or equivalent education/certification, technical skills in SQL Server Production DBA, HA/DR solution implementation, backup/restore solutions planning and implementation, housekeeping procedures, tuning SQL Server databases, table partitioning and archiving mechanisms, Azure or AWS administration, and MS BI Stack (SSRS, SSAS, SSIS) administration. Professional and soft skills required include effective teamwork, strong customer service and interpersonal skills, eligibility to work in the United States, effective verbal and written communication skills, and ITIL practices adherence.

Requirements

• Minimum of 5 years of SQL Server Production DBA experience or equivalent education/certification as a SQL Server DBA in SQL server 2016 or above
• Able to plan and implement an HA/DR solution using Clustering, Log Shipping, Availability Groups, Mirroring, Replication, or other solutions
• Able to recommend, implement, and monitor backup/restore solutions to meet customer SLAs and recommend SLAs where they don’t exist
• Able to implement and support housekeeping procedures such as backups, integrity checking, index maintenance
• Able to tune SQL Server databases. This includes the use of T-SQL, Profiler/Extended Events, Indexing, Statistics, Query Plan Analysis, Query Store
• Able to read, write, and troubleshoot TSQL to support production environments
• Able to provide Database Administration for SQL Server installations including capacity planning, installing, upgrading, configuration and patching, and all functions to provide high availability, high performance, and high security
• Working and practical knowledge of table partitioning and archiving mechanisms
• Demonstrated Production Database Administration experience in Azure (preferred) or AWS including ability to: Implement a secure environment, Monitor and optimize operational resources, Optimize query performance, Perform automation of tasks using automation, Plan and implement a High Availability and Disaster Recovery (HADR) environment, Perform administration by using T-SQL
• Able to install and administer the MS BI Stack (SSRS, SSAS, SSIS) in a production environment

Responsibilities

• Provide operational database management tasks for select customers
• Perform day-to-day duties for proper database maintenance and proactive measures to maximize the database security, availability, and performance

Preferred Qualifications

• Additional experience in SQL Server Development DBA
• Experience with Developing for the Microsoft BI Stack (SSIS, SSRS, SSAS) and/or PowerBI
• Experience with Server admin, network, and virtualization
• Ability to produce and maintenance of high-quality documentation
• Ability to Migrate data to/from multiple data sources using SSIS, PowerShell, or similar tools meeting customer SLAs

Benefits

Flexibility to work from a home office a majority of the time with occasional visits to customer locations