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.
• Strong experience in Oracle database replication techniques using Oracle DataGuard, Materialized Views.
• Strong experience in design, deployment and administration of large Data warehouse and Data mart Databases.
• Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups Restores, Security Management, DTS import/export, Performance Tuning.
• Knowledge of Data transfer between SQL Server and Oracle.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs UNIX , Autosys jobs, Scheduled Tasks Windows .
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Used Grid Control, Oracle Enterprise Manager and command line Sqlplus and 3rd party administrative tools like Toad.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script development and documentation.
• Recovery of Databases Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc. .
• Supported a large number of Development Databases, mainly in tuning the SQL code to improve Performance
• 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.
• Excellent work experience in developing applications using Oracle SQL Scripts, PL/SQL, shell programming, and PRO C optimization.
• 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.
• Experience in implementing security policies to meet SOX Compliances
• Experience in upgrading databases. 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1 .
• Expertise in Oracle Golden Gate software.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Experience in installing and configuring Golden Gate 9.5.
• 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.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Upgradation and Migration of Database from 10g to 11g, cross platform migration from Windows, AIX, UNIX to Linux platforms and applying patches whenever required.
• Experience with Data Modeling, Logical and Physical database design.
• 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.

technical 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

professional Background

Confidential

SR ORACLE DBA

Responsibilities:

• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Applied database patches using Opatch utility building Clone instances for Development and Test teams.
• Extensive Hand on experience in handling Physical and Logical Corruptions and recovery using RMAN Recovery Advisor .
• Extensive experience on 10g and 11g oracle ASM management.
• Patching and Upgrades of Oracle 10g, 11g databases to protect from VTM.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Reconfigured and restored OCR and Voting Disks for changing the bonding on 4/6 node RAC.
• Hands on Experience on oracle 11g New Features for Administration and Tuning.
• 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
• Setup and monitored multi node RAC to RAC Data guard with real time apply for DR and offload backups
• Experience on working with Database Monitoring tools like TOAD, BMC PATROL.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Upgraded oracle RAC databases from 10g to 11g.
• Upgraded oracle 10g databases to oracle 11g R1 11.1.0.6, 11.1.0.7 and 11g R2 11.2.0.2 .
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Installed oracle 10g Data Guard Physical Standby at DR site for production nodes.
• Implemented and monitored 10g RAC Logical Standby database for reporting.
• Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Installed and configured oracle 10g and 11g Management Agent silent and Agent push and cloned it to the multiple nodes.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Implemented Oracle 11g OPS Center and fully integrated hardware and storage Arrays to the Grid Control.
• Responsible for Build Work in various servers which has 3 Node RAC Non RAC, High Availability, Golden Gate Technologies.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• 24 7 Production Technical Support and Hardware Support.
• Have experience in RAC, RMAN, SQL tuning, and preferably GoldenGate Performs data modeling, logical and physical database design.
• 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

SR ORACLE DBA

Responsibilities:

• Implemented goldengate for different datacenters and perform switchover.
• 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.
• 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

SR ORACLE DBA

Responsibilities:

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

SR ORACLE DBA

Responsibilities:

• 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, administered and maintained high availability environments.
• Performed database cloning using hot/cold and RMAN using Duplicate database command.
• Installed db2 9.1 fix pack 6 on Solaris 10
• Implemented centralized database backup/recovery solution, using RMAN, Catalog database repository.
• Structural database creation in UAT from PROD using imp/exp.
• Part of database support team, providing 24/7 support and resolution of tickets of all databases across the organization.
• 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.
• 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.
• Experience in oracle features Flashback version query, Rollback Monitoring, Tablespace Management, Oracle Datapump, Flashback Table, RMAN and Auditing
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions
• implementing a better way to transfer and secure the messages using Oracle Streams.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Responsible for upgrading GoldenGate 9.5 to GoldenGate 10.0.
• Responsible for installing and configuring GoldenGate 9.5 on Oracle Servers
• Creating and Managing Tablespaces with different block sizes to prevent row chaining
• 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

ORACLE DBA

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 DBA

Responsibilities:

• Scripting of Automated backup for Cold / Hot backups.
• Performing Online and Offline database backups on schedule.
• Installed and Upgraded Shareplex 3.2 to 4.1 a replication tool for reporting environment.
• 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.
• Involved in monitoring the lock/block processes, releasing locks in case of resource blockage and gathering statistics.
• 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 Database sizing, Capacity Planning.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Review alert logs and dump files to check for any problems related to the database/user.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• 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.