Microsoft SQL DBA

Must have skills:

10+ years of MS SQL Server DBA experience

MS SQL Server replication, always on, and mirroring experience

SQL coding and tuning experience

Power Shell scripting and automation experience

SQL Server Management Studio experience

Working knowledge of SSIS and SSRS

AWS/Cloud Services experience: EC2, RDS, and Aurora Cloud deployments experience: Jenkins, Bitbucket, Terraform

Hands-on, technically adept DBA, capable of performing required DB tasks

Strong troubleshooting/performance tuning skills

Ability to assess and improve SQL performance

Understanding of MS SQL Server underlying storage engine

Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

Profile server resource usage, optimize and tweak as necessary

Expert level MS SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in large and very dynamic environments

Strong commitment to following SDLC/Change-Management principles

Self-starter and be able to perform work with minimal supervision

Knowledge of data quality, data management, and data testing strategies and practices

Strong communication skills, both oral and written

Strong experience working with ticketing tools such as ServiceNow, Zenoss, Foglight, or other monitoring tools, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool)

Strong problem-solving and troubleshooting skills

Keen analytical and structured approach to problem solving

Ability to accommodate flexible work schedules

Desired skills:

Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers)

Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, or other techniques

Secondary experience in DB2 UDB, Oracle, Postgres, MySQL, and/or Cassandra is plus

Experience with configuration management tools: SCCM; Puppet; or Ansible.

Development or enhancement of training and upskilling programs

Bachelor's Degree or similar required