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 flexible server + Experience in UNIX shell scripting + Experience in SQL / PLSQL development and tuning + Experience in operational and incident management/resolution + Strong documentation skills