MS SQL DBA

Software Guidance & Assistance, Inc., (SGA), is searching for a MS SQL DBA for a right to hire assignment with one of our premier Insurance services clients in Bethlehem, PA or Holmdel, NJ .

Responsibilities :

• Be part of an on-call rotation providing xx incident and outage response, including non-business hours support
• Perform initial investigation and / or troubleshooting of database and database system issues to resolve issue & determine root cause
• Process all support requests within SLA by following procedural requirements
• Escalate to vendors, where necessary, to ensure timely resolution
• Thoroughly document steps taken to resolve incidents and fulfill catalog requests within ServiceNow tickets
• Develop, document, and update standard operating procedures and knowledgebase articles
• Identify, address, and resolve repeating alert trends to improve stability and performance
• Suggest defects and product / infrastructure enhancements to improve stability and automation
• Participation in periodic skills enhancement sessions and training courses
• Be a project lead, as well as a project participant for various activities : cloud migration, lifecycle management, application modernization, capacity planning, financial optimization, performance, and stability optimization, build and design state configuration automation, etc.

Required Skills :

• Bachelor's Degree or similar required
• 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 : EC, 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

Preferred 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
• Experience in DB 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
30+ days ago