• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Senior Database Engineer(PostgreSQL )

In United States

Save this job

Senior Database Engineer(PostgreSQL )   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Senior Database Engineer(PostgreSQL )

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Alpharetta, GA United States

JOB DESCRIPTION:

Summary

 

At Global Payment, We are creatively and disruptively solving some of the most complex database problems related to immense growth,scaling, extremely high performance and high availability requirements. Do these types of challenges excite you?

 

Global Payment is seeking a Senior PostgreSQL Database Engineer within our multi-database Data Engineering Group. The Department is focused on the development and maintenance of various database applications supporting all of the TSYS Issuer solutions Applications. The successful candidate will have considerable and proven experience in database design, development, a good working knowledge of end-user and server-side data processing techniques.The successful candidate will be a self‑starter and conscientious architect capable of building reusable software components.

 

Responsibilities

  • At least 5 years of experience using Python with Postgres.

  • Supporting the community edition PostgreSQL databases throughout the development and production lifecycles in an AWS environment.

  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues.

  • Performance tuning, query optimization, using monitoring and troubleshooting tools.

  • Provide database solution reviews, advice, and solution adjustments for application database requirements.

  • Provide guidance in the creation and modification of standards and procedures.

  • Participate in technical reviews and walkthroughs of system design documentation with development and design team members.

  • Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations.

  • Create, test, and implement scripting for automation support.

  • Troubleshoot and resolve database integrity issues, blocking and deadlocking issues, indexing issues, replication issues, log shipping issues, connectivity issues, security issues, etc.

  • Conduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks.

  • Setup alerting mechanism and monitor for both database and supporting hardware to ensure system health and maximum availability.

  • Identify and resolve incidents and address user problems/concerns.

  • Assess, evaluate and provide resolution for database performance problems

  • Document procedures for build, test, update, and upgrading RDS Postgres database environments.

  • Provide backup and recovery functions for PostgreSQL RDS environments.

  • Create, document, and test backup and recovery procedures including Operational and Disaster Recovery scenarios

  • Support the standing standards, policies and procedures of the customer team.

  • May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.

  • Create users, establish database security, create resource queue, performance tuning in terms of query execution etc.

  • Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources and system architects.

  • Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.

  • Willing to take on-call Production rotation and occasional weekend work

 

 

 

 

Position Details

POSTED:

Nov 11, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16521408220782220

LOCATION:

United States

CITY:

Alpharetta, GA

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Senior Database Engineer(PostgreSQL )    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Summary

 

At Global Payment, We are creatively and disruptively solving some of the most complex database problems related to immense growth,scaling, extremely high performance and high availability requirements. Do these types of challenges excite you?

 

Global Payment is seeking a Senior PostgreSQL Database Engineer within our multi-database Data Engineering Group. The Department is focused on the development and maintenance of various database applications supporting all of the TSYS Issuer solutions Applications. The successful candidate will have considerable and proven experience in database design, development, a good working knowledge of end-user and server-side data processing techniques.The successful candidate will be a self‑starter and conscientious architect capable of building reusable software components.

 

Responsibilities

  • At least 5 years of experience using Python with Postgres.

  • Supporting the community edition PostgreSQL databases throughout the development and production lifecycles in an AWS environment.

  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues.

  • Performance tuning, query optimization, using monitoring and troubleshooting tools.

  • Provide database solution reviews, advice, and solution adjustments for application database requirements.

  • Provide guidance in the creation and modification of standards and procedures.

  • Participate in technical reviews and walkthroughs of system design documentation with development and design team members.

  • Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations.

  • Create, test, and implement scripting for automation support.

  • Troubleshoot and resolve database integrity issues, blocking and deadlocking issues, indexing issues, replication issues, log shipping issues, connectivity issues, security issues, etc.

  • Conduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks.

  • Setup alerting mechanism and monitor for both database and supporting hardware to ensure system health and maximum availability.

  • Identify and resolve incidents and address user problems/concerns.

  • Assess, evaluate and provide resolution for database performance problems

  • Document procedures for build, test, update, and upgrading RDS Postgres database environments.

  • Provide backup and recovery functions for PostgreSQL RDS environments.

  • Create, document, and test backup and recovery procedures including Operational and Disaster Recovery scenarios

  • Support the standing standards, policies and procedures of the customer team.

  • May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.

  • Create users, establish database security, create resource queue, performance tuning in terms of query execution etc.

  • Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources and system architects.

  • Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.

  • Willing to take on-call Production rotation and occasional weekend work

 

 

 

 


Please wait..!!