SUMMARY

• A highly dependable Oracle Certified professional with more than 8 years of IT experience as an Oracle Database Administrator in heterogeneous environments including Sun Solaris, Linux, HP - UX, AIX, UNIX and Windows.
• Extensive experience with Oracle database administration activities including Designing, Installation, Migration, backup & disaster recovery of databases, Tuning and Troubleshooting of database issues
• Experience with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration and system testing, performance tuning
• Hands on experience with Oracle utilities including Oracle Data pump
• Writing UNIX Shell Programming.
• Experience writing functions, triggers, stored procedures and PL/SQL packages to provide database access and manipulation functionality
• Experience with implementing database security features like auditing, profiles, users security, roles and privileges.
• Experience with Oracle 11g Active Cloning using RMAN.
• Worked with profile setup and maintaining the concurrent programs using Oracle Apps E-Business Suite tool.
• Experience in managing RAC clustered databases on ASM.
• Expertise in creating (Manual & DBCA) the databases and configuring them to get the best throughput
• Experience with table and index partitioning using various methods.
• Experience with tablespace and space management.
• Solid experience with routine maintenance of Oracle databases including gathering stats and Monitoring the databases using OEM
• Solid experience with Oracle Backup utility Recovery Manager(RMAN)
• Experienced in upgrading databases and applying patches.
• Experience with loading bulk data with SQL*Loader.
• Experience working with schema, table and database refreshes.
• Experienced with latest Oracle 10g features including Flashback and ASM
• Data Analysis to support Management Decision Making and Planning
• Creative problem solving skills in both strategic and tactical areas

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/ 2005, MS Access

Oracle Tools: SQL*PLUS, SQL*Loader, Export/Import, Datapump, Oracle Enterprise Manager, TKPROF, Log Miner, and RMAN

Technologies: EXPLAIN PLAN, Data Guard, Grid Control, Data Streams, Flashback and AWR / STATSPACK

Languages: SQL, PL/SQL, C, C++, J2EE, VB.Net, Shell Scripting

OS: HP-UX, AIX, Linux, UNIX, DOS, and Windows

Web Technologies: HTML, XHTML, XML, CSS, Dream Weaver, Photoshop, HTML.

Other Tools: MS Office, Shareplex, Toad, Erwin data modeler and Visual studio

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Oracle DBA

Responsibilities:

• 24*7 On-Call production support and monitor of critical banking and insurance applications.
• Schema refresh from production to the non-production environments using Oracle datapump
• Table refresh from production to the non-production environments using Oracle datapump
• Cloning of production database using Oracle Active Cloning 11g.
• Converting non-partitioned tables to the partitioned tables in Oracle 11G.
• Created New Users, Profiles and managed Roles and Privileges.
• Planned and Implemented appropriate backup and recovery strategies for the database.
• Recruited, Interviewed, hired, trained and managed the team to successful completion of project goals and objectives.
• Exporting and importing of very large sized databases.
• Resolving the tablespace issues when reaches the threshold.
• Resolving the issue when the filesystem is getting full.
• Experience with pl/sql functions, stored procedures, packages, triggers, synonyms and sequences.
• Installed, configured, maintained Oracle Database Software 11g/10g on Sun Solaris, AIX and linux platforms.
• Using OEM Grid control, AWR and ADDM for performance monitoring.
• Adding / deleting / truncating partitions. Backing up partitions.
• Upgraded and migrated databases from Oracle 10g (Sun Solaris) to Oracle 11g (AIX).
• As a production Support DBA troubleshooted and resolved several types of production issues during the off hours and over the weekends.
• Periodic Database CLONING from production to Development and QA environments
• Creating, Maintaining and Supporting Physical standby databases.
• Handling issues related to Database Upgrade/Migrate and Patching.
• Adding and dropping partitions.
• Resolving issues with the gap between the primary and the standby dataguard.
• Creating shell scripts, SQL scripts for task automation.
• Converting a single instance to a RAC node in Oracle 11g.
• Worked with RMAN Backup, Restore and Recovery.
• Analyzing, consolidating and tuning database for optimal efficiency.
• Implemented Database Security Features.

Environment: Oracle 11g/10g, Solaris, AIX, Linux, SQL-PL/SQL, Shell Scripts

Confidential, Warren, NJ

Oracle DBA

Responsibilities:

• Performed On-Call Production Support (24X7).
• Installed, configured, maintained Oracle Database Software 9i/10g on SUN Solaris Sparc, IBM-AIX, HP-UX.
• Installed, configured, maintained Oracle Database Software 11g on Linux.
• Creating new databases in various environments.
• Experience with tablespace management.
• Taking backups and performing recoveries.
• Involved in installing and setting up the Grid Control and Intelligent Agents
• Installation of Oracle 11g databases.
• Involved in setting up disaster recovery sites using Data Guard technology
• Resolving performance issues using Oracle utilities including EXPLAIN PLAN, TKPROF, SQL Trace and AWR
• Experience with upgrading from 10g to 11g databases.
• Setting up alerts in OEM.
• Creating dblinks and symbollic links.
• Working with Development in resolving Bugs with Oracle 9i/10g/11g.
• Used block corruption methods in order to check for the validity of the blocks.
• Recovered the table using flashback feature.
• Perform Space Management & Troubleshooting the database issues.
• Creating Oracle materialized views.
• Worked on PL/SQL stored procedures, functions, packages and triggers.
• Upgraded databases from 10g to 11g, 9i to 10g
• Worked with RMAN Backup, Restore and Recovery.
• Monitoring of more than 100 Oracle Databases through OEM Grid control.
• Creating documentation and uploading them in sharepoint.
• Re-organizing indexes.
• Created materialized views for better performance.
• Monitoring the databases through OEM.
• Applied CPU patches.
• Installed 4 node RAC and managed the RAC clustered databases on ASM storage device.
• Used Shell Scripts to automate database operation and schedule batch jobs using CRONTAB

Environment: Oracle 11g/10g/9i, Linux, Windows, SQL Server, Toad, OEM

Confidential, Palo Alto, CA

Oracle DBA

Responsibilities:

• 24*7 on call production support.
• Installation, Configuration, Designing and Maintaining of Oracle 10g on AIX 5.3
• Ministering the databases in both Production and Development environments
• Providing roles and responsibilities to various users, developers and business analysts.
• Implementing range, list partitions, hash partitions.
• Performing export/ import of different database Objects/Schemas using Oracle Datapump utility
• Performed Blockout using OEM.
• Created and maintained different database structures including tablespaces, data files, redo log files, rollback segments and renaming/relocating of datafiles on different servers
• Database upgrade from 9i to 10g.
• Applied security patches from metalink.
• Setup backup and recovery procedures using RMAN.
• Experience with Microsoft SQL Server 2005.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Upgraded Oracle databases from 9i to 10g.
• Experience working with E-Business Suite.
• Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Creating and refreshing materialized views.
• Configuring and troubleshooting RMAN backup & recovery issues.
• Implemented the Oracle Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
• Set up profiles, starting and stopping concurrent managers and programs.
• Configuring and troubleshooting RMAN backup & recovery issues.
• Implementing single and composite partitions.
• Extensively used Oracle utilities -Export, Import, data pump and Sql loader.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, Explain Plan and optimizer hints.
• Performing the OS level tuning and SQL tuning.
• Created and maintained bigfile tablespaces.
• Responsible for fixing human/application errors using flashback technology.
• Applied patches using Opatch.

Environment: Oracle 9i/10g/11g, Linux and Toad

Confidential, Pittsburg, PA

Oracle DBA

Responsibilities:

• Provided 24X7 support for production problems
• Performing the daily checking routines by monitoring the Alert log, trace files of the database.
• Creating tablespaces, tables, views, scripts for automatic operations of the database activities.
• Taking hot/cold backups
• Creating users and assigned required permissions through roles
• Installed 9i, 10g applied patches in various environments and upgraded databases from 9i to 10g.
• Used Toad to run SQL and PL/SQL code to manipulate the databases in all environments
• Used gzip and gunzip to compress and uncompress very large files.
• Installing and maintaining Oracle database according to security baseline.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Designed logical databases and implemented physical databases.
• Analyzed tables and re-builded indexes regularly.
• Developed/customized UNIX shell scripts to automate routine DBA tasks.
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
• Audited database for statements, privileges, and schema objects.
• Truncating audited tables frequently.
• Monitoring of data guard in the production environment
• Debugging the bugs in SQL using toad and troubleshooting end users problems.
• Monitoring the auditing tables.
• Monitoring RMAN jobs and events by using OEM.
• Creating users and Creating Roles, and assigning roles, privileges and profiles to users.
• Monitoring the Tablespace Usage and Indexes usage regularly.
• Export and Import of schemas using conventional export/import.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Performed DBA Maintenance tasks in the form of adding datafiles to tablespaces, resizing the datafiles, increasing the size of redo log files and reorganising the data.
• Used unix level powerful commands such as top, sar, vmstat, iostat.
• Utilized SQL*loader and data pump import to load data into tables.
• Executed shell script files in the background by using nohup command.
• Maintained UAT/PERF/TEST and PROD environments.
• Experience using vi commands.
• Used CRONTAB to automate database operations and schedule batch jobs.

Environment: Shell Scripting, OEM, HP-UX, Oracle 9i

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Assigning roles and responsibilities to the developers, testers and business analysts.
• Storage and space management including tablespaces and datafiles.
• Executing sql, pl/sql and shell scripts as per the user's requests.
• Storage management, sizing the database objects, monitoring Disk usage.
• Monitoring the Tablespace Usage and Indexes usage regularly.
• Creating users and Creating Roles, and assigning roles, privileges and profiles to users.
• Monitoring the alert logs and trace files regularly.
• Creating Indexes and Monitoring Performance
• Used EXPORT/IMPORT to do table level and full database defragmentation
• Coding PL/SQL, SQL and Unix Scripts
• Perform Daily Logical backups using exp
• Trained a new DBA in our environment
• Writing Oracle Procedures and functions
• Installed and implemented the Oracle Database creation
• Take care of the Database design and implementation
• Implemented physical and logical database design.
• Assisted code writing in development using PL/SQL Block, Procedures, Functions Database Triggers and Packages
• Setup and maintain documentation and standards
• Moved database Schema changes to stage or production
• Created database objects like tables, views, indexes, partitions, Materialized Views.
• Automated jobs using cronjob in Shell Script.
• Monitoring Database and Tablespaces Growth and Monitoring Space Availability at Operating System
• Data warehouse Analysis, Design, Document Fact, Dimensional tables and growth requirements.
• Developed complex packages, stored procedures and functions to implement business logic
• Deploying packages to various environments with the help of kintana software.
• Troubleshooting and resolving the bottlenecks and helping the developers.
• Performing backups and recoveries using conventional hot backups.
• Took initiative to prepare the document that listed the Pre-Upgrade, Upgrade and Post upgrade task required.
• Data Load using Golden Gate Replication.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Frequent Check of any errors in Alert log
• Loading the data from flat files to the oracle databases using sql*loader tool
• Creating documentation and uploading in the sharepoint

Environment: Oracle 10i/11i, Linux, Toad, and kintana

Confidential, Chennai, TN

Oracle DBA

Responsibilities:

• Installing and configuring Oracle 9i on UNIX and Solaris.
• Storage and space management including table spaces and data files.
• Monitoring Database for fragmentation and correcting them.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Involved in writing Queries, Stored Procedures, functions and triggers to implement the business requirements.
• Involved in Loading data (flat files) into the database tables using SQL*Loader.
• Used Oracle conventional Import and Export utilities for migrating data to different environments.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform
• Experience with dbms packages.
• Dealt with stats, range commands in Golden Gate.
• Preparing Backup and Recovery Plan.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a Development cycle
• Analyze and suggest improvements to SQL queries and statements written by others.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Performing Monthly Cold Backup, Weekly Hot Backup and daily backups using Export.
• Tuning the databases for optimal performance.
• Planning and implementation of Backup and recovery procedures and maintenance of Database.
• Management of table space growth, monitoring data files additions, extent growth
• Partitioning Tables by determining the suitable methodology to improve performance and manageability
• Creating and dropping of users, granting and revoking rights as and when required.
• Diagnose and troubleshoot database problems and failures
• Constantly monitor the performance using dynamic performance views of databases.
• Worked as DBA trainee to assist developers team in execution of basic DBA tasks.
• Developed and modified PL/SQL packages, stored procedures, functions, cursors, triggers as per the customer requirements
• Partitioned large tables to increase the performance
• Designed backup and recovery procedures for OLTP system
• Used TOAD tool to access the databases
• Involved in user creation and user access control, Schema creation and management
• Created indexes, rebuild indexes and maintained indexes
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Created PL/SQL packages, procedures, cursors & exception handling.
• Creating and dropping of users, granting and revoking rights as and when required.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.

Environment: Oracle 8i/9i, Linux 7.2, Windows 2000 server