**Responsibilities**:**What will you contribute?
**+ Support, administer and maintain the Oracle & PostgreSQL database environments.
+ Participate in On-Call Respond to incidents and provide RCA and resolution.
+ Create new database environments (DEV/QA/UAT/Production/Standby) to support development and product progression.
+ Responsible for project work package breakdown and effort estimation.
+ Perform Releases and Implementation to all database environments.
+ Responsible for storage estimation & forecast.Install, configure and manage RAC.Patch and upgrade databases+ Should be able to respond successfully to incidents and provide timely RCA and resolution.
+ Effectively maintain and manage critical databases successfully.
+ Build, configure and install Oracle, PostgreSQL Databases software and configure in line with team standards.
+ Provide project breakdowns and estimates on delivery.
+ Successfully deliver on project and TSS initiatives.
+ Support the Infrastructure Management team budget+ Successfully support and complete projects to reduce cost by automation and consolidation whenever possible+ Responsible for solution designs and documentation for projects.
+ Responsible for performance tuning.Create & manage/administer/maintain Grid Control/Cloud Control.
+ Provide complete documentation and handover to team members.
+ Identify and recommend solution to performance issues on Oracle DBs & PostgreSQL databases.
+ Manage and monitor database alerts for all DBs using OEM13c or any cloud portal.
+ Responsible for solution designs and documentation for projects and training team members on new technologies.




+ Train and assist in improving technical skills of the team by holding knowledge sharing session about new technologies and trends.
+ Responsible for configuration and implementation of databases backups.
+ Configure, setup, maintain database security and auditing.
+ High availability, disaster Recovery planning and implementation.Using RAT, SPA to during upgrade to reduce risk.
+ Manage and monitor backups on weekly basis.
+ Build, support and manage the DR environment.
+ Test and certify database upgrades and patches.
+ Review and resolve any performance issue that arises during patching or upgrades.
**Responsibilities & Deliverables**:Your deliverables will include, but are not limited to, the following:Reporting to the Manager Database, the Oracle & PostgreSQL DBA/ will be the primary technical resource in developing and maintaining Finastra's large and complex database infrastructure.The incumbent is responsible for building/managing business critical Oracle & PostgreSQL Databases to support multiple LOBs at Finastra, maintaining, enhancing, upgrading, and tuning existing databases, and supporting production operations.
**Required Experience**:+ Must have 10+ years of experience managing large and complex OLTP and warehouse databases using Oracle 11g /12c /19c and PostgreSQL 13/14/15/16+ Must have 10+ years of experience in managing Oracle & PostgreSQL databases on Solaris/ AIX / Linux platforms+ Experience in tuning, monitoring, and securing Oracle & PostgreSQL databases+ Experience in managing and tuning OLTP / DW databases+ Experience Oracle Data Guard, ASM, RAC, AWR, OEM and MS Azure PostgreSQL adaptable server+ Experience in UNIX shell scripting+ Experience in SQL / PLSQL development and tuning+ Experience in operational and incident management/resolution+ Strong documentation skills

📌 Database Administrator - Senior (Guadalajara)
🏢 Finastra USA
📍 Guadalajara