Job description

Position: Slalom Flex (Project Based) - Senior SQL Server Database Administrator Role: Slalom Flex (Project Based) - Senior SQL Server Database Administrator Location: Remote, Local to Denver Metro Area or ability to support MST hours Who You'll Work With At Slalom, personal connection meets global scale. Our vision is to enable a world in which everyone loves their work and life. We help organizations of all kinds redefine what's possible, give shape to the future-and get there. The CMS Content Author will help deliver and implement the companies broader goals. What You'll DoSupport application owners with the migration of their on-prem SQL Server databases to new domain on new or existing shared infrastructure Use questionnaires and/or conduct interviews with app owners to determine requirements and opportunities for rehosting including decommission, rehost on-prem (new or existing shared infrastructure), cloud migration using Azure (first choice) or AWS IaaS (Infrastructure as a Service), SQLMI (SQL Managed Instance), or RDS (Remote Desktop Services) Identify and convert all service accounts (SQL Server or Domain) and RBAC (Role Based Access Control) AD (Active Directory) groups to new domain while incorporating latest RBAC best practices and naming conventions Configure database replication, linked servers, and Availability Groups (AG) as required Plan and build new SQL Server infrastructure as required including: Infrastructure resource planning (CPU, Memory, Storage) and documentation in conjunction with migration plan Expand server resources to accommodate adding databases to existing shared SQL Server instances or Azure SQLMIPlan, install, and configure new SQL Server named instances on new or existing virtual servers to include Windows Server Failover Clustering and SQL Clustered Instances following established processes and best practices Planning, installing, and configuring new Azure SQLMI following established processes IAC (Infrastructure As Code) and best practices Decommission of legacy databases, RBAC, and infrastructure while maintaining documentation following established processes and procedures Support all aspects of SQL Server database infrastructure in conjunction with application migration plans to include application and/or database upgrades or significant changes related to AOAG (Always On Availability Group), or cloud migration Attend and participate in regular status and planning meetings What You'll Bring Minimum 5-7 years' experience as a SQL Server DBAMinimum 5 years' experience with SQL migration Experience with migration to on-premises environment Deep knowledge of nuances of resource configurations Deep experience with SQL server installations and migrations Excellent organizational and time-management skills Excellent communication skills About UsSlalom is a fiercely human business and technology consulting company that leads with outcomes to bring more value, in all ways, always. From strategy through delivery, our agile teams across 52 offices in 12 countries collaborate with clients to bring powerful customer experiences, innovative ways of working, and new products and services to life. We are trusted by leaders across the Global 1000, many successful enterprise and mid-market companies, and 500+ public sector organizations to improve operations, drive growth, and create value. At Slalom, we believe that together, we can move faster, dream bigger, and build better tomorrows for all. Compensation and Benefits Slalom prides itself on helping team members thrive in their work and life. As a result, Slalom is proud to invest in benefits that include meaningful time off and paid holidays, parental leave, 401(k) with a match, a range of choices for highly subsidized health, dental, & vision coverage, adoption and fertility assistance, and short/long-term disability. We also offer yearly $350 reimbursement account for any well-being-related expenses, as well as discounted home, auto, and pet insurance. Slalom is committed to fair and equitable compensation practices. For this position, the hourly pay range is $80 to $95/HR depending on experience. Actual compensation will depend upon an individual's skills, experience, qualifications, location, and other relevant factors. The hourly pay range is subject to change and may be modified at any time. EEO and Accommodations Slalom is an equal opportunity employer and is committed to inclusion, diversity, and equity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veterans' status, or any other characteristic protected by federal, state, or local laws. Slalom will also consider qualified applications with criminal histories, consistent with legal requirements. Slalom welcomes and encourages applications from individuals with disabilities. Reasonable accommodations are available for candidates during all aspects of the selection process. Please advise the talent acquisition team if you require…

Requirements