PROFESSIONAL SUMMARY

6 plus years of experience in Oracle Database Administration, tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.

• Experience in Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database.
• Oracle Database Administration in a variety of environments like Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL, CentOS and Windows NT/2000/2003.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Experience in installing, maintaining, upgrading and patching Oracle versions 11g/10g/9i/8i.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Managed Oracle and SQL server in High Availability environments using Failover, Clustering, Mirroring, Dataguard and Cloning technologies. Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Experience in database full Backup (hot and cold), Incomplete Backup, DataPump Export/Import, SQL Backtrack and Restore procedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience in Database creation with RMAN jobs and security implementations in Oracle Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Installed 10g Gridagent on servers and configure OEM Grid control.
• Tuning with STATSPACK, ADDM, V$ views, ASH, TOP, netstat, vmstat, iostat and prstat.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Used parameters to configure, install and manage ASM instance in 10g RAC.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard for OLTP, Decision Support Systems (DSS) Data Warehouse environments.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Experience in using oracle Streams for replication of database.
• Job scheduling using crown utility and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.
• Experience in using System Development Life Cycle (SDLC).
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Experience in ERWIN Data modeling and MS Visio for E-R diagrams and Logical, Physical layout designs.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.
• Experience in Very Large Multi Terabyte Database (VLDB) and also performed migrations in this environment.
• Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
• Documented all Oracle database installations and database operations
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.

EDUCATION:

• Bachelor’s Degree

TECHNICAL SKILLS:

• Database: Oracle 11g/10g/9i/8i, RAC 11g/10g, SQL Server
• Operating System: Linux, HP-UX 11/11i, Sun Solaris, AIX and Windows NT/2000/2003
• Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting
• Tools/Utilities: SQL*Loader, DataPump (Export/Import), OEM, RAC, TOP RMAN, TOAD, AWR, ADDM, STATSPACK, TKPROF, Crystal Reports, Oracle Grid Control, Log Miner, ERWIN.
• Web Tools: Visual Basic 6.0, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential
Franklin, TN July 2009 – Present
Senior Oracle DBA

Healthways offers comprehensive solutions that improve well-being, decrease healthcare costs, enhance performance and generate economic value for Healthways customers. Worked as a member of Healthways team to solve customer’s most pressing problems. This project deals with Data Center Migration and Delivery and Hosting Operations. It includes installation of oracle 11g RAC, upgrades, Dataguard reconfiguration and improving the performance of database, maintenance of standby database, backup and recovery using RMAN and applying patches.

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Upgrade of database from 10.2.0.4 to 11.1.0.6 by applying patches using Opatch utility.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, Grid Monitoring.
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH.
• Tuning whichinvolved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Cloned database for test environment.
• Migrated 10 databases (14TB+) from SQL Server 2000/2005to Oracle 11g database.
• 24x7 on-call production database support.
• Administrating Real Application Cluster (RAC) databases running on Cluster File system.
• Migrated database objects from database to other server by using Export/Import, Datapump.
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup’s logs and alert logs
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and use datapump jobs for loading the subscriber and history related data at replicated site.
• More than 2 Terabytes of data migrated using migration utilities Data Pump, Export and Import (schemas and full database) and Transport Tablespaces for different character sets of databases.
• Configured user log on load balancing and failover on RAC database.
• Database Capacity Planning & configuration (redo and stream sizes), design staging schema and use of DBMS_STREAM_ADM packages.
• Handful of experience with ERWIN tool for data modeling.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager (OEM).
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Assisting developers in getting database connection from the client using SQL *net and Net8.
• System wide tuning using UTLBSTAT and UTLESTAT (stat pack).
• MaintainedVery Large Multi Terabyte (VLDB) around 14TB+ in Data Warehouse Environment for DSS.
• DBA activities which includeCreating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, roles, user management, and maintenance.
• Load data from OLTP systems into data warehouse databases.
• Documentation of Oracle database operations and training of backup personnel.

Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11, Toad, SQL, PL/SQL, ERWIN, Dataguard, DataPump, OEM, RMAN, SQL*Loader, Streams, Shell Scripting, SQL Server, Data Warehouse, OLTP.

Confidential
Dallas, TX Jan 2007 – June 2009
Senior Oracle Database Administrator

Citigroup offers a broad range of products and services that are improving productivity in financial services. Worked on one of the largest and most sophisticated business intelligence and marketing database. The project deals with installation of Oracle 10g RAC with ASM, migration of database, setup and maintain standby database, RMAN backup and recovery and performance tuning.

Responsibilities:

• Installed, Created and maintained 3 Node 10g RAC and created database for production, development and test environment on HP-UX platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Upgradation and Migration of Database from 9.2.0.6 to 10.2.0.2(RAC) and applying patches whenever required.
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp).
• Manage and maintain database and user security using OEM Grid Control
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.
• Writing backend procedures, functions, packages and triggers using PL/SQL.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Installed Oracle 11g database in thetest environment and tested the upgrade from Oracle 10g to 11g.
• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX serversusingIOSTAT, NETSTAT, VMSTAT, TOPAS and PRSTAT.
• Applying upgrade patches, maintenance and interim patches on all the databases
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures
• Designed physical and logical database structures and created, managed Tablespaces.
• Applied High priority patches downloaded from Metalink.
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Gathering schema stats and monitoring the index usage.
• Documented backup and recovery plans and tuning procedures.

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, Red Hat Linux 4.x, HP-UX 11,Windows 2003, IBM-AIX, Data Warehouse, ERWin, Netbackup, OEM, SQL*Loader, Grid Control, RMAN, ASM, Dataguard, TOAD, Datapump.

Confidential
Conway, AR Apr 2005 – Jan 2007
Oracle DBA

ACXIOM provides consumer insight to connect clients with their customers for business relationships. Acxiom serves clients around the world from locations in the U.S.A, Europe and Asia-Pacific regions. It is one of the largest and most sophisticated business intelligence and marketing database. This project deals with installation, migration, RMAN backup, setup standby database and performance tuning.

Responsibilities:

• Installing Oracle 8i/9i/10g on AIX and RHEL creating database for production, development and test environments.
• Assisting developers and 24*7 production database supports.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN, Complete and incomplete recovery of database.
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Migration of database from 8i/9i to 10g in the production and development.
• Performed SQL query optimization by gathering statistics and by using explain plan, STATSPACK, TKPROF and SQL Trace.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g RMAN’s New Features and Data guard(stand by database)
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
• Used RMAN for Cloning of the creating database in test and development environment.
• Performed migration of database with Export, Import, Datapump and SQL*Loader jobs.
• Periodically uploading data from flat files using SQL*Loader
• Monitoring production systems to establish status and conduct proactive maintenance
• Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
• Online index rebuilds. Controlling and monitoring user access to the database. Monitoring Rollback Segments.
• Estimation and creation of Control file, Log file (including multiplexing), Data files, Tablespaces and rollback segments.
• Environment: Oracle 10g/9i/8i, RHEL, IBM-AIX, Windows NT, RMAN, Datapump, SQL, PL/SQL, exp/imp, TOAD, SQL*Loader.

Confidential, New Delhi, India
PL/SQL Developer. Apr 2004 – Apr 2005

Network Metrics Platform (NMP) is a Data Warehouse system designed to meet the reporting requirements for BOSCH (Germany) towards the Federal Communication Commission. NMP is divided into five domains; Pre-order, Order, Billing, Provisioning, Maintenance & Repairs. The system gets all its data from the Legacy systems the business logic is applied on the data. The responsibilities for the production, development, test and QA databases as follows

Responsibilities:

• Developed PL/SQL procedures/functions to build business rules to load data and implementation of Customization.
• Analyzed, designed and developed, ad-hoc SQL queries using TOP-N-analysis, Created Tables, Constraints, Database Links, Views, Indexes, Synonyms and Sequences using TOAD.
• Expert on Oracle internals, memory and resource management and data and storage layout.
• Tuned application's SQL statement for efficient uses of Indexes, Index creation & maintenance, used SQL Trace, Analyze, Explain Plan utilities and TOAD
• 24/7 monitoring and production support of orders database

Environment: Oracle 8i viz. v8.1.7 Server, HP-UNIX, Windows NT, TOAD, and Oracle Enterprise Manager.

Confidential
Hyderabad, India Mar 2003 – Mar 2004
Assistant Oracle Administrator

This project deals with the maintenance of finance database and customers profile.

Responsibilities:

• Installed, configured and managed Oracle 8i, 9i on HP-UX and IBM-AIX environments for production, test and development.
• Performed Backup and Recovery strategies and procedures after evaluating various options includingHot and Cold backups.
• Upgrade and Migration of production and development databases from Oracle 8i to Oracle 9i.
• Performed physical and logical database design.
• Worked with database export/import to backup database structure
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
• Involved in PL/SQL Coding, Scripting & Training Developers
• Responsibilities include installation and configuration of the database and application clients and server software, applying upgrades and patches, developing development standards and naming conventions, consulting developers, code review and integrating third party tools with Oracle Enterprise Manager OEM.
• Optimized INIT.ORA parameters like DB block size, block buffers, shared pool.
• Net8 Configuration for Clients Connection.
• Generate technical document from the requirements of the business user.

Environment: Oracle 9i/8i, IBM-AIX, HP-UX, Windows 2000, RMAN, Physical Backups, PL/SQL, Shell Scripting, exp/imp, SQL, SQL/PLUS.

Reference:
References will be provided upon request.