SUMMARY

• 7+years of experience in IT industry as an Oracle Database administrator, having exclusive experience in database administration, production support, installation, configuration, upgrades, cloning, space management and database security with Oracle Software 11g/10g on Red Hat Linux, HP - UX and Windows Platform. Possess high competency in advanced DBAskills such as backup, recovery & Migration.
• Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Experience in installing and patching Oracle RAC with ASM on Linux platforms.
• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.
• Good exposure of Oracle DBAtasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Extensive knowledge of database backup/recovery strategy using RMAN and configuration of Recovery catalog for multiple databases.
• Performed periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.
• Experience with logical backups of the database using Data Pump (Expdp and Impdp).
• Performed backups and tested crash recoveries using conventional Hot and Cold backups.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience in Oracle Database Tuning and Performance by using tools/utilities like Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Database health checks (space, parameter, long running queries, Wait events).
• Managing internal databases, from planning and testing stages through implementation and support.
• Experience in Managing Database Structures, Storage, Table/Index segments, Constraints, Database Access and Rollback segments.
• Implemented Database security administration by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.
• Experience in Deployment process in all phases from Development to production.
• Strong working knowledge of database tools like TOAD, SQL Developer, SQL Plus and Rapid SQL.
• Hands on experience in Unix shell scripting and scheduling jobs using CRONTAB
• Provided 24/7 on-call DBAsupport for Production/Development databases, responding to trouble calls from multiple database sites and offering solutions to database applications.
• Extensive DB2 DBA and DB2Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.Migrating data from DB27.1 to DB28.2.Performance monitoring and tuning for DB2databases

TECHNICAL SKILLS

Database Admin: Oracle 12c/11g/10g/9i/ SQL Server 2008/2005

OS: Linux -Windows2000 Server, Windows XP, Windows 2003 Server, Red HatLinux 5.4

Virtualization: VMware and Oracle Virtual Box

Languages: Oracle SQL, PL/SQL, Java

Backup: RMAN, Hot and Cold backup

Tuning Utilities: SQL Trace, Autotrace, TKPROF, Explain Plan, AWR, ASH, ADDM and ADRCI

Migration Tools: Data Pump (expdp /impdp), SQL*Loader

High Availability: Data Guard, RAC and ASM

New updates: Oracle 12c Multitenancy

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential -Washington, DC

Responsibilities:

• Performed Migration and Upgrade of databases to 12c and 11g.
• Extensive experience on Oracle 12c/11g/ASM/RAC and upgrade of standalone databases to 11g RAC environment
• Perform database health check using OEM 12C
• Maintain Oracle Applications 11g DBA skills for complex 24 7 environments
• Provides user management and database security using DISA STIGS strategies Backups, exports and imports, archiving old records and verification of processes, create and maintain database through, DDL/DML, back - up/restore strategy, replication strategy.
• Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances
• Provides logical backups of data using oracle data pump utilities EXPDP and IMPDP, to move Oracle data from a database or schema to another.
• Experience with various tools such as Data Pump, SQL*Loader, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
• Maintaining Oracle Data Guard & Standby Database and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods.
• Experience in writing scripts proactive monitoring the disk usage and the memory usage of the server and monitoring tablespaces.
• Responsible for a variety ofDB2database administration duties in support of a customer tracking system conversion fromDB2/TELON-based applications toDB2/Visual Basic.
• Responsible for performing DB2 DBAduties in a DB2z/OS environment, using DB2V10. The utilities of choice at this installation are the BMC DB2utility suite. Am proficient with BMC DASD Manager, BMC Catalog Manager, BMC Change Manager, BMC Unload Plus, BMC Load Plus, BMC Reorg, BMC Copy and DB2Utilities
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Communicate with Oracle support via the Metalink for other important troubleshoot issues.
• Upgrading databases using best practices and DBUA

Environment: Oracle 11g R2, LINUX, Exp/Imp, RMAN, SQL Developer, OEM, SQL*LOADER, Cute FTP DB2 SQL, MVS Workload Manager, TOAD, Microsoft Word, PL/SQL

Oracle DBA

Confidential -Dallas, TX

Responsibilities:

• Responsible for logical and physical databases design, implementation, and maintenance
• Administering database user accounts. Creating, modifying and deactivating user accounts; Assigning and monitoring user access rights
• Troubleshoot the database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Managing schema objects
• Implemented Recovery Manager (RMAN). Implemented and maintained Database security providing database administration on testing and development database servers.
• Administering data pump IMPDP and EXPDP
• Rebuilding / monitoring the indexes at regular intervals for better performance
• Monitoring the user sessions and take appropriate action to kill the inactive sessions
• Recovering the databases from backup in disasters.
• Running variousDB2utilities in Mainframe onDB28 andDB210.
• Experience on RMF to monitor CPU usage of entire mainframe on parallel sysplex environments
• Experience on VAM for DASD Management and SMS managedDB2objects
• Experience in Migration fromDB28 toDB210
• Implementing Point - In-Time Recovery solutions.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification
• Applying quarterly CPU patches to different version of databases.
• Perform upgrade with other DBA's when necessary

Oracle PL/SQL Developer

Confidential - Silver Spring, MD

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement document
• Created tables, synonyms, sequences, views, PL/SQL stored procedures, functions and triggers
• Improved performance of some query using explain plan.
• Created database links to retrieve data from multiple servers.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Involved in code reviews of other team members.
• Used CuteFTP for File transfer protocol to transfer file from local to remote site.
• Created shell scripts to monitor the processes.
• Used various Joins for data retrieval from multiple tables according to the requirement
• Used DBLINK to call various database objects in local environment.
• Used DML triggers to update the tables when any DML event occurs.
• Enforced database integrity using primary keys and foreign keys.
• Installation ofDB2instances on AIX.
• Defining procedures, triggers and resolving issues on performance, backup/recovery, data integrity, database availability and other requirements forDB2and IMS
• Implemented DB2fixpaks and did migrations, client installations and upgrades.
• Served as the DB2 DBAfor the development, installation, and support of all online applications including implementation of various Amex projects