SUMMARY:

• Around 8 years of experience as an Oracle Database Administrator.
• Excellent experience in 24x7 production database administration, support, installation, configuration, upgrades,database migrations, patches, performance tuning, backup and recovery, cloning, space management, database security & auditing.
• Experience in OLTP/DSS database systems, managing large Oracle databases.
• Proven experience with database performance and tuning techniques to enhance database optimization plans.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK, AWR, ADDM
• Experience with Oracle 11g RAC/10gRAC/9i/8i in Installation, Administration, Monitoring, Database Backup and Recovery.
• Knowledge of SQL analysis tools and database internal debuggers including ORADEBUG.
• Proficient with Database Cloning, Migration, Standby Database (Data Guard)
• Experience in Oracle Cluster Ware environment.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Have implemented ORACLE STREAMS and GoldenGate
• Extensive Experience with RMAN Backups, Cold Backups, Hot Backups and Logical Backups.
• Experience in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experienced in using RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience on working with Oracle E-business suite environment.
• Experience in Data Migrations.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX/LINUX/Windows platforms includes HP, SOLARIS, AIX, and LINUX.
• Implemented various database solutions such as 11g RAC, 10g RAC, 9i, Data Guard, Oracle Grid, Oracle Streams, GoldenGate.
• Experience in UNIX shell scripting, CRON jobs.
• SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
• Possesses strong analytical and problem solving skills coupled with very good communication and interpersonal skills.
• Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading)
• Excellent experience in Oracle Support processes for technical requests through Metalink.
• Dealing with database security and auditing.
• Experience in SOX Controls, compliance reporting and audit validation.

TECHNICAL SKILLS

Operating Systems

HP-UX 10.x, 11.x, VMS, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,6.1  Red Hat Linux RHEL 3.x, 4.x,5.x and Windows 95/98/ME/NT/2000/XP.

RDBMS

Oracle 11g RAC, 10g RAC/9i/8i , SQL Server 2000/2005/2008, MySQL

Languages

SQL, PL/SQL, Delphi, VC++, UNIX Shell Scripting, Perl

Tools/Utilities

RMAN, OEM, SQL*Loader, ASM, EXP, IMP, DataPump(expdp, impdp), TOAD, Golden Gate

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling

Erwin 4.0, Rational rose, Toad Data Modeller, ER/studio

Other

EMC, NetApp, Veritas NetBackup, TSM, HP Data Protector

WORK EXPERIENCE

Client: Confidential, NY
Duration: Apr 2009 to till date
Role: Senior Oracle DBA
Environment: Oracle 11g RAC/10g RAC/9i ,Sun Solaris ,Red Hat Linux, HP-UX, OEM Grid Control, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, AWR, ADDM,SQL* Loader.

Responsibilities:

• 24x7 production database administration and applications support
• Installed Oracle 11g RAC, 10g RAC databases.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Installed CRS in the environment during the implementation of RAC.
• Configured ASM (Automatic Storage Management) which includes creating disks, diskgroups for the RAC environment.
• Using the tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Configured, implemented, 10 RAC/11g RAC
• Worked on designing, installing & maintainingCRS, RAC and Dataguardcomponents of Oracle.
• Writing SHELL SCRIPTS for the system and database for effective functionality, report generation, backup and cloning.
• Upgradation and Migration of Databases and applying patches whenever required.
• Maintaining schemas and partitioning tables.
• Oracle Data warehouse database administration and management of VLDB environments, Oracle OLTP.
• Experienced with all kinds(Status, Performance, Trend Analysis) of DB MONITORING
• Provided ERD diagrams using the ERWIN tool and developed physical and logical models of the databases.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Developing SHELL SCRIPTS to automate the processes.
• Played major role in the migration from Microsoft SQL Server to Oracle 10g.
• Experienced with SRVCTL.
• Implemented and developed compliance reports and audit reports.
• Performed RMAN backup and recoveries.
• Creating tablespaces, tables, and users for custom applications.
• Working experience with DATAWARE HOUSING tools like ETL, INFORMATICA.
• Knowledge of working on Oracle E-business Suite environment.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with SPACE MANAGEMENT and SECURITY.
• RMAN point in time recovery and Instance recovery done on 11g/10g databases.
• Working with QA team in unit testing.
• Implemented Oracle Streams for the replication of data.
• Used all types of Normalization techniques for the normalization of data.
• Thorough knowledge in setting up infrastructure for databases in huge data centers.
• Developed numerous PL/SQL Procedures, Packages, Functions and Triggers for various requirements.
• Implemented oracle high availability solution using oracle PHYSICAL STANDBY.
• Importing data from flat files into database using SQL loader and External Tables.

Client: Confidential, TX 
Duration: Jan 2008 – Apr 2009
Role: Senior DBA
Environment: Oracle 11g RAC/10g RAC/9i/8i, AIX, Sun Solaris, Windows NT / 2000, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, OEM.

Responsibilities:

• 24x7 production database administration and applications support
• Supporting multiple databases for production, development, test and staging purposes
• Applying upgrade patch, maintenance and interim (opatch etc) patches on all the databases.
• Refreshing Dev and test instances with data from Production on a regular basis.
• Installation of Oracle 11g/10g RAC and Standby Database for High Availability and Disaster Recovery purpose.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Provided performance tuning of Oracle Databases.
• RMAN point in time recovery and Instance recovery done.
• Developed compliance reports and performed auditing at higher levels.
• Worked on the migration of SQL Server databases to Oracle databases.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 9i to 10g, 9i, 10g to 11g. and applying patches whenever required.
• Monitoring and optimizing the performance of the database/application
• Capacity planning: Allocate system storage and plan future storage requirements.
• Creating OEM alerts that provides notifications.
• Performing housekeeping tasks like checking log and trace files.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Worked on Data modeling
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes.
• Developed Physical and Logical Models of databases and ERD diagrams using ERWIN.
• Experienced in working with the ORACLE STREAMS for the replication of data.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Implemented Normalization techniques for the normalization of data.
• Maintaining the data warehouse databases.
• Experience in writing UNIX SHELL scripts.

Client:Confidential, Phoenix, AZ 
Role:Senior Database Administrator 
Duration: Aug 2006 – Dec 2007
Environment: Oracle 10g RAC/9i/8i,Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows NT/2000.
Responsibilities:

• Involved in administration of over 150 Oracle instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Involved in the process of tuning and refining queries of various applications.
• Installed Oracle 9i Data guard.
• Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary table spaces.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Performing hot and cold backups.
• Restoration and recovery from backup.
• Conducting sizing and capacity planning for oracle databases.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
• SQL issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups, restoration and cloning.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Client: Confidential, Poughkeepsie , NY 
ROLE: Database Administrator 
DURATION: May 2005- July 2006
ENVIRONMENT: Oracle 10g /9i/8i, Red Hat Linux, HP-UX, AIX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows NT/2000.

Responsibilities:

• Provided 24X7 supports for production problems.
• Installed Oracle 10g, applied patches in various environments and upgraded databases from 9i to 10g.
• Performed day-to-day DBA tasks.
• Logical & Physical database design and implementation
• Experience in OLTP/DSS database systems, managing large Oracle databases.
• Set up, configured and maintained Oracle data guard(physical/logical standby databases) to ensure disaster recovery,high availability and data protection.
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, explain plan optimizer hints and SQL tuning advisor.
• Created and implemented Oracle database backup and recovery strategies
• Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and lost of control files
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Analyzed tables and re-build indexes regularly.
• Created procedures, functions, packages, and triggers using PL/SQL.
• Developed ERD diagrams along with physical and Logical models with ERWIN tool.
• Hands on experience with the normalization of data through normalization techniques.
• Experienced in ETL (Extraction, transform, Load).
• Utilized SQL*loader and data pump import to load data into tables.
• Audited database for statements, privileges, and schema objects.
• Developed/customized UNIX shell scripts to automate routine DBA tasks.

Client:Confidential. 
Role:Database Administrator 
Duration: Jan 2004 - Mar 2005
Environment:Oracle 10g/9i/8i/7.3, RMAN, Sun Solaris, AIX, Windows, RedHat Linux
Responsibilities:

• Managed in-house Oracle Databases running on Windows to Linux.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• 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.
• Writing technical manuals.
• 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.
• 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.