Database Engineer Lead 1

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM. RSM has an opportunity for a highly motivated Lead Database Reliability Engineer (DRE) who has a passion for orchestrating site resiliency and DRE/SRE standards/technologies. You will work alongside our top-notch IT professionals supporting RSM’s modern information technology infrastructure and data platform. You’ll be a leading member of a team who is responsible for the performance and reliability of data systems across datacenter and cloud solutions You will be expected to identify, design, and implement internal process improvements to automate manual processes, improve application performance, and optimize data delivery. You’ll be responsible for building and optimizing SQL processes to support data transformation, data structures, metadata, dependency, and workload management. Outside of your team, you’ll collaborate with other engineering and development teams to build tools, applications, and services that improve our ability to provide reliable and performant services.You’ll be challenged to create innovative solutions to legacy and cloud compute as well as new concepts, ideas, and continuous process improvement. You will demonstrate and maintain high standards while fostering a proactive, efficient, and service-oriented work environment.Communication and professionalism are paramount as you will be representing RSM Technical Services to effectively engage with technical and business leadership, as well as external providers of IT services. You will also use all your abilities to explain solutions and complex issues while demonstrating the ability to lead and impart knowledge effectively to other team members. Provide subject matter expertise (SME) for the design, configuration, support, and maintenance of data platforms. Identifies changes to product architecture from the reliability, performance and availability perspective with a data driven approach focused on relational databases. Implements SRE/DevOps standards for data technologies and continually improves upon these processes and technologies. Design, implement and automate continuous integrations pipelines for major data technologies in a templatized IaC format for reusability across the Enterprise, utilizing market leading IaC tools, services, and technologies. Monitors and manages system health, functionality and availability related to database and other related data services. Install, configure, secure, and maintain multi-tiered environments across multiple regions. Develop and implement technical standards, procedures, and techniques for the resolution of Enterprise IT system problems to ensure maximum application availability and performance. Participates in scheduled and unscheduled weekend/after-hours system maintenance and support using established change management procedures.Performs rotational on-call duty. Other duties as assigned. EDUCATION/CERTIFICATIONS Preferred: Bachelor's degree in computer science, Software Engineering, Information Systems, equivalent work history/experience or working towards achieving a degree TECHNICAL SKILLS Advanced knowledge Azure and On-Prem SQL Server - Required Troubleshooting of complex distributed environments - Required Management of Public Cloud Offerings (IaaS, SaaS, PaaS, ADO) – Required Advanced Scripting Skills (PowerShell, Terraform, C#, .NET) - Required Proficient with SQL Performance Tuning and System Optimization - Required Data Technology Platform Monitoring experience – Required Strong background with Data Warehousing, and Operational Data Stores - Preferred Working knowledge of Azure DevOps – Preferred 3rd Party Tools (Veeam, ServiceNow, Teams, and MS SCOM) - Preferred EXPERIENCE 9+ years of MS SQL DBA experience - Required 6+ Experience with Public Cloud Solutions (Azure) – Required 2+ year of experience as lead SQL DBA on moderate to large projects - Required ETL Development, and support experience using SSIS and ADF– Required Proven experience with development languages (T-SQL, PowerShell,) - Required Strong unstructured Data Technology experience i.e., Cosmos DB, Mongo, Data Bricks - Preferred Experience with and using Infrastructure as Code technologies – Preferred Experience with IT audit standards - SOC II, and ISQM – Preferred. LEADERSHIP/SOFT SKILLS Experience in team collaboration – Required Excellent written and oral presentation skills – Required Exceptional analytical and process development skills – Required Experience managing multiple priorities and projects - Required At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at . RSM does not tolerate discrimination and/or harassment based on race; colour; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the in the Indian Armed Forces; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation.  Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please send us an email at .