SUMMARY

• Over 7 years of experience in Oracle DBA/Architecture/Implementation/System Study/Support with emphasis on Evaluation of existing system and Data collection, System Design, Implementation specifications, Implementation schedules, Development, testing and Documentation of business applications using Oracle technologies 11g RAC, 10g RAC/9i, Distributed Database System and Oracle Dataguard (DR).
• Experienced in Oracle DBA duties including installation, configuration, backup, recovery, performance tuning, upgrading, migration, patching, system security, auditing and decommissioning of oracle databases.
• Managed user - managed cold and hot backup, RMAN backup, applied ETL tools such as Export & Import, SQL*Loader and data pump.
• Experienced in planning & implementation of logical backup using Data Pump utility and physical backup using Shell Script, RMAN, crontab.
• Proficient in setting up the network connections, troubleshoot Oracle networking issues.
• Strong Hands-on experiences of high availability of RAC environment (2 node clusters) both in configuration and administration.
• Expertise in Oracle Enterprise Manager (OEM): DB control, 11g Grid Control and OEM 12c.
• Co-ordinated with LINUX/UNIX Administrators for space management on various servers.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace & TKPROF.
• Tuned performance using ADDM, AWR, ASH and Real-time ADDM, i.e., tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Experienced in working with Oracle Streams, Oracle Data Guard & Data Guard Broker.
• Proficiently accomplished set-up and configuration of Standby/Dataguard Database using Shell Script and RMAN utility, Activating Standby Database & Re-building Standby. Performed switchover and failover operations on demand.
• Enabled and Configured Database Auditing Vault and Firewall Management console for Production databases.
• Experienced in supporting clients engaged in various industries exclusively in financial, telecom, banking, insurance and government.
• Attended various trainings from Oracle: - Oracle database 11g Performance Tuning Edition 2, Oracle Database administration workshops.
• Good knowledge/understanding in other RDBMS like Microsoft SQL Server and non-RDBMS like Mangodb.
• Possessed excellent analytical, problem-solving and learning skills as well as keen interest in emerging technologies.

TECHNICAL SKILLS

Operating Systems: Linux (64 bit), Sun Solaris 9, 10, AIX, Red Hat Linux RHEL 4, 5.x, 6.x and Windows/98/ME/NT/2000/XP/2003/2008

RDBMS: Oracle 12c Multi-tenant, Oracle 11g, Oracle 10g, Oracle 9i, 11g ASM

High Availability: 11g/10g Real Application, Cluster (RAC), Oracle, Standby/dataguard database

Languages/Scripting: SQL, PL/SQL, Java, UNIX/LINUX, bash shell scripting and Windows PowerShell.

Database Tools: RMAN, OEM, Enterprise Manager Console, ETL Tools SQL*Loader, EXP, IMP, data pump (expdp, impdp); DGMGRL, CRSCTL, SRVCTL, CLUVFY, SQL, Developer, TOAD for DBA 11.6, SSH Secure Shell Client 3.2, Putty

Tuning Tools: EXPLAIN PLAN, STATSPACK, ADDM, ASH, AWR, Real-time ADDM, ADRCI

Ticketing/Change Management: BMC Remedy ITSM 8/9, Serena Business Manager, Issue Tracking System

Storage: EMC, NetApp, Veritas NetBackup

Others: MS-Office, VMware, OID/OIM, VPN, VDI, Erwin, ER Schema, UltraEdit Version 18.20, SnagIt Version 12.0, Reflections R3 15.1, Serena PVCS Version Manager 8.4, WinZip, WinSCP, Tortoise SVN Revision/Version Control 1.8

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• Managed Oracle ASM space/storage. Monitored and resized tablespaces, and monitored file system disk space proactively and resolved space issues coordinated with SAs and CSVD personnel.
• Cloned databases as per request, Refreshed full databases, tablespaces, schemas and tables from one environment to another environment as project requirements.
• Managed nightly RMAN backups and datapump exports and troubleshoot and resolved issues related to backup and datapump export failures.
• Tested backup and restore strategies: working closely with Apps, QA and Oracle support teams Restored databases, tablespaces, schemas and tables.
• Proactively monitored major performance of databases and recommended solutions coordinated with development and CSVD team.
• Maintained database user accounts, created and maintained schemas, dblinks, profile, database roles, grants etc.
• Secured database security, PII data both in use, movement and at rest through the use of Oracle Wallet, Encryption/Transparent Data encryption (TDE) and data redaction.
• Planed and estimated capacity of databases.
• Installed Oracle software and setup new databases for existing or new projects.
• Installed Oracle Patches and upgraded oracle releases from 11.2.0.4 to 12.1.0.2, requirement planning and installation of Oracle 12c CDBs and PDBs.
• Proactively monitored databases and troubleshoot of incidents/problems and found resolution by doing root cause analysis.
• Developed and maintained scripts for automation of redundant DBA tasks to save time-consumed for other administration tasks.
• Performed weekly or monthly application releases coordinated with development and SA team.
• Deployed/promoted scripts which modify schemas to different environment: Development, Testing, Integration, Beta and production environments.
• Deployed/Promoted application code to different environments: Development, Testing, Integration, Beta, production.
• Maintained CRON jobs which are related to application databases on the database servers as per run time requirement of developers.
• Installed Oracle 12c multitenant databases (CDB/PDB) for version upgrade evaluation purposes.
• Worked with My Oracle Support (Metalink) on database software bugs.
• Proficiently raised TAR using SR Packaging, SR Ticket and implemented work around or permanent fixes.
• Documented system design, system configuration, developed system implementation plan and database log files.
• Documented documentation of procedures and SOP’s.
• Supported 24/7 database through weekly on-call rotation.

Environment: Enterprise Linux 6.X, RAC 11g R2, standby db (DR), Distributed Database System, DGMGRL, OEM 12c, OID/OIM, Oracle multitenant 12c:CDP/PDP, RMAN, Crontab, ASM11gR2, AWR, ADDM, ADR, PL/SQL, expDp/impDp, VDI, ASMCMD, Oracle Client Server, SQL, SQL*Plus, Vi/Vim, TOAD DBA 11.6, UltraEdit Version 18.20, snagit Version 12.0, Reflections R3 15.1, Serena PVCS Version Manager 8.4, Winzip, WinSCP, Tortoise SVN Revision/Version Control 1.8, Remedy ITSM 9, Serena Business Manager, SSH Secure Shell Client, Oracle SR

Confidential, West Hartford, CT

Oracle DBA - Oracle Database Engineer

Responsibilities:

• Helped Very Large Database (VLDB) to Medium Production databases of customers engaged in financial, banking, health and Insurance sectors, on 24/7 basis.
• Performed day to day activities: Such as daily error checks and database health monitoring, monitoring of physical resources (such as disk space, memory, CPU, etc.).
• Automated routine database jobs and written scripts and triggers for automation, detection and reporting of database failures to minimize time taken for administration tasks.
• Disaster Recovery Management, defined and implemented into Production DR databases, administration for log-shipping/standby/dataguard database systems.
• Conducted health checks of production database for proactive measure and suggested recommendations.
• Participated in High Availability database studies of gold standard databases, and recommended for technical and non-technical solutions.
• Performed Oracle DBA administration on Unix environments including the biggest and most critical environments.
• Installed Oracle software’s and databases on test/development and production databases on RAC and Non-RAC environments on multiple platforms (Solaris, Linux, and Windows).
• Installed ASM instances, created ASM disks, diskgoups and added disks/diskgroups as needed.
• Troubleshoot production database issues and resolved accordingly.
• Efficiently performed performance tuning of databases using AWR, ADDM, and ASH reports and other statistical and diagnostic tools.
• Proficiently installed, configured and deployed Oracle Enterprise Manager (OEM) 12c, and deployed Oracle management agents to target, managed and monitored oracle production databases, middleware and application.
• Efficiently applied patching, refreshed/cloned prod databases to Testing/staging databases, upgraded and migrated databases.
• Resized tablespaces and de-fragmented databases as needed, system shut down and restart, unlocked database table locks, as well as monitored and created additional tablespace and file space (datafiles) as needed.
• Provided mentoring and training of Oracle 11g Database Administration for junior Oracle DBA teams.
• Implemented oracle trend monitoring scripts in production databases.
• Using it monitored and analyzed database growth trends of Oracle databases to help informed decision making of managers with regard to resource management.

Environment: Enterprise Linux 4.X, 5.X and 6.X, Solaries 10, Windows 2008 R2/2012, RAC 11g R2, standby db (DR), DGMGRL, OEM 12c, RMAN, Crontab, ASM 10g/ASM11gR2, ASMCMD, AWR, ADDM, ADR, Oracle SQL, PL/SQL, Secure Shell, expDp/impDp, VPN, Terminal Server, VMWare, Vsphere Client, cygwin Terminal, Issue Track, SQL*Plus, Vi/Vim, Powershell, Windows Server Manager, Veritas storage, Oracle Connection Manager, RDP, RDP connection Manager, data modeling tools, ER schema, Oracle SQL Developer

Confidential, Silver Spring, MD

Oracle Database Administrator

Responsibilities:

• Proficiently installed and Set up of 10g and 11g on RAC and non-RAC databases.
• Extensive experience with database replication technologies (Data Guard/Standby, Advanced Replication).
• Performed day to day activities: Such as daily error checks and database health monitoring, monitoring of physical resources (such as disk space, memory, CPU, etc.).
• Automated routine database jobs and written scripts and triggers for automation, detection and reporting of database failures.
• Provided Primary architectural and administrative support for new projects.
• Provided Production DBA support, as needed, on a 24/7 basis.
• DBMS Software Updates - Installed DBMS software per best practices. Applied Patch and version upgrade evaluation, planning and installation.
• Utilized OEM and Toad for DBA’s for monitoring and management of database environment.
• Applied DBMS configuration planning for systems physical environment, hardware capacity planning and licensing of enterprise environment.
• Database Recoverability- Supported Operational Reporting, Development backups and restorations and participated in Disaster Recovery testing.
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Disaster Recovery Management, Defined and Implemented Production DR databases, administration for log-shipping/stand-by database systems.
• Worked on multiple projects simultaneously, met project deadlines and worked under pressure.
• Worked independently with little or no supervision and experienced in managing multi-terabyte databases.
• Proficiently raised TAR (SR) with My Oracle Support (Metalink) and using SR Packaging, SR Ticket to resolve internal software error/bug in the database environment.

Environment: Oracle 11g(RAC)/10g(10g RAC)/9i, RHEL 5.0, LINUX(64 bit), ExpDp/ImpDp, Grid Control (OEM), Enterprise Manager Console, RMAN, Crontab, TOAD, SQL, SQL*Plus, ASMCMD, vi/vim editor, VNC server, Putty, DGMGRL, ADRCI, BMC Remedy ITSM

Confidential, Washington DC

Oracle Database Administrator

Responsibilities:

• Supported 24/7 database administration, production support and monitoring.
• Installed and configured databases on both windows and Linux & Oracle application Server installation and configuration.
• Applied Patching and Upgrading of Oracle 10g. databases.
• Setting up Linux kernel parameters, permissions and file structures for Oracle.
• Documented Change Request Design Documents and install scripts for enhancement issues.
• Performed logical backups of database using Oracle Export and physical backups using both user-managed backups and RMAN Cold/Hot backups.
• Experienced in using Import feature to import databases.
• Troubleshoot and solved day-to-day user Problems/incidents.
• Experienced in ETL using Export & Import both at table, tablespace, schema and database level.
• Monitored & Managed Tablespaces and Datafile growth.
• Monitored locks and various sessions using OEM.
• Managed control of database privileges and Managed user Accounts.
• Created and administrated database objects like tables, views, materialized views, indexes, etc.
• Provided support for the smooth functioning of the Database to developers and clients.
• Applied all types of flashback technologies accordingly for user error and logical corruption.
• Alleviated performance bottle necks using various performance tuning techniques and tools.
• Installed with RAC 10g, 11g and Oracle 11g R2 ASM databases on Oracle Enterprise Linux Using VMware Server.
• Participated in planning, migrating and implementation of Windows SQL Server database into oracle 11g database.

Environment: Oracle 11g (RAC)/10g (10g RAC), RHEL 5.0, LINUX (64 bit), AIX, Data Pump, OEM Grid Control, TOAD, SQL*plus, ASMCMD, vi/vim editor, VNC server, Putty, BMC Remedy ITSM

Confidential, Dublin, Ireland

Oracle Database Administrator

Responsibilities:

• Installed, configured and maintained Oracle 10g RAC and non-RAC databases.
• Created test, production and archive databases and its application tablespaces.
• Created admin users and granted the role to the users with high level security.
• Involved in creating database objects, Created roles and users and Space management.
• Monitored application related jobs and data replication activities.
• Performed application tuning and performance monitoring.
• Worked as part of a team and provided 24/7 support when required.
• Interfaced with Oracle Corporation for technical support.
• Played an important role in migrating database objects from Test database to Production database.
• Application tuning using Explain Plan and SQL trace facilities.
• Tuning of I/O to reduce disk contention by distributing I/O.
• Good knowledge in Real Application Cluster (RAC).
• Optimized databases queries and recommended tuning enhancements.
• Performed troubleshooting of databases and supported Developers and QA testing team.
• Performed SQL tuning using Explain Plan and SQL Trace.
• Involved in writing shell Scripts for Backup and recovery methods.
• Maintained Databases including backups, restores, recoveries, imports, exports.

Environment: Oracle 10g/9i, RHEL Linux, OEM, SQL, SQL Plus, TOAD