Summary

• 24 years of Information Technology experience. 17 years Dev/Test/Production Oracle Database Administration from version 7, 8, 9i, 10g to 11g, under different OS platform AIX,Sun Solaris,HP-UX,Linux, Windows , ASM. Oracle Apps and E-Business Suite DBA from version 10 to 12.
• 8 years Oracle Application DBA.
• Proficient in Database/Apps Administration from Installation, Upgrade, Patching, Cloning of Databases, User Management.
• Proficient in Performance Tuning using AWR, ADDM, Global ADDM, ASH, OEM, Statspack, I3.
• Proficient in Backup and Recovery. Planning, designing, implementation, support, documentation of Backup/Recovery/Archive using RMAN, Netbackup BMR, SSO, Puredisk, VTL, B2D , TSM, SQL Backtrack, Netvault.
• Proficient in Database/Server/Storage Migration from one database to another. From old versions to new versions of Oracle. From and to different Hardware/Servers, From old to new datacenter.
• Proficient in Database/Server/Storage Capacity Planning.
• Proficient in Data Security. Supported/provided/complied with the Auditing requirements of the Auditors.
• 13 years experience on planning, design, creation, support and maintenance of OLTP databases ranging from 500 GB to 500 TB of data.
• Managed Development, Test, QA, Project and Production databases and OS from GB to TB of data of Telecommunication companies in US, Australia and Asia Pacific Banks, Telecommunication, Government agencies, Manufacturing and Logistic Companies.
• 11 yearsexperience on Datawarehousing, Datamining, from planning, mapping, extraction, cleansing/transformation, loading Informatica up to querying, reporting of data using BI tools like Oracle Discoverer, Business Objects, OBIEE Answer/Publisher and Crystal Reports.
• Planned, Designed, Implemented, TroubleshootRAC, DataGuard, ASM, Streams and GoldenGate, SOA, OID.
• Utilized Data Pump, Flashback and other new features of latest Oracle database releases.
• 12 years experience using Oracle Database tools like OEM, DBArtisan and TOAD.
• 7 years experience managing E-Business Suite R11 and R12. INV, PO, FA, GL etc
• Installed, configured, supported Oracle Forms, Reports and Discoverer.
• Created and updated accurately present Standard Operating Environment.
• Highly experienced with IT processes such as SDLC, ITIL, Change Management, Release Management, SOA Patch Management, Problem Management, Business Continuity Plan and Vendor Relationship Management.

Technical Summary

Hardware : IBMPower 770, P590, P595 RISC/6000 R24,R30,F50,S7A , AS/400, Sun E250,E450, E10K, T2000, HP Superdome, 9000 K Series,Texas Instrument 990, Compaq Proliant, AlphaServer, NetApp, Storagetek. NCR 4980, 5380,Exadata,

Oracle Products: Oracle RDBMS ver 7, 8.x, 9i, 10G, 11gr2, SQL Net, Net 8, Oracle Forms, Reports and Discoverer, Oracle Designer 6, Oracle Financial Software Application OFSA , EBusiness Suite r11and 12, Oracle Express, Access, RAC, Streams, Active DataGuard, RMAN 10 and 11g. Oracle 9AS and 10 Application Server. Oracle Vault, Oracle Identity Management, Oracle Warehouse Builder, Oracle Data Integrator. OEM DB Control and OEM Grid Control. Golden Gate.Oracle RUEI, OEM Fusion Middleware Control, OID, RAT, Advance Compression, Weblogic, Tuning Pack, Audit Vault, Database Vault, OLAP.

Storage/Backup SW/HW: Veritas Netbackup 5.x, 6.x, Netvault, NAS SAN, EMC Storages Symetrix DMX 1000, 2000, DMX 4 ,EMC/BCV, FasTt. SQLBacktrack 7.x, TruCopy, HDS Shadow Image.

DWH and BI Tools: Informatica Powermart 2.x, Cognos, Business Objects, Crystal Reports

High Availability/DR Software: Oracle RAC, IBM HACMP, HP Service Guard

Monitoring Tools for Database/OS : OEM Grid Control, TOAD, DB Artisan, I3, BMC Patrol, Nagios,

Other Software: Sybase, MS Exchange, MS Cluster Server, Apache Web Server Clustering, EMC BCV, Dimensions,

OS: HP-UX 10x, 11x, AIX 4.x, 5,6.1 Sun Solaris 7, 8, 9, 10, RH Linux, Windows 2003, 2008, SCO Unix

Programming: UNIX Shell scripting, SQL/ PLSQL,

Professional Work History:

Confidential

Senior Oracle Consultant

• Managed Dev, Test and Production databases.
• Upgraded Oracle 10g to 11gr2
• Migrating 1 node to RAC environment
• Applying patches, Database Clonning
• Database Security, Auditing and compliance.
• Managed E-Business suite.
• Database Tuning and Backup and Recovery implemented RMAN and Active Dataguard
• Database refresh from Prod to Test.
• Managed Exadata, Oracle Linux
• Database Replication using Golden Gate.

Confidential

Lead Oracle Application DBA

• Managed Dev, Test and Production databases and Applications.
• Test databases Refresh.
• Database Tuning using AWR, ADDM etc. Monitor, troubleshoot Netbackup backup.
• Database Documentation Operation Manual and Contingency report
• Backup and Recovery documentation and support.
• Applying Oracle and Application Patches CPU .
• Application upgrade from version 11 to 12.
• Database Migration from Oracle 9i to 10g to 11gr2.
• Planned, installed, configured and maintained OEM 12c

• Database and Oracle R12 Applications administration, support, and maintenance
• Patching and upgrading Oracle Applications
• Database maintenance and migration
• Oracle Database and Applications security
• Cloning Oracle Database and Applications
• Disaster recovery of Oracle Database and Applications
• Management and maintenance of enterprise management system OEM
• Manage and support Oracle Golden Gate and Oracle Business Intelligence OBIEE
• Management of Dell/Quest Foglight monitoring tools.

• Oracle eBusiness Suite experience in both project and enterprise level production support environments:
• Installation, Configuration of components. Workflow, Patching Analysis, Environment Cloning, Admin utilities, Starting / Stopping Environments, Troubleshooting,Planned,
• Installed, configured Implemented and supported Production replications using Golden Gate for 3 locations institutions.Using One way, broadcast and integration replication. Using GG Director and Veridata.
• Managed Middleware products, Weblogic, SOA and OSB, RAC, DG, ODI and OAM..

• Created OBIIE Answers reports, KIR.Design and develop the OBIEE Metadata Repository including the physical layer, business model, mapping and presentation layer for various subject areas.Design, develop and configure Dashboards, Answers requests, prompts, and BI Publisher reports as per user requirements Proactively prevent and support data quality issues, query performance and reportassistance through BI user community Administer and configure the OBIEE reporting platform including security.
• Develop project plans and communicate project status to the appropriate members of the project team.Work with customers and business analysts to understand requirements and develop the BI reporting solution.
• Actively participate in architectural reviews and provide guidance on Business Intelligence and Data Warehousing
• Plan, Design, Implement, Support and Document RAC 11g, ASM for new Project.
• Implemented Oracle Data Masking.
• Managed 6 new IBM P770 Servers, Creating LPAR, DLPAR, VIO. Installed AIX 7 on LPAR at IBM P770 servers. Created AIX SOE. Created plan for backup using Netbackup 7.x, HP Servers and RHEL.

• Installed and configured VIOS servers and related LPARs through HMC.
• Installation, configuration and maintenance of IBM PowerHA/HACMP on AIX 6.1 and 7.1.

• Created Volume groups, file systems, LVs, adding PVs disk
• Applied patches for databases and O.S.
• Managed 3 members of Database Admin Team. Assigned Project task. Mentoring
• Supporting Test Team, tuning the new Oracle 11g Database servers to work on SOA.

Environment:E Business Suite 12, AIX, IBM Power P 770, Oracle for Windows, EMC Symetrix DMX 4,HP-UX, Linux, Oracle 9i. 10g and 11g. OEM Grid Control 11g and 12c,OBIEE and OBIEE Answers, SOA, Netbackup 7. Foglight, ODM, ODI, RAC, Data Guard, ASM, Golden Gate, Exadata.

Confidential

LeadOracle DBA/Apps DBA Consultant

• Managed Dev, Test, Prod Oracle 10g, 11g assigned Databases.

• Supporting Developers, Testers on transferring newly created/updated codes from Dev to Test to
• Production databases release.
• Performance Tuning using AWR, ASH, ADDM
• Supported backup and recovery using RMAN, and TSM. Implemented on Dev and Test.
• Clonningof databases.
• Installed, configured and supported Oracle Forms, Reports and Discoverer for 1 project.
• Supported Golden Gate for database replication.
• Daily database administration doing tables partitioning, export/import using Data Pump, creating
• indexes, synonyms, sizing tables, refreshing Materialized view, approving codes for testing and
• implementation to Production. Supporting, troubleshooting RAC and Dataguard .RAC Installations, adding/deleting Nodes
• Maintaining databases using Oracle Grid Control, I3 and TOAD.
• OCFS/OCFS2 file systems. Managing, Restoring and Recovering Clusterware Components OCR,VD
• Patching RAC databases. Troubleshooting Node/Instance evictions. Implemented RAC with
• Managed on-call Production DBA activities such as checking on tablespace problems, nightly/weekly
• backup problems, responding to Oracle errors, and blocking locks conditions.
• Applying Oracle patches. CPU
• Diagnosed and corrected problems in Production and non-Production Databases. Doing root-cause
• analysis and implementation of permanent solutions
• Rehosting of databases to new servers and storage. Database refresh using SQLBacktrack, BCV.
• Monitor database capacity and estimating growth based on the current/previous size/load.
• Doing a continuous database health check of the databases.

• Review physical data models, data access patterns, and database design.
• Work with Development Team and Test Team to identify any potential issues in their design or PL/SQL code and to ensure that the design/solution are appropriate.
• Projects : Purging of Production database and Migration of databases from old server/storage to a new one.
• Lead the projects and mentor the other DBA.

Environment: Oracle 10g, 11g, Solaris, AIX, HP-UX, SQLBacktrack 7, RMAN, TOAD, I3, RAC, ASM, Active Dataguard. RAC, Grid Control, Golden Gate, HP PA-RISC and Itanium Server, Dimensions. Fusion Middleware.

Confidential

Lead Oracle DBA/Database Architect Consultant

• Working with Database Architecture Group who are managing 1000 plus databases on Oracle 10g and 11g from Development, Test to Production.
• Planned, designed, implemented, support, troubleshoot RMAN, RAC, DataGuard, RAT, GoldenGate and Streams
• Database Maintenance, Performance Tuning, Back up and recovery.
• Provide DB design and architecture support for new and existing applications. perform data modeling and evaluate requirements for performance, availability and replication incorporating them into the final design. Creating tablespaces, schema, users, sizing of tablespace etc . on ASM.
• Data modeling of new and existing schemas to create new designs and optimizations for existing designs ensuring normalized data modeling of entities, attributes and relationships.
• Evaluate requirements and best practices to provide product recommendations based on suitability to task.
• Perform logical database design, capacity planning and external data interface specifications.
• Created data loading plans, data maintenance plans, design security policies in conjunction with existing policies and security teams
• Documented and communicate the database design, analyze data in the current schema, make recommendations for improving data integrity and creating Oracle sizing guidelines to assist operational DBA's in setting up database environments.
• Assist with the optimization of database instances, PL/SQL queries and to quickly escalate and resolve design related issues Review failures or results providing recommendations to prevent future occurrences
• Planned, installed, configured, implemented and supported Oracle Golden Gate Broadcast replication.

Environment: Oracle 10g, 11g, Solaris, Linux. DBArtisan, Patrol, SQLBacktrack, RMAN, PowerDesigner, RAC, ASM, Dataguard, Golden Gate. IBM P590, HP Superdome. SOX

Confidential

Senior Oracle Apps DBA Consultant

• Managed 6 Projects simultaneously. Planning, sizing, building the databases for Dev, System, UAT and Production. From installing Oracle binaries, applying patches, creation of databases, schemas, users, database refresh, etc.
• Installation, configuration of backup system and monitoring system.
• Coordinating with Apps Group for any request and troubleshooting.
• Participated on on-call schedule to troubleshoot Production databases.
• Followed bank standards on creating databases. Improved documentations.
• Experience with fulfilling regulatory compliance auditing and evidence collection Sarbanes Oxley and audit/database logging.

Environment: Oracle 10g, 11g, Solaris, Linux. DBArtisan, Patrol, SQLBacktrack, Streams, ASM, RAC and Grid Control, OBIEE, OEM, Foglight, SOX

Confidential

Senior Oracle DBA Consultant

• Managed Oracle 10g and 11g databases. Migration, Dev, Test, Pre-Production
• Implemented RMAN backup, Data Pump and Dataguard.
• Planned, designed, implemented and documented RAC.
• Built new Linux servers for the infrastructure changes to accommodate new databases.
• Performance Tuning of Pre-Production, using ADDM, AWR, ASH and SQL Tuning
• Database, tablespace, table sizing. SGA or parameters sizing.
• Troubleshooting Oracle Problem.
• Code deployment from Dev to Test to Pre-Prod.
• Participated on different group meetings and On-call Roster
• Documentation.

Environment: Oracle 10g, 11g, Red Hat Linux.OEM Database Control, RAC and Grid Control, Weblogic, Remedy

Confidential

Senior Oracle DBA Consultant

• Managed Data warehouse Dev, Test and Production.
• Refreshed data from Prod to Test.
• Supported Informatica for ETL.
• Installed, configured Oracle 11g for Test machine.
• Monitor/troubleshoot backup using RMAN/Netbackup.
• Maintained RAC, ASM
• Adding disk to ASM and load balance.
• Hardware/Software/Process documentation.

Environment: Solaris, Oracle 9, 10g,11g, Informatica PowerCenter 7.3 and 8, OWB, RAC, Remedy

Confidential

• Database Creation, Administration, Cloning, Troubleshooting, Monitoring
• Updating existing documentation and creating SOE for Oracle.
• Managed backup using RMAN and Netbackup.
• Planned, designed, implemented and managed RAC and Oracle Applications 9 and 10.
• Migrated some dev database from 10g to 11g.
• Supported Applications, and Web Tier.
• Produced report on system availability, usability, performance, incidents, root causes and solutions.
• Planning and implementation of appropriate database capacity increases that is required to support continuous business growth
• Planning and monitoring of proactive maintenance activities required to ensure ongoing database operations at required SLA levels, including management of database performance, availability, recoverability and data security.
• Participating in the planning, implementing and testing of appropriate backup and disaster recovery activities to ensure ongoing business continuity.
• Managing the long term system strategic life cycle planning such as remediation programs and decommissioning plans
• Incident resolution and system restoration
• Conduct root cause analysis and problem rectification, including system changes required to prevent a recurrence of the incident. Implement urgent system changes as required due to a fault or incident.
• Produce regular reports on system availability, usability, performance, incidents, root causes and other measurements.
• Maintain required levels of knowledge and documentation relating to the systems
• Engaging in appropriate change management, release management, release planning, risk assessments mitigation strategies.
• Configured Table Partitioning using Range, Hash and Composite partitioning techniques for Production and Warehouse Databases
• Defining operational requirements for new systems

Environment:Linux, Oracle 9, 10g, Application Server 9iAS, RAC, Streams, OEM Database Control

Confidential

Senior Oracle DBA/Unix SysAdmin Consultant

• Planned, designed, sized, created new Oracle Databases.
• Implemented RAC, ASM, and Dataguard
• Managedphysical and logical structures of database.
• Managed storage based on design.
• Managed security. Database Tuning.
• Createddatabase backup/recovery using RMAN and Netbackup.
• Database and Application problem troubleshooting.
• Install/build Linux, AIX, create filesystems. Upgrade/patch software. Creating LPAR's, Setting up NIM Server.
• Cabling SAN, Document backup/restore/dr of databases of Prod/Dev machine.

Environment: IBM P590. AIX 5, Linux, Oracle 9, 10g, RAC, ASM, Dataguard, RMAN, DataPump, OEM

Confidential

Senior Oracle DBA/Solaris Admin Consultant

• Cloned Databases to produce another set of Prod Oracle10g , Pre Prod, QA and Training.
• Implemented RMAN backup and recovery.

Environment: Linux, Solaris, Oracle 10g, Dataguard, RMAN, DataPump, OEM, Netbackup

Confidential

OracleDBA/Unix Sys Admin Consultant

• Oracle Database Administration, patching, upgrading version 9.2 to 10G of 10 Production and 5 Development and Test databases with a total of 10 Terabytes
• SAP Administration, upgrade.
• Implemented RMAN backup system
• RAC design and implementation
• Unix Administration, Storage Administration.

Environment: IBM P595. AIX 5, Linux, Oracle 9, 10g, Dataguard, RMAN, DataPump, OEM Database GRID Control, TSM, SAP

Confidential

Oracle DBA/Netbackup Specialist

• Improved Filesystem/Oracle backup/recovery system for their clients Connex, Vline, HDS using Netbackup
• Day to day Database Administration
• Monitoring/Troubleshooting and on-call.
• Documentation

Environment: Solaris, HP-UX, Linux, Oracle 9, 10g, RMAN, DataPump, OEM, Netbackup, Sybase, Rem

Confidential

Oracle DBA/Unix Sys Admin

• Managed Oracle Databases in Dev, Test, QA and Production machine running in Solaris Unix internally and Kaz Clients.
• Upgraded Oracle 9i to 10 G for Development/Test machines.
• Set the automatic segment management, use Data Pump. Tablespace Management
• Partitioned big tables, created more indexes and views for the Production system.
• Install, configure and utilized Oracle Enterprise Manager.
• Backup the systems
• Documentation of the whole system and the daily. Weekly, monthly or ad hoc task.
• Set-up Data Guard
• Support AIX, Linux running in P590 Server.
• Migration of data center from IBM datacenter to Kaz Datacenter.

Environment: IBM P590. AIX 5, Linux Red Hat, SUSE , Oracle 9, 10g, RAC, ASM, Dataguard, RMAN, DataPump, OEM, Netbackup, Weblogic, HACMP

Confidential

Senior Oracle DBA

• Managed Telstra Databases. Implemented RMAN and Netbackup backup for Solaris and Oracle databases running in Solaris, AIX and HP-UX.
• AIX installation, configuration, Created NIM, LPAR, HACMP

Environment: IBM P590. AIX 5, Linux, Oracle 9, 10g, RMAN, OEM, Netbackup, TSM

Training Summary

AIX 4.3, HP-UX 10, Sun Solaris 9, 10 Basic and Advanced Systems Administration.

Oracle Database Administration, Oracle 8i, 9i, 10g,11g for Administrator. Oracle Developers 2000, Express Database, Discoverer, OFSA, Microsoft SQL Server, MS Exchange Server, Netbackup v, 4.5 5.1, 6. DB2, Novell Netware, Informatica., SAN, NAS. Teradata Basic and Datawarehouse Administration, Basic and Advance SQL, Teradata, Six Sigma, ITIL, MySQL