SUMMARY:

An Oracle DBA with 8 plus years of experience in oracle (8i, 9i, 10g RAC, 11g RAC), data guard, installation, configuration, migration, designing, backup, recovery, scripting, performance tuning etc, spanning various industries like insurance, banking, wireless, financial etc. in variety of environments like UNIX (Solaris, HP-UX, AIX), LINUX, WINDOWS NT 4.0/2000/2003 in production as well as development databases.

• Experience in oracle 8i/9i/10g RAC/11g RAC, installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting, database design, UNIX shell scripting and documentation.
• Expert in installation, maintenance and tuning of Oracle 10g/11g RAC and Physical/Logical standby database for high availability and disaster recovery/reporting purpose.
• Performed upgrades from Oracle 8i to 9i, 9i to 10g, 9i,10g to 11g.
• Expert in implementing ORACLE STREAMS, GOLDENGATE and logical standby and physical standby databases.
• Expert in implementing development, testing, staging, production, RAC and standby databases for OLTP, Data Warehousing.
• Comprehensively analyzed business function using ERP and performed changes for the better utilization of resources.
• Worked on very large databases of size multiple TB.
• Proficient knowledge in hot/cold backups, RMAN backups (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery.
• Excellent knowledge in SQL, PL/SQL Programming, Partitioning, and Data Modeling, logical and Physical Database design, procedures, Functions, Packages, Database triggers.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL Net, Data modeling, Logical and Physical databases design using tools like Erwin.
• Excellent knowledge in Cloning of databases.
• Implemented OEM/Grid Control.
• Oracle database capacity planning, space management, storage allocation
• Expert in SQL*Loader, export/import and data pump import to load data into tables.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache and redo mechanisms.
• Experience is partitioning large tables. Capacity planning and bench marking.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers.
• Expertise in SQL tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Expertise as On-Call 24x7 production DBA and application/development DBA and oracle support processes for technical requests through Meta link and other support Procedures.
• UNIX shell scripts for hot backups, cloning, monitoring, SQL*Loader, export and import of database.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.
• Oracle Certified Professional (10g).

Education:Bachelor’s of Science in Computers

Technical Skills:

Operating Systems

HP_UX 10.x, 11.x, Sun Solaris 8, 9, 10 AIX 5.1, 5.2,5.3, Red Hat Linux RHEL 4.x, 5.x and Windows 95/98/NT/2000/XP

Languages

SQL, PL/SQL, C, C++, Java, J2EE, UNIX Shell Scripting.

RDBMS

Oracle 11g RAC/10g RAC/9i/8i/7.3

Tools/Utilities

RMAN, OEM, Sql Navigator, OEM, Grid Control, SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup, MS Access, GoldenGate

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling

Erwin 4.1.2, rational rose, Visio

PROFESSIONAL EXPERIENCE:

Confidential, May2009- present
Minneapolis, MN
Oracle Database Administrator
Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, configuration, administration maintenance Oracle 10g RAC/11g RAC databases.
• Performed upgrades from Oracle 9i to 10g, 10g to 11g, applied patches.
• Migrated databases from Window to Linux, HP-UX to Linux.
• Setup, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Data Migration as part of enterprise data warehouse project.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, cloning, backup, Health Check of Databases, Analyzing tables and Rebuilding Indexes.
• Data Modeling, Database design.
• Worked on import/export, export data pump/import data pump and SQL Loader.
• Installed and Implemented Backup and Recovery Procedures, Implemented Hot, Cold, Logical backup and RMAN backups.
• Downsizing and defragmenting the Very Large Databases by export/ import, cloning those using RMAN duplicate features and then upgrading them Oracle 10g/11g.
• Performance monitoring and tuning using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, ADDM
• Used sql server for ecommerce applications.
• Configured Streams to capture propagate; apply changes in multiple databases.
• Installation and administration of GoldenGate.
• Load Balancing, Databases/Schemas/Table Re-Organization for faster performance using export/import & Move procedures. Storage Management Managing space, Table spaces, Segments and Extents, Rollback Segments and Data Dictionary
• Monitored log files, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing and performance tools in physical/logical databases.
• Used OEM/Grid Controll for monitoring
• Designing the security and database access strategies.
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.
• Partitioning large tables. Capacity planning and bench marking.
• Shell scripting, SQL, PL/SQL programming. Written functions, procedures, packages and triggers.

ENVIRONMENT: Oracle 11g RAC, 11g RAC, Red Hat Linux 5.x, Solaris 10, HP-UX, Windows, PL/SQL, SQL*Loader, AWR, ADDM, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access.

Confidential,
New York NY Dec2007-April2009
Oracle Database Administrator
Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC/11g RAC database for high availability.
• Performed upgrades from Oracle 9i to 10g, 10g to 11g
• Involved in Design and Implementation of physical/logical standby databases for disaster and reporting
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Closely monitoring and administering log transport services and log apply services in physical/logical databases.
• Used shell scripting for RMAN backups and hot backup and recovery.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Implemented Backup using RMAN (Recovery Manager) as a media management layer.
• Have worked on building complex logical data models, reverse engineering and forward engineering using sophisticated modeling techniques and tools like Erwin and Visio.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Performance tuning i.e. tuning RAC, applications , shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/ Logical I/O and Memory usage.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Optimizing ETL procedures and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL Trace.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Consulting and advising with developers on the design of applications having complex database considerations, design custom database objects as required and recommended data access solutions that best fit the needs of the application.
• Used export/import for schema, table and database refresh.
• Supported bi-directional replication using oracle streams and designed the conflict resolution.
• Installation and administration of GoldenGate.
• Implemented Range, List Partitions, Hash Partitions,
• Creating and refreshing materialized views.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and tuning.
• Have done database backup and recovery using(cold backup/Hot backup/ logical)

Environment: Oracle 10g RAC/11g RAC/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN,TKPROF,SQL-Trace

Confidential,
Silvers spring MD Nov2006- Nov2007
Oracle Database Administrator
Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC database.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.4
• Install, Upgrade and configure Oracle database for various 32-bit and 64-bit platforms like HP-UX, Solaris Sun SPARC & Intel, MS Windows 2000.
• Use of Data Guard Manager, 9i and 10g Data Encryption.
• Carry general administration tasks using tools like OEM and Toad.
• Implemented and maintained streams for synchronization of data at various sites.
• Used RMAN for backup and recovery jobs.
• Create & Manage Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Applied patches on oracle database.
• Setting the tuning goals like improving the performance of the data loads by reducing the total turnaround time to complete the load.
• Shell scripting to automate all RMAN jobs.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers.
• Designed logically and configured oracle RDBMS on UNIX for better management of databases.
• Ran the STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Enabling the Trace files for the sessions which experience a very bad performance and generate the Trace output using TKPROF utility for further Analysis.
• Trace the SQL that have poor performance and identify the ways of improving the performance by adding necessary indexes or removing the unwanted indexes.
• Trace the frequently called procedures/packages and pinning them to improve the performance.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Providing the final recommendation based on our studies and testing results to the development team and SME’s for implementing them in production.

Environment: Oracle 11g/10g/9i, Sun Solaris, HP-UX, Redhat Linux, Windows 98/NT/2000, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN.

Confidential,
Denver CO July2005 Oct2006
Oracle Database Administrator
Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g databases.
• Installation, maintenance and tuning of Oracle 10g RAC databases.
• Performed upgrades from Oracle 8i, 9i to 10g
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Creating primary database Storage Structures.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Cloned Environments to create Patch Test, Development and QA Environments.
• Applied patches using Opatch utility, keeping applications software bug free, and improving data integrity.
• Applied High priority, Security Patches downloaded from Metalink.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Responsible for setting and managinguser accounts, Granting required privileges to users.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Monitoring the Database storage and Day to Day activities.
• Configured Scripts to monitor activity with database.
• Partitioned large tables to increase the performance.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Providing the final recommendation based on our studies and testing results to the development team and SME’s for implementing them in production.

Environment: Oracle 10g/9i/8i, Sun Solaris, HP-UX, Redhat Linux, Windows 98/NT/2000Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDm.

Confidential,
Hyderabad
Oracle Database Administrator/Developer Nov2003- May2005
Responsibilities:

• Involved in the installation of Oracle 8i/9i on Solaris platform.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures.
• Preparing Backup and Recovery Plan.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Storage and space management including table spaces and data files.
• Database Designing includes designing table spaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for better performance.
• Monitoring Database for fragmentation and correcting them.
• Creating and implementing backup and recovery strategies.
• Shell Scripting, SQL, PL/SQL programming. Written functions, procedures, packages and triggers.

Environment:Oracle 8i/9i, SQL, PL/SQL, RHEL,Sun Solaris,Shell scripting, Tkprof,Explain plan.

Confidential,Mar2003 Oct2003
Hyderabad
Junior Oracle database Administrator/Developer
Responsibilities:

• Oracle configuration. Oracle Tuning. Oracle Patch Administration.
• Wrote stored procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Performed Database tuning. Performed database security and Integrity.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Responsible for writing database programming to Store/ Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, Indexes, views, synonyms and all schema objects in Oracle.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers. Writen shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i/7.3, SQL server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*Plus, EXPLAIN PLAN, Shell scripting, Quest software tools, PL/SQL navigator.