SUMMARY

• 6+ years of experience in Oracle Database Administration and Performance DBA, tuning, development, patches, upgrades, migrations, configuration, database security, capacity planning, space management, GoldenGate, RAC, PL/SQL, troubleshooting and documentation.
• Experience in supporting large dB’s from 100gb to a three - terabyte data warehouse; worked in enterprise-wide database optimization and instance and resource monitoring.
• Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• 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 performed migrations in this environment
• Worked on Oracle Key vault, wallets and TDE encryption.
• Made effective use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• 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: /Utilities: RMAN, TOAD, Oracle Grid Control, DataPump (Export/Import), OEM, RAC, AWR,ASH, TKPROF,ADDM, TDE, GoldenGate, OKV, Informatica MDM

Operating System: Linux, Unix, Sun Solaris, Exadata machine, Windows, AIX

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• Upgrade of databases from 11.2.0.3 to 12.1.0.2 .
• Configured Backup and Recovery setting for Oracle database 10g, 11g, 12c, & 18c for single instance on File system & ASM storage using RMAN.
• As a team assisted in setting up unidirectional replication using GoldenGate 12.1 for high availability, reporting projects. Setup Goldengate in RAC environment for near zero down time strategy and for replication purpose.
• Develop database structures, implement applications, enhance system performance, and ensure database security.
• Manage business continuity efforts with oversight for backup and recovery of data.
• Provide after hour maintenance, coordinate with consultants, and manage vendors for patches and upgrades.
• Create and maintain data dictionaries, physical databases, logical database models and conceptual models.
• Responsible for creating tables and indexes, performance monitoring of queries, and data striping.
• Used table partitioning to archive data and improve database performance.
• Applying upgrade patches, maintenance, and interim patches on all the databases.
• Installation of Oracle cluster ware, Configuring public (SCAN) and private network and VIP.
• Performance monitoring, Database Monitoring using OEM, TOAD and Spotlight, and Database/Instance/RAC tuning using Dictionary views, AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces at performance standpoint.
• 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.

Environment: Oracle SQL Developer, Toad for DBA’s, Oracle 12c, ASM, Data Guard, Oracle 12c/11g, Oracle RAC, Oracle SQL Loader, SQL*Plus, PLSQL, Oracle Enterprise Manager, AWR, ADDM, ASH, Oracle Replication and Golden Gate.

Confidential

Enterprise Apps 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.
• Responsible for optimizing the queries and application tuning.
• Worked with PL/SQL stored procedures and Triggers.
• Applying upgrade patches, maintenance, and interim patches on all the databases.
• Experience in scripting various Unix Shells, PL/SQL and SQL scripts to monitor the database and system.
• 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 database 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

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