Ensono
Ensono delivers complete Hybrid IT solutions, from mainframe to cloud, tailored to each client’s journey.
Senior SQL Database Administrator
Location
United States
Posted
3 days ago
Salary
$95K - $148K / year
10 yrs expEnglishAnsibleAWSAzureChefCloudPostgre SQLPythonSalt StackSQLTerraformVmware
Job Description
• 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.
Job 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
