Summary

• 8 years of experience as an IT professional along with extensive experience as an Oracle DBA, transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions.
• Experience in Administration, Performance Tuning, Backup/Recovery, Upgrade, Security, Provisioning, Consolidation of, development, staging, validation, qa and production database environments.
• Oracle Certified DBA, proficient in Oracle 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x design, installation, administration, management, performance tuning, upgrades, disaster recovery strategies, and high-availability solutions on Sun Solaris 10, 9, 8, HP Unix 11.x, AIX 5.x, 6.x, Redhat Enterprise Linux 4.0, Windows-2003, Windows-2000, Windows NT 4.0 environments, on HP Blade servers, Sun Sparc servers, HP and EMC SANs.
• Experience in design, deployment, administration, management of Disaster Recovery solutions, proficient in Business continuity and High availability solutions, using Data-Guard, RAC, ASM and RMAN.
• Efficient knowledge Monitoring, Troubleshooting RAC cluster using Srvctl, oradebug, TAF.
• Strong experience in implementing and monitoring Physical Standby Database for Data Guard disaster recovery technique and DGMGRL.
• Proficient knowledge in configuring ASM for RAC databases.
• Managed Db2 Databases in test and dev environments using command line and control center
• Good Experience in Installing db2 9.1 fix pack 6 on Solaris 10
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 40 Terabytes of Oracle Databases on Oracle 11g/10g/9i.
• Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV'S, SRDF, and managing of partitions and clustering of tables.
• Experience in using OEM, TOAD, and Data Migrations using export/import, ATG, benchmarking using Load testing tools
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Experience with Data Modeling, Logical and Physical database design.
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Involved in doing Data Modeling, data mart, designing data warehousing boundaries and parameters, Data Transformation, PL/SQL. Experience in using Golden Gate to support data replication in the Oracle database environment.
• Experience in installing and configuring Golden Gate 9.5.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Expertise in Oracle Golden Gate software.
• Experience in upgrading databases. 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1 .
• Experience in implementing security policies to meet SOX Compliances
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM. Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Excellent work experience in developing applications using Oracle SQL Scripts, PL/SQL, shell programming, and PRO C optimization.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Supported a large number of Development Databases, mainly in tuning the SQL code to improve Performance
• Recovery of Databases Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc. .
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script development and documentation.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Used Grid Control, Oracle Enterprise Manager and command line Sqlplus and 3rd party administrative tools like Toad.
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs UNIX , Autosys jobs, Scheduled Tasks Windows .
• Knowledge of Data transfer between SQL Server and Oracle.
• Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups Restores, Security Management, DTS import/export, Performance Tuning.
• Strong experience in design, deployment and administration of large Data warehouse and Data mart Databases.
• Strong experience in Oracle database replication techniques using Oracle DataGuard, Materialized Views.
• Extensive experience in design, deployment and administration of databases of sizes ranging from 200 GB to 6 TB plus in large enterprise environments.
• Strong experience in working with various project, application and infrastructure teams, in large enterprise projects, along with architecture, design and deployment of new databases.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Strong experience in evaluation, design and deployment of centralized database monitoring and administrating solutions using tools like Oracle Grid Control 10g/11g, Spotlight.
• Strong experience in Database Migration/Upgrades various Oracle platforms to Oracle 11g, 10gR2 and Oracle 9.2.0.x environments.
• Strong experience in database performance tuning using tools like Oracle Grid Control 10g R2,sql trace, tkprof, AWR, ADDM, SQL Advisor, Spotlight, Performance Analysis, SQL Tuning.
• Strong experience in Database provisioning, consolidation and configuration management.
• Strong experience in complete Systems Development Life Cycle, using object oriented design and development methodologies on client-server and three tier architectures, Business Applications Development and Project management.
• Diverse experience of full life cycle of deployment project management, across diverse domains, experienced in Global business and IT best practices across various Fortune-500 and MNC business domains.
• Strong experience in business domains like Pharmaceutical, Clinical Research, Biotechnology, Healthcare, Finance, Banking, Engineering.
• Analytical problem solving and a good team player with strong interpersonal and communication skills.

RDBMS: Oracle 11g/10g/9i/8i/8

• Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, MS SQL Server 2000 2005,Windows NT,XP
• Languages: SQL, PL/SQL, C, C , Perl, Korn, UNIX Shell Scripting, Java, VB, Advanced VB
• Networking: ISO 8583, TCP/IP, UDP, SCI, SPI, PCI, NFS, DHCP, LAN
• Tools: RMAN, OEM 9i, 10g, 11g, SQL Loader, EXP, IMP, expdp, impdp, TOAD, RAC in 10g, 11g R2, R1 with ASM, OEM.
• Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.
• Other Tools: EMC, NetApp, Veritas NetBackup, CSS, HTML, Java Script, Golden Gate

Confidential

SR ORACLE DBA

Confidential is one of the leading Banks in U.S. and all over the world. Being an Oracle DBA I was responsible to Support Oracle Administration on on-call basis regularly and involved in the design and build of several servers depending on the requirement and the needs of the clients, and production support for large databases of over 4 TB using Oracle 10g oracle 11g with RAC and Non-RAC Systems.

Responsibilities:

• 24 7 Production Technical Support and Hardware Support.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Responsible for Build Work in various servers which has 3 Node RAC Non RAC, High Availability, Golden Gate Technologies.
• Implemented Oracle 11g OPS Center and fully integrated hardware and storage Arrays to the Grid Control.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Installed and configured oracle 10g and 11g Management Agent silent and Agent push and cloned it to the multiple nodes.
• Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Implemented and monitored 10g RAC Logical Standby database for reporting.
• Installed oracle 10g Data Guard Physical Standby at DR site for production nodes.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Upgraded oracle 10g databases to oracle 11g R1 11.1.0.6, 11.1.0.7 and 11g R2 11.2.0.2 .
• Upgraded oracle RAC databases from 10g to 11g.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Experience on working with Database Monitoring tools like TOAD, BMC PATROL.
• Setup and monitored multi node RAC to RAC Data guard with real time apply for DR and offload backups
• Implemented and administered Oracle Golden Gate v10 for Database Replication between production and reporting node.
• Hands on Experience on oracle 11g New Features for Administration and Tuning.
• Reconfigured and restored OCR and Voting Disks for changing the bonding on 4/6 node RAC.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Patching and Upgrades of Oracle 10g, 11g databases to protect from VTM.
• Extensive experience on 10g and 11g oracle ASM management.
• Extensive Hand on experience in handling Physical and Logical Corruptions and recovery using RMAN Recovery Advisor .
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• Responsible for monitoring and administering EMC Storage Arrays using Navisphere.
• Responsible for monitoring and Administering SUN STORAGE Arrays using SCCLI Storedge 6140, StorEdge 6130, StorEdge 3510

Environment: SUN SPARC, Dell Power edge, Sun STOREDGE 6140, 6130, 3500, EMC Storage, VERITAS Netbackup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, 11g OPS center.

Confidential

SR ORACLE DBA

Provided DBA support to EMC which is a global provider of professional services and pre-packaged IT solutions to the Insurance and Financial industries. Part of an 18-member DBA team managing databases. This included 15 production databases and 55 development/test databases with sizes of databases varying from 70 GB to 1.5 TB.

Responsibilities:

• Implementing upgrade, migration, security, management, performance tuning, backup recovery, patch management, shell scripting, 24/7 technical support of Oracle 10.2.0.x, 10.1.0.x, 9.2.0.8, 9.2.0.7.0 databases, on UT,SIT,UAT,PROD environments.
• Part of database support team, providing 24/7 support and resolution of tickets of all databases across the organization.
• Structural database creation in UAT from PROD using imp/exp.
• Implemented centralized database backup/recovery solution, using RMAN, Catalog database repository.
• Installed db2 9.1 fix pack 6 on Solaris 10
• Performed database cloning using hot/cold and RMAN using Duplicate database command.
• Configured, administered and maintained high availability environments.
• Responsible for administration of disaster recovery strategies for 24/7 operations, and deployment of high availability systems on Oracle 10.2.0.x using Oracle Data-Guard, RAC, RMAN.
• Configured Data Guard Broker using DGMGRL to monitor and manage physical standby database.
• Management of RAC database storage using ASM by creating failover groups.
• Responsible for writing Shell scripts using tools like SED, AWK for monitoring tablespaces.
• Configured and Implemented Oracle Flashback technology to recover tables/database.
• Creating and Managing Tablespaces with different block sizes to prevent row chaining
• Responsible for installing and configuring GoldenGate 9.5 on Oracle Servers
• Responsible for upgrading GoldenGate 9.5 to GoldenGate 10.0.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions
• Experience in oracle features Flashback version query, Rollback Monitoring, Tablespace Management, Oracle Datapump, Flashback Table, RMAN and Auditing
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Scheduling jobs using Oracle Job Scheduler
• Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption
• Installation and configuration of Oracle Client software and Tools, Also manipulating the various databases using different kind of automation tools like OEM, ATG, TOAD,
• Monitoring and Optimizing database performance
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Perform database capacity planning and growth projection by monitoring the tablesapce space requirements and ensuring that there is enough disk space available to support the various end-user applications that access the databases.
• Performance tuning of corporate databases, using tools like sql trace, tkprof, AWR, ADDM, SQL Tuning.
• Assess and deploy the Oracle Critical security patches, released by Oracle Corp, across all the corporate databases.
• Developed and maintained database standards, conventions, data dictionaries, data element naming standards.

Environment: Oracle 11G, 10.2.0.x, 9.2.0.x, expdp/impdp, SRVCTL, RMAN, Data Guard, RAC, Spectrum, Harvest, CA Service Desk, sqlTrace, Tkprof, explainPlan, AWR, ADDM, OEM, IBM AIX 6.1, SAN EVA 8100.

Confidential

SR. ORACLE DBA

Provided DBA support to EMC which is a global provider of professional services and pre-packaged IT solutions to the Insurance and Financial industries. Part of an 18-member DBA team managing databases. This included 15 production databases and 55 development/test databases with sizes of databases varying from 70 GB to 1.5 TB.

Responsibilities:

• Implemented a Lean project by developing automated pre-clone using shell scripting. Preclone activity involves backing up env files both on DB tier and Application tier , dbl inks, and downloading responsibilities.
• 24 7 Production oracle database support and administration.
• Responsible for implementation of oracle 11g Grid control and successfully monitored whole environment from central datacenter console for database health checks and application audits.
• Implemented 10g Data Guard for American Seeds Trisler seeds and Grow Direct databases.
• Oracle Clusterware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM..
• Upgraded 4 node Oracle 10g RAC to 11gR1 RAC .
• Implemented database replication using Golden Gate and scheduled some maintenance scripts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Setup oracle VM servers and create Development and QA environment databases.
• Oracle VM servers are continuously monitored and tuned according to the need of the environment from shared pool of resources using VM manager.
• Expert in configuration of Hardware Clusters Environment with HACMP, VCS, VCFS.
• RMAN backups Incremental and full are automated and monitored regularly for all production databases.
• Worked on Data Integration from multiple platforms using ETL and Oracle Data Integrator ODI .
• Scheduled XML transfer of schema data in between different environments.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Managed oracle forms 10g on reporting databases.
• Creating and refreshing materialized views performing SQL loader jobs for data loading.
• Logical backups are scheduled for Development, QA, Help Desk and UAT databases using export/import and Data Pump.
• Applied database patches using Opatch utility building Clone instances for Development and Test teams.
• Development and QA environments are refreshed with production backups in order to support Help Desk tickets.
• Successfully lead the Team through YE' 2009 quarter close for all 16 companies.
• Created users and responsible for managing their security grants financial .
• Monitored and published database response times, uptime of different applications in supporting different database applications.
• Top SQL that are consuming heavy resources are identified and assisted development team by fine tuning the sql with SQL Access Advisor and QUEST optimizer.
• Instrumental in updating oracle licenses for the new environment built and enrolled users and maintain security, ensuring compliance with database license agreements.

Environment: HP Proliant DL 380 G4, HP Integrity rx 8640, Dell Power edge 2650, 64GB,2TB SAN, Amanda Backup utility, RHEL 4, 11g GRID, 10g RAC 3 node ,oracle 10g forms, Erwin Data Modeler, Orbit/Oasis, DSView, F-Secure SSH, Cygwin.

Confidential

JR. ORACLE APPS DBA/ DBA

Provided DBA support to Confidential or multiple large databases in production, development and test environments for various types of databases. Part of a 3-member DBA team managing databases. This included 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.

Responsibilities:

• Installed and Upgraded Shareplex 3.2 to 4.1 a replication tool for reporting environment.
• Performing Online and Offline database backups on schedule.
• Scripting of Automated backup for Cold / Hot backups.
• Implementation and Configuration of OEM Oracle Management Server for maintenance and monitoring.
• Performing daily Archive log file backup and checking Alert Log files.
• Monitoring the table space growth and resizing the table space on 9i RAC environment.
• Using RMAN User Managed backup methods for better control.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database/user.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Involved in Database sizing, Capacity Planning.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine tuned for better performance.
• Involved in monitoring the lock/block processes, releasing locks in case of resource blockage and gathering statistics.
• Maintained Microsoft SQL Database Server 2003.
• Net8 Configuration for Clients Connection.
• Creating ODBC for users Application Developers.
• Co-ordination has been extended to Application developers for coding to improve the performance of the database.
• Co-ordination has been extended to nearly more than 10 Units for online database activities.
• Exported data's from all Units are imported at Central Office for Management review about the Units.
• Data replication between units has been done.
• Created users and set permissions.
• Managed database security using groups and roles.
• Created database objects and managed the permission access on the objects with necessary security.
• Handled no. of Databases in different places.

Environment: Oracle 8i, Oracle 9i 9.0.1.2.0 9.2.0.4.0 10g 10.2.0.1 , AIX 5.2, 5.3 RS6000, Solaris 3500, Solaris 10k, Dell 5560 with Xeon Processors.

Confidential

JR. ORACLE APPS DBA/ DBA

Provide Oracle DBA support for multiple databases in production, development and test environments for various OLTP databases. Part of a three-member DBA team managing databases. This included 3 production databases and 7 development/test databases with sizes of databases varying from 100 GB to 2 TB.

Responsibilities:

• Installation of Oracle Application 11.5.2.
• Handling day-to-day activities.
• Database administration of the Oracle database System.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Involved in the process of tuning and refining queries of various applications.
• Involved in the writing most of the packages, procedures, and functions for the application.
• Involved in the process of exploring new areas of Oracle and its products.
• Worked as Database administrator for the Human Resources database.
• Oracle 9i Database software in Linux, created database according to the requirement of Application Software, monitored and configured databases.
• Oracle Database Administration logical Physical database backup, database tuning
• Daily database backup, table space administration, SQL net configurations and basic database tuning as part of maintenance activities.
• Maintenance of existing system and provided advanced level support.
• Involved in System study, Analysis, Design and Development.
• Developed back-end Stored Procedures, triggers, functions.
• Worked on import/export and SQL- loader.

Environment: Oracle 8i, 9i, RMAN, Solaris, Erwin, Sql Server 2000, Windows NT