SUMMARY

• Over Nine years of experience working as Oracle Application DBA,OBIEE,OIM in OLTP, production support DBA and data warehouse systems. Installing, Optimizing and Administering of Oracle Apps DBA.
• Involved in Technical project implementations, Requirements Analysis, Workflow Analysis, Business process design and Standard Operating Procedures.
• Managed and led a team of software engineers from modeling to implementation involving Oracle Apps / SQL server database.
• Experience in implementing or designing implementations of Oracle Identity Manager (OIM), Single Sign - on (SSO), Oracle Internet Directory (OID), Oracle Access Manager (OAM) and analyzing complex access requirements against highly-sensitive data and designing and/or implementing reliable and secure solutions to accomplish them.
• Fair knowledge in designing functional and non-functional test scenarios and execution of scenarios
• Experience in deploying enterprise topologies for the Oracle Identity Management Infrastructure Components.
• In-depth understanding of Installation, configuration and maintenance of the IAM environments.
• Experience in gathering user requirements, Planning, Data modeling, Data structure, Tables, Database designs, Normalization, Stored Procedures, Database & Instance Creation. Strong Experience in Oracle Apps 11i/12i on different UNIX platforms and Windows.
• Implementation and maintenance of Oracle Real Application Cluster (RAC). Experience working with Oracle 10g Automatic Memory Management, Oracle Flashback and FGA.
• Comprehensive experience of using Oracle partitioning options, materialized views and external procedures, in order to gain best performance. Managed and maintained Golden Gate Processes. Provided troubleshooting for abended processes.
• Extensive experience of communication with Oracle Support for various production level issues, Oracle bugs and severity issues.
• Maintain the all Network Devices and point to point connectivity via lease line.

TECHNICAL SKILLS

Databases: 11i APPS SERVER (11.5.8, 11.5.9), 12i,Oracle 11g/10g/9i/8i, Dbase, FoxPro, SQL SERVER 2000 /2005.

Operating Systems: Sun Solaris, HP-UNIX, Red Hat Linux and MS-Windows NT/2003/XP

DBA Tools: Oracle Enterprise Manager, TOAD, Export & Import, Data Pumps, Flash Back, SQL Loader and RMAN.

CASE Tools: Oracle Designer 10g/9i/6i - Data Modeling, Process Modeling, Entity Relational Diagramming and Erwin.

Front-end Tools: Visual Basic, Forms / Reports Interfaces.

Programming Languages: SQL, PL/SQL, Korn Shell Script, BASH Shell Script.

Application Servers: Oracle Application Server 9i / 10g.

PROFESSIONAL EXPERIENCE

Confidential

Senior Consultant

Responsibilities:

• Monitoring and Managing Oracle Database 11g, 10g and Application.
• Responded promptly to On-Call pagers / email alerts due to issues arouse from a wide range of architectural and functional features. Eg. Replication (Golden Gate), Data Guard, RAC, ASM, Streams, Bigfile tablespaces, Materialized view, DBA JOB and scheduler job, RMAN etc.
• Provided On-Call DBA support as a member of a dedicated 24/7 oncall DBA team.
• Applying latest releases of the patches from Oracle to the instance to resolve few application issues
• Installed 11g/10/9i on many servers. Upgraded 8.1.7 to 9.2.0 on many servers on different platforms.
• Upgrade of Applications from 11.5.9 to 11.5.10 on test servers successfully
• Designed Backup strategies and wrote scripts to manually implement it.
• Implemented Backups on Disk, using Veritas Net Backup and BCV.
• Heavily involved in Capacity planning and Performance tuning.
• Worked to bring all our systems in compliance with Sarbanes-Oxley (SOX).
• Worked in Sun Cluster environment with Oracle RAC.
• Managed and maintained Golden Gate Processes & provided troubleshooting
• Designed Data Warehouse projects including Data Design, Tools selection, Designing Target databases, Defining data sources etc.
• Working in a 24/7 environment with ON-CALL rotation.
• Supporting mission critical Payments application
• Performance tuning, OEM managing and monitoring.
• Recovered the database in a hard disk failure (Performed a point in time recovery).
• Mentored other DBAs and Developers.
• Working in HP-UX, AIX, Linux and Sun Solaris environment.

Confidential, CA

Sr.Oracle Apps DBA/Data Analyst

Responsibilities:

• Installed Oracle 11i Apps Server (11.5.8,11.5.9),12i on Solaris and created the test database for the Application.
• Migration and up gradation of Database 11i to 12i.
• Maintenance Oracle 12i servers as production and test database.
• Writing RMAN backup Scripts and testing on the database.
• Installed and applied patches for the same from the metalink site.
• Involved in load testing and capacity planning of Production/Development databases.
• Configured and implemented RMAN utility for backups and recovery.
• Prepared and implemented the backup and recovery strategies.
• Conducted disaster recovery trials from missing data files, redo logs and entire database using the backups.

Confidential

Staff Consultant

Responsibilities:

• Installed Oracle 11i Apps/12i on Solaris and created the test database for the Application.
• Install and maintain Oracle Applications in typical environments such as Single-node and multi-node installations.
• Migration and up gradation of Database 8i to 9i.
• Maintenance Oracle Application servers 11i as production and test database.
• Writing RMAN backup Scripts and testing on the database.
• Installed and applied patches for the same from the Oracle metalink.
• Involved in load testing and capacity planning of Production/Development databases.
• Configured and implemented RMAN utility for backups and recovery.
• Prepared and implemented the backup and recovery strategies.
• Conducted disaster recovery trials from missing data files, redo logs and entire database using the backups.
• Automated the database maintenance procedures, Ex. Gather statistics, rebuild indexes, Like Clean up log files, cycle alert log at server startup etc
• Developed shell scripts, tuning queries, PL/SQL procedures to monitor the databases.
• Involved in Troubleshooting and Supporting databases, applications and development tools.
• Created and Maintained Documentation of databases and the related products.

Confidential

Oracle DBA / Network administration

Responsibilities:

• Oracle software installation and Database migrations as part of the current system migration process from Oracle 8i to 9i
• Played a vital role in multi tera bytes data warehouse project as a Database Administrator (DBA).
• Provided the optimum database design and backup and recovery policy that meets the business requirement and standards
• Gather business requirement and provide logical and physical database design.
• All concerning Networks matters, Internet & their Securities.
• Implementing interVLAN routing.
• Creating VLAN’s for management purpose.
• Responsible for designing and implementation of customers network infrastructure