What are the responsibilities and job description for the PostgreSQL Database Engineer position at Bank of America?
Job Description:
At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.
One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. We’re devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being.
Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization.
Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!
Job Description:
This job is responsible for providing front-line support to end users, responding to issues related to incidents and problem management governance for multiple applications, and leading triage activities on all business impacting incidents. Key responsibilities include ensuring compliance with incident management and problem management policies and procedures, serving as a focal point for the customer, client, and associate experience, restoring complex production incidents under tight Service Level Agreements, and pursuing root cause and problem resolution follow ups.
Responsibilities:
Leads production support triage efforts, manages bridge line troubleshooting, engages in technical research, and escalates issues to leadership as needed
Ensures all impacts are accurately recorded and documented in the system of record, oversees that documents and wikis are updated and available for use during triage, and supports the documentation of application flows, upstream/downstream impacts during outages, the customer experience, and contacts for support needs
Identifies and/or validates business impacts through interpretation of monitors, dashboards, and logs to communicate with leadership and vendors
Manages activities to identify incident root cause, resolution, preventative actions, and change requests, and reports on incident data quality
Promotes and enforces production governance during triage/testing and identifies production failure scenarios, vulnerabilities, and opportunities for improvement
Serves as a subject matter expert for applications within a portfolio, leveraging extensive knowledge of application functionalities and application flows
Assesses and prioritizes research requests, ad hoc reports, and offline incidents at the direction of senior team members and delegates work as needed to team members and peers
Required Qualification :
Experience architecting a large-scale production database platform.
5 year of experience on data base management.
Strong Knowledge of Postgres production and contingency peplication feature and configuration.
Strong Knowledge of Postgres HA Clustered environment.
Strong hands-on experience on failover/migration and data restores in a HA environment.
Support Database patching and ability to provide continuous support for the Application.
Proficient in handling crontabs and data backups using pgBackRest.
Proficient in handling Kubernetes/Open Shift cluster for PostgreSQL.
Creating and maintaining documentation, troubleshooting playbooks, testing failover and recovery plans.
Perform regular database maintenance tasks.
Ability to write ansible playbooks.
PostgreSQL DBA experience in a 24x7 production environment.
Desired Qualifications :
Proficient in one of the following scripting languages: Python, Bash
Skills:
Production Support
Risk Management
Automation
Collaboration
Innovative Thinking
Solution Design
Solution Delivery Process
Stakeholder Management
Shift:
1st shift (United States of America)Hours Per Week:
40
