PROFESSIONAL SUMMARY:

• About 8 years of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD
• Monitoring VLDB (Very Large Databases) using Grid Control
• Wrote several Purging shell scripts on Linux which have been used as standard scripts at the workplace
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean - up, data archiving, etc
• Developed RMAN scripts for database back up and recovery including- hot and cold backup
• 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
• Installed Oracle 11g with ASM and OCFS2 File systems.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Team player with excellent interpersonal, analytical and communications skills
• Wrote scripts to notify the DBAs on the status, performance and space management of databases
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Performed backup & recovery of large databases and provided 24X7 production support to highly critical databases
• Provided root cause analysis and permanent fix of production problems
• Installation, administration and maintenance of Oracle 11g
• Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to 11g) and patching
• Involved in performance tuning and database reorganizations.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space. Performed SAN analysis and provided recommendations
• Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life-Cycle (SILC).
• Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical and BLOB data
• Monitored and managed various database components (logical & physical) like tablespaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x, AIX, Unix Solaris and Windows 2008

RDBMS: Oracle Database 10g/11g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control 12c, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

DBA

Responsibilities:

• Assist with the planning and coordination of OS and Database Software Upgrades and Patching
• Manage and support the deployment of objects builds into different environments as well as production environments through Release deployments and other database related projects.
• Tune and resolve database performance problems including lock contention and SQL performance issues using AWR, ADDM and statspack Reports for the troubleshooting of performance issues
• Troubleshoot and develop scripts for re-organization of database objects, index rebuilds, partition maintenance and creation.
• Effectively manage and monitor all aspects of Oracle environments (development, test, and production)
• Assist in creation of SQL/PLSQL scripts and other required database stored procedures, functions and automated jobs, Shell Scripting
• Monitor and manage space issues in tablespaces and database growth projection.
• Monitor alerts, failures and other incidents from scheduled jobs.
• Perform OS and Database Shakeouts after changes, configurations, installations, upgrades.
• Manage / support data migration activities.
• Perform schema, tables refreshes from Production to other lower environments using Datapump, traditional Export and Import utilities
• Support requests for other database platforms; Sybase, MS SQL Server in Lower environments such as refreshes, data modifications.
• Actively and successfully participated in the Flyway Adoption development project

Environment: Oracle 11g/12c, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus, RMAN, SQL, PL/SQL, Unix/Linux Operating Systems

Confidential, Plano, TX.

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• 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.
• Experienced in the configuration of ASM for RAC and NON- RAC environments.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.
• Experienced in Data Center migration of databases to prepare the proof of concept, DB migration procedures and scripts, developed templates that include check list for migrating the databases.
• Performed Database upgrades, migrations; take logical exports from the QA, DEV etc instances and importing the data on to the production systems etc.
• Establish Backup policy using RMAN and VNB (Veritas Net Backup). Also managed Backup, Restore using Data Pump, Traditional Export and Import Utilities.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Used AWR, ADDM and statspack Reports for troubleshooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• Used Datapump export/ import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance
• Expert in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• 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.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Confidential

Oracle DBA

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Installed and configured block change tracking to work with RMAN Merged incremental backups.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• 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, free space, used space, fragmentation etc.
• 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.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Provided 24X7 supports for all the production and development databases.

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, North Canton, OH

Junior Oracle DBA

Responsibilities:

• Managed in-house Oracle Databases running on various operating systems like Windows 2003 and Linux.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Using Enterprise Backup utilities for backup.
• Writing scripts for backup and recovery.
• System tuning for better performance.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Designing and enforcing standards and naming conventions.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing UNIX shell scripts for backup and recovery.
• Supervised the installation and configuration of Oracle databases on Linux and Windows 2003
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading to the payroll system.
• Problem trouble shooting and resolution.
• Database installation and instance creation.
• Database tuning, backup and recovery and general day to day running of the system.
• Systems analysis and design.
• Creating project plans and implementation schedules.

Environment: Oracle 11g, Oracle 10g, Sybase, MS SQL Server, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.