Senior Database Administrator

Chicago, IL, United States

Senior Database AdministratorRemote - United StatesJR010399

Join a business that embraces innovation, gives you the scope to seize every opportunity and help get you where you want to go. Life at Ensono begins in an unprecedented environment with a role that matters, taking you on a fast-paced journey of discovery, however big that might be.

At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things! We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with cross-platform certifications, Ensono empowers our clients to keep up with continuous change and embrace innovation.

We can Do Great Things because we have great Associates. The Ensono Core Values unify our diverse talents and are woven into how we do business. Honesty, reliability, curiosity, collaboration, and passion are the key to achieving our purpose.

Job Description

Reports to the US Database manager. You’ll be part of Global Implementation & Operational team, supporting the Operational & migration activities of mission critical infrastructure of Ensono’s clients, delivering a responsive and exceptional support service for client events and requests. We are looking for a Senior SQL Server DBA who can bring strong expertise to join our team as a dedicated resource for a key client. The job entails:

Primary role will be to support our existing key client.

Working with clients on issues, requests related to Projects.

Working proactively and reviewing high level project requirements and deliverables.

Lead & guide the team during major incidents & Outages.

Automation of DBA best practices and collection process.

You will achieve common goals with our teams to create a positive learning environment where knowledge sharing will help all associates be able to support the environment. The position will be challenging with opportunities to work on a broad range of Cloud technologies and products.

Key Responsibilities

Design and enhance, upgrade, or build new client MSSQL environments.

Work closely with clients daily on projects, troubleshooting, or consultations.

Perform software installations, upgrades, and patches to MSSQL instances and servers

Define and maintain MSSQL standards and governance

Utilize industry standard technologies& methods to ensure the integrity & recoverability of MSSQL applications.

Perform strategic analysis and design of MSSQL infrastructure and make recommendations on improvements and/or new systems required to meet business needs and future capacity.

Serve as technical resource to business analysts, solutions development, and other groups responsible for MSSQL application development standards, system design and integration.

Ensure MSSQL systems remain at operational excellence during infrastructure improvements (hardware/software upgrades server migrations/consolidations, application deployment, etc.).

Assist in creating new or maintaining documentation, runbooks knowledge articles and diagrams.

Assist with major issues, technical challenges, and troubleshooting, serving as an escalation point for complex problems.

Facilitate open communication and collaboration between our ops DBA team and the client, ensuring alignment and effective problem-solving.

Knowledge

Required

Excellent understanding of SQL Server Technology (builds, upgrades, patching, migrations, troubleshooting multiple versions of SQL Server)

Experience with automation using PowerShell or a scripting language is a must.

Experience of SQL Server database administration in versions ranging from 2008 to current versions.

Experience of configuring and administering log shipping, mirroring, clustering and Always On availability groups.

Experience with SQL Transaction replication on complex environments.

Experience with SQL Performance Tuning and identifying the bottleneck.

Experience in migrating server databases from on-premises environments to the public/private cloud.

Knowledge of other Database technologies such as Postgres or cloud native databases is desirable.

Excellent understanding of VMware and awareness of Cloud technology

Excellent technical awareness of IT server infrastructure

Working knowledge of tools, Ansible, Chef, Terraform, Python, Salt, Shavlik is desirable.

Must have excellent communication skills since working directly with the client is a significant requirement of this position.

Must have deep understanding of AWS & Azure technologies related to SQL Server.

Desired

Netbackup, Commvault, Idera SQL Diagnostic manager

Knowledge of the ITIL framework

Skills

Ability to work independently, analyze the requirement, and provide solutions.

A ‘client centric’ approach

Excellent demonstrable English written and verbal communication skills

Able to communicate in groups with confidence and conviction

Ability to multi-task and work well under pressure

Excellent team working skills are essential

Ability to document processes and procedures in a clear, concise, and logical manner

Self-starter with the capability to work independently and produce positive results that will keep migration timelines on schedule

Experience

At least 7-10 years’ experience in an IT MSSQL support environment

Why Ensono?

Ensono is a place to make better happen – for our clients and for your career. You can do great things through innovation or collaboration, by learning or volunteering, or to promote diversity and inclusion. You can do great things for your own health or for a healthier planet. Whatever it means to you to do great things we want Ensono to be the place you can do it.

We are a client-facing business, but we do encourage clients to allow us to work remotely most of the time so if you are not required to be on client site, you can choose to work from home or in our Ensono offices.

Unlimited Paid Days Off

Two health plan options through Blue Cross Blue Shield

401k with company match

Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts

Depending on location, ability to take advantage of fitness centers

Wellness program

Flexible work schedule

Ensono is an Equal Opportunity/Affirmative Action employer. We are committed to providing equal employment to our Associates and building a diverse and inclusive workforce. All qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or other legally protected basis, in accordance with applicable law.

Pay transparency nondiscrimination statement/posting OFCCP’s pay transparency policy can be found onOFCCP’s website (https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf) .

If you need accommodation at any point during the application or interview process, please let your recruiter know or email [email protected] .

.

JR010399