SUMMARY:

• Over 7+ years of extensive experience as an Oracle Production Database Administrator on versions 12c/11g on different UNIX Platforms.
• Hardworking, result oriented good interpersonal and communication skills
• Experience in Installation and Configuration of Oracle 10g and 11g in UNIX (Linux, HP, AIX, and Solaris) and Windows environment.
• Experience in RAC and Adding instance to the existing multiple node cluster.
• Experience in regular Database Administration activities such as Upgrades, Migration, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation
• Experience in using 10g features Flash - Back Recovery, Data Pump, AWR, ASM, ASH, Grid Control
• Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices and 10g CRS.
• Experience with Golden Gate, Installed, configured and supported Unidirectional replication
• Strong physical and logical Data Guard skills.
• Upgrade databases from 10g to 11g R2 and from 11g to 12c
• Experience with new features of 11g R2 which includes SQL Access Advisor, SQL Performance Analyzer, SQL Plan Manager, Table compression enhancement, Active Data Guard, Query Result Caching, Invisible Indexes. etc
• Creation and management of Materialize View server for reporting purpose.
• Installing oracle server and client software, creating, upgrading, cloning and patching databases and applications in UNIX and Windows environments, maintaining standby databases and clone/refresh databases.
• Experience in migrating from SQL to Oracle, Replications, and Clustering.
• Experience with installing and maintaining Oracle Grid Control.
• Experience with Tuning Tools like Oracle Enterprise Managers (OEMs), SQL analyzer, top session, top SQL,
• Performance Tuning of test and production database, monitoring system. Tuning and diagnosing of database performance by query Optimization and trace facility Monitoring users, free spaces, table spaces and indexes.
• Installed and configured 10g RAC on LINUX platform with ASM disks for storage.
• Skilled in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Experienced in RAID, storage technologies and backup solutions
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux
• Skilled in using tools such as SQL Developer.
• Dealing with database security and auditing.
• Experience on Oracle Support processes for technical requests through Metalink.
• A self-motivated, responsible and team player with a set of strong technical skills.
• Creating and reviewing documentation for change management, implementation plan and proof of concept (POC).
• Supported the system 24x7. Ability to work beyond regular hours.
• Implemented hot backups and recovery procedures using RMAN.

TECHNICAL SKILLS:

• Performance Tuning
• Backups
• Recoveries
• Upgrades
• Project Management
• Organizational Communication
• 11g/12c Patching
• Application modeling
• Decision Analytics
• Data guard
• Team work
• RAC
• Oracle 11g/12c
• Toad
• SQL Developer
• Database Access Suite
• Spotlight
• Putty
• MobaxTerm

PROFESSIONAL EXPERIENCE:

Confidential, Celebration, FL

Oracle DBA

Environment: Oracle RAC, ASM, Linux, Solaris, Data Guard

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 10g and 11g clients/databases on Solaris and Linux.
• Complete Build of 4-node 10g RAC Cluster on RHEL 4 from scratch.
• Migrated 10g database to 11g R2 and 11gR2 to 12C
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases and applying patches whenever required.
• Developed 10 PL/SQL Packages from the scratch for monitoring purpose.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• Handled RAC Node hangs and node eviction issues.
• Configured and maintained uni-directional and bi-directional GoldenGate replication.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farm house.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Tuning high - resource queries introducing hints and creating indexes/parturitions, changing the query if necessary
• Configured and Maintenance of SQL Server databases
• Implemented 10g, 11g Physical Data Guard.
• Implemented Oracle high availability solution using oracle RAC, Physical Standby and GoldenGate.
• Importing data from flat files into database using SQL loader and External Tables
• Written shell scripts to automate the tasks
• Physical and Logical database design.
• Database sizing, Capacity Planning.
• Worked very closely with development team

Confidential, Atlanta, GA

Oracle DBA

Environment: Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Datapump, STATSPACK

Responsibilities:

• Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
• Maintaining databases from all the environments from all pre production to production which are on RAC and
• Experienced in ORACLE 11g installation, configuration, and upgrading.
• Experience with rolling upgrade to Oracle 11G RAC.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle
• 10g RAC on AIX and HACMP.
• Installation, Configuration, Upgrading, Migration and Maintenance.
• Configure, maintain and deploy the Data Guard and grid control.
• Installing and maintaining Oracle GRID CONTROL
• Configured Workload Management, JDBC, ASM, and RMAN for maximum performance.
• Troubleshoot OCFS2 install issues and working with Enterprise Manager.
• Design and implement Auditing and other security features for the existing Production systems.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Migration from Linux to Solaris and 32 bit to 64 bit.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Created users and grant privileges according to the requirements.
• Working knowledge on UNIX administration on AIX server.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.