Database Administrator - Senior

What will you contribute?

1. Support, administer and maintain the Oracle & PostgreSQL database environments.
2. Participate in On-Call Respond to incidents and provide RCA and resolution.
3. Create new database environments (DEV/QA/UAT/Production/Standby) to support development and product progression.
4. Responsible for project work package breakdown and effort estimation.
5. Perform Releases and Implementation to all database environments.
6. Responsible for storage estimation & forecast. Install, configure and manage RAC. Patch and upgrade databases.
7. Should be able to respond successfully to incidents and provide timely RCA and resolution.
8. Effectively maintain and manage critical databases successfully.
9. Build, configure and install Oracle, PostgreSQL Databases software and configure in line with team standards.
10. Provide project breakdowns and estimates on delivery.
11. Successfully deliver on project and TSS initiatives.
12. Support the Infrastructure Management team budget.
13. Successfully support and complete projects to reduce cost by automation and consolidation whenever possible.
14. Responsible for solution designs and documentation for projects.
15. Responsible for performance tuning. Create & manage/administer/maintain Grid Control/Cloud Control.
16. Provide complete documentation and handover to team members.
17. Identify and recommend solution to performance issues on Oracle DBs & PostgreSQL databases.
18. Manage and monitor database alerts for all DBs using OEM13c or any cloud portal.
19. Responsible for solution designs and documentation for projects and training team members on new technologies.
20. Train and assist in improving technical skills of the team by holding knowledge sharing session about new technologies and trends.
21. Responsible for configuration and implementation of databases backups.
22. Configure, setup, maintain database security and auditing.
23. High availability, disaster Recovery planning and implementation. Using RAT, SPA to during upgrade to reduce risk.
24. Manage and monitor backups on weekly basis.
25. Build, support and manage the DR environment.
26. Test and certify database upgrades and patches.
27. 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:

1. Must have 10+ years of experience managing large and complex OLTP and warehouse databases using Oracle11g /12c /19c and PostgreSQL 13/14/15/16.
2. Must have 10+ years of experience in managing Oracle & PostgreSQL databases on Solaris/ AIX / Linux platforms.
3. Experience in tuning, monitoring, and securing Oracle & PostgreSQL databases.
4. Experience in managing and tuning OLTP / DW databases.
5. Experience Oracle Data Guard, ASM, RAC, AWR, OEM and MS Azure PostgreSQL flexible server.
6. Experience in UNIX shell scripting.
7. Experience in SQL / PLSQL development and tuning.
8. Experience in operational and incident management/resolution.
9. Strong documentation skills.