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.
