professional 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, Quest Shareplex 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.
• Upgradation and Migration of Database from 10g to 11g, cross platform migration from Windows, AIX, UNIX to Linux platforms 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, Oracle Big Data Appliance, Hadoop.
• 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.

summary

• RDBMS: Oracle 12c,11g/10g/9i/8i/8, Sybase 15
• 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,12c 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

SR ORACLE DBA

DELL is one of the leading Computer manufacturing companies and also part of providing Software Solutions for various different companies around the world, As an Oracle DBA on Production Support and Project Work I was part of an Oracle Production DBA Team having over 50 DBA's all around the world, which provide 24 7 Support on Shift Basis. I was Responsible for giving support to maintain for more than 8000 Databases ranging from 500 GB to 20 TB which are accessing by all over world 24 7. As a part of Project Oracle DBA Team which comprises of more than 15 DBA's I was responsible for PSU Patching, DB Upgrades, DB Migrations.

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.
• Have experience in RAC, RMAN, SQL tuning, and preferably GoldenGate Performs data modeling, logical and physical database design.
• 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.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• 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, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operations
• 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 .
• Applied database patches using Opatch utility building Clone instances for Development and Test teams.
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• On call Production Support ON Shift Basis.

Environment: Oracle 11G, 10.2.0.x, 9.2.0.x, RMAN, Data Guard, RAC, Golden Gate, Harvest, sqlTrace, Tkprof, explainPlan, Tivoli, AWR, ADDM, OEM 10g, 11g,12c, IBM AIX 6.1, SAN EVA 8100, Sybase 15.

Confidential

Responsibilities:

• Handled high customer expectation and escalation and reguraly talking customer for performance improvement of team
• Installation and configuration of a 2 node to 6 node RAC on 11g R2.
• Upgrade from 11.1.0.7 to 11.2.0.3, 10.2.0.4 to 11.2.0.2 11.2.0.3.
• Installation and Upgrade of OEM from 11.1.0.1 to 12.1.0.1.
• Implemented goldengate for different datacenters and perform switchover.
• Configuration and installation tasks related to ASM.
• Configuring a Oracle Active dataguard Physical stand by with Maximum Availability mode.
• Configuration and implementation of Golden Gate based replications.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Setup and administration activities of GoldenGate.
• Troubleshooting of Replication errors/lags.
• Backup/Recovery for GoldenGate instances and related databases Experience in Replication, Clustering, and other methods of disaster recovery.
• Have experience in RAC, RMAN, SQL tuning, and preferably GoldenGate Performs data modeling, logical and physical database design.
• Performing maintenance of database dictionaries, monitoring of standards and procedures Responsible for data loading, security, performance monitoring and tuning, capacity planning, and backup and recovery.
• Executes database software installation, database creations/configurations and loads. Experience working with an application development team. Solid skills in database performance factors, DR,monitoring tools and tuning procedures.
• Worked with Data Architect on dimensional modeling to optimize the already existing data-warehouse database using STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Responsible for online and offline backups of the oracle database using RMAN.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Experience in cross platform Oracle RAC Database migrations from Windows, Solaris, AIX to Linux.

Environment: Oracle 11G, 10.2.0.x, 9.2.0.x, RMAN, Data Guard, RAC, Golden Gate, Harvest, sqlTrace, Tkprof, explainPlan, Tivoli, AWR, ADDM, OEM 10g, 11g,12c, IBM AIX 6.1, SAN EVA 8100, Sybase 15.

Confidential

confidential the leading Investment Banks in the world, As an Oracle DBA on Production Support I was part of a Global Oracle DBA Team having over 50 DBA's all around the world, which provide 24 7 Support on Shift Basis. I was Responsible for giving support to maintain for more than 8000 Databases ranging from 500 GB to 20 TB which are accessing by all over world 24 7.

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.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• 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, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operations
• 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 .
• Applied database patches using Opatch utility building Clone instances for Development and Test teams.
• 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.
• On call Production Support ON Shift Basis.

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

J.P. Morgan Chase is one of the confidential. 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:

• 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
• implementing a better way to transfer and secure the messages using Oracle Streams.
• 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, NetApp.
• Experience in SQL Server 2008 R1 R2 databases along with Oracle for day to day routine Maintenance and problems.
• 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, SQL Server 2008 R1 R2, 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

Multiplan is the leading Insurance Maintaining Corporation in the United States. Being an Oracle DBA I was responsible to

Support Oracle Administration on 24x7 critical production and large databases of over 4 TB using Oracle 10g RAC.

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

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 TB.

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.