Company:
Trident Consulting
Location: Holmdel
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / 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
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