Senior Database Administrator, MS SQL Server

At STERIS, we help our Customers create a healthier and safer world by providing innovative healthcare and life science product and service solutions around the globe.Position SummaryJoin STERIS' global Information Technology team as it provides world class services and support to this growing, market leading company. The Microsoft SQL Server, Senior Database Administrator will be responsible for providing production database operations, ensuring performance and scalability, high availability and disaster recovery, compliance and security of database servers in addition to providing technical leadership within DBA team.You will develop best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, space management, backup and restore, performance monitoring and tuning. You will also recommend physical database design, architecture, and testing of database technologies. identify data sources, construct decomposition diagrams, provide data flow diagrams and document processes.• *This position is located onsite in Mentor, Ohio with the opportunity for a hybrid work schedule. Qualified candidates must relocate or be located within driving distance of Mentor, Ohio.Duties• Manages MS SQL Server databases through multiple product lifecycle environments, from development to mission critical production systems.• Applies data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.• Provides high availability solutions for multiple database configurations.• Uses extensive experience in disaster recovery solutions and best practices to create, maintain, and verify backups using native and 3rd party solutions. Discusses RPO and RTO strategies with business leaders.• Performs advanced performance monitoring and troubleshooting. Creates execution plans, uses database optimizers, and has experience using database-specific monitoring technologies.• Applies a cybersecurity mindset and best practices to secure Database servers. Interacts/guides audit and compliance teams. Uses data security/encryption mechanisms (e.g., TDE, data masking/redacting/subsetting). Hardens database servers based upon security hardening requirements. Assists with security audits from internal and external providers.• Identifies and resolves capacity issues. Regularly monitors/reviews performance metrics to identify trends and future risks in the environment before they happen and works with leadership to get the work prioritized.• Independently analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.• Refines and automates regular processes, tracks issues, and documents changes.• Assists developers with complex query tuning and schema refinement.• Provides 24x7 support for critical production systems. Participates in an On-Call rotation as needed• Performs scheduled maintenance and support release deployment activities after hours.• Shares domain and technical expertise, providing technical mentorship and cross training to other peers and team members.• Installs, configures, patches, and upgrades database servers. Manages on-prem and cloud based (Azure-preferred) database servers and services in PaaS and IaaS cloud solutions.Required Experience• Bachelor’s degree in Computer Science, Information Technology or other related degree along with 5+ years of MS SQL Server Database Administration experience.• In lieu of degree 13+ years of MS SQL Database Administration experience.• Technical knowledge in database development methodologies, design and implementation and basic database administration skills/experience (procedures for change control, test and production release).• Experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools.• Experience with backups, restores and recovery models.• Knowledge of High Availability and Disaster Recovery options for database technologies.• Experience migrating on-prem environments to public cloud (Azure-preferred)• Knowledge of best practices in the areas of application design, performance, security, scalability and maintainabilityWhat STERIS OffersThe opportunity to join a company that will invest in you for the long-term. STERIS couldn’t be where it is today without our incredible people. That’s why we share in our success together by rewarding you for your hard work. Hiring people who are in it for the long run with STERIS is our ultimate goal. We do this by providing competitive salaries, healthcare benefits, tuition assistance, paid-time off, holidays, matching 401(k), annual merit, and incentive plans. Join us and help write our next chapter.#LI-KK1#LI-HybridSTERIS is a leading provider of products and services that meet the needs of growth areas within Healthcare: procedures, devices, vaccines and biologics. We exist to fulfill our MISSION TO HELP OUR CUSTOMERS CREATE A HEALTHIER AND SAFER WORLD. STERIS is a $3B, publicly traded (NYSE: STE) company with approximately 16,000 associates and Customers in more than 100 countries.If you need assistance completing the application process, please call 1 (440) 392.7047. This contact information is for accommodation inquiries only and cannot be used to check application status.STERIS is an Equal Opportunity Employer. We are committed to equal employment opportunity and the use of affirmative action programs to ensure that persons are recruited, hired, trained, transferred and promoted in all job groups regardless of race, color, religion, age, disability, national origin, citizenship status, military or veteran status, sex (including pregnancy, childbirth and related medical conditions), sexual orientation, gender identity, genetic information, and any other category protected by federal, state or local law. We are not only committed to this policy by our status as a federal government contractor, but also we are strongly bound by the principle of equal employment opportunity.The full affirmative action program, absent the data metrics required by § 60-741.44(k), shall be available to all employees and applicants for employment for inspection upon request. The program may be obtained at your location’s HR Office during normal business hours.