MICROSOFT SQL DBA

Company: Trident Consulting
Location: Holmdel
Posted on: September 25, 2024

Job Description:

Trident Consulting is seeking a Microsoft SQL DBA for one of our clients in Bethlehem, PA / Holmdel, NJ - Hybrid. A global leader in business and technology services.

Role: Microsoft SQL DBA

Location: Bethlehem, PA / Holmdel, NJ - Hybrid

Type: Contract to Hire

About the Client:

Our client is a prominent company in the insurance sector, dedicated to providing innovative and reliable insurance solutions to their customers. As part of our team, you'll have the opportunity to support and optimize critical database systems that are integral to their operations and customer satisfaction.

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

About Trident:

Trident Consulting is an award-winning IT/engineering staffing company founded in 2005 and headquartered in San Ramon, CA. We specialize in placing high-quality vetted technology and engineering professionals in contract and full-time roles. Trident's commitment is to deliver the best and brightest individuals in the industry for our clients' toughest requirements.

Some of our recent awards include:
--- 2022, 2021, 2020 Inc. 5000 fastest-growing private companies in America
--- 2022, 2021 SF Business Times 100 fastest-growing private companies in Bay Area

Keywords: Trident Consulting, East Brunswick , MICROSOFT SQL DBA, IT / Software / Systems , Holmdel, New Jersey