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 noledge in SQL and database design
• Experienced wif 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 wif Golden Gate Change Data Capture (CDC) setup
• Excellent noledge to setting up Golden Gate wif DB2 for Change Data Capture (CDC) performed to setting up Golden Gate for Change Data Capture (CDC) extraction of files for ETL implemented teh 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 noledge 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 teh Datacenter for High Availability. involved in setting up teh table replication in Golden Gate and Version Upgrades.
• Database Upgrade using Golden Gate and datapump.
• Involved in mastered physical database design and has expertise wif 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 teh 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 teh 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 teh UML, Use Cases, Assent Management Tools.
• Implemented automated backup strategy using teh UNIX shell script CRON UTILITY.
• Performance tuning of teh database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk me/O, Sizing of tables and indexes.
• Partitioning strategies for very large tables. Partitioned large objects to improve teh query performance and manageability working wif Oracle 9i and 10g partitioned tables.
• Performance Tuning me.e. tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms.
• Excellent effectively convey information and work well in a structured environment wif other team members.
• Excellent communicate effectively wif different levels of management as well as both teh 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 wifin teh 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 wif Golden Gate Change Data Capture (CDC) setup
• Excellent noledge to setting up Golden Gate wif 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 teh 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 teh user access issues like resolve problems at teh database, server, network and client levels.
• Installed OEM 12c and Monitoring mission critical business databases.
• Worked wif 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 wif 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 has expertise wif database indexing, statistics and tuning.
• Excellent noledge in SQL and database design
• Experienced wif 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 teh databases up to date wif teh Oracle security updates.
• Provided support to 10g RAC databases.
• Cloning teh 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 teh user access issues.
• Developed teh applications through using PL/SQL Packages, Triggers, Cursors, Procedures and functions
• Good noledge in Exceptions and advanced concepts of PL/SQL.
• Involved in mastered physical database design and has expertise wif database indexing, statistics and tuning.
• Strongly performed in hardware configuration, networking concepts and terminology
• Involved in Creation of User profiles and roles.
• Worked closely wif teh application teams on scheduling teh patching windows.
• Cloning teh databases regularly for teh 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 teh 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 teh 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 wif other team members.
• Excellent communicate effectively wif different levels of management as well as both teh 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 wifin teh stringent response/resolution SLA timelines.
• Configured Golden Gate Data Replication (Bi-directional, Cascading, Homogenous and heterogeneous DB’s)
• Prepared shell scripts to monitor all teh 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 teh 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 wif 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 teh transfer of data, transactions, and events wifin 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 teh performance and manageability
• Downsizing and defragmenting teh 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 wif development Team. Extensive familiarity wif 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. Teh environment includes 650 oracle databases running 24/7 wif 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 wif post upgrade issues.
• Responsible for Hands on PLSQL Development, mentoring developers in using oracle latest features, interpret query plans, generating stats, dealing wif query plan flips, analyzing AWR/ADDM and make teh development teams self-sufficient.
• Top Notch Application Performance tuning skills along wif 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. Teh environment includes 3 node, 2 node RAC clusters and Single instances configured in OCFS2 and ASM.
• Familiar wif Oracle Discoverer, App Server, Web Server and other middle tier Components.
• Extensively monitored teh 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 teh 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 teh test cases. Involved in creating use cases and test cases.
• Designed Logical and Physical Layout of teh databases.
• Enforcing data integrity constraints on teh tables in accordance wif 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 wif Oracle Corp for technical issues.
• Responsible for creating new indexes and analyzing tables and design teh queries to improve teh query performance.
• Monitored Index Usage.
• Administration of 10g Data Guard for high availability.
• Involved in design and implementation of teh data warehouse.
• Monitored daily refresh of reporting databases.
• Responsible for teh scheduling of teh batch programs.
• Supported teh database full time during teh batch programs, analyzing teh failure of teh batch program and escalating teh issues to teh corresponding teams.
• Involved wif 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 teh databases upto date wif teh Oracle security updates
• Involved in health monitoring Unix shell scripts
• Scheduled teh health scripts using cron tab, mailx.
• Trouble shooting teh user access issues.
• Involved in Creating User profiles and roles.
• Worked wif teh development team on DBA issues.
• Involved in Application support functions, Application issue trouble shooting, Collecting teh requirements, Analyzing teh requirements and Testing teh updates.

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