Senior Database Engineer(PostgreSQL )

$86,600 - $155,200 yearly
  • The Resume Review - Recruiting Department
  • Alpharetta, GA, USA
  • May 12, 2022
Full time Information Technology

Job Description

Job description
At this company, 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?
This company  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.
  • 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