Ensono

Senior SQL Database Administrator

Ensono

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $95,000 - $148,000 per year

Job Level

About the role

  • 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.
  • 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.
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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL ServerPowerShelldatabase administrationlog shippingmirroringclusteringAlways On availability groupsSQL Transaction replicationSQL Performance Tuningmigration to cloud
Soft Skills
communicationleadershipproactive problem solvingteam guidance