SUMMARY:

• 6+ years of experience in Oracle Database Administration and GoldenGate, Performance DBA, tuning, development, patches, upgrades, migrations, configuration, database security, capacity planning, space management, Exadata, PL/SQL, troubleshooting and documentation.
• Experience in testing and implementing RMAN scripts in Unix, Linux, Oracle11g.
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments.
• Experience in Very Large Multi - Terabyte Database (VLDB) and also performed migrations in this environment
• Worked on Oracle Key vault, wallets and TDE encryption.
• Participated in a team involving monitoring Exadata hardware.
• Made effective use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• As a Golden Gate DBA, I am defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems.
• Participated in team for analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• As a team assisted in integration of Exadata applications into current IT actionable events and solutions.
• Have good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Experience in creating Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Worked on Oracle databases in High Availability environments using Failover, Data guard and Cloning technologies.
• Experience in Database problem resolution, dealing with Oracle, creation of SRs.
• Performed extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• Proficient in migrating database from 11g to 12c by using Scripts and applied patches by Opatch utility.
• Have hands on experience in using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM.
• Experienced in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Provided 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.
• Expert in Partitioning Administration: creating, managing, purging and merging the partitioned tables.
• Installed Imperva Agents for database monitoring.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Experience in using parameters to configure, install and manage ASM instance in RAC.
• Experience in monitoring of systems using 12c Grid control.

TECHNICAL SKILLS:

Database: Oracle 12c/11g, RAC 11gr2, 10g, 9i,8i

Languages: SQL, PL/SQL, UNIX

Tools: RMAN, TOAD, Export/Import, OEM, RAC, AWR.

Operating System: Linux, Unix, Exadata machine

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

DBA

Responsibilities:

• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs/Archive logs and regular monitoring of Flash Recovery Area.
• Migrated databases from version 11.2.0.1.0 to 12.1.2.1.10.
• Database migration strategy to relocate databases to new Linux, AIX and windows servers.
• Performed Migration and Upgradation of databases to 12c, 11gR2 and 11gR1.
• Setup backup and recovery procedures using RMAN/Snapshot backup Mirroring for high volume databases.
• Implemented Oracle Data guard for maintained oracle disaster recovery.
• Configured retention period of FRA and RMAN backups.
• Data migration between environments using expdp/impdp, transportable Tablespace and Oracle Schemas.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and SQL DEVELOPER and SSMS.
• Worked with PL/SQL stored procedures and Triggers.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Experience in Database design on OLAP databases and maintained database security create and maintain users and roles, assign privileges.
• Worked closely with application team to reduce any impacts on db level.
• OEM13c Agents installation to monitor oracle databases.
• Helped in setting up user accounts, privileges, profiles and roles.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Database migration strategy to relocate databases to new Linux, AIX and windows servers
• Configured RAC Physical standby database for RAC primary using ASM filesystem.
• Performed installation, configuration of oracle server software and its related products.
• Applying oracle security and patch sets.
• Setup configuration of oracle RAC environments, and maintenance of oracle RAC databases.

Environment: PL/SQL Developer, Toad, ASM, Data Guard, Oracle 11g/10g, RAC, Oracle 12c, 11gR2, Oracle Streams, SQL*Plus, OEM, Grid Control.

Confidential, St. Louis, MO

Database Administrator

Responsibilities:

• Performed installation, configuration of oracle server software and its related products.
• Applying oracle security and patch sets.
• Setup configuration of oracle RAC environments, and maintenance of oracle RAC databases.
• Helped in setting up and configuration of OEM12c Cloud control and agent setup for databases monitoring.
• OEM12c Agents installation to monitor oracle databases.
• Helped in setting up user accounts, privileges, profiles and roles.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Configured GoldenGate for extraction and replication of transactional Data Manipulation Language (DML) operations and Data Definition Language (DDL) changes.
• Full scale Golden Gate implementation experience across different databases such as Oracle, Sybase and MS Sql Server.
• Setup Golden Gate replication to replicate data across heterogeneous database platforms.
• Setup and configuration of oracle GoldenGate replication(unidirectional) with conflict detection and resolution. Strong replication experience.

Environment: s: RAC, OEM 12c, Oracle 12c, GoldenGate, Linux, TOAD

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Provided 24x7 production database on-call rotation support as a DBA
• Manage end-to-end complex data migration, conversion and data modeling.
• Maintained existing data migration program with occasional upgrades and enhancements.
• Performed data migration enforcement tasks.
• Analyzed data structures and movement evaluations.
• Executed data migration in coordination with management and technical services personnel.
• Performed source system data analysis in order to manage source to target data mapping.
• Managed data migration workstream within the established project budgets and advise Project Manager of potential deviation.
• Worked on installation, configuration, management and upgradation of oracle server software and its related products and applying oracle security and patch sets.
• Checked with configuration and management of oracle RAC environments, and maintenance of oracle RAC databases.
• Helped in setting up and configuration of OEM13c Cloud control for databases performance monitoring.
• OEM13c Agents installation to monitor oracle databases, MySQL databases.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved in capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lack activity.
• Performed cloning of the primary database schemas, tables and full database level.
• Created databases on CDB and PDB (12c multitenant) for development, testing and production
• Took Databases Backup, restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Experience in scripting various Unix Shells, PL/SQL and SQL scripts to monitor the database and system.
• Maintained backup and recovery policies and procedures and performed periodic recovery tests.
• Performed fine tuning of databases by tuning memory structures, data dictionary, redo logs and creating appropriate rollback segments.
• Experienced in Data migrations which include migrating the source from flat file to the Oracle Database using SQL*Loader (control files).
• Improvised database performance by database tuning and troubleshooting and performance monitoring, tuning of corporate databases, using tools like SQL trace, AWR, ADDM and SQL Tuning.

Environment: WinFTP, VM Ware, TOAD, Oracle 12c, OEM 13c, RMAN, DataGuard.

Confidential

Oracle DBA

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Worked in designing logical and physical data models for star and snowflake schemas using Erwin.
• Written sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Upgraded database from 10.2.0.4 to 11.2.0.3 by applying patches using Opatch utility in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Performed creation of database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Meeting with the Client, and working RI Bridges tickets for the data fix scripts.
• Provided support 24/7 for database systems including performance monitoring, performance tuning, troubleshooting and client support.
• Worked with Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Worked hands on using the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Understood the Architecture by the kind of data modelling and the work flow by executing SQL scripts

Environment: Oracle OEM, Share Point, Jira, Jama, Windows 2010, RHEL 6.0, Pl/Sql Developer, RMAN, Data Guard, UHIP VPN Production Database. Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad.

Confidential

Oracle Database Admin

Responsibilities:

• In-place Upgrade/Migration of 11g databases to 12c. Performed application tuning and performance monitoring.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN- complete and incomplete recovery of database
• Interact with oracle through Metalink for ORA-600 Issues.
• Installed key vault and configured database connections.
• Created and encrypted new table spaces and dumped data from original table spaces.
• Worked policies to flag unauthorized logins, monitor activity, generate reports & applied policies in Imperva.
• Performed SQL query optimization by gathering statistics and by using explain plan.
• Upgrade and Retirement of Databases/ Applications.
• Installed and set up 11g RAC and applied TDE Encryption on RAC databases and monitored databases through OEM 12C.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Maintained standby databases to ensure disaster recovery, high availability & data protection.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Worked on 11g Features: Data Pump, Automatic performance and diagnostics and Flash Back Technology.
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
• Installed Imperva agents in sniffing mode to track database activity.
• Worked in a team to create 2- nodes and 3 node RAC environments for development and staging environment with oracle 12c .
• Writing and maintaining SQL and PL/SQL scripts, complex code deployments.
• Upgraded database from 9i to 10g for upgraded features.
• Used RMAN for Cloning of the creating database in test and development environment.
• Monitoring production systems to establish status and conduct proactive maintenance
• Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
• Participate in an On-call rotation with other dba's to provide 24 x 7 coverage and monitoring service now tickets.
• Documented all Oracle database installations and database operations.

Environment: Oracle 11gr2/12c, IBM-AIX, RMAN, Data pump, PL/SQL, exp/imp, TOAD, SQL*Loader, Imperva, TDE, Key vault.