Sr. SQL DBA

Sr. SQL DBA

The Senior Database Administrator is responsible for setup, support & management of SQL Server Databases in production, test & development environments. The candidate will be responsible for creation and administration of SQL Server 2012, 2014, 2016, 2017, 2019, and 2022 databases in standalone, mirrored, clustered, and AlwaysOn environments. He/she must have substantial hands-on technical experience in addition to strong conceptual knowledge about SQL Server database and underlying architecture and fundamentals. Duties and responsibilities are focused on database management and administration, including infrastructure strategy, design, deployment, monitoring and maintenance of database systems.

Essential Duties and Responsibilities:

• Implement industry best practices for consistent modularized installation and configuration for production and non-production environments, including self-service options to service teams using a DevOps mindset and principles.
• Identify cost saving opportunities surrounding compute, storage, and other cloud resources.
• Troubleshoot, track, and resolve complex database issues, identify recurring problems, and apply fixes.
• Collaborate with key stakeholders to gather requirements and engineer solutions that meet business needs.
• Install, configure, and document high availability and business continuity solutions as per business requirements.
• Implement sound backup and recovery policies and procedures using cloud based backup solutions.
• Monitor production database systems and proactively mitigate performance and configuration issues.
• Lead the database deployments, tech upgrades, and approved changes.
• May provide guidance, coaching, and training to other employees within job area.

Install SQL Server 2016, 2017, 2019, and 2022 databases

• Support SQL Server 2012, 2014 2016, 2017, 2019, and 2022 databases
• Write and optimize T-SQL
• Setup and support AWS RDS/Azure SQL instances
• Build and support database replication using mirroring, clustering, log shipping, and AlwaysOn
• Establish and maintain sound backup and recovery policies and procedures using SQL Server maintenance plans
• Adhere and improve "best practices" documentation
• Perform health checks and proactive monitoring
• Establishes and enforces all database standards and integrity
• Be online during normal working hours and provide occasional after hours 24x7 support.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Effectively demonstrate on performance analysis, tuning & improvements of SQL Server database based application systems
• Install and support SQL Server Reporting Services
• Install and support SQL Services Integration Services
• Database security and hardening (TDE, encryption in transit, etc), knowledge of TLS a big plus

Minimum Requirements:

Bachelor's degree in relevant field of study and 5+ years of relevant professional experience required, or equivalent combination of education and experience. Bachelor's degree from an accredited college or university in Engineering or Computer Science or equivalent experience. AWS Cloud Practitioner certification required or obtainable within 3 months of hire. Experience required - 10+ years SQL Server administration supporting a production environment; SQL Server Reporting Services; SQL Server Integration Services; Troubleshooting SQL Server database issues; Experience in code migration, database change management and data management through the various stages of the development life cycle; Ability to write complex T-SQL scripts; Transparent Database Encryption implementation; Demonstrated experience in development of long-term database strategies for the enterprise environment to stay current with technology and provide the required functionality to the organization and as well as adherence to Change Control procedures and policies; Technically enthusiastic and willing to learn attitude is required; Familiarity with large IT budgeted projects, data center migration efforts, and designing disaster recovery procedures. 2+ years AWS RDS/Azure SQL. Nice to have Experience with SQL Server Analysis Services, Druva backup application, and Splunk

Pay Transparency:

Maximus compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of Maximus's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, Maximus provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. Maximus will comply with regulatory minimum wage rates and exempt salary thresholds in all instances.

Minimum Salary: $102,720.00

Maximum Salary: $154,080.00