SUMMARY:

• Experienced Oracle DBA with 6 years of experience in Oracle Database Administration in large - scale production environments across multiple platforms.
• Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) 10g/11g,12C and Data Guard.
• Ability to work both as an individual contributor and as a member of a team.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
• Experience in configuring Data Guard. Implemented Physical Standby in latest project.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Monitoring and Optimizing the Database Performances through Database Tuning, System Tuning, Application/SQL Tuning.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups (with Export/Import utilities).
• Expertise in UNIX shell Scripting (Bash).
• Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Experience in working with Large Tables and VLDBs.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Hands on experience working on High Availability Environments.
• Working experience on VMWARE.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone database to RAC environment.
• Experience in configuration and maintaining Oracle Physical Standby Database using Oracle Data Guard 10g and 11g.
• Knowledge in configuring ASM (Automatic Storage Management) for both the standalone database and RAC database environments.
• Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN
• I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using DBUA.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Extensive work experience in a database migration project team, serving in both an advisory and technical capacity.
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Linux, Unix shell scripting, C, C++

RDBMS: Oracle 9i, 10g, 11g, 11g2, 12C

Tools: Oracle Grid control, Oracle Enterprise Manager(OEM), TOAD, PUTTY, SQL Plus, SQL Developer, SQL Access Advisor, SQL Tuning Advisor

Utilities: SQL Loader, Export / Import, Expdp /Impdp, AWR, RMAN, STATSPACK

Operating Systems: RHEL 4/5,6, Sun Solaris 5.8, 5.9, Windows 98/NT/2000/2003/XP/7, AIX

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, Telnet

Office Packages: Word, Excel, Power point, Access

Web Tools: HTML, XML

Database Modeling: ERWIN

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12C

Responsibilities:

• Utilizing command line to create and manage database users and objects on a daily basis.
• Provide operational support to developers and application support teams
• Monitor user sessions, killing inactive session when necessary
• Implemented ASM on RAC and stand-alone databases.
• Managing disks and disk groups with ASM.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Test backups periodically to ensure minimal recoverability time to meet business objectives.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using O patch utility.
• Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.
• Experienced in Design, implementation and generating documentation of Oracle 10g and 11gData Guard on both physical/logical standby databases in high availability mode.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.6) and Oracle 11g (11.1.0.6) to Oracle 11g (11.2.0.3) on Red hat Linux 6, IBM-AIX.
• I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using DBUA.
• Writing and modifying UNIX Shell Scripts to manage Oracle environments for Backend Processes.
• Developed SQL*PLUS & PL/SQL scripts for extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
• Database Refreshing / Replication from production to testing using Exp /Imp.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM)

Confidential

Oracle Database Administrator

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing Tablespaces growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Implemented the resizing the online redo logs in production and in standby database.
• Configured RMAN and performed daily backups.
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, Tablespaces, Control files, log files and user profiles.
• Installed, Configured and Administered Oracle Streams.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs in the database.
• Analyze the schema and tables.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 10g versions to 11g.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Responsible for all database activities such as User management, space management, database security management.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and Creating & Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

Confidential - Virginia Beach

Jr. Oracle Database Administrator

Environment: RHEL 3.X, 4.X; Windows NT 2000/2003; Oracle 10g; VMware.

Responsibilities:

• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation,
• Designed database tables as per technical specifications.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Scheduled and performed various modes of backups using RMAN
• Monitored and proactively tuned Oracle databases via the OEM grid control (11)
• Automated hourly, daily, weekly system health reporting using Crontab, and OEM cloud control
• Performed Hot Backups, Cold Backups, as well as incremental backups using Recovery Manager (RMAN)
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Performed day to day activities such as, daily error checks and database health monitoring of physical resources (disk space, memory, CPU, etc.).
• Performance parameters adjusted as needed.
• Produced backup report to ensure the backups were all successful and troubleshoot if the backup was not successful to find out the root cause.