SUMMARY:

• 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 from9i 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
• 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 in data analysis, data mapping, and data quality validation
• Database Upgrade using Golden Gate and Data pump.
• Involved in mastered physical database design and have expertise with database indexing, statistics and tuning.
• 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, Stats pack 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, Data pump, 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.
• Installed and configured the WebLogic Admin, IDM and SOA managed servers in a single as well as multiple domains.
• Experience with, Oracle Access Manager ( OAM ), Service Oriented Architecture ( SOA ), Oracle Identity and Access Management ( IDAM ).
• Set up Secure Sockets Layer ( SSL ) communication with WebLogic Application Server.
• Worked on upgrading JDK versions, also WebLogic servers from lower versions.
• Worked extensively on WebLogic Portal server and Oracle Fusion 11g .
• Experience in installing Oracle SOA suite 11g .
• Experience in Maintaining , Configuration and Trouble-Shooting Oracle WebLogic Server.
• Worked on OPAM RESTful APIs that can access OPAM functionality from applications and scripts. that API's can be used to check-out passwords through application code.
• Provided OPAM out of the box reports which can be integrated with Oracle's BI publisher to create and manage formatted reports.
• Worked on OPAM authentication which relies on Java Authentication & Authorization Service (JAAS) support in WebLogic.
• Working with all communication with, and between, OPAM-related components (including Oracle Privileged Account Manager's Console, command-line interface, and server) occurs over SSL.
• So that OPAM relies on and transparently uses the local ID Store configured for the WebLogic domain in which Oracle Privileged Account Manager is deployed. All of the passwords needed by OPAM at run time (such as passwords to target systems, transient passwords for accounts, and so forth), are stored in the DB repository.
• 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

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.

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

SOFTWARES, APPLICATIONS & TOOLS: OPAM, WebLogic, SOA, IDAM, DBCA,DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Cluster ware, VCS, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, Erwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DB Artisan, 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, Bethlehem, PA

Oracle Database Administrator

Responsibilities:

• Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, ASM, RMAN.
• Experience in system Monitoring, Database Tuning, Memory and SQL Tuning using OEM 12c, Top command, VMSTATS, IOSTATS, Explain plan, SQL Trace, TKPROF, AWR, ADDM, ASH, Cluster Interconnect Tuning (RAC). And Assisted in providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible.
• Designed, installed and configured databases in an Oracle Cloud environment.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM.
• Created and monitored Physical and Active standby databases, running on maximum protection, or performance modes for Disaster Recovery and High Availability on 11g and 12c Oracle databases.
• Migration, security, performance tuning and monitoring of databases.
• Assisted Developers with tuning slow running sql statements.
• Managed Amazon Web Services Console, created new users, giving access to bucket to new users.
• Configured Oracle secure backup to backup with RMAN tool to S3 Bucket.
• Upgraded Grid Infrastructure and databases from 11g to 12c manually or using DBUA. Involved in applying upgrade patch, maintenance and interim (Opatch) patches on all the databases for security and bug fixes.
• Capacity planning: Allocate system storage and plan future storage requirements.
• General maintenance: hardware, upgrades, backups, troubleshooting, recovery.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts to provide reports.
• Granted privileges on Packages, Procedures, Functions.
• Installed, Configured, Setup, Maintained and Supported Oracle 11g, 12c Standalones and 3 nodes RAC, Physical and Logical Standby database for Test, Development and Production, and staging on Linux, AIX and Windows environments for various home-developed applications like Portfolio Management Systems, vendor applications such SAP Business solutions and so on.
• Scheduled and monitored on Crontab repetitive activities such gathering schema statistics, table space usage report, Refreshing Dev and Test instances with data from Production using Data pump and to monitor blocking sessions. Configured and monitored Golden Gate.

Environment: Oracle 12cR2, Oracle Privileged Account Manager (OPAM), WebLogic, SOA, IDAM, RMAN, SQL Developer, Oracle on OEL 6/7 AIX.

Confidential, Sunnyvale, CA

Oracle Database Administrator

Responsibilities:

• installed, configured and support Golden Gate uni-directional and bi-directional Oracle-to-Oracle replicated.
• 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.
• Experience in planning, design, install, configure, perform upgrade and maintain oracle11g (R1, R2) and 12c across multiple platforms, like Sun Solaris, RHEL, AIX, HP-Ux.
• More than six years' experience and solid hands-on experience in Installation / Configuration / Performance Tuning / Troubleshooting Oracle Golden Gate in Oracle to Oracle
• Worked on setup and configuration of Fusion Middleware components Oracle SOA, Web Logic 12c, IDM and EM 12c.
• Web logic Server Cloning and patching in Hyperion environment.
• Proficient in Install, upgrade, clone, administrate, patch and troubleshoot oracle databases.
• Thorough knowledge of various Oracle tools like OEM with management pack, RMAN, SQL Loader, TKPROF, Stats pack, AWR, ASH, ADDM TOAD, SQL trace to perform day to day job.
• Proficient in installation, configuration, administration, patching and maintenance of ORACLE, RAC multi-node cluster and add/remove node as per need.
• Extensive experience in configuring, implement, maintain and troubleshoot errors of physical and logical standby databases Data Guard.
• Experience in replication, extract and apply on production using Golden Gate.
• Extensive experience in installation and maintenance of OEM Database & Grid control for database monitoring, performance and diagnostics.
• Experience in configuring, maintaining, upgrading and troubleshooting Exadata environment.
• Experience in on-Exadata to Exadata database migration.
• Worked extensively on WebLogic Portal server and Oracle Fusion 11g . Experience in installing Oracle SOA suite 11g .
• Experience in Maintaining , Configuration and Trouble-Shooting Oracle WebLogic Server.
• Centralized password management for privileged and shared accounts, including UNIX and Linux root accounts, Oracle Database SYSDBA, application accounts, and LDAP admin accounts
• Interactive, policy-based account check-out and check-in
• Automatic password changes using the Identity Connector Framework ( ICF )
• We Changed privileged account passwords on a regular basis is difficult. Notifying everyone using the account requires a coordinated effort.
• We Changed passwords in scripts/config files requires lot of effort during password change cycles.
• Worked on Centralizing password management for privileged and shared accounts.
• Performed Interactive, policy-based account check-out and check-in.
• Worked on Oracle Privileged Account Manager so it requires all authorized users to check out an account before using it, and then to check that account back in when they are finished with it.
• Performed audits account check outs and check ins by tracking the real identity (the person's name) of every shared administrator user at any given moment in time. By using this information,
• Created Identity Connector Framework (ICF) for Changing Passwords Automatically.
• Configured to automatically change the passwords when user checks-out password and checks back in.
• Adding Targets in OPAM by Using ICF Connecters.
• We Performed Different OPAM administrator user so that can perform different configuration tasks based on Admin Roles assigned.
• Evaluated Oracle Privileged Account Manager’s Default Usage Policy and Default Password Policy and, if necessary, modifies these policies or creates new ones.

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:

• 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 croon jobs for RMAN backups, monitoring for alert log errors, batch jobs and export jobs.
• Troubleshooting the user access issues like resolve problems at the database, server, network and client levels.
• Installed OEM12c 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 in data analysis, data mapping, and data quality validation
• Troubleshooting 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.
• 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

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.
• 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

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.