SUMMARY:

• Oracle DBA with 8+ years strong experience in Oracle database administration, providing 24x7 production support for 10g, 11g, and 12C in mission critical databases on different Platforms including (Linux/Solaris/HP - UX/AIX) and widows systems.
• Hands-on experience in the implementation and managing heterogeneous systems including RAC, ASM, Dataguard, Exadata and GoldenGate environments .
• Good experience in the installation, configuration, monitoring and maintenance of Golden Gate for data replication
• Involved with installation and maintenance of Dataguard standby database for High Availability and Disaster Recovery purpose
• Hands on experience in Grid Installation - Oracle Clusterware/ASM setup and configuration.
• Extensive experience in database Backups using RMAN (Full/Incremental backups) and logical backups using Datapump(expdp/impdp)
• Experience in Implementing Flashback technology and its various features in Oracle 10g/11g/12c.
• Performance tuning of the database using utilities like STATSPACK, EXPLAIN PLAN, Autotrace, AWR and ADDM
• Hands-on experience in database security strategies implementing transparent data Encryption (TDE).
• Hands on experience creating and maintaining users accounts, user roles, profiles and p privileges
• Good Experience in patching and upgradation of Oracle Development and Production databases from 10g to 11g, 11g to 12C.
• Experienced in creating, upgrading and applying patch on RAC and non-RAC databases
• Experienced in Database migration using RMAN Duplicate, Datapump and Transportable Tablespaces
• Experienced in Database Refresh/cloning from production to development with RMAN and DATA PUMP as per development team request
• Good experience in writing/editing SQL, PL/SQL scripts and UNIX Shell Scripts for the administration and database monitoring
• Extensively used Oracle Enterprise Manager (OEM), SQL Developer, TOAD and Data Dictionary views for maintaining and monitoring database
• Experience with My Oracle Support (MOS) using Metalink for Oracle SR to resolve the bottlenecks in the database environments.as well as patch downloads.
• Team player with excellent interpersonal, analytical and communications skills
• Actively involved in On-call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours which include oversight of DBA on-call rotations.

TECHNICAL SKILLS:

Operating System: UNIX (Linux, Solaris, HPUX, AIX), Windows.

Technical Environment: Oracle 10g, 11g, 11g/12c, RAC, ASM, DATA GUARD, Golden GateVirtualization Technologies: VMware, Oracle Virtual Machine.

Languages: SQL, SQL*PLUS, PLSQL, UNIX shell scripting, scripting, Batch Scripting.

Database Development Tools and Utilities: Oracle Cloud Control (12c,13c), Oracle Enterprise Manager (OEM), SQL Developer, Data pump, Database Oracle Label Security, Explain Plan, Statspack, AWR, ASH, ADDM, RMAN, TKPROF, Flashback, OLTP, OLAP, CRSCTL, SRVCTL, OUI, DBCA, DBUA, Oracle Net Manager, SQL*Loader, TOAD, putty, WINSCP, SFTP, SCP.

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Senior Oracle Database Administrator (Consultant)

• Actively participated in the installation and configuration 11g and 12c GRID Infrastructure on Linux operating system
• Created and Installed several RAC and standalone databases on ASM and DATAGUARD
• Built and maintaining Oracle Standby databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery
• Upgraded multiple Production RAC/Standalone databases from 4 and 11203/ c including releases.
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using autopatch utility
• Applied critical Patches to several RAC/Non-RAC databases in production, UAT, test and Development environments on quarterly basis
• Installed and configured Goldengate replication. Monitored and maintained Golden Gate for data replication.
• Designed POC and worked on database Wallet and TDE (Transparent Data Encryption) for encrypting sensitive data including backups
• Implementing Oracle Transparent Data Encryption (TDE} in all of our new/existing databases for Tablespace encryption.
• Setup and configured OEM 12C Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications.
• General administration and routine operations including applying database tuning improvements, troubleshooting and performance tuning.
• Storage Management including file system disk space, tablespace monitoring ASM diskgroups management, and adding of new disks
• Managed User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Cloned/Refreshed tables and schemas from production to Development as per development/Application team requirements using Data pump and transportable tablespace.
• E xtensive experience in database Backups RMAN ((Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces
• Configured RMAN backups for databases and schedule them through Crontab
• Generated shell scripts for daily maintenance routine activities, growth rate monitoring and optimizing database performance.
• Provided planned maintenance and built a pilot environment which mirrored production to do in depth testing for all customers. Migrated production cluster to the new environments for the implementation of new releases.
• Actively participate in On-call rotation to support 24x7 mission critical production databases after normal business hours (nights, weekends, and holidays)

Confidential, Troy, MI

Oracle Database Administrator

• Supported the Confidential Company production/UTA/Test/Dev database systems in a large complex LINUX, HP-UX, AIX and Windows environment. installed, upgraded and configured the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation and system management.
• Configured and monitored Physical Standby database for maximum performance mode - Oracle Data Guard
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Performed day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs
• Used AutoSys and Crontab to schedule backup and file clean performance monitoring jobs.
• Closely tracked and administered the production environment, which includes database alert logs, file system disk space, tablespace monitoring, system shut downs, and database restarts for maintenance purposes.
• Performed database Refresh/clone from production to testing using Datapump expdp/Impdp
• Successfully run complete, incremental, and archive backups with RMAN.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Developed scripts to monitor database usage, track performance and conduct regular maintenance operations.
• Configure OID and LDAP Oracle service names and alias registration.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Participated in On-Call 24x7 production support to application/development DBA.

Confidential, Fredrick, MD

Oracle Database Administrator (Consultant)

• Created several RAC/Non-RAC database.
• Maintained and monitored database schedules that included regular Backups.
• Monitored database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files.
• Created and managed User accounts, Roles and granting required access permissions
• Configured database, making changes to the Initialization Parameters dynamically in session.
• Checked database servers for disk contention, resource usage, system events and waits to maximize performance.
• Created database storage structure working with developers in designing application schemas.
• Tuned database to ensure acceptable level of performance and availability.
• Developed database links for remote database access.
• Provided On call technical support for 24x7 mission critical production databases.