SUMMARY:

• Around 7 + years of experience as Oracle DBA. Worked extensively on Oracle 12c,11g, 10g, and 9i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Worked on 8i, 9i, 10g, and 11gR2, 12c, database servers wif RAC, ASM, Data Guard, Grid Control Oracle Golden Gate Data Integration and Replication experience.
• Installed RHEL for RAC builds.
• Build multiple node RAC Clusters on Linux.
• Build 12c, 11g Replication using Oracle GoldenGate.
• Worked on uni - directional and bi-directional GoldenGate Replication.
• Performed various types of Backup and Recovery scenarios using RMAN.
• Worked on data migration using logical backups like export/import and data pump.
• Designed and build DR solutions using Oracle Data Guard
• Extensive experience on of Flashback technology in Oracle 10g, and 11g.
• Proficient in Oracle RDBMS - including SQL and all areas of database Administration.
• Designed Automated Storage Management (ASM) disk layout wif storage team.
• Experience in setting up Grid Control.
• Comfortable wif both command-line and GUI interface.
• Worked on Database Migrations.
• Worked on cross platform migration using transportable tablespaces
• Extensive experience on providing solutions to developer/user requests.
• Migrate and upgrade and maintained Oracle databases (10g, 9i, 8i).
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for hot and cold Backups.
• Hands on experience of database Backup and Recovery using RMAN.
• Wrote Shell scripts to automate business process
• Experience in Application tuning using session trace file and TKPROF utility.
• Hardworking, result oriented good interpersonal and communication skills.
• Extensive experience in supporting mission critical application
• Worked on OLTP applications demanding high availability
• Worked on materialized Views.
• Worked wif Oracle troubleshooting issues.
• Upgrade Database from 8K block size to 32K block size to optimize performance.
• Responsible for installation and configuration of SQL server 2005/2008 and 2012.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Upgraded SQL server
• Experience in Backup and Recovery
• Applied latest service packs and security patches.
• Excellent analytical, problem solving, communication, managerial and interpersonal skills wif teh ability to interact wif individuals at all levels. Good interpersonal skills, self-motivated and fast ability to absorb new technology.

TECHNICAL SKILLS:

Operating Systems: RHEL, HPUX, AIX, Exadata, Sun and Windows

RDBMS: Oracle 12c, 11/10g, 9i, SQL Server

High Availability: RAC, Data Guard, ASM

Languages: SQL, PL/SQL, UNIX Shell scripting, T-SQL,Perl.

Tools: RMAN, OEM, exp, imp, expdp, impdp, TOAD, dbconsole, asmcmd, Foglight, Golden gate.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, performance analyzer

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential

Responsibilities:

• Worked on 3 to 4 Node RAC Clusters.
• Worked on Critical customer environments
• Managed over 100 Databases both single instance and RAC Clusters
• Worked on Datagaurd physical Standby’s including Standalone and RAC for DR and High availability.
• Regularly Flash backed Databases using guaranteed restore points
• Monitored and Administered Databases across teh Environments using OEM and Toad.
• Worked on Database and application upgrades using Korn shell and Perl automated scripts.
• Monitoring ASM file system FRA and DATA usage wif big datafiles.
• Exported Data using Transportable tablespaces on critical Prod and Non Prod environments.
• Worked on Golden gate environments.
• Troubleshoot OGG lag
• Configured extracts pump and replicats on source and target servers.
• Backup and Recovery using RMAN
• Gathered DB, Schema level and table level stats using scheduled Cron jobs.
• Tuned slow running queries using explain plans, SQL Tuning Advisor (STA).
• Fair understanding of AWR and ASH Reports.
• Generated and analyzed sql health check to find tune sql queries.
• Troubleshoot post upgrade performance issues.
• Joined day to day on going Production incidents via bridge calls.
• Part of regular on call shift rotation.
• Ability to work under pressure and meeting deadlines.
• Easy to work wif.
• Adaptable to new environments.
• Team Coordinator

Environment: Oracle 12c,11g, Red Hat Enterprise Linux, SUN Solaris 2.7, Oracle RAC, Oracle Enterprise Manager, Toad, RMAN, Materialized Views, Explain Plan, expdp/impdp utilities, Oracle database upgrade assistance, Automatic Workload Repository, Prod, Preprod, Reporting and Non Prod GoldenGate.

Oracle Database Administrator

Confidential

Responsibilities:

• Worked on Oracle 11g Databases
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across teh Globe.
• Worked and Build 3 and 2 Node RAC Clusters
• Supported up to 500 Databases.
• Installed and Managed 11g OEM.
• Worked on Very Powerful Monitoring Tool Fog light.
• Monitoring Fog light Console. Trouble Shooting, Agent logs, broken agents, blacked out Agents analysing Daily Heart Beat Report for about 100 Linux and Aix Prod and Non- Prod Oracle Servers.
• Supported application and professional services to manage their data ranging from GB to TB in oracle database, solving of space problem, data loading problem.
• Executed Both DML and DDL Sql Queries in RAC and Golden Gate Replication Environments.
• Installed and Supported 11g Golden Gate Environments.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyse jobs, database backup logs etc.
• Worked wif database export & import scripts to backup database structures and automation procedures.
• Upgrade/Migration databases from Oracle 10 to Oracle 11g.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance
• Installed GoldenGate software in Test and dev instances
• Configured Goldengate on production servers.
• Setup classic capture and integrated capture replication mechanism using goldengate
• Configured GoldenGate to achieve unidirectional and bidirectional replication
• Troubleshooting and fixing goldengate errors in single instance and cluster production environment.
• Test impact of multiple Extract and Replicat processes on a Single Node.
• Monitored database for blocking sessions, enqueues and waits.
• 24/7 Support production, dev and test systems.

Environment: Oracle 12c, 11g, Oracle 10g. Red Hat Enterprise Linux, SUN Solaris 2.7, Oracle RAC, Tkprof, Oracle Enterprise Manager, Toad, RMAN, Materialized Views, Explain Plan, expdp/impdp utilities, Oracle database upgrade assistance, Automatic Workload Repository, Dell’s Monitoring Tool Foglight and Golden gate.

Oracle Database Administrator

Confidential

Responsibilities:

• Responsibilities include maintaining databases, monitor daily database activity, implement customer requirements, coordination, performance tuning.
• Installed and configured Oracle 10g/11g Databases on AIX and Linux Operating systems on Development, UAT and Production Systems.
• Designed and Implemented database security using Oracle roles and privileges. Set up teh password for new users and tan managed users and their respective sessions.
• Maintenance of teh RMAN repository database and configuration of backup policies.
• Installed and administered RAC databases.
• Setup monitoring for 240 Databases using Oracle Enterprise Manager (OEM) 12c.
• Implemented Dataguard setup for production databases using Oracle Enterprise Manager (OEM) 12c.
• Implemented Incident rule creation, Mail Server registration, Email subscription and repeated alert notification in OEM 12c.
• Converted teh single instance standby database to RAC using Oracle Enterprise Manager (OEM) 12c.
• Refreshed 14 test and development databases wif production data using rman duplicate database feature wif set until time clause.
• Generated CPU Utilization, Memory Utilization and Database growth reports using Oracle Enterprise Manager (OEM) 12c.
• Registered newly built databases in OEM 12c and deleted teh targets associated wif obsolete databases from OEM 12c.
• Configured commvault to run rman full backup production, test and development databases using RMAN.
• Successfully compared schemas across databases using Toad and Oracle Enterprise Manager (OEM) 12c.
• Installed and Configured Golden Gate Setup for replication.
• Creating Indexes, rebuilding indexes, analysing indexes to improve teh performance of query.
• Monitored teh various database activities by developing shell scripts and using various tools.
• Worked closely wif Developers to develop, maintain and evaluate PL/SQL codes and troubleshooting other issues.
• Upgraded Databases from Oracle 10.2.0.4 to 11.2.0.2
• Extensively used Oracle Flash back features.
• Widely used Oracle Grid Control for monitoring teh database activities.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Setup, Configured Oracle Data Guard using physical standby database.
• Implemented Dataguard / Standby (wif FAL), performed switchover/failover.
• Patched Oracle databases using OPatch utility.
• Used OEM to monitor Database health, Bottlenecks, session information, table privileges and user roles and grants.
• Monitored scheduled jobs for backups, gathering statistics, AWR reports, data guard status reports, disk space utilization report
• Using Oracle Database Upgrade Assistant for Upgradation and Migration of oracle database to higher version and other platforms.
• Generated triggers for data integrity, created views to resolve complex queries.
• Database Cloning to create Test and Development environments from Production.
• Imported and exported files, databases, schemas and tables using import and export dump features of Oracle database 10g.
• Identifying teh poorly performing queries using Explain Plan, TKPROF, and assisting teh developers in optimizing and tuning teh SQL and PL/SQL code using SQL trace.

Environment: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Red Hat Enterprise Linux, SUN Solaris 2.7, Oracle RAC, Tkprof, Oracle Enterprise Manager, RMAN, SQL developer, Materialized Views, Explain Plan, expdp/impdp utilities, Oracle database upgrade assistance, Automatic Workload Repository.

Oracle DBA

Confidential . Chicago, IL.

Responsibilities:

• Build Data Guard
• Build uni-directional and bi-directional 11g GoldenGate Replication on RHEL5.
• Configured and maintained Schema level uni-directional Replication using GoldenGate in production.
• Configured and Managed ASM disks and disk groups using both Grid Control and ASMCMD utility.
• Conducting Installations of Oracle 10g, Oracle 11g on standalone servers
• Worked on Migration Projects.
• Upgraded Databases from 10g to 11g R2.
• Resolved many GoldenGate issues like Abend Extract, Abend Replicat, data-synchronization issues, discrepancies in data, re-synchronization of out-of-sync data etc.
• Fully documented 11g GoldenGate installation for internal DBA team members
• Familiar wif ggsci GoldenGate commands.
• Worked on GoldenGate trace parameters, reports and logs, logdump etc. While building, configuring and managing GoldenGate replication.
• Worked on GoldenGate Director, a web based tool.
• Build database servers on VMWare.
• Worked sizing/capacity planning efforts for teh Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Migration of system and applications from Oracle 8i to9i to 10g.
• Configuring and using teh Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving teh performance of teh database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Responsible to improve teh performance by Using teh Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line wif Business requirements (SQL Backtrack and RMAN)
• Automating teh backup processes using shell scripts. Performing recovery in cases of system crashes.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• Worked wif RAC implementation team. Added nodes.
• Refreshed multiple databases for Development and Testing upon short request.
• Performed database cloning/exp/imp to setup identical databases in teh production and development environments.
• Created and maintain users, roles and privileges.

Environment: HP-UX, Windows 2000/2003, and Linux, Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clear case, SQL*Plus, PL/SQL, SQL, SQL*Loader

JR Oracle DBA

Confidential

Responsibilities:

• Supported more TEMPthan 30 databases including development/production environment..
• Designed, Installed and configured teh Oracle server software and related products.
• Worked on RAC Clusters.
• Scheduled meetings wif application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to TEMPeffectively administer teh database environments.
• Ensure databases adhere to corporate standards and policies.
• Worked wif application, developers, change management and DBA teams.
• Worked on user managed backups and learned RMAN backups.
• Monitored, scheduled backup procedures for daily basis using crontab.
• Refreshed schemes using export /import and datapump.
• Upgraded from 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating wif Oracle support through metalink (MOS) to resolve them in timely manner.
• Involved in discussions wif teh management regarding teh advantages/disadvantages and upgrade plans.
• Performed Export/Import through Data Pump.
• Used Grid Control
• Worked on basic replication through Materialized Views.

Environment: Oracle 10g, HP-UNIX, Sql-Loader, UNIX Shell Programming, SQL, PL-SQL, Stored Procedures, Functions and Triggers, TOAD

Confidential

Desktop /IT Support

Responsibilities:

• Provided user support via phone and email
• Worked on LAN
• Worked on Access DB
• Written SQL Queries to fetch data
• Worked on Client/Workstations.
• Troubleshot issues via phone and email wif phone back-ups Assist in Windows7 deployment to include peripheral setup, data migration, and software installations.
• Recognized for outstanding work on special projects, Created and edited documentation.