Senior SQL Database Administrator

Ensono

4h•$95,000 - $148,000

About The Position

You will 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. · 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.

Requirements

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.

Nice To Haves

Netbackup, Commvault, Idera SQL Diagnostic manager
Knowledge of the ITIL framework
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

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.

Benefits

Unlimited Paid Days Off
Three health plan options
401k with company match
Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts
Family Forming Benefit including fertility coverage and adoption/surrogacy reimbursement
Paid childbearing and paternal leave
Education Reimbursement, Student Loan Assistance or 529 College Funding
Sabbatical leave
Wellness program
Flexible work schedule