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.
Want more jobs like this?
Get jobs in Guadalajara, Mexico delivered to your inbox every week.
+ 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 flexible server
+ Experience in UNIX shell scripting
+ Experience in SQL / PLSQL development and tuning
+ Experience in operational and incident management/resolution
+ Strong documentation skills