SUMMARY

• Over 5+ years of experience as an Oracle Database Administrator - performing various tasks like database installation, administration, configuration, upgrades, patching, backup and recovery, performance monitoring, performance tuning, cloning, space management, database security and production support.
• Expertise in Oracle, 10g /11g/12c/18c/19c on various Unix platforms (Linux, HP-UX, Solaris, AIX), windows NT 4.0/2000/2003 in the areas of database creation, refreshing database, user management, RMAN, Export and Import utility.
• Experience Perl and shell scripting and other Oracle tools and utilities like Oracle OEM (12c/13c), SQL Developer and TOAD.
• Involved in Installation, Performance Tuning, Backup and Recovery, RDBMS Patching, Security, Oracle Enterprise Manager (OEM), Standby Database, Database Upgrade from 11g to 12c and 18c and 19c, troubleshooting and basic knowledge of networking and security.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK
• Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers, and procedures.
• Migrated database from Oracle to AWS instances, using the SCT.
• Design and implementation of Backup & Recovery using RMAN and SQL scripts.
• Proficiency in using Log miner, SQL *Loader and Export/Import utilities.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Trace files and backup verifications.
• Setting up Standby Database / Oracle Data Guard to protect against failures.
• Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
• Experience in installation and configuration of Oracle RAC (3 nodes)
• Experience as 24x7 on call Production DBA as well as application (development) DBA.
• Good Knowledge in Golden Gate installation, configuration, and troubleshooting
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Transforming data from various data sources using OLEDB connection by creating various DTS packages.
• Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.
• Experience on installation and implementing OEM 12C and 13c.
• Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables
• Proactive and efficient in timely delivery of all assignments, always enthusiast to take up new challenges.
• Motivated team player and an adaptable individual with good analytical and strong interpersonal skills.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Databases: Oracle 10G/11G/12C/18C/19C

Operating Systems: Linux Enterprise Server 9, 10. Windows 95/98/NT/2000 Solaris, OCI, AWS, AZURE

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, MARYLAND

Oracle Database Administrator

RESPONSIBILITIES:

• Installation of oracle 11g, 12c, 18c and 19c databases in production, development and test environments depending on project requirements.
• Oracle HA Stack: Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.
• Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC)
• Design and Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems
• Upgrade DBs from 11.2.0.4 to 12.1. From 12c to 18c and 19c. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade patches, maintenance and interim (Opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Creating and assigning appropriate roles and privileges to users depending on the user activity Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 10G to 12c.
• Experience and solid hands-on experience in Installation / Configuration / Performance Tuning / Troubleshooting Oracle Golden Gate in Oracle-to-Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• Scheduled RMAN backups, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM.
• Monitored and troubleshooted database issues with OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site.
• Very comfortable in using ASM for creating disk groups, adding additional storage (Disks) and troubleshooting ASM issues.
• Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured with Goldengate.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Windows, Linux Red hat)
• Successfully installed Oracle Real Application Cluster (RAC) including Grid infrastructure (Cluster ware and ASM) and Oracle rdbms software on a 2 nodes RAC architecture in development and UAT running oracle.
• Experience in designing and configuring high-availability systems using Data Guard with physical standby effectively configured and used Data Guard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
• Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, SQL Analyze, ADDM, AWR reports etc.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases.
• Administered databases of various sizes from 200GB to 6TB.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.

Confidential, PLANO, TEXAS

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 12.1.0.2, 12.2.0 databases on Linux platform.
• Successfully performed migrations from Oracle 11g/12c to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2, 12cR2.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 11gR2.
• Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
• Configure Data Guard on both standby and primary for 15 production databases.
• Fail over and switch over between standby and primary databases.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Hands-on experience for various performance tuning issues using VM sphere client.
• Experience in working with virtual machine and oracle virtual machine (OVM).
• Experience in migrating from multiple Oracle 11gR2 database to oracle 12cR1 on virtual machine.
• Hands-on experience in taking snapshots and rebooting the server's and performance monitoring for Oracle databases in virtual machines.
• Experience in adding and expanding the disk volumes to oracle serves on virtual machines.
• Experience in installing oracle software and creating standalone databases on virtual machines.
• Hands-on experience in working with virtual machine under different operating system like Linux, sun Solaris and windows.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).
• Setup RMAN solutions for all Oracle Databases -- provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g, 12c Data Guard/standby databases for switch-over and fail-over purposes.
• Experience in Implementation of High Availability solutions with Oracle 10g,11g and 12c RAC, Physical Standby Databases (Data Guard). Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 11.2.0.1 and 11.2.0.3, 10.2.0.4.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Oracle Software Installation and creation of databases and database objects
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and Perl based utility “opatch”.
• Extensive Experience with RMAN Hot & cold Backups, User Managed backups, and Logical Backups. Used recovery Catalog to maintain and manage backups.
• Used shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.
• Extensively worked in various areas of Data guard i.e., Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a job scheduled (Crontab)
• Automated the Data Replication process using Materialized Views for reporting databases.
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL, and UNIX shell scripting.
• Monitored the Applications and database using OEM.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH)
• Used Oracle Enterprise Manager (OEM) 11gGrid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• 24 X 7 Production & Development database support and administration