Senior Oracle Apps/database Analyst Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- Seeking senior level assignments in IT Service Management / Databases Administration / Customer Support / Technical Support with a leading organization of repute in Canada and Province.
- Seasoned certified Professional with 14+ years of exceptional service in Database Administration, IT Project Management, Planning Coordination, IT Service Management, and IT Operations Management.
- Successfully implemented IT Service Management System through ISO 20000 and ITIL Framework
- Expert in Oracle RAC & Oracle E - Business Suite.
- Strong problem-solving, planning, team-building & management skills.
- Possess valuable insights, keen analysis and a team approach to implement best practices to achieve business excellence.
- Exercise a high degree of discretion, mature judgment and tact in handling issues of a sensitive nature.
SKILLS:
Quest Software DBA tools (Space Manager, Schema Manager, Spotlight, Toad and SQL Lab Xpert).
Benthic Golden, PLEdit and GoldView
Microsoft Office, Visio,Project
Project Management
ITIL Foundation - Change Management
Troubleshooting
Dashboard, Qlikview
Process Design,Bizagi
Arabic
English
EXPERIENCE:
Confidential
Senior Oracle Apps/Database Analyst
Responsibilities:
- Service Delivery & Support Selected by Strategic team to be part of Core team to create unique Service Management Framework for ADP Organization.
- Part of Tactical team in IT Service / Process Design and Implementation for ADP IT & Telecom Division.
- Played a vital role in implementation of ITIL process (Configuration, Change, Incident, Problem & event management) at corporate level and BMC Service Desk integration.
- Conducted workshop and coordinated with IT Operations & Helpdesk during IT&T SMF project Live.
- Contributed in developing new Business Continuity Plan and Disaster recovery Management for ADP datacenter.
- Part of Business Intelligent team in data analysis, building new dashboards and management information system
- Provided round the clock support for 30 Oracle 10g Databases and 20 Oracle Application Servers and 3 Instances on Oracle e-Business Suite R12. Responsible for enhancement, setup, document and automation of DBA processes Involved in installation, patching, cloning & administering Oracle E-Business Suite R12 & database environments and perform capacity planning.
- Handling installation. patch and configuration Oracle Enterprise Manager grid Control 10gR5 Developing change, configuration and problem management databases based on ITIL standards Design and Implement Backup & Restore Strategies using RMAN.
- Research, develop and conduct migration with minimal down time. Responsible for developing Oracle Datagaurd setups and Performance tuning.
- Build RAC &Active/passive Databases. Install, configure and Manage SQL Database ServersMiddleware Oracle, Oracle Apps)
- Responsible for installation, configuration, troubleshooting, and cloning middleware environments including Oracle e-Business Suite ERP, upgrade of oracle applications and database.
- Strong Knowledge on Patching, Cloning, Sysadmin Activities like user creation, responsibility creation, registering reports etc.
- Trouble shooting Concurrent Requests/Programs. Accountable for Deploy / Undeploy applications.
- Involved in preparing architecture, sizing, and providing Backup.
Confidential
Senior Database Administrator
Responsibilities:
- Responsible for: §10Build Change,configuration and problem management databases based on ITIL standards. §11Design, document and implement Oracle Application Server backup & restore & Clone Strategy.
- Design, document and implement SQL Server backup & restore & Clone Strategy.§13Manage and administer more hat 50 Production SQL Servers and SQL 2008 Migration.§14Supporting 200+ Databases, 50+ Application Servers, 5 Oracle E-Business Suite environments (each environment consist of DEV/SIT/UAT/PROD); providing 24x7 support.
- 15Conduct DR, Performance and HA testing for critical services to ensure validity & efficiency of the implemented architecture.§16Professional troubleshooting skills for Oracle RAC & Oracle E-Business Suite.
- 17Administering Oracle e-Business Suite 11.5.10.2 on HP-UX (RAC & multi-mid-tier environment).
- Administering, Tuning & Securing Application Server components (OC4J, Apache, SSO, OID, BPEL) versions 9.0.4.x - 10.1.3.x.§19Maintain OID integration with Active Directory and Windows Native Authentication configuration.
- Securing Database/Application Server/ E-Business Suite using oracle standards and best practices.
Confidential
Senior Database Administrator
Responsibilities:
- Operational processes enhancement.2Design and develop Change Management and Release Management Software's (Change Manager).
- Change and Release Manager.4Re-evaluate and implement Backup strategy polices.5Implement and manage maximum availability architecture using RAC Databases, Clustered Application Server and Oracle Data Guard.6Design, Implement and manage Maximum Availability architecture MAA ( Clustered Application servers is two physical site and RAC databases on site 1 and Data Guard ( Physical Standby Databases) on site2)
Confidential
Technical Team Leader
Responsibilities:
- Managing a team of DBA's, Unix & Storage Admin's.8Architect and manage 16 HP-US server holding 10gR2 RAC Database Servers and 10gR2 Clustered Application Server and 10gR3 Enterprise Manager Grid Control and manage a team of 4 persons.
- Design and Implement Backup strategy using IBM Tivilo TSM backup utility ~
Confidential
Oracle Database Administrator
Responsibilities:
- Session awareness and trainings.
- Adopt new Oracle features and study analysis on them.
- Install. Configure, administer and tune 9i an 10g Oracle Application Servers ( J2EE and Web Cache, Oracle Forms and Reports ) on Solaris
- Install, Administer and tune Oracle 8i,9i and 10g Oracle Database
- Upgrade Client-Server applications from 6i,9i to 10g Web enabled Application.
- Upgrade Java Applications from J2EE 903 to J2EE 10.1.216
- Upgrade 8i and 9i DB E.E to 10g17Implement Backup and Recovery Strategy with RMAN 10g
- Implement Database High availability using Data Guard ( Logical and Physical databases)
- Enhance Oracle Databases and Application Server Performance
Confidential
Oracle System Support
Responsibilities:
- Oracle database administrator versions (8.0.4~9.2.0.2.0 and 10g) on NT/2000/2003/Advanced Server, Sun Solaris, Linux, Irix and HP-UX.
- Database migration from SQL Server, Turboimage (HP) and Ingress to Oracle.§Sizing, backup, installation, high availability, configuration, monitoring, security, troubleshooting, partitioning and upgrades. Application Server:
- Oracle application server administrator versions (2.x, 3.x, 4.x, 9i, and 10g) on NT/2000, Sun Solaris, Linux, and HP-UX.§High availability infrastructure (N-Tier architecture).§Web forms deployment, configuration and administration.
- Discoverer/Reports/ Portal deployment, configuration and administration.
- J2EE deployment, configuration and administration (BC4J, TobLink).
- Oracle Collaboration Suite (OCS) installation and configuration§Application Server Tunning.
- Install and configure and manage Windows 2000 and 2003 Domain Controllers.
- Install and configure and manage ISA 2000, Exchange 2000,2003§Install and Configure and manage, DHCP, AD, Group Policy Implementation.
- Administration on Local and Domain users and Groups and providing appropriate rights.
- Implementing system policies
- Install and configure WSUS ( Windows System Update Service )
