SUMMARY

• Demonstrated excellent professionalism over 5+ years of cross - platform experience in oracle Database and System Administration experienced in Windows and Linux/Unix environments.
• Extensive knowledge of the Oracle database gained over years of experience in installation, configuration, maintenance, security, backup and recovery, troubleshooting, performance tuning of Oracle RDBMS in Linux/Unix, Window and Solaris environments.
• Proficient in Oracle 9i, 10g, 11g, 12c database Administration.
• Proficient in Oracle Enterprise manager Database control.
• Proficient in RMAN backup and recovery policy and procedure.
• Proficient in Database Migration, Upgrade and Patch Application.
• Proficient in Real Application Cluster Database and Data-guard Administration.
• Proficient in setting up and installation of Oracle, ASM, Cluster in large multi nodes.
• Strong in solving problems of diverse scope where technical analysis and evaluation is required.
• Results-driven IT personnel with skills in team building and problem-solving with an established reputation for effectively working with diverse groups of people and adaptability to changing environments.
• Ability to participate in off-hours on-call rotation and provide 24/7 supports.

TECHNICAL SKILLS

Platforms: Windows XP/7/8, Linux, UNIX, Solaris, Mac- OS.

Database: Oracle 9i, 10g, 11g, 12c, Enterprise Manager, RMAN, SQL*Plus, Mysql DB, Microsoft Access DB, RAC, Data-guard, Oracle PL/SQL, Performance tuning (AWR, ADDM), Oracle Security/Access Control, Data-pump.

Languages: Window Power shell Script, SQL and Java.

Tool: Symantec Virus Protection.

Programming: Visual Basic, C and C++.

Storage: ASM, NAS and SAN.

PROFESSIONAL EXPERIENCE

Confidential, Huntsville TX

Oracle DBA

Responsibilities:

• Install Oracle Clusterware as part of oracle’s Grid Infrastructure 11gr2.
• Install and configuring oracle 11gr2 software on the server for both non RAC and RAC environment.
• Working with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System.
• Monitoring and tuning database performance.
• Create synchronized standby databases using Oracle Data Guard.
• Create and manage the tables and others objects used to manage the application data.
• Reliably archive and restore data with Oracle Recovery Manager.
• Implement and utilize backup and recovery used RMAN utility.
• Configuring and maintaining RMAN repository catalogs for backup and recovery.
• Implementing and maintaining database security (create users, roles, assign privileges).
• Extensively used Data-pump utility for logical backup & migration.
• Populating database tables with sql loader utility.
• Use Oracle Flashback to identify and undo user errors.
• Troubleshooting and resolving various database problems.
• Build test clusters and hosts using Oracle Linux OS.
• Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment.
• Used AWR, ADDM and various EM tools (Oracle Advisors) to tuning database.
• Manage cluster resources with CRSCTL and grid control utility.
• Manage cluster database with SRVCTL and grid control tools in RAC environment.

Confidential - Laurel MD

Oracle DBA

Responsibilities:

• Planned, Installed, Configured, managed and troubleshoot of Oracle 10g and 11g databases on Linux and Windows OS.
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
• Installed and managed Oracle Enterprise Manager. installed and configured relevant network components to ensure database access as well as database consistency and integrity
• Troubleshoot and resolve various Oracle connectivity problems.
• Provided network troubleshoot and administrative support for the development staff.
• Installation and management of Oracle database using database control
• Created and managed documentation on the configuration and support of the Oracle databases
• Performed bulk load into the database using SQL Loader
• Performed standard and fine grain database auditing.
• Documented database structure, changes, problems, issues for future reference
• Administered database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights.
• Provided database administration on production, testing and development database servers.
• Regular Monitored Alert log Files and trace files on Day to Day Basis.
• Identified and removed Fragmentation, row migration/chaining of database objects.
• Analyzed the Tables and Indexes on performance base regularly
• Monitored Table spaces and Data files utilization.
• Managed Undo Table spaces, Redo Logs, Control files and Archive logs.
• Implemented multiplexing control files and redo log files
• Configured various RMAN parameters as per the requirement.
• Performed physical backups using RMAN utility.
• Performed Complete Media Recovery of Database depends on the nature of failure.
• Configured and implemented the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases
• Extensively used DATAPUMP and Export /Import utilities for logical backups.
• Performed database cloned using RMAN.
• Monitored the user sessions and take appropriate action to kill the inactive sessions
• Created and rebuild indexes as necessary.
• Performed various performance goal oriented database tuning.
• Tuned various slow running query
• Performed instance tuning, memory tuning query tuning and complete database tuning.
• Created and implemented various table partitions for large tables
• Resolved various complex issues with the database.
• Applied quarterly CPU patches to different version of databases.
• Upgrade Oracle 10g database to 11g.
• Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
• Installed, configured and managed 11gR2 (RAC) on ASM storage
• Manage RAC databases using CRSCTL, SRVCTL and grid control
• Configured and setup Oracle 11gR2 Data Guard.
• Managed Data Guard using Data Guard broker.
• Troubleshoot and resolved log gap in Data Guard Configuration.

Confidential, Baltimore MD

Oracle DBA

Responsibilities:

• Performed Installation, configuration of oracle 10g, 11g.
• Performed creation of databases used DBCA and script.
• Managed and maintained oracle databases running on Window and Linux Operating System.
• Installed Red Hat Enterprise Linux (ISO) 5.5 Operating System on Servers.
• Implemented operating system and RMAN backup and recovery policy and procedure.
• Configured Oracle network used NETCA and NETMGR utilities.
• Worked independently and collaboratively with DEV. teams to resolve complex Oracle issues.
• Managed system issues, performance tuning, backup/recovery and replication issues.
• Configured and maintained RMAN repository catalogs for backup and recovery.
• Automated RMAN full and incremental backups through Shell scripting.