SUMMARY

• Over 9 years of Experience in Oracle database administration, tuning, development, analysis, design, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, SQL, PL/SQL, troubleshooting and documentation. Also oracle database 11g Administrator certified Associate.
• Installed oracle database server on SOLARIS, HP - UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g,9i to11g, 12c applied oracle patches. years of database development experience
• Expert in writing PL/SQL, SQL*Plus, database scripting, etc.
• Involved in Active Batch or similar job scheduling/management tool
• Excellent knowledge in SQL and database design
• Experienced with stored procedure languages
• Demonstrated expert in designing, building, implementing, and deploying database tables, procedures, functions, views etc.
• Involved in extrapolate business requirements into database design/objects
• Performed to meet deadlines, be results focused, and deliver high quality work products
• Involved indataanalysis,datamapping, anddataquality validation installed, configured and support Golden Gate uni-directional and bi-directional Oracle-to-Oracle replicated.
• Good experienced with Golden Gate Change Data Capture (CDC) setup
• Excellent knowledge to setting up Golden Gate with DB2 for Change Data Capture (CDC) performed to setting up Golden Gate for Change Data Capture (CDC) extraction of files for ETL implemented the agency at internal and external professional committees and groups.
• Experience in replication using golden gate, materialized views.
• Configured scripts to monitor and alert for Golden gate trail files
• Involved in required knowledge Abilities and Skills essential to Job Functions.
• Replication and Extracting data and applying on production using Golden Gate.
• Implemented Golden Gate for Active-Active Replication between the Datacenter for High Availability. involved in setting up the table replication in Golden Gate and Version Upgrades.
• Database Upgrade using Golden Gate and datapump.
• Involved in mastered physical database design and have expertise with database indexing, statistics and tuning.
• Strongly performed in hardware configuration, networking concepts and terminology.
• Installation, maintenance and tuning of RAC Applications. Performed Table, Index Partitions for increased performance and for better storage management.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Documented the Role Transition method from Primary to Standby and vice versa of Data guard environment.
• Established Backup policy using RMAN and Network backups. Also managed Backup, Restore using Data Pump, Traditional Export and Import and Recoveries using RMAN and conventional UNIX shell scripts. involved in database link creation in multiple database instances.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Data pump.
• Worked on different technological Platforms, Golden Gate, RAC, ASM, configured Data Guard for Standby Database, GRID Control. performed leading efficiency improvements and implementation of DB policies and procedures.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager(12c).
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups Recoveries using RMAN-Netbackup.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader, RMAN.
• Expertise in maintaining Database Security using security compliance auditing (SOX), expertise in loading data from flat files using external tables, SQL*LOADER.
• Involved in Configuring and managing the listener files and setting up of multiple listeners.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard. involved to designing the UML, Use Cases, Assent Management Tools.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability working with Oracle 9i and 10g partitioned tables.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Excellent effectively convey information and work well in a structured environment with other team members.
• Excellent communicate effectively with different levels of management as well as both the business and technical communities.
• Excellent Communications and Presentation skills.
• Administering and maintaining production, stage, development instances 24/7 production database support and maintenance.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2005 and DB2, Oracle Applications 11.5.10.2 and R12.1.1

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.7, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES: SQL, PL/SQL, T-SQL,MYSQL, VB, UNIX Shell Scripting, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM. Golden Gate

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metal ink, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Oracle Database Administrator

Responsibilities:

• Involved in handling mission critical databases on cluster 24x7 environment within the stringent response/resolution SLA timelines.
• Golden Gate Bi-directional Configuration
• Preparation of Golden Gate solution and development of code for new project requirements.
• Configured and supported golden gate DML, DDL replication to oracle and TERADATA databases.
• Good experienced with Golden Gate Change Data Capture (CDC) setup
• Excellent knowledge to setting up Golden Gate with DB2 for Change Data Capture(CDC) performed to setting up Golden Gate for Change Data Capture (CDC) extraction of files for ETL
• Expert in writing PL/SQL, SQL*Plus, database scripting, etc.
• Involved in Active Batch or similar job scheduling/management tool implemented the agency at internal and external professional committees and groups.
• Building active data guard as high availability disaster recovery solution for Production databases. Monitoring and supporting exadata databases.
• Maintained unidirectional golden gate replication b/w source and target databases.
• Involved in Configuring and troubleshooting cron jobs for RMAN backups, monitoring for alert log errors, batch jobs and export jobs.
• Trouble shooting the user access issues like resolve problems at the database, server, network and client levels.
• Installed OEM 12c and Monitoring mission critical business databases.
• Worked with data stage environment. Knowledge in ETL methods and XML files.
• Administer data on both OLTP and OLAP database on RAC cluster environment.
• Installed Oracle 10g, 11g RAC software with ASM & OCFS2 File systems.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server.
• Involved in mastered physical database design and have expertise with database indexing, statistics and tuning.
• Excellent knowledge in SQL and database design
• Experienced with stored procedure languages
• Demonstrated expert in designing, building, implementing, and deploying database tables, procedures, functions, views etc.
• Handled Installation, maintenance and tuning of RAC Applications. Performed Table, Index Partitions for increased performance and for better storage management.
• Expertise in maintaining Database Security using security compliance auditing (SOX), expertise in loading data from flat files using external tables, SQL*LOADER.
• Doing monthly database refresh according to request.
• Provided monthly tenant storage usage reports for various cluster databases and anticipating usage growth.
• Handled Performance issues at application level and database level.
• Involved in Applying regular quarterly CPU patches and keeping the databases up to date with the Oracle security updates.
• Provided support to 10g RAC databases.
• Cloning the Oracle home and upgrades.
• Created health monitoring UNIX shell scripts.
• Involved in extrapolate business requirements into database design/objects
• Performed to meet deadlines, be results focused, and deliver high quality work products
• Involved indataanalysis,datamapping, anddataquality validation
• Trouble shooting the user access issues.
• Developed the applications through using PL/SQL Packages, Triggers, Cursors, Procedures and functions
• Good knowledge in Exceptions and advanced concepts of PL/SQL.
• Involved in mastered physical database design and have expertise with database indexing, statistics and tuning.
• Strongly performed in hardware configuration, networking concepts and terminology
• Involved in Creation of User profiles and roles.
• Worked closely with the application teams on scheduling the patching windows.
• Cloning the databases regularly for the reporting databases and stage environments.
• Handled creation of Backup schedules and taking periodic backups both offline and online using RMAN.
• Involved in participating in corporate DR drills and ensuring the data protection.
• Created partitions for partitioned tables periodically.
• Involved in Managing materialized views and refreshes.
• Created PL/SQL functions to facilitate business functions and calculations.
• Created DB links to heterogeneous environments for the data warehouse.
• Periodic index management, index rebuilding.
• Involved in doing code deployments on production according request after approvals.
• Investigating various diagnostic reports like stats pack, AWR reports to improve performance.
• Established master-master replication and master slave replication between various MySQL servers.
• Excellent effectively convey information and work well in a structured environment with other team members.
• Excellent communicate effectively with different levels of management as well as both the business and technical communities.

Environment: Red Hat Linux, Oracle 9i/10g/11g, Oracle Enterprise Manager, RMAN, 10G, Data Guard, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2008, Shell scripting.

Confidential, Atlanta GA

Oracle Database Administrator

Responsibilities:

• Handled databases including finance related, mission critical, business critical data warehouse and sensitive health care related databases within the stringent response/resolution SLA timelines.
• Configured Golden Gate Data Replication (Bi-directional, Cascading, Homogenous and heterogeneous DB’s)
• Prepared shell scripts to monitor all the golden gate processes and replication lag.
• Installed and configured of OLAP reporting database using Golden Gate.
• Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3.
• Requirement Gathering and providing Golden Gate solution design.
• Oracle Golden Gate & Oracle Golden Adapter installations.
• Code development to Golden Gate extract selective data from source database.
• Involved in monitoring and supporting exadata databases.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Handled Installation, Upgrade and Configuration of Oracle (8i, 9i, and 10g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 10g, 11g and worked on ASM.
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings
• Configuration, maintenance and tuning of Oracle 10gRAC.
• Involved in Installing and configuring Recovery Manager (RMAN) and Flash Recovery.
• Performance Tuning, Memory (SGA) Tuning, RMAN backup
• Cloned databases using scripts as well as RMAN.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Utilized oracle golden gate replication to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Proficient in advance features for PL/SQL programming like Using cursor variables, Ref. cursors, arrays, nested tables and Dynamic SQL.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets.
• Oracle replication using Golden gate and active data guard.
• Involved in Partitioning large objects to improve the performance and manageability
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Used Active Data guard makes a read-only replication of a given database.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager's (OEM's), Oracle cost based optimizer, SQL analyzer, top session, top SQL, Performance Manager, Stats pack. For SQL tuning using "Explain plan", "TKPROF", "SQL TRACE", Optimizer modes, using Optimizer hints, Gathering statistics, Stats pack.
• Involved in Creating database maintenance plans, including updating statistics, rebuilding indexes, structure modifications, Capacity plans, and index analysis.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Involved in Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side.
• Handled writing scripts for backup and recovery, Import and export procedure.

Environment: Red Hat Linux, Windows 2000/2003, Oracle 9i/10g/11g, Oracle Enterprise Manager, RMAN, 10G, Data Guard, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2008, Shell scripting.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Hired for supporting Mission Critical applications running on Oracle 11g, 10g, oracle 9i databases. The environment includes 650 oracle databases running 24/7 with FTS support around Singapore, London and NY.
• Monitored VLDB applications running on 2/3 node Veritas clusters for various production and performance issues.
• Extensively involved in migrating databases from oracle 10g to 11.2.0.2, applying required CPU patches and dealing with post upgrade issues.
• Responsible for Hands on PLSQL Development, mentoring developers in using oracle latest features, interpret query plans, generating stats, dealing with query plan flips, analyzing AWR/ADDM and make the development teams self-sufficient.
• Top Notch Application Performance tuning skills along with an out of box approach towards complex issues.
• Supported Mission Critical applications on (10 TB) databases and resolved various bottlenecks.
• Installed, Configured Oracle Gateway for accessing data from Sql Server into Oracle real time.
• Responsible for Installation and Configuration of two node 64 bit Oracle 10.2.0.1 RAC cluster on Dell 2800 Servers running Red-hat Linux AS 4.0. The environment includes 3 node, 2 node RAC clusters and Single instances configured in OCFS2 and ASM.
• Familiar with Oracle Discoverer, App Server, Web Server and other middle tier Components.
• Extensively monitored the database for performance using OEM grid control, AWR reports, Oracle Wait Interface and command line utilities like - Explain Plan, Auto trace, 10046 and 10053 events.
• Extensively configured Data Guard, flashback database and well versed in resolving Data Guard issues, Data Restore scenarios.
• Responsible for end to end analysis of performance analysis (Database, Application Server and Webserver), load estimation and capacity planning.
• Responsible for setting up RMAN backup jobs.
• Responsible for migrating Oracle database from Windows to Linux using Data Pump.
• Involved in the physical design which involves Partitioning, Materialized views and use of Analytical functions.
• Responsible for automating various routine tasks such as verification of TSM database backups, adhoc refresh of dev/uat databases from production (via Data pump or RMAN duplicate).
• Well versed in Disaster Recovery exercises, production issues remediation, escalation procedures and quick resolutions.
• Excellent automation skills using Shell, AWK and other Unix Utilities.

Environment: Red Hat Linux, Oracle 10g/11g,, ASM, Oracle App Ser/Mid Tier, Oracle Gateway, Discoverer, RMAN, SQL, PLSQL, Shell scripting, Autosys, Tivoli Storage Manager, Shell, AWK.

Confidential

Oracle DBA

Responsibilities:

• Involved in Installation, Configuration and upgradation of Oracle Databases.
• Designed and implemented backup and recovery strategy using RMAN.
• Table space and Storage Management.
• 10g RAC Design/Installation/Configuration/Support.
• Disaster recovery using Standby database and Database cloning.
• Monitored database health by scheduling shell scripts through cron jobs.
• Created Databases, Table spaces and Schemas.
• Tested PL/SQL procedures against the test cases. Involved in creating use cases and test cases.
• Designed Logical and Physical Layout of the databases.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using ‘Explain Plan’, SQL Trace and TKPROF.
• Created snapshots, database links that are required for distributed databases.
• Rebuilded index for better performance.
• Coordinated with Oracle Corp for technical issues.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Monitored Index Usage.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of the data warehouse.
• Monitored daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supported the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.
• Involved with installation and maintenance of ORACLE 10g RAC database for high availability.

Environment: Oracle 10g/9i on AIX/Sun Solaris/Linux/Windows

Confidential

Oracle DBA

Responsibilities:

• Handled high availability (24/7) database in onshore-offsite model
• Handled Performance issues.
• Applied regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates
• Involved in health monitoring Unix shell scripts
• Scheduled the health scripts using cron tab, mailx.
• Trouble shooting the user access issues.
• Involved in Creating User profiles and roles.
• Worked with the development team on DBA issues.
• Involved in Application support functions, Application issue trouble shooting, Collecting the requirements, Analyzing the requirements and Testing the updates.

Environment: Oracle Applications, and Oracle 9i, 10g,Sun OS, IBM-AIX, Linux.