PostGres DBA

Job Description

Insight Global is looking for a PostGres DBA for a fortune 50 financial company- candidate will be required to work 3 days on site in either Plano, TX, Chandler, AZ or Charlotte, NC. This person will be needed to implement High Availability solutions for an enterprise wide application platform and to deliver comprehensive end-to-end support for production applications, ensuring their ongoing stability, reliability, and optimal performance. The ideal candidate will be experienced in Production DBA responsibilities with a strong background in managing high-availability environments across multiple data centers, and skilled in performing database upgrades, building and deploying applications, and troubleshooting complex production issues to ensure system stability and performance. Responsibilities include, but are not limited to:

Provide end-to-end support of production applications, ensuring their stability, reliability, and performance.

Conduct in-depth problem analysis of application, troubleshoot system errors, and performance issues.

Perform proactive application stability analysis to investigate performance concerns, system errors and improvement opportunities.

Provide production on-call support, including weekend rotation on a round-robin basis.

Creating and maintaining documentation, troubleshooting playbooks, testing failover and recovery plans.

Create the objects in the database, such as triggers, indexes, etc.

Monitor the performance of the database and ensure optimum performance.

Maintain backups and perform disaster recovery in case a disaster destroys the database.

Monitor security and prevent any unauthorized access to the database.

Schedule consistent maintenance on the server

Maintain database schema.

Manage database availability.

Tablespace management.

Role management.

Ensure data integrity.

Availability for on-call support, including weekend rotations, on a round-robin basis.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form . The EEOC "Know Your Rights" Poster is available here .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: .

Skills and Requirements

7+ years of experience as a PostGres SQL DBA in large, global enterprise environments

Experience optimizing database performance, smooth functioning and monitoring its security

Strong experience in Shell and/or python scripting, DB replication, ability to create playbooks

Strong knowledge in Unix system administration

Creating and maintaining documentation, troubleshooting playbooks, testing failover and recovery plans in a 24/7 production environment

Knowledge/experience with Ansible, Jenkins, Splunk, Kafka, Kubernetes (will be supporting a DevOps team)

Financial Industry experience

Bachelors degree or related experience Previous Bank of America experience of financial institution background null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to .