Manager Oracle
Resume:
[pic]
Akif Zeeshan
Tel #1-732-***-****
E-mail: ***********@*****.***
Professional Summary
Oracle Application
. More than 11 years of experience of Oracle database (9i, 10G, 11G) and
e-Business suite (11i, R12) implementation, post implementation
production support.
. I am an Oracle Certified DBA, worked on Oracle E-Business Suite11i/R12
(APPS RAC/Data Guard 10gR2), and RMAN.
. Proficient in Installation, Upgrade, Migrate, Configuration &
Supported Oracle Databases 9i/10g/11g, Oracle Apps 11i,R12, On call
Support, Performance Tuning & Troubleshooting.
. I have expertise in DB Cloning (RMAN/ Flashback),Apps Cloning (RAC to
Non-RAC), Upgrade, Installation, Apply Patches/Patch analysis and
Administration
. Implementation of Oracle Grid Control 10gR2 (10.2.0.1)
. Installation and configuration of Real application cluster (RAC
10G/11G).
. Experience of Oracle DBA in large Production Environments with
Database Implementation in Red Hat Linux 2.1, 3.0, and 4.0 AS, HP-
Unix, AIX, Sun Solaris and Windows with single node as well as multi
node.
. Coordinate the architecture activities throughout the program
timeline.
. Installed and cloned various 11i, R12 instances (Prod, Vision, Test,
Patch, Dev, and CRP).
. Upgrading Oracle E-Suite of applications 11.5.7 to 11.5.9, 11.5.9 to
11.5.10.2.
. OATM migration as well as configured SHARED APPL TOP.
. Experience in running AD Utilities (Ad Patch, Ad admin, and Ad ctrl)
to administer the Applications.
. Manage and administer SSO/OID, Discoverer with EBS.
. Give support to modules like (Fins/HR/SCM) and help functional
consultant with their work.
. Created both single tier and multi-tier E-Business Suite instances.
. Implemented Oracle 10g/11g Real Application Cluster (RAC) environment
with high availability and for disaster recovery solution. Supported
the performance issues of Oracle10g RAC environment with other DBAs.
Also supporting application development teams.
. Experience in system administration (concurrent manager setup, user
management, assigning responsibilities, notification mailer setup,
printer set)
. Coordinate research, planning and implementation of databases and
applications Patches.
. Applied patches for localization and HR global patches.
. Patch Application on Database & Application Tier.
. Implemented 'Oracle Applications 11i cloning' successfully to refresh
the TEST system periodically from the PRODUCTION system in order to
keep the TEST system current.
. Configuration of parallel concurrent processing (PCP).
. Experience as On-Call 24x7 production DBA and application/development
DBA.
. Experience in running AD Utilities to administer the Applications.
Oracle DBA
. Installation, configuration, creation, migrations of Oracle 9i/10g/11g
on Solaris 8/9, HP-UX 11, RHE Linux 4.0, and Windows 2000/2003.
. Experience in Installing and Configuring ASM, CRS and RAC for high
availability databases.
. Mange database 9i/10G/11g design, creation and configuration, space
management and other database maintenance procedures in multiple
production and development environment.
. Tuning SQLs using EXPLAIN PLAN, SQL Trace, TKPROF, and SQL Tuning
Advisor.
. System resource management including bottleneck detection, contention
tuning on SGA, CPU, Memory and I/O etc using AWR snap shots through
ADDM.
. Experience is designing schemas/products, database objects; file
system structure, tables, views, packages, procedures, functions,
triggers, sequences, indexes, and constraints.
. Develop instance strategy, integration plan, and design data modeling
. Installed and configured oracle 10G DATAGUARD.
. Designing Backup & Recovery Policy for the Database, which includes
Cold Backups, Archive Logs & Export Import dumps.
. Install, create and administer the ASM databases on 11g also convert
non ASM databse to ASM
. Solid experience in Oracle Recovery Manager (RMAN), advanced
replication, and standby database using Data Guard 9i/10g.
. Creating, Upgrading databases for various versions of 9i/10g/11g using
DBCA, DBUA.
. Preparing a suitable backup & recovery strategy, performing Database
Backups & dealing all Recovery issues of an Oracle database.
. Provided all kinds of DBA support to development teams as well as
production support to various applications.
. Database and application optimization including performance tuning,
query optimization and supportability.
. Install and configure ONAMES, OID (oracle internet directory).
. Configuration and installation of CRM application Seibel 8.0.
. Well versed with Storage Technologies (NSF or clustered file system),
SAN configuration and RAID Levels.
. Worked with database architects assisting with database design,
creation and implementation.
. Oracle database upgrades from 8i to 9i and from 9i to 10G.
. SQL Net installation/configuration/troubleshooting (Server and Client
side).
. Reviews, evaluates, designs, implements and maintains company database
. Experience with UNIX shell scripting.
. Experience in Concurrent Managers and Concurrent Programs.
. Monitoring 'SR' to resolve the known issues in coordination with
Oracle Support.
. Provided On call support and 24x7 support for mission critical
databases
. Knowledge of Database OFA Standards, Importing / Exporting, Patch
installs, Version Upgrades, Monitoring and Tuning, Listener TNS-Names
Configuration, Names Server maintenance.
. Have Strong interpersonal skills with the ability to interact with end-
users, managers, technical personnel, etc. Excellent work ethics and
team oriented with strong analytical and leadership qualities.
. Excellent communication, interpersonal and business interaction
skills. Friendly, cooperative attitude, detail-oriented, analytical
and self-driven Mentored Oracle DBA.
Academic Qualifications:
Oracle 10G certified professional
Post Graduate Diploma from NED University of Engg & Tech., Center Of
Continuing Engineering education (Oracle 9i)
M.S (Master of Computer science) from Pakistan institute of management
science
B.C.S (Bachelor of Computer science) from Shah Abdul Latif University
Technical Skills
Languages : SQL, and PL/SQL
RDBMS : Oracle 8i,9i,10G, 11G
ERP : Oracle apps 11i (Versions 11.5.7,11.5.9,11.5.10,11.5.10.2),R12(12.0.0.4)
Tools : TOAD,PLSQL Developer, Enterprise Manager,Spot light
Operating System : WIN 2000,2003,Solaris,LINUX,AIX,TRU64 UNIX,AIX.
Professional Experience:
Client: VISA Inc Foster city, CA
Aug-09 till date
Role: Sr.APPS DBA, Sr.Oracle DBA
Visa is a global payments technology company that enables consumers,
businesses, financial institutions and governments to use digital
currency instead of cash and checks.
Responsibilities:
. Configuring administration of oracle application 11i.
. Administration of Oracle 11i development, staging and production
environments on Sun Solaris create users, responsibilities, and roles.
. Installed and cloned various 11i instances(Prod, Vision, Test, Patch,
Dev, CRP)
. Experience in system administration (concurrent manager setup, user
management, assigning responsibilities, notification mailer setup)
. Install, create and administer the ASM databases on 11g
. Install and configure 11G RAC on two node using ASM on Linux.
. Cloning PROD to DEV,TEST,TRNG,QA.
. Code migration using SQL LOADER, FNDLOAD, Forms and reports
compilation and registration.
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Apply the quarterly Security patches (PSU) to NON RAC, RAC databases.
. Configure RMAN backup and export/import for databases (10g, 11g).
. Manage and administer SSO/OID, Discoverer with EBS.
. Administration and configuration of 170 mark view
. Configuration of oracle database with VERITAS Clusters
. Database Problem Diagnosis, Research, Fix, Testing and Resolution
apply and test Patches on 11i environments.
. Converting 10G databases from NON ASM to ASM.
. Installing and configuring administration of Oracle 10G Grid control.
. Involved in managing Oracle10g databases and creating database
objects, which include data files, transaction log files, file groups,
tables, views, indexes, and stored procedures.
. Cloning RAC 11G database to Non RAC from PROD to (TEST, DEV instance)
using RMAN.
. Administer & maintain Oracle 10G instances, provide end-user support,
application of patches.
. Upgrade the database from 9i to 10G, 10G to 11G, patch set application
. Apply the 10G patch set 4 to upgrade to 10.2.0.4
. Used ANALYZE... COMPUTE STATISTICS for fine tuning table, indexes
&other schema objects
. SQL Tuning using Explain Plan, TKPROF with SQL trace and SQL Tuning
Advisor with Enterprise Manager. Monitoring database performance by
AWR and ADDM alerts
. Database and application optimization including performance tuning,
query optimization and supportability
. Use AWR for 10g to collect complete database statistics to identify
database bottleneck and high resource SQL statements.
. Work with business users to resolve performance issue.
. Provide 24x7 on-call support for databases and disaster recovery
support.
. Design, implementation and support of backup and recovery procedures
using RMAN.
. Create, modify and maintain database objects, users and security
management
. Installation of printers at operating system and then defining in
oracle application.
. Technical Documentation for Oracle ERP Solutions
. Troubleshooting and assisting development team and patching of the
instances
. Experience in working with internal users to identify and resolve
application issues.
. Experience in SYSADMIN.
. Experience in Concurrent Managers and Concurrent Programs.
. Experience in running debugging scripts.
Environment: Oracle E-Business Suite 11i (11.5.10.2), sun Solaris, Database
9i/10G/11G, Enterprise Manager, Toad, Grid control, spot light
Client: NHR (Network hardware resale) Santa Barbara, CA
Feb-09 to Aug-09
Role: Lead APPS DBA, Lead Oracle DBA
NHR is the provider of refurbish Cisco products and also the provider of
Force10 products lines, its operations is running across 4 countries, hard-
to-find, and end-of-sale or end-of-life Cisco hardware.
Responsibilities:
. Installing and configuring administration of oracle application R12
multimode oracle on ASM.
. Installation and administration of Oracle R12 development, production
environments on Linux 4.0 create users, responsibilities, and roles.
. Cloning from RAC to non RAC from PROD to DEV,TEST,TRNG using RMAN
. Installed and cloned various R12 instances(Prod, Test, Dev, TRNG)
. Production support of R12/10g Instance after go live
. Code migration and data pulls, Forms and reports compilation and
registration
. Troubleshooting and assisting development team and patching of the
instances
. Develop instance strategy, integration plan, and design data modeling.
. Experience in system administration (concurrent manager setup, user
management, assigning responsibilities, notification mailer setup)
. Give support to modules like (Financials (AP, GL, AR, FA) OM) and help
functional consultant with their work.
. Installing and configuring administration of Oracle 10G Grid control.
. Involved in managing Oracle10g databases and creating database
objects, which include data files, transaction log files, file groups,
tables, views, indexes, and stored procedures.
. SQL Tuning using Explain Plan, TKPROF with SQL trace and SQL Tuning
Advisor with Enterprise Manager. Monitoring database performance by
AWR and ADDM alerts
. Database and application optimization including performance tuning,
query optimization and supportability
. Use AWR for 10g to collect complete database statistics to identify
database bottleneck and high resource SQL statements.
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Work with business users to resolve performance issue.
. Database Problem Diagnosis, Research, Fix, Testing and Resolution
apply and test Patches on 11i environments.
. Provide 24x7 on-call support for databases and disaster recovery
support.
. Design, implementation and support of backup and recovery procedures.
. Create, modify and maintain database objects, users and security
management
. Installation of printers at operating system and then defining in
oracle application.
. Technical Documentation for Oracle ERP Solutions
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Experience in working with internal users to identify and resolve
application issues.
. Experience in SYSADMIN.
. Experience in Concurrent Managers and Concurrent Programs.
. Experience in running debugging scripts.
Environment: Oracle E-Business Suite R12 (12.0.0.4), Linux 4, Enterprise
Manager, Toad, Grid control.
Client: EDS (Electronic data systems) Plano, TX Jan-08
to Feb-09
Role: Technical consultant, Lead Oracle DBA, Lead APPS DBA
Injazat Data Systems, the region's leading Information Technology
Outsourcing (ITO) and Business Process Outsourcing (BPO) Company, they are
the partners with EDS (Electronic data systems). Injazat provides IT
outsourcing services to the United Arab Emirates government, and oil and
gas, utilities, financial services, transportation, telecom and healthcare
sectors.
Responsibilities:
. Hardware sizing, Oracle presales and solution designing.
. Creating industry specific, Product specific solution.
. Installing and configuring administration of oracle application 11i,
R12.
. Installation and administration of Oracle 11i, R12 development,
staging and production environments on Windows2003 create users,
responsibilities, and roles.
. Installed and cloned various R12 instances(Prod, Vision, Test, Patch,
Dev, CRP)
. Production support of R12/10g Instance after go live
. HR Data Installer and HRGLOBAL update installation.
. Applied patches for UAE localization and HR global patches.
. Troubleshooting and assisting development team and patching of the
instances
. Develop instance strategy, integration plan, and design data modeling.
. Experience in system administration (concurrent manager setup, user
management, assigning responsibilities, notification mailer setup)
. OATM migration
. Installing and configuring administration of CRM Seibel 8.0.
. Upgrade the Siebel application from 8.0 to 8.0.3.
. Give support to modules like (Financials (AP, GL, AR, FA)/HR,
PAYROLL/SUPPLY CAHIN) and help functional consultant with their work.
. Installing and configuring administration of Oracle 10G which is the
database for Siebel application.
. Involved in managing Oracle10g databases and creating database
objects, which include data files, transaction log files, file groups,
tables, views, indexes, and stored procedures.
. SQL Tuning using Explain Plan, TKPROF with SQL trace and SQL Tuning
Advisor with Enterprise Manager. Monitoring database performance by
AWR and ADDM alerts
. Upgrade the database from 9.2.0.6 to 10G for HR global patch
installation.
. Overall maintenance of the Oracle database 10G & applications.
. Installed and configured oracle DATAGUARD.
. Database and application optimization including performance tuning,
query optimization and supportability
. Use Stats pack for 9i and AWR for 10g to collect complete database
statistics to identify database bottleneck and high resource SQL
statements.
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Configuration and installation of 10G IAS application server.
. Reviews, evaluates, designs, implements and maintains Oracle database
10G.
. Work with business users to resolve performance issue.
. Administer & maintain Oracle 10G instances, provide end-user support,
application of patches.
. Coordinate the architecture activities throughout the program
timeline.
. Oracle Database & Applications Technical Support Proposals /
Solutions.
. Database Problem Diagnosis, Research, Fix, Testing and Resolution
apply and test Patches on 11i environments.
. Created Oracle Test Environment server to test new software and
patches before applying to the production server.
. Provide 24x7 on-call support for databases and disaster recovery
support.
. SQL Net installation/configuration/troubleshooting (Server and Client
side).
. Design, implementation and support of backup and recovery procedures.
. Create, modify and maintain database objects, users and security
management
. Creating Applications and Database Users and maintaining Applications
and Database security by controlling and monitoring user access to the
database and Applications.
. Installation of printers at operating system and then defining in
oracle application.
. Technical Documentation for Oracle ERP Solutions
. Experienced in performing database audits and user management
. Experience in working with internal users to identify and resolve
application issues.
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Experience in working with internal users to identify and resolve
application issues.
. Working knowledge of EMC backup storage over VM ware servers.
. Experience in SYSADMIN.
. Experience in Concurrent Managers and Concurrent Programs.
. Experience in running debugging scripts.
Environment: Oracle E-Business Suite 11.5.10.2, R12 12.0.0.4, Windows 2003,
Enterprise Manager, Toad.
April-07 - Dec -07
Client: Fidelity investment Durham, NC
Role: Oracle Apps DBA
Fidelity Investment Employee Services, Health and Welfare division
provide the services for 401k benefits one of the world's largest
providers of financial services, Fidelity Institutional Wealth
Services offers a powerful set of capabilities for registered
investment advisors, trust institutions and third-party
administrators.
Responsibility:
. Installing and configuring administration of oracle application 11i.
. Oracle 11i Administer development, staging and production environments
on AIX, create users and responsibilities, administer & maintain
Oracle 9.2.0.8 instances, provide end-user support, application of
patches, patch management.
. Created Oracle Test Environment server to test new software and
patches before applying to the production server.
. Database Health Check and Tuning for existing system applications used
in the production environment using RDA (Remote Diagnostic Agent),
Stats pack, ACT (Application Collection Tool) and Enterprise manager.
. Troubleshooting and assisting development team and patching of the
instances
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Create, modify and maintain database objects, users and security
management
. Production cycle support and maintenance.
. Extensive working knowledge in maintaining and configuring large scale
multi terabyte databases.
. Administration of the onames server.
. Give support to modules like (Financials/HR, PAYROLL) and help
functional
. Database and application optimization including performance tuning,
query optimization and supportability
. Installed and configured oracle standby databases.
. Creating Applications and Database Users and maintaining Applications
and Database security by controlling and monitoring user access to the
database and Applications
. Experienced in performing database audits and user management
. Database support (pre-production and production)
. Work closely with Fidelity developers to install/test fixes and
enhancements
. Database refreshes and copies.
. Snap technologies for database restoration and cloning through EMC.
. Managing Concurrent Managers and Concurrent Programs.
. Running AD Utilities to administer the Applications.
. Use Stats pack for 9i and AWR for 10g to collect complete database
statistics to identify database bottleneck and high resource SQL
statements.
. Cloning from production to test/dev instances.
. Managing Application utilities like Rapid Install, Ad Patch, Ad admin,
and Ad ctrl etc for application maintenance.
. Database Problem Diagnosis, Research, Fix, Testing and Resolution
apply and test Patches on 11i environments.
. SQL Net installation/configuration/troubleshooting (Server and Client
side).
. Support for maintenance, troubleshooting of 11i environment.
. Experience in working with internal users to identify and resolve
application issues.
. Experience in SYSADMIN.
. Experience in running AD Utilities to administer the Applications.
. Experience in running debugging scripts.
Environment: Oracle E-Business Suite 11.5.10.2, AIX, Oracle 9i, PL/SQL,
Enterprise Manager, Toad.
Client: Lincoln Financial Group (LFG), Greensboro, NC
Jul-05 to Mar-07
Role: Oracle DBA
Lincoln Financial Group is a provider of investment products, life
insurance and group and employee benefits, group benefit, mutual funds,
automobile, investment management and business insurance. They have
extensive products in providing claim handling and claim processing
services.
Responsibilities:
. Installing and configuring administration oracle database 9i, 10G.
. Design, implementation and support of backup and recovery procedures.
. Support of multiple production, development and test environments.
. Installed and Configured a two tiered disaster recovery solution
involving
physical/logical standby databases with Oracle DATAGUARD.
. Installation and configuration of Real application cluster (RAC).
. Implemented Oracle10g Real Application Cluster (RAC) environment with
high availability and for disaster recovery solution. Supported the
performance issues of Oracle10g RAC environment with other DBAs.Also
supporting application development teams.
. Designing and planning of database, which involves deciding about
logical storage structures and forecasting future expansions.
. Extensive working knowledge in maintaining and configuring large scale
multi terabyte databases.
. Configured ASM (Automatic Storage management) and migrated the
databases to ASM. Proactive database monitoring using 10g grid
control.
. Clone RAC database to non RAC environment.
. SQL Tuning using Explain Plan, TKPROF with SQL trace and SQL Tuning
Advisor with Enterprise Manager. Monitoring database performance by
AWR and ADDM alerts
. Reviews, evaluates, designs, implements and maintains database
. Experience in working with ETL from source to target.
. Provide 24x7 on-call support for OLTP database and disaster recovery
support.
. Migration of existing application to Oracle 9i to 10g.
. Re-organization of database.
. Use Stats pack for 9i and AWR for 10g to collect complete database
statistics to identify database bottleneck and high resource SQL
statements.
. SQL Net installation/configuration/troubleshooting (Server and Client
side).
. Modifying the database structure, according to requirements of the
application.
. Performance tuning, SQL tuning.
. Install and configured OID (Oracle internet directory).
. Developing the backup and recovery strategy, configuring RMAN for
backup and recovery.
. Database Health Check and Tuning for existing system applications used
in the production environment TOAD.
. Setup, configure and implement Oracle DB Disaster Recovery Servers
using DB Cloning, RMAN and Archive logs.
. Designed and architected database server for higher availability,
performance and capacity
. Implement Database level auditing using AUDIT_TRAIL.
. Performance tuning and maintenance of Oracle database.
Environment: Oracle Database 9i, 10G, Sun Solaris, HP UNIX, Windows XP,
Enterprise manager, Toad.
Integrator: Jaffer Business Systems (JBS). Mar-02 - May-
05
Client: UBL, Getzpharma, PARCO, Hinopak, Engro Asahi Polymers &
Chemicals
Role: Oracle APPS DBA
JBS partners with Oracle in providing its customers the entire stack of
technology - Oracle Applications, Tools and Core Technologies. JBS have
partnered with Deloitte & Touch, Ernst & Young International and A.F.
Ferguson for the implementation of Oracle Applications at the clients'
sites. One of the largest ERP implementers in Pakistan with clients like
(united limited bank, Getzpharma, Tapal Tea, Hinopak, Pak Arab refinery).
Responsibilities:
. Installation, maintenance and upgrades of Oracle Applications (11.0.3,
11.5.7, 11.5.9, 11.5.10).
. Oracle Database & Applications Technical Support Proposals / Solutions
. Packaging for Oracle Technical & Functional Support Services
. Designing project plans for Jaffer Oracle Support Centre
. Creating awareness regarding Oracle Applications and Database
Upgrades, Disaster Recovery Plan (DRP) Solutions, and the need of an
ON - SITE support offered by Jaffer Brothers Private Limited based on
yearly contracts.
. Hardware Sizing Proposals / Solutions
. Experience in working with IBM p series and HP superdome servers
. Technical Documentation for Oracle ERP Solutions
. Installation, maintenance and upgrades of Oracle Applications.
. Operating systems upgrades and migration.
. Patching and cloning of database.
. Provided all kinds of DBA support to development teams as well as
production support to various applications.
. Upgrade from Oracle Applications R10.7 to Oracle Applications R11.5.9.
. Performance tuning and maintenance of Oracle database.
. Design, implementation and support of backup and recovery procedures.
. Designing and planning of database, which involves deciding about
logical storage structures and forecasting future expansions.
. Installed and Configured a two tiered disaster recovery solution
involving
physical/logical standby databases with Oracle DATAGUARD.
. Managing physical and logical storage structure
. Security Administration by creating Users with appropriate roles and
privileges.
. Re-organization of database.
. Provide 24x7 on-call support for OLTP database and disaster recovery
support.
. Configured and managed oracle Data Guard for high availability.
. Uses Application Desktop Integrator (Oracle ADI) to import / export
large number of data to/from Oracle Financial tables from/to Excel.
. Upgrade from Oracle Applications R11.5.7 to Oracle Applications
R11.5.9.
. Configure ADI and workflow notification.
. Upgrade family pack.
Environment: Oracle E-Business Suite R11i (11.5.x), TRU64 UNIX, Windows XP,
PL/SQL, Toad Enterprise Manager.
Integrator: iWAYS. Jan-1999 - Feb-02
Client: Karachi Port Trust
Role: Oracle DBA
IWAYS is software development house which build a business application
for Karachi port trust known as vessel control system.
Responsibilities:
. Plan Database with application requirement make physical design for
database and optimize the application e.g. Create Foreign Key Indexes
to reduce locking issues, create locally managed Table spaces,
configure Parameter for instance to reduce contentions of latches
. Install and Configure Oracle 9iAS (Application server) Make database
backup strategy, configure database in archive log mode so no data
loss is guarantee,
. Utilize best of their resources a weekly cold backup is taken on
separate tape drive and archiving on another tape drive using RMAN. As
per application requirement design sequences with enhance
functionality.
. Configure STANDBY DATABASE (Oracle 9i Data Guard Maximum Protection
Mode) to meet their requirement of minimize downtime and 0% Data Loss.
Environment: Oracle Database 8i, 9i, Linux, Enterprise Manager, Toad.
* - References shall be furnished upon request.
Contact this candidate