Company:
SGA Inc.
Location: Bethlehem
Closing Date: 22/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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 24x7x365 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
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
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 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
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy
Responsibilities :
Be part of an on-call rotation providing 24x7x365 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
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
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 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
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy