Senior SQL Server DBA

• Expert level performance tuning is required.
• Expert knowledge of infrastructure best practices.
• Expert knowledge of indexing best practices
• Able to switch between OLTP and OLAP environments
• Bachelor's degree in engineering and/or related experience of 15+ years as DBA
• Azure Certification is a Plus
• Experience in multiple cloud offerings a plus
• Experience building and utilizing various High Availability (HA) and Disaster Recovery (DR)
• options for SQL Server.
• Experience with multiple database platforms a plus: MySQL, SQL Server, Oracle, Postgres,
• MongoDB, CosmosDB, MariaDB.
• The applicant will need to have a deep understanding of integrated security and be able to
• participate in troubleshooting activities.
• The ability to discuss database related topics with both technical & business audiences.
• Troubleshoot, investigate, offer and execute resolution to database issues.
• Monitor and report on database storage utilization.
• Experience with data warehousing, data access accountability.
• Experience writing T-SQL and the ability to understand what others have developed.
• Monitor, tune and manage scheduled tasks, backup jobs, recover processes, alerts, and
• database storage needs in line with firm change control procedures.
• Perform fault diagnosis, troubleshoot and correct problems at the database and application performance level.
• Work well in a team environment within the database administration team as well as with other Technical Service Group teams and other departments within the Wolters Kluwer.
• Provide regular reports on performance and stability of database environment, identifying coming needs proactively to ensure continued reliable service.
• Work with other teams and departments architecting database backend to support new solutions as required for project and operational tasks.
• Document, develop, test and implement updates to database systems.
• Enjoy constantly learning new technologies and contributing to the knowledge of others.
• Work outside of regular business hours as required for project or operational work.

Experience

• Experienced Database professional with over 5+ years of experience in Database Administration, System Analysis, design, support of database systems.
• Ability to manage high availability solutions.
• Experienced in building cloud servers and configuring health check monitoring using PowerShell
• integration using cloud schedulers through portals.
• Automation using PowerShell scripts.
• Extensive experience with all aspects of setup, maintenance, troubleshooting, performance
• tuning and optimization, capacity management, monitoring, load testing, and security, including, encryption, and HADR options, such as Always On availability groups, mirroring, log shipping,VM replication, as well as robust backup and restore plans using SQL Server native tools and other third-party solutions.
• Experienced in Upgrade/Migration of database platforms of On-Prem to cloud solutions.
• Self-motivated, with the proven ability to work independently.
• Take ownership of and proactively seek to improve on existing systems.
• Develop automation for both repetitive or unique and complex tasks to reduce overhead and increase reliability.
• Have developed several systems to monitor capacity, audit security, capture events to a database, etc., using a variety of database tools.
• Experience in Installation, configuration and upgrades of Servers.
• Monitor, optimize and report on system performance.
• Experience with Failover clustering and SAN replication.
• Experience with transactional replication.
• Experience with Cognos/Analysis Services, Integration Services/Muelsoft/Informatica, or PowerBI/Reporting Services a plus.
• Experience developing, managing and testing back-up and recovery plans.
• Experience with code migration of all objects following established change control procedures.

Technical Skillsets

• Solid Database Administration.
• Building cloud model servers end to end a plus.
• On-premises to Cloud DB migrations.
• Automation of regular tasks using PowerShell.
• Performance Tuning & Capacity Monitoring.
• Data Security, Backup & Recovery using native and third-party tools.
• High Availability Groups & Replication.
• SQL Server Stand Alone/Windows Cluster Installation.
• Strong problem-solving skills and a commitment to getting things done right.
• Experience in Performance Tuning and Index Design/Maintenance.
• Expert level understanding design and writing of PowerShell scripts within SQL Server and WMI a plus
• Experience working with Windows server, including Active Directory.
• Excellent written and verbal communication.
• Flexible, team player, “get-it-done” personality.
• Ability to organize and plan work independently.
• Ability to work in a rapidly changing environment.