Software Guidance and Assistance, Inc.
MS SQL DBA
Software Guidance and Assistance, Inc., Bethlehem, Pennsylvania, United States, 18020
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 supportPerform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root causeProcess all support requests within SLA by following procedural requirementsEscalate to vendors, where necessary, to ensure timely resolutionThoroughly document steps taken to resolve incidents and fulfill catalog requests within ServiceNow ticketsDevelop, document, and update standard operating procedures and knowledgebase articlesIdentify, address, and resolve repeating alert trends to improve stability and performanceSuggest defects and product/infrastructure enhancements to improve stability and automationParticipation in periodic skills enhancement sessions and training coursesBe 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 required10+ years of MS SQL Server DBA experienceMS SQL Server replication, always on, and mirroring experienceSQL coding and tuning experiencePower Shell scripting and automation experienceSQL Server Management Studio experienceWorking knowledge of SSIS and SSRSWS/Cloud Services experience: EC2, RDS, and Aurora Cloud deployments experience: Jenkins, Bitbucket, TerraformHands-on, technically adept DBA, capable of performing required DB tasksStrong troubleshooting/performance tuning skillsbility to assess and improve SQL performanceUnderstanding of MS SQL Server underlying storage enginebility to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.Profile server resource usage, optimize and tweak as necessaryExpert 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 environmentsStrong commitment to following SDLC/Change-Management principlesSelf-starter and be able to perform work with minimal supervisionKnowledge of data quality, data management, and data testing strategies and practicesStrong communication skills, both oral and writtenStrong 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 skillsKeen analytical and structured approach to problem solvingbility to accommodate flexible work schedulesPreferred
Skills :
bility to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers)bility to implement automation to reduce manual administrative tasks through use of jobs, scripts, or other techniquesExperience in DB2 UDB, Oracle, Postgres, MySQL, and/or Cassandra is plusExperience with configuration management tools: SCCM; Puppet; or Ansible.Development or enhancement of training and upskilling programsSGA 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 https://sgainc.com/ .
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 EEO page to request an accommodation or assistance regarding our policy
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 supportPerform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root causeProcess all support requests within SLA by following procedural requirementsEscalate to vendors, where necessary, to ensure timely resolutionThoroughly document steps taken to resolve incidents and fulfill catalog requests within ServiceNow ticketsDevelop, document, and update standard operating procedures and knowledgebase articlesIdentify, address, and resolve repeating alert trends to improve stability and performanceSuggest defects and product/infrastructure enhancements to improve stability and automationParticipation in periodic skills enhancement sessions and training coursesBe 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 required10+ years of MS SQL Server DBA experienceMS SQL Server replication, always on, and mirroring experienceSQL coding and tuning experiencePower Shell scripting and automation experienceSQL Server Management Studio experienceWorking knowledge of SSIS and SSRSWS/Cloud Services experience: EC2, RDS, and Aurora Cloud deployments experience: Jenkins, Bitbucket, TerraformHands-on, technically adept DBA, capable of performing required DB tasksStrong troubleshooting/performance tuning skillsbility to assess and improve SQL performanceUnderstanding of MS SQL Server underlying storage enginebility to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.Profile server resource usage, optimize and tweak as necessaryExpert 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 environmentsStrong commitment to following SDLC/Change-Management principlesSelf-starter and be able to perform work with minimal supervisionKnowledge of data quality, data management, and data testing strategies and practicesStrong communication skills, both oral and writtenStrong 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 skillsKeen analytical and structured approach to problem solvingbility to accommodate flexible work schedulesPreferred
Skills :
bility to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers)bility to implement automation to reduce manual administrative tasks through use of jobs, scripts, or other techniquesExperience in DB2 UDB, Oracle, Postgres, MySQL, and/or Cassandra is plusExperience with configuration management tools: SCCM; Puppet; or Ansible.Development or enhancement of training and upskilling programsSGA 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 https://sgainc.com/ .
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 EEO page to request an accommodation or assistance regarding our policy