Oracle Dba Resume
SUMMARY:
- 15+ years of experience as architect, systems support and development professional
- Quick learner, hardworking, excellent analytical skills
- Excellent leadership, communication (written and oral) and interpersonal skills
- OCP 10g DBA, Citrix certified Administrator (XP FR2)
- Security clearance - Enhanced Reliability Status (Canada)
- Excellent programming abilities with math background
- 11 years in consulting including 3 years in Oracle consulting as a member of the Systems Performance Architecture Team . Architectural design, capacity planing for high availability, scalability and performance. Advanced performance tuning for high profile clients on behalf of Oracle Consulting (Munich Reinsurance, Toronto stock exchange, Canadian Broadcasting Corporation ) as well as for my company ( Confidential inc) clients ( Confidential Ontario, LondonHydro, Confidential, Spinnaker, Confidential )
- Logical and physical database design. Normalized, denormalized, star, snowflake, relational, hierarchical, object oriented schema designs. Optimizing physical database design for performance.
TECHNICAL SKILLS:
Oracle: Worked on various versions of Oracle products(7.3-12c), Real Application Cluster, OAS,RMAN, OWB/ODI, Data Guard, Streams, GoldenGate, OEM/Grid Control, Oracle Financials R12(GL,AR,AP), Pro C, Oracle Developer (version 6i and 9i), Designer 2000, JDeveloper with ADF, XML, BPEL,SOA, J2EE, Veritas, RMAN, Oracle VM, Data Warehouse, Database Administration and Application Software Development, Oracle Application Server, BEA WebLogic, WebCenter portal l1g administration, OAM/OIM 10g and 11gR2 suite, Oracle SOA suite and FMW 11g-12g
Microsoft: Windows 2003/2012 domain administration (AD, DNS), Exchange 2000, Outlook 2000, SQL server, MS Office, C++ development, IIS clustering, ASP, VB script, .NET
Java: JEE, JPA, Servlets/JSP, JSTL, JSF, ADF, XQuery/Xpath, JAX-WS, JAX-RS,SOA, BPEL, XML, XSD, WSDL, BPM, SCA
Unix: HP-UX (Risc-Itanium-Superdome), Solaris, AIX, Linux (OEL, RedHat, Suse, blade servers) (Korn/Shell scripting)
Citrix: Metaframe XP/1.8 (load balancing, Nfuse, Citrix Secure Gateway, performance tuning/troubleshooting)
SAN: Hitachi, EMC, HP
Cloud: AWS, Azure, Oracle Field Service Cloud, private cloud deployments, VMware ESX and Oracle Virtual Machine
PROFESSIONAL EXPERIENCE:
Confidential
Oracle DBA
Responsibilities:
- Oracle e-Business suite customization and upgrades up to version 12.2. Performance tuning, upgrade assessment and upgrades, rapid cloning, patching and concurrent manager administration in the high availability environments under Oracle Access/Identity governance. Customization of the presentation layer with OAF and APEX(Restful) interfaces and mobile options MWA (Mobile Supply Chain)
- Oracle e-Business suite deployment for high -availability (MAA), Oracle RAC/ASM, Dataguard, GoldenGate, version 11g -12c
- TDE encryption administration with Oracle Key Vault(OKV). OKV installation and deployment.
- Architectural design and review of the vendor's proposals (Oracle)
- Oracle RAC /ASM installation, configuration, and migration of clients on RAC (11g-12c) on various platforms (Linux, Exadata).
- Automated code build deployment for Webcenter Portal with GitLab, Jenkins, Maven, ant, Archiva.
- Oracle OAM/OAAM/OIM/OID/OVD/OIF implementation. SSO and Windows Native Authentication. Integration with Oracle e-Business Suite, BI Publisher and APEX apps (RESTful) . Weblogic and OHS servers administration. Single SignOn Oracle e-Business Suite. OAM policies development and deployment for different authentication schemas. Manage users privileges with OAM connected to AD and OID domain. Oracle Identity Federation (SAML)
- Regression testing with Oracle Application Testing Suite
- Oracle advanced performance tuning and proactive performance monitoring.
- Migration regression testing with Real application Testing
- Installation and agent deployment Oracle OEM 12c .
- GoldenGate replication, administration and proactive monitoring. Enforcing transformation rules for the GoldenGate replication with ODI.
- Security Platform Delivery( PaaS and IaaS) based on Oracle cloud.
- Oracle NoSQL database administration, ODI data loads and transformation into JSON format from legacy DB2. Data Warehouse migration from SQL server to Oracle 12c with ODI. Data mapping and scenarios development for production. Cubes aggregation. GoldenGate Data replication verification with ODI. Deployment ODI for WebServices.
- Oracle database and products administration under AIX, Linux and Windows. Oracle High-availability solutions: Oracle RAC/Dataguard and middle tier clustering, Exadata, Exalogic, ZFS appliances. Oracle Key Vault, Oracle Database Vault, Oracle Database Firewall/Audit
Confidential
Consultant(Identity Architect
Responsibilities:
- Oracle OAM/OAAM/OIM/OID/OVD/OIF/OAAM (11gR2S2-S3) implementation in the POC environment.
- Architectural documentation.
- OAM Oauth implementation in OAM mobile and social for RESTfull services
- Migration from ODSEE to OUD. Performance comparison between ODSEE and OUD for identity bulk load operations and groups with large membership.
- OAM SAML POC implementation, troubleshooting use cases as per requirements in cloud environment(AWS, private cloud)
- BPEL workflows implementation, troubleshooting and POC of the use cases.
- Active-Active Multi-Data Center architectural design collaboration.
- SAML for open source implementation (Shibboleth IdP, Amazon AWS cloud,Azure cloud AD domain )
- OEM implementation.(12c)
- Platform Delivery ( PaaS and IaaS) based on private (Toyota) and Azure cloud.
- Oracle database administration, RAC, Data Guard, GoldenGate, Exadata and Exalogic appliances. Platform provisioning, performance tuning, administration and virtualization in the corporate cloud environment.
Confidential
B3 Technology specialist
Responsibilities:
- Oracle OAM/OIM/OID/OVD/OIF/Mobile/Oath implementation. SSO and Windows Native Authentication. Integration with Oracle e-Business Suite and APEX apps. Weblogic and OHS servers administration. Single SignOn Oracle e-Business Suite. OAM policies development and deployment for different authentication schemas. Manage users privileges with OAM connected to AD and OID domain. SAML and Identity Federation
- Oracle e-Business suite administration and customization . Performance tuning, upgrade assessment and upgrades, rapid cloning, patching and concurrent manager administration in the high availability environments under Oracle Access/Identity governance.
- Clustered Oracle Service Bus and SOA deployment/administration for high-availability environment. PKI configuration for transport and message level security.
- Oracle BPEL and Discoverer upgrade and migration from 10g to 11g
- Oracle RAC /ASM installation, configuration and migration of clients on RAC (11g) on various platforms (Linux, Exadata).
- Regression testing with Oracle Application Testing Suite
- Oracle advanced performance tuning and proactive performance monitoring.
- Migration regression testing with Real application Testing
- Installation and agent deployment Oracle OEM 12c .
- GoldenGate replication, administration and proactive monitoring
- Regression testing with Oracle Application Testing Suite (OATS)
- Installation and agent deployment Oracle OEM 12c.
- Oracle NoSQL database administration, ODI data loads and transformation into JSON format from legacy DB2. Data Warehouse migration from SQL server to Oracle 12c with ODI. Data mapping and scenarios development for production. Deployment ODI for WebServices.
- Oracle Forms and custom java application upgrade and migration from 10g (OAS) to 11g (Weblogic) for LAPD/Sheriff’s department. Database upgrade from 10g to 11gR2
- Platform Delivery (PaaS and IaaS) based on Oracle Cloud and private cloud.
- Oracle database and products administration under AIX, Linux and Windows. Oracle High-availability solutions: Oracle RAC/Dataguard and middle tier clustering, Exadata and Exalogic, ZFS appliances.
Confidential
Contract DBA
Responsibilities:
- SAP and Oracle11 upgrade consultant. Work on Oracle 11G upgrades and performance tuning for smart metering systems Operational Data Store (ODS).
- Working for Oracle upgrades and performance tuning for Operational Data Store (ODS) to support smart metering systems rate structure. Upgrades for ITRONE and Sensus applications. Automated deployment with shell/ant/perl/WLST/python scripts.
- Designed and Installed proof of concept for IAM solution - Oracle 11gR2 Identity and Access Management solutions. Webgate configuration.
- Migration regression testing with Real Application Testing
Environment: Oracle 11G RAC, OEM 12c, SAP, Basis, Apache, OAS, IIS, Weblogic, NetWeaver, Jboss Oracle Identity/ Management (OIM/OAM), Java, SOA, WSDL, Oracle Service Bus(OSB)
Confidential
Infrastructure specialist
Responsibilities:
- Implemented Network Outage Management System for Hydro One. Directly responsible for the architecture and design process, as well as the overall implementation. Advanced performance tuning, application baselining and stress testing. Conversion from COTS to in-house application
- Provide installation services in a complex, highly available networking environment. Oracle deployment for hardware and software virtualization, cloud computing, PaaS (Oracle 10/11g, Solaris 10, RedHat 5, VMware ESX, Windows)
- Application migration from forms/reports to Oracle JSF/ADF .
- Managed delivery of power system services based on NERC requirements.
- Architectural review and recommendations according Oracle MAA. Backup/DR procedure review and recommendations. SCADA HA architecture.
- Architect and Design interfacing with customer ERP (SAP) system. SAP SOA connectors and integration with customer Java applications. Oracle Service Bus, SOA development, WSDL, XSD, SOAP message transformation, proxy, alerting. Oracle Service Bus/AquaLogic administration.
- Provide technical expertise and consulting
- Migration regression testing with Real Application Testing
- Worked in the change management control environment (Maven and CVS)
- Implemented OIM/IAM deployment and integration with active directory domain. Environment integration with Single sign on (SSO) .Webgates 10g installation
- LDAP consolidation under OVD
- Platform and version migration and implementation of the 11g high-availability infrastructure for corporate primary and backup sites. (RAC 10/11g, Data Guard, Grid Control-Enterprise Manager, OWB/ODI, Streams, GoldenGate, Weblogic, OAS). Hitachi remote SAN mirroring replication
Environment: ORACLE RAC DG, GoldenGate, Weblogic and OAS, Hitachi SAN, OIM/IAM, firewalls, HP Blade technology, Citrix, VMWare
Confidential
Senior Principal Consultant
Responsibilities:
- Worked as a consultant/architect with the Oracle Corporation helping to deliver world-class business and technology solutions
- Worked with different clients in the government and public sectors
- Architect and Design solutions for customer needs.
- EBS on RAC installation, upgrade, migration (11i, R12)
- In depth knowledge of the distributed, HA, and mission critical databases/applications
- Consulting in the High Availability solutions: RAC, Data guard, Oracle Warehouse Builder/Oracle Data Integrator, Grid Control, Streams.
- Responsible for the installation, configuration, and migration of clients on RAC (9i, 10g, 11g) on various platforms (Linux, AIX, Windows, Solaris, HP-UX(Supedome, Itanium)
- Organization skills and ability to manage multiple concurrent initiatives
- Advanced performance tuning for various clients applications.
- OEM/Grid Control implementation. Installation, configuration, user training, customization. Services, beacons custom alerts development including 11g
- OID/OVD//IAM implementation. SSO and OAM for Discoverer portal.
- Delivered Proof of Concept designs with VMWare and Oracle VM.
- Responsible for reviewing and validating proposed architecture plans for clients.
- Architectural design and implementation of the high performance storage systems (RAW, ASM, OCFS, Veritas Cluster VxCFS) for RAC Oracle Database systems with various storage platform vendors (Hitachi, EMC, HP).
Confidential
Corporate DBA/Network Administrator
Responsibilities:
- Database administration Oracle servers (30 instances/clients, production, backup and recovery, tablespace/dataspace planning and management, application/database tuning, migration to 8i, 9i, 10g).
- Support high-availability Oracle databases (Oracle RAS, Veritas/Compaq SAN)
- Developing/implementation Oracle backup/recovery plan (Veritas Backup Exec, RMAN, CommVault)
- EBS installation and upgrades (11i10) Architectures for mission-critical systems on HP-UX, AIX, Solaris, Linux, Windows platforms
- Developed Fibre Channel HP EVA 6000/8100 SAN solution to address the need for increasing disk space on demand and a better backup capability. SAN administration (Veritas cluster filesystem/volume manger, Oracle RAC) for UNIX and Windows servers.
- Deployed a VMWare ESX solution for rapid system availability in a test environment that reduced cost on the amount of hardware based test servers needed for customers. Also deployed Windows Virtual Server.
- Setup/Configure/Maintain high-availability multi home (NLB) web servers. (IIS, Apache, JSP/ASP API, OAS 9i).OAS Portal administration
- Architected and maintain Windows clustered servers using Oracle, MS SQL and IIS along with standard file services.
- Portal administration for admin team’ s homepage that provides among other things information to local and enterprise wide customers on site server’ s status and planned outages
- Checkpoint and ACE server administration. Head of system security for the team to include use of Internet Security System’ s Internet Scanner, Tippingpoint, installation and maintenance of Norton Antivirus, NT OS and IIS hardening, network intrusion detection. Identity management and single sign-on solutions. Compliance with credit card vendors and Sarbanes Oxley governance. Arcsite administration. ASA firewalls.
- Network devices configuration (routing switches, routers, VLAN, meshing, trunks). CISCO & HP
- Architected and deployed several Citrix solutions using Citrix Metaframe XPE and Presentation server to allow external business customers to collaborate with internal businesses. Environment now being retrofitted on Windows 2008 application server. (XP FR3, CSG, nfuse, load balancing).
- Planning for perspective projects (yearly budgets)
- Sharepoint Administration
- Security
- Maintained external DNS, DHCP
- Architected and maintain five production Windows 2003 Active directories and two Windows 2000 Active Directories including group policy implementation. Corporate migration from Windows NT to Windows 2003 AD domain.
- Network/DB projects and related documentation development
- SW and HW purchase recommendations
- Windows 2003, Solaris 8-10, Linux RH3-4, Oracle 7.3/8i/9i/10g, OWB/ODI, OAS 9i,SQL server 7,Citrix Metaframe XP FR3, Checkpoint Firewall-1/VPN, ACE server 5.1
Confidential
Senior Programmer Analyst
Responsibilities:
- Converting of the legacy system (COBOL/IBM370) to the Oracle workshop
- Database design modeling and normalization (insurance premiums datamart)
- Development and reconciling DSS application (insurance premiums) with legacy system.
- Support of the production.
- Development servlets for web-enabled application. (Export utility for brokers)
- Development of the survey reports for Insurance Board Canada and users request
- Application optimization and performance tuning, tablespaces management (application DBA).
- Oracle 7.3/8i and Oracle Developer/Designer 2000 tools, C++, Pro* C, Windows NT, JDK 1.2, HP/UX, AIX, Solaris environment.
