SUMMARY:

• Over 7+ years of hands - on experience as an Oracle Database Administrator. Have complete life cycle (SDLC) knowledge and experience including Installation and configuration.
• I have worked on Oracle 11g, 10g versions involving database administration production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, database cloning, space management and security.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for the purpose of monitoring multiple databases and application servers.
• Highly experienced in using Oracle 10g features Flash-Back Recovery and Recycle Bin.
• Experience with Oracle 11g/10g in Installation, Administration, Monitoring, Database Backup and Recovery.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.
• Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
• Expert in RMAN backups including full, incremental and cumulative.
• Expert in NETAPP backups and storage
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Extensive knowledge on Cisco Networking technologies.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, MySQL 5.6

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

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, NX client, Winscp.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE:

Confidential, LA, CA

Oracle/MySQL DBA

• Install and configure new databases based on best practices
• Perform day to day database administration on existing databases including implementing patches and upgrades as needed
• Work with development team in optimizing SQLs.
• Participate as a member of the engineering teams for database-related tasks
• Develop, test, and implement the appropriate backup procedures
• Design, test and implement Oracle and Enterprise MySQL high availability solutions
• Maintain effective database performance monitoring procedures.
• Perform database tuning for optimal performance to meet Business SLAs
• Control and monitor user access to databases and maintain database security
• Allocate storage and develop plans for future storage requirements
• Maintain documentation of systems and standard operating policies and procedures
• Resolve development and QA database requests.
• Provide technical assistance and mentor junior members of the team
• Be available for rotating on-call

Environment: MySQL, 5.5.40, NDB- Cluster, 7.2.18, MySQL 5.6.30, NDB-Cluster, 7.3.7,-Oracle 11G RAC/11.2.0.3, REHEL 6, Sun Solaris.

Confidential, Fredrick, MD

Oracle Database Administrator

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer, Foglight.
• Monitoring rollback segment and temporary table space use.
• Performing housekeeping tasks like checking log and trace files.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Richmond, VA

Oracle Production Support Database Administrator

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 10g (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential, Bowie, MD

Oracle Production Support Databse Administrator

• Installed and configured ORACLE 10g on HP-UX and Windows NT.
• Performed Upgradation of databases from Oracle 8i to Oracle 10g.
• Planned and implemented physical backup (both hot and cold) & recovery procedures for the database using RMAN utility of Oracle 10g.
• Implemented coalescing when required by monitoring the database for fragmentation.
• Performing table space management, monitoring data files additions, extent growth, normalization, indexing as a part of day-to-day activities.
• Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.
• Implemented proactive monitoring using STATSPACK, SQL TRACE & TKPROF, EXPLAIN PLAN.
• Separated the indexes, data, rollback segments and redo log files on separate disks to minimize contention, Monitored the buffer cache hit ratio and the dictionary cache miss ratio. The DB BLOCK BUFFERS and SHARED POOL SIZE were increased, resulting in tremendous improvement in performance.
• Creating the users and assigning them the required privileges.
• Provided 24x7 on-call support as needed.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential, Reisterstown, MD

Unix Administrator

• Part of the team which was responsible for the overall management of the LAN/WAN.
• Installed, configured and administered network devices such as routers, switches and hubs and performed LAN/WAN routine maintenance and troubleshooting.
• Overall responsible to ensure reliable and consistent LAN/WAN network performance and Services.
• Implemented and administered Virtual Local Area Networks.
• Administered Remote Access Server and defined its network security policies and User accounts.
• Installed and administered NT servers for 100+ users.
• Backup and Recovery as per the defined backup Strategies.
• Installed security programs such as Public Key Infrastructure (PKI) into the military computer network using the Remote Installation System (RIS) programs.
• Designed desktop account security parameters on one workstation which served as template for all terminals.
• Monitoring of the system performance and corrective action for smooth functioning of system.
• Installation and configuration of Windows NT 4.0 and MS-Proxy Server.
• Hardware Maintenance

Environment: Windows 95 /98, Windows NT 4.0, MS-Proxy Server, FTP Server Print Server, MS-Exchange Server 5.5'CISCO Router 1700 Series and 3COM - Switches.