Search Jobs
Find your next opportunity here.
The Panther Group
https://www.thepanthergrp.com/wp-content/uploads/2022/03/sm-logo-200x200-1.png
https://www.thepanthergrp.com
https://www.thepanthergrp.com
USD
92.59
HOUR
true
Talyn Scarbrough
PostgreSQL DBA
Posted: 06/19/2024
2024-06-19
2024-10-11
Employment Type:
Contract To Hire
Job Number: 42082
Pay Rate: 92.59
Job Description
PostgreSQL DBA
The Panther Group is actively seeking a passionate, driven Senior, Database Engineer to provide operational support for a well known client within the insurance industry's database systems, design and build database systems using automation in both data center and cloud platforms, including identifying build defects and create self-healing routines.
You have
In-depth knowledge and troubleshooting skills in the following:
Must have skills:
•            10+ years of PostgreSQL DBA experience
•            PostgreSQL replication experience
•            SQL coding and tuning experience
•            Shell scripting and automation experience
•            PostgreSQL PGAdmin client connectivity tool experience
•            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 experience
•            Strong troubleshooting/performance tuning skills
•            Ability to assess and improve SQL performance
•            Understanding of PostgreSQL’s underlying storage engines
•            Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
•            Profile server resource usage, optimize and tweak as necessary
•            Expert level PostgreSQL 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 supervisory direction
•            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 or any other monitoring tool, 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, cron, or other techniques
•            Experience in DB2 UDB, Oracle, MySQL, Microsoft SQL Server, MongoDB, 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
You will:
•            Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes
•            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 fulfil 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
Location: Bethlehem, PA or Holmdel, NJ. Local candidates preferred. The Database Service is scheduled to work Monday through Friday 8:00 AM ET till 5:00 PM ET. Currently candidates are working 3-days remote and 2-days in the office -operate on a 24x7x365 using an on-call rotation which the candidate will be a part of.
The Panther Group is actively seeking a passionate, driven Senior, Database Engineer to provide operational support for a well known client within the insurance industry's database systems, design and build database systems using automation in both data center and cloud platforms, including identifying build defects and create self-healing routines.
You have
In-depth knowledge and troubleshooting skills in the following:
Must have skills:
•            10+ years of PostgreSQL DBA experience
•            PostgreSQL replication experience
•            SQL coding and tuning experience
•            Shell scripting and automation experience
•            PostgreSQL PGAdmin client connectivity tool experience
•            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 experience
•            Strong troubleshooting/performance tuning skills
•            Ability to assess and improve SQL performance
•            Understanding of PostgreSQL’s underlying storage engines
•            Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
•            Profile server resource usage, optimize and tweak as necessary
•            Expert level PostgreSQL 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 supervisory direction
•            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 or any other monitoring tool, 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, cron, or other techniques
•            Experience in DB2 UDB, Oracle, MySQL, Microsoft SQL Server, MongoDB, 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
You will:
•            Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes
•            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 fulfil 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
Location: Bethlehem, PA or Holmdel, NJ. Local candidates preferred. The Database Service is scheduled to work Monday through Friday 8:00 AM ET till 5:00 PM ET. Currently candidates are working 3-days remote and 2-days in the office -operate on a 24x7x365 using an on-call rotation which the candidate will be a part of.
Meet Your Recruiter
Talyn Scarbrough
Staffing Manager
I am an IT staffing specialist with 5+ years of experience between both recruiting and sales in STEM environments. I am focused on the candidate experience while finding the win-win situations matching candidates with the right opportunity for their career.
Fun Fact: I'm an avid Pittsburgh Steelers fan!
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Bethlehem, PA
Ready to kickstart your career in the charming city of Bethlehem, Pennsylvania? This vibrant area nestled in the Lehigh Valley boasts a rich history, a thriving arts scene with galleries like the Banana Factory Arts Center, Sands Bethlehem Event Center for live performances, and the captivating architecture of the Moravian Historic District. With delectable dining options ranging from iconic cheesesteaks to local craft breweries, there's something for every palate. Explore job opportunities near popular sites like the SteelStacks entertainment complex or enjoy outdoor adventures at the picturesque Jacobsburg State Park. Join us in Bethlehem and discover endless growth possibilities in a community that blends culture, history, and opportunity seamlessly. Explore our job listings today to find your perfect fit!
