TECHNICAL EXPERIENCE

• Databases: OLTP, Data warehouse, Oracle Databases 12c/11g/10g/9i/8i.
• DBA Skills: Database Maintenance, Disaster Recovery, Security Management, HA Management, RAC, ASM, CRS cluster.
• Tools/Utilities: CRON, TOAD 10.1/12, OEM Grid Control 10g/12c, Datapump, export/import, SQL Loader, RMAN,DBNEWID,BMC Change Control, Erwin, Shareplex for Oracle, AWR, ADDM, Oracle Streams, Sql Developer, Oracle Golden gate, DB Artisan 8.7.
• Shell Scripting: UNIX Shell Scripts on Sun Solaris, HP-UX and Linux platform
• Operating Systems: RHEL 3.0/4.0/5.2/5.6/6.2, HP-UX 10/11.21, 11.31, AIX 4.3, Solaris 8/7, SunOS 5.10, Oracle Linux, Windows 2003/2000/NT

PROFESSIONAL EXPERIENCE

Experience Brief

• An Oracle DBA with 8 years of DBA experience in 24 7 OLTP and Data Warehouse databases. Supported production, Testing, development environments on HP-UX, Linux, AIX, Solaris, Windows 2000/NT.
• Extensive knowledge and experience as an Oracle DBA 11g/10g/9i/8i including installation, configuration, performance tuning etc.
• Experienced in installation and maintenance of ORACLE 10g/11Gr2 RAC, ASM database for high availability on HP-UX 11.31, Sun Solaris.
• Implemented Disaster recovery using Data guard/Active Data guard.
• Experience in Migration of 9i, 10gr2 databases to 11gr2 databases from HP-UX Server to Sun Solaris Server using Transportable databases very large databases like > 2TB , RMAN, Datapump.
• Experienced in Oracle Migration and upgradation of 50 applications. Good understanding of migration processes and doing the migration and upgrades of 10gr2 databases to 11gr2 from HP-UX to 11gr2 SunOS servers, involving character set conversions using CSSCAN and CSALTER.
• Implemented daily Backup strategies for Oracle databases using RMAN.
• Experienced in administration of databases like Creating and Managing Users, Views, tablespaces, indexes, roles, space management, and resizing, partitioning and shrinking tablespaces. Database security by restricting users by granting related privileges, roles.
• Knowledge on Oracle Golden gate replication.
• Installed, configured Shareplex Replication which replicates from online to reporting Servers and disaster recovery servers.
• Implemented . Oracle Goldengate for replication between Oracle database tables.
• Familiar with table partitions, table cluster, Materialized view, streams.
• Experienced in SQL Performance and Database/Instance Tuning of the database using AWR/ADDM reports, SQL TRACE, Explains plans, Sql Tuning Advisor, Memory Tuning advisors, OSWATCHER.
• Good experience in Export/Import, RMAN, SQL Loader, Oracle Enterprise Manager OEM , Standby Database, AWR and Statspack.
• Applied oracle critical patches and other patches using oracle utilities.
• Experience in Capacity planning, Sizing tablespace, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, 24x7 operation DBA support, Disaster recovery Automate jobs, Schema managing, Tune database, Tune SQL.
• Strong leadership qualities with ability to define individual and shared goals for teams and growth path for individuals. Good interpersonal Communication Skills and a good Team player with activities and timelines.
• Experience in writing autosys Jils for Oracle jobs.
• Good expertise in writing of Unix shell scripts and scheduling cronjob. Use of awk, grep, top, sed, etc commands.
• wyndham hotel group, phoenix, az Jul' 13 TO TILL DATE

Sr. database administrator

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC with Goldengate and Dataguard environments.
• Have a good understanding of Wyndham hotel business and its brand partners.
• Reviewing Development team requests, discussing and suggesting oracle recommended approaches to maintain healthy database.
• Installed, configured and maintaining 2 Node 11.2.0.3 RAC databases in Linux/Solaris Servers.
• Experienced in monitoring database performance through OEM and also through database command line.
• Maintaining and Troubleshooting Goldengate replication v11.1 in 2 Node RAC database in Solaris servers.
• Experienced in Database refreshes in production to non-production and masking the sensitive data in non-prod environments.
• Documented Audit mechanism and implemented for the oracle databases according to PCI security requirements.
• Experienced in Administering teradata databases like Creating users, granting privileges, monitoring performance, storage etc.
• Experienced in teradata viewpoint which is used for monitoring users, storage, performance etc.
• Experienced in preparing Design/Vision documents and identifyig database/server requirements for new projects.
• Experienced in Basic MS Sqlserver Database Administraion.
• Upgraded Oracle 11.2.0.3 2 Node RAC databases to 11.2.0.4 on Solaris servers.
• Performed troubleshooting of database using AWR and ADDM reports for 11g databases.
• Performed SQL tuning using SQL Tuning Advisor in Oracle Enterprise Manager.
• Worked with oracle support and performed root cause analysis for critical issues.
• Installed Oracle snap management utility SMU which is used for database cloning, refreshes and database backups.
• Working on multiple projects and delivering projects within timeline.

Environment: Oracle 10gR2/11gR2, RAC, ASM, Goldengate v11.1, Data Guard, Linux 6.2, Shell Scripting, RMAN, Data pump, OEM Grid Control 12c, Toad for Oracle, Oracle SMU, Teradata 14, Teradata viewpoint, Oracle Goldengate.

Confidential

Oracle database administrator

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on AIX.
• Working on Migrations of 10g databases to 11g databases on AIX environment.
• Installed and configured OEM grid agents on AIX servers.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Built DataGaurd physical and Active databases on AIX servers.
• Experience in implementing Oracle wallet TDE for data security for single and RAC databases

Environment: Oracle 10gR2/11gR2, RAC, ASM, Data Guard, AIX 6.1, Linux 6.2, Shell Scripting, RMAN, Data pump, OEM Grid Control 12c, Toad for Oracle

Confidential

ORACLE PRODUCTION DBA

• The Pacific Gas and Electric Company, commonly known as PG E, is the utility that provides natural gas and electricity to most of the northern two-thirds of California, from Bakersfield almost to the Oregon border. It is the leading subsidiary of the PG E Corporation. Working on Data center Modernization project.
• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on AIX.
• Working on Migrations of 10g databases to 11g databases on AIX environment.
• Installed and configured OEM 12c grid agents on AIX servers.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Built DataGaurd physical and Active databases on AIX servers.
• Experience in implementing Oracle wallet TDE for data security for single and RAC databases.
• Installed and Configured DataGaurd Broker and Observer to implement FSFO for fast and Automatic Failovers.
• Configured RMAN backup jobs for newly built databases.
• Worked on Performance issues which raised after migrations using AWR, ADDM, and Sql tuning Advisors etc.
• Implemented Oracle latest features Advanced Compression, Oracle partitioning Interval Partitioning .

Environment: Oracle 9i/10gR2/11gR2, RAC, ASM, DataGaurd with FSFO, DG Broker, Observer, AIX, Linux, Shell Scripting, RMAN, Data pump, OEM Grid Control 12c, Toad for Oracle.

Confidential

ORACLE PRODUCTION DBA

Confidential is an American multinational diversified financial services company with operations around the world. Worked as an Production Oracle DBA for critical applications.

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Experienced in supporting Oracle 11gR2 RAC databases on SunOS 5.10, Linux.
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on Linux.
• Monitoring and supporting more than 100 database instances using scripts and daily health check like alert logs, invalid objects, tablespaces usage, long running queries, backups, listener up and running, etc.. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email. Also, wrote scripts for monitor Shareplex and migration monitoring and purging.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Involved in building backup and recovery plans for critical databases from failures with minimum downtime.
• Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
• Provided Assistance to application team at the time of SQL tuning in applications.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.. .
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Experience in Data modeling using Erwin tool.
• Installed, Configured and Supported application which had 4-way shareplex replication.
• Upgraded databases from 9i, 10.2.0.4 to 11.2.0.2/11.2.0.3, applied CPU patches and put off patches which has 4-way replication with shareplex replication without any downtime.
• Created and maintained partitions for Large tables, used 11g partitioning feature automatic partitions creations.
• Experienced in Advanced Compression for Large tables.
• Worked on Table partitioning to increase performance.
• Responsible for network configuration and involved in a Client Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Monitored and troubleshooted database issues with OEM grid control.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Experience in writing autosys Jils for Oracle jobs.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11,RHEL 5.6/6.2,Db artisan 8.7, AIX, Shell Scripting, RMAN, Datapump, OEM Grid Control, Db Artisan, Pac2000.

Confidential

ORACLE PRODUCTION/migration DBA

Confidential is one of the world's largest investment management organizations with assets of around one trillion USD under management. I contributed to the Technology Rationalization Oracle Consolidation project as an Oracle DBA.

Responsibilities:

• Installation, Configuration, Maintenance of oracle 10gR2, 11gR2 databases on SunOS 5.10.
• Migration and consolidation of 9i, 10gr2 databases from hp-ux/Solaris to 11gr2 SunOS server Farm, involving character set conversions using CSSCAN and CSALTER.
• Migrated more than 50 applications around 50 databases using datapump, RMAN, Transportable tablespaces TTS .
• Implemented transportable tablespaces method for migrating huge databases up to 10 TB and resolved the issues during the migration of live Production databases.
• Used Datapump export/import as the prime method for migrating smaller applications. Also, worked on customizing the process by creating pre-check, migration and validation scripts.
• Validated the database migrated from offshore as per migration process.
• Implemented . Oracle Goldengate for replication between Oracle database tables.
• Implemented RMAN cloning as a migration strategy for very large applications and later customized the target environment as per client standards. Renamed Databases to new name using DBnewid.
• Upgraded databases from 10.2.0.4 to 10.2.0.5 using Patch sets.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Scheduled jobs like collecting stats for tables/indexes etc., regular backups and monitoring tasks using Oracle scheduler, Crontab.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11, Toad 10.1.1.8, Shell Scripting, RMAN, Datapump, CSSCAN, CSALTER, OEM Grid Control, Oracle Goldengate 10.

Confidential

Verizon Communications is a global broadband and telecommunications company. As a DBA I migrated all mission critical databases to RAC environment, which reduced downtime/outages and increased performances for applications.

Responsibilities:

• Supported critical OLTP development and Production databases on RAC environment.
• Worked with a team for installation and maintenance of 4 nodes ORACLE 11g RAC, ASM database for high availability on HP-UX 11.31 server. Well conversed using the CRSCTL and SRVCTL tools for maintaining database.
• Installed and Configured of OEM Grid Control to administer and monitor database.
• Upgraded oracle databases from 9i to 10gR2 and 10gR2 to 11gR2.
• Supporting Developers and testing teams across different projects for new module implementation, DDLs and package creation using Erwin Data modeller logical to physical design, refreshing data for testing environment from production using RMAN and Datapump.
• Implemented failover strategy using HP Service guard.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Working on Shareplex Replication which replicates from online to reporting Servers and disaster recovery servers.
• Involved in partitioning large tables to improve the performance.
• Installed, Configured and used BMC change control to track DDL changes for the Oracle databases.
• Performed troubleshooting of database using AWR and ADDM reports for 10g, stats pack for 9i databases.
• Performed SQL tuning using SQL Tuning Advisor in Oracle Enterprise Manager.
• Experienced in doing Complete/Incomplete and Tablespace point in time recovery of database using RMAN.
• Used Erwin for data modeling to support application teams.

Environment: OEM Grid Control, Oracle 9i, 10g, 11gr2, HP-UX 10/11.21, 11.31, AIX 4.3, RMAN, HP Service guard, Import Export, Datapump, Data guard, oracle 10g/11g RAC, ASM, CRS clusters, BMC change Control, TOAD 7.2/10.1 , Shareplex replication 5.2/5.3 etc.

Confidential

Oracle production DBA

Sharp Electronics Corporation produces world class consumer and business products and technology. Sharp's business activities in the United States include manufacturing, distribution, marketing, sales, and servicing of Sharp products. As an Oracle DBA my responsibilities included upgrading to newer version of database, database maintenance, user management, day to day activities, Performance Tuning.

Responsibilities:

• Support has been provided for the critical OLTP databases, Data warehouse Production databases.
• Developed and customized scripts to monitor the health, functioning and performance of standby databases.
• Worked extensively Provided Assistance to application team at the time of SQL tuning in applications Oracle Dataguard troubleshooting, resolved issues relating to standby switchover and failovers. Implemented incremental backup method in order to resolve archive log gaps created as a result of network failures.
• Successfully implemented physical standby database using Oracle Data Guard feature for Disaster recovery in RAC.
• Worked on RAC on Red Hat Linux Advanced Server with 4 nodes.
• Upgraded oracle databases from 9i to 10g.
• Planned, tested and implemented different backup and recovery strategies for 9i and 10g databases using RMAN utility..
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc. Provided Assistance to application team at the time of SQL tuning in applications
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Communicated and coordinated with Oracle using TAR system for major database issues/ problems apply the required patches, test and roll out and implement the patches into production.
• Implemented a series of monitor programs to check Database, table space growth, extent growth, de-fragmentation, examining row cache activity, eliminate chained rows, and index analysis.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, RHEL 4.0, RMAN, Import Export, Datapump, Data guard, VLDB, ASM, TOAD, VERITAS Cluster etc.

Confidential

Oracle DBA

Confidential is among the top 100 insurance organizations in the nation, and our products include a wide range of commercial and personal coverage's. I have worked for Utica National on this project as a Database Administrator installed oracle, created, monitored, upgraded databases from Oracle 9i to Oracle 10g

Responsibilities:.

• Supported different Databases like Production, Development, Testing, and Data warehouse environments.
• Performed upgradation of Databases from Oracle 9i to Oracle 10g on Solaris.
• Experienced in Data conversion using RMAN in the migration process of Oracle databases in Cross platforms.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Created physical standby database and worked with data guard to provide Disaster Recovery.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities Export/Import EXPDMP and OS methods.
• Responsible for network configuration and involved in a Client Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql Loader, Import Export, Datapump, Data guard, RMAN, AWR, ADDM, Statspack, ASM, TOAD 7.4, Shell scripting, Data warehouse, AIX 4.3 etc.