Senior, App DBA – IT Infrastructure Services

About Ensono

Ensono, Inc is a Delaware corporation incorporated in 2015 and located in Downers Grove, Illinois. Ensono, Inc provides infrastructure management services that help clients address their current needs, while engineering IT solutions for the ever-changing demands of tomorrow. From current platforms to evolving technologies, we deliver results for our clients by flawlessly executing infrastructure operations so our clients can focus on what they do best. Our infrastructure management services increase security and performance while reducing total cost of ownership by an average of 15 percent. Ensono, Inc has more than 46 years of experience managing business complexity, distinguishing us from our competitors. We have managed hundreds of complex migrations and have designed solutions that address a wide range of challenges that companies are facing today. We adapt to and work seamlessly within our clients' culture and value the expertise of their employees. Our collaborative approach to meeting our clients' challenges keeps them with us for an average of 10 years.  We are ranked by Information Week 500 for our technology innovation and by the Uptime Institute for 100% availability. We are headquartered in Downers Grove, Illinois and currently have 2,100 associates.

About the role

We want all new Associates to succeed in their roles at Ensono. That's why we've outlined the job requirements below. To be considered for this role, it's important that you meet all Required Qualifications. If you do not meet all of the Preferred Qualifications, we still encourage you to apply. 

Job Description

Reports to the 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

• Monitor database performance and conduct tuning activities (e.g., indexing, query optimization).

• Performance Tuning - Perform health checks and capacity planning, optimize SQL queries and stored procedures, implement indexing strategies and resource monitoring.

• 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.

Required Skills

• 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 in complex environments.

• Performance Tuning: Deep understanding of query optimization, indexing strategies, and execution plans.

• Schema Design: Experience in logical and physical database design for enterprise applications.

• Monitoring & Troubleshooting: Hands-on experience with tools like OEM, SQL Profiler, pgAdmin, etc.

• Experience with SQL Performance Tuning and identifying the bottleneck.

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

• Excellent understanding of VMware and awareness of Cloud technology

• Excellent technical awareness of IT server infrastructure

• Working knowledge of tools, Ansible, Ivanti, Python.

• 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 Skills

• Experience in Powerbuilder & Powerdesigner preferable, or similar technologies.

• NetBackup/Commvault, SQL Sentry, Terraform.

• BMC Topaz Workbench or other data obfuscation tools.

• 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

• Bachelor’s degree in Computer Science, Information Technology, or related field.

• 8–15+ years of experience in SQL Server database administration.