PostgreSQL Database Administrator Job at Insight Global, King of Prussia, PA

Wm15YTRMZnU3eXA0dTJjWWh0N3kwY2MyT2c9PQ==
  • Insight Global
  • King of Prussia, PA

Job Description

Job Description: The database performance engineer is responsible for setting up database performance monitoring across various database in the org including structured and unstructured databases.

- Analyze all the applicable database performance monitoring tool that’s available for workload, throughput, resources, optimization, and contention in the market and pick the right one fits our environment and approved by the security team

- Understand our application and platform use cases thoroughly before making the selection of the database performance monitoring tool.

- If non-available in the market that satisfies the requirement of performance monitoring our databases, then come up with a plan to build one in-house with approved tools.

- Set best practices for database performance engineering and monitoring for all the database in the org

- Set thresholds and alerting based on the various performance metrics and document the corresponding actions in detail for the rest of the team to follow.

- Set anomaly detection in all the databases, which might cause abrupt performance impact in production and detail the steps the resolve the same.

- Once have everything in place , start training the DBA’s and other data engineers in the team to use the third-party tool or the custom-built tool in detail.

- Once the DBA’s and data engineers are fully trained, shadow support the team for minimum 3 months to complete the full transition of this role to the existing team.

Required Skills and Experience:

• At least 6+ years of experience in database performance tuning on PostgreSQL, MySQL, Oracle & Couchbase.

• Skills: In depth database (MySQL, Postgres) experience on workload, throughput, resources, optimization, and contention.

• Troubleshooting: Strong troubleshooting skills and the ability to chase down complex issues. Anomaly detection techniques

• Passion: A genuine interest in solving challenging performance problems.

Salary: $125,000/year to $135,000/year.

Job Tags

Similar Jobs

K.A. Recruiting, Inc.

Psych Nurse Practitioner Job at K.A. Recruiting, Inc.

PSYCH NP NEEDED AT LARGE HOSPITAL LOCATED IN BEAUTIFUL AREA WHERE OUTDOOR RECREATION IS PLENTIFUL! We are looking for an APRN or Nurse Practitioner for this hospital employed, fulltime opportunity. The position will consist of 80% outpatient therapy new evaluations, follow... 

GHR Healthcare

Travel Nurse RN - Psychiatric - $2,214 per week Job at GHR Healthcare

 ...Job Description GHR Healthcare is seeking a travel nurse RN Psychiatric for a travel nursing job in Harrisburg, Pennsylvania. Job Description & Requirements ~ Specialty: Psychiatric ~ Discipline: RN ~ Start Date: 01/20/2025~ Duration: 13 weeks ~36 hours... 

Illumia

Advanced Palliative Care Nurse Specialist (Hiring Immediately) Job at Illumia

 ...growing part of Gentiva, an industry leader in hospice and palliative care. Our clinical teams serve as an extension of physicians care,...  ...in private homes, assisted living facilities, and skilled nursing facilities They provide education to patients and families and work... 

Social Capital Resources

AML Analyst Job at Social Capital Resources

 ...Bank in Midtown, Manhattan is seeking a BSA / AML Analyst for a long-term, temp-to-perm assignment. Responsibilities: Conduct high risk customer EDD reviews and assess potential suspicious activity Review and clear alerts generated by OFAC watchlist screening... 

Gunner

Finance Internship (Summer 2025) Job at Gunner

 ...motivated and talented individuals to join our 8-week summer internship program. As an intern with Gunner, you will gain practical experience...  ...development, preparing you for a fulfilling career. As a Finance Intern, you will work closely with our finance team,...