
Senior SQL Database Administrator
Ensono
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
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