09/05/2024 updated
SW
100 % available
ORACLE CONSULTANT, ORACLE CONSULTANT, ORACLE ENGINEER/GLOBAL SME
United Kingdom BSc Hons Computing Science/Marketing (1st class)
DatabasesDatabase AnalysisRelational DatabasesLinuxOracle DatabasesOracle ApplicationsCloud Migration
Oracle DBA engineer/architect - over 20 years experience
Specialist in cloud migration/RAC/19c/OCI and Oracle Enterprise Manager
Specialist in cloud migration/RAC/19c/OCI and Oracle Enterprise Manager
Languages
EnglishFluent
Project history
Oracle DBA Engineer. Oracle 12c/19c technology utilising RAC/ASM, Exadata CC, OCI and on premise platforms.
Database migrations to Exadata CC, perform upgrades from 12c to 19c.
Oracle Enterprise Manager quarterly patching.
Real Application Testing workload capture/replay/tuning to supplement migration projects.
Oracle Engineer DBA specialising in Oracle Cloud Infrastructure (OCI) rollout and migration projects. Implementing and supporting a mix of on-premise and OCI hosted environments, Oracle 19c RAC/ASM and single instance environments. Providing OCI/DBA expertise to migration projects and developing/implementing database migration and cloning strategies to meet customer requirements. Providing OCI engineering expertise from environment design to undertaking deployment/configuration of OEL compute instances, database services, autonomous databases, NSGs and associated resources. Planning and performing the migration of customer's on-premise OEM 13c environments to OCI.
Technology: Oracle RDBMS 12c-19c, Oracle Restart, ASM, Heterogenous DB Gateways, Oracle Enterprise
Manager 13c, Ellucian Banner 8/9, Apache Tomcat, Ansible
Platforms: Solaris 11, RHEL 7 & 8, Azure
Responsibilities: Consultant for a major project to migrate/upgrade on-premise Oracle 12c hosted Ellucian
Banner 8/9 environments to Azure/Oracle 19c whilst providing BAU DBA support. As Lead Oracle SME on the
project, I performed a detailed performance/capacity planning analysis of the existing solution, mapping this to a
new build Oracle Restart managed multi-tenant architecture within Azure on RHEL. I defined, tested and
documented database migration/cloning strategies from on-prem to Azure (Data Pump and PDB based),
designed and implemented an Oracle Data Guard DR solution and liaised with clients/3rd parties as I built out and
tested new environments. I planned/performed full OAT, DR and performance testing for the new environments.
I assisted on-prem interface analysis and supported the transition of these to Azure, including Oracle Database
Gateways connectivity to SQL Server. I also provided PL/SQL and SQL recoding effort where required. I designed
and implemented an OEM 13.5/19c solution within Azure, wired to AD for authentication/authorisation, and
configured extensive monitoring/alerting across the UoL Azure Banner estate. I developed a consistent and
reproducible build/rollout procedure in Ansible for the entire Oracle stack and database build process. Extensive
documentation was also created, defining Oracle build standards, HLD and LLD artifacts, recovery procedures
and handover documents for BAU DBAs and Application Support teams. I provided critical warranty support for
the environments including problem remediation, database patching, performance tuning and adhoc assistance.
Manager 13c, Ellucian Banner 8/9, Apache Tomcat, Ansible
Platforms: Solaris 11, RHEL 7 & 8, Azure
Responsibilities: Consultant for a major project to migrate/upgrade on-premise Oracle 12c hosted Ellucian
Banner 8/9 environments to Azure/Oracle 19c whilst providing BAU DBA support. As Lead Oracle SME on the
project, I performed a detailed performance/capacity planning analysis of the existing solution, mapping this to a
new build Oracle Restart managed multi-tenant architecture within Azure on RHEL. I defined, tested and
documented database migration/cloning strategies from on-prem to Azure (Data Pump and PDB based),
designed and implemented an Oracle Data Guard DR solution and liaised with clients/3rd parties as I built out and
tested new environments. I planned/performed full OAT, DR and performance testing for the new environments.
I assisted on-prem interface analysis and supported the transition of these to Azure, including Oracle Database
Gateways connectivity to SQL Server. I also provided PL/SQL and SQL recoding effort where required. I designed
and implemented an OEM 13.5/19c solution within Azure, wired to AD for authentication/authorisation, and
configured extensive monitoring/alerting across the UoL Azure Banner estate. I developed a consistent and
reproducible build/rollout procedure in Ansible for the entire Oracle stack and database build process. Extensive
documentation was also created, defining Oracle build standards, HLD and LLD artifacts, recovery procedures
and handover documents for BAU DBAs and Application Support teams. I provided critical warranty support for
the environments including problem remediation, database patching, performance tuning and adhoc assistance.