SUMMARY:

• Oracle Database Administration
• Oracle Business System analysis and design experience
• Experience with Oracle database design, installations and conversions
• Experience with various database Management System Products
• Experience in maintenance, enhancement, designing of data dictionaries, database models, and performance tuning
• Experience in technical documentation
• Experience in Oracle best practices
• Excellent communication

PROFESSIONAL EXPERIENCE:

Confidential, Ridgeland, MS

Database Administrator / Technical Lead

Responsibilites:

• Created, Configured, Upgraded And Administered 10.2.0.4/11.2.03 versions Oracle databases on Linux SUSE / Solaris 10/ AIX 6.1
• Supported SQL Server 2005/2008/2012 Database Instances of TEST/PROD environments hosting applications to support more than thousands of users
• Installed And Configured OEM 12c on Linux platform - Installed Agents on Solaris/AIX platforms, Configured Email Notifications, Alert log filters, Administration Groups, Administration Jobs, & RMAN Backup Jobs
• Ensured optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring using OEM 11g/12c, TOAD 11.6.0, Automated Scripts, SQL Developer 3.2.20
• Participated in meetings for Project Updates/Project Enhancements/Trouble shooting periodically
• Provided Plan Stability for critical processes across different versions of databases
• Configured OEM 12c on Solaris 5.10 / AIX 6.1

Environment: ERP: R12.1.3; Oracle DB 10.2.0.4/11.2.0.1/11.2.0.3 ; SQL Server 2005/2008/2012 ; OS WINDOWS 7.0/LINUX-SUSE 11/SOLARIS 10/AIX 6.1 DB Admin Putty, Win SCP, VNC Viewer, OEM 11g/12c, RMAN; TOAD 11.6.0, SQL Developer 3.2.20, RMAN; Performance Tools AWR, SQLT, EXPLAIN PLAN, TRCANLYZR, Replication Data Guard, IDR (Informatica Data Replication), MVs

Confidential, Colorado Springs, CO

Database Administrator / Technical Lead

Responsibilities:

• Supported production oracle DB 10.2.0.4 on Linux platforms
• Supported development team of size 20 in enhancing project of the existing prod system
• Used Sybase power designer for data modeling, applying db changes & reverse engineering
• Defined project requirements, analysis for best practices.
• Existing systems for documentation
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Tuned resource consuming queries on prod and dev systems using performance tuning tools - SQLT, AWR, EXPLAIN PLAN, ASH & ADDM
• Monitored changes using DB ADMIN tools - EMBARCARDERO DB Artisan & DB Change
• Manager, SQL Server DB Admin
• Responsible for Database Administrator to support database and data warehouse production/development environment.
• Responsible for designing, database Installing, conversion, enhancement, maintenance, monitoring, performance tuning, configuring, object (databases, tables, triggers, indexes, procedures and functions) creation and backing up of databases.
• Manages and maintains the data dictionaries.
• Participated in Partitions decision making, capacity planning & development analysis meetings
• Raised SRs to Oracle Support as-and-when required for analyzing prod issues
• Support monthly maintenance tasks and resolved/supported critical issues on PROD

Environment: Databases: Oracle 10.2.0.4/11.2.03 on Linux 5.0, Data Modelling: Sybase Power Designer 15.2.0, OS Tools: Putty, WinSCP, TELSA, Tight VNC2.0.4, Performance: SQLT, TRCA, EXPLAIN PLAN, SQL Profiling, Development: SQL developer 3.1.07, SQL, PL/SQL,

Confidential, Chicago, IL

Production DBA

Responsibilities:

• Clearing tickets raised by HITACHI offshore team on PROD and SUPPORT instances
• Coordinating with onshore analysts and offshore development team
• Checking status of daily backup jobs for purging archive logs (hourly), refreshing SUPP, DEV, TRAIN, TEST with PROD periodically
• Defined project requirements, analysis for best practices.
• Troubleshooting failed backups, slow-running queries, setting up new users and add/remove privileges on PROD for key development team
• Documented and complied with company policies and standard operating procedures.
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Responsible for designing, database Installing, conversion, enhancement, maintenance, monitoring, performance tuning, configuring, object (databases, tables, triggers, indexes, procedures and functions) creation and backing up of databases.
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Manages and maintains the data dictionaries.
• Coordinated with Oracle Support to resolve issues on 24*7 basis
• Achievements
• Setup data guard from Chicago and Newyork server on TEST and coordinated with third party vendor to setup on PROD
• Setup link between oracle and SQLServer instances using DG4MSQL and tested successfully on TEST environments

Environment: Dba team of size 4 - 2 onsite and 2 offshore, 16 Oracle Instances (10.2.0.4, 11.2.0.3), 40 Sql Server Instances (2005, 2007), Frontend applications are In house .net applications & PeopleSoft (Financials on Oracle & HR running on SQL Server)

Confidential, NASHVILLE, TN

Oracle Production DBA

Responsibilities:

• Checked backup jobs using RMAN, Exp dump & check db health of PROD and TRAIN
• Refreshed TRAIN site for training county users as when request comes from DPA
• Monitoring and resolving slow running query issues on PROD and recommend dev team
• Performed Extraction, Conversion & Loading of data from Main Frames to Oracle databases 10.2.0.4 / 11.2.0.3 versions
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Designed OLTP & DSS systems from the beginning and provided documentation for development and analysis teams
• Defined project requirements, analysis for best practices.
• Responsible for designing, database Installing, conversion, enhancement, maintenance, monitoring, performance tuning, configuring, object (databases, tables, triggers, indexes, procedures and functions) creation and backing up of databases.
• Applied Patches for Oracle Server and database tools as when new patches are released
• Coordinating with Oracle Support for troubleshooting issues on 24*7 basis
• Achievements
• Documented and complied with company policies and standard operating procedures.
• Migrated environment from single-server to multi-server environment
• Moved environment from Non-RAC to 2 node RAC environment running on ASM
• Installed GIS environment (ArcGIS tools) on TEST and PROD to access data from oracle and SQL server and publish on website
• Manages and maintains the data dictionaries.
• Played major role in integrating individual modules to IAS World Website accessed by more than 97 counties in the STATE
• Setup data guard on DR site to replicate data from PROD on regular basis

Environment: DBA Team of size 2, Development Team of size 12 (Applications running on .NET, JAVA, MS ACCESS & Oracle Forms & Reports), Oracle 10.2.0.x/11gR2 OS : Windows 2003/2008 Tools: TOAD8.6.0, SQL Developer Application Server: 10g AS OS: Windows Vista/2003R2/2008R2 RAC: 4-Node (4 processors, 32.0 GB RAM) 64-bit Application Server: Web Logic Server 11gR1 (10.3.5.0), Jdeveloper - 11g (11.1.1.5.0 )

Confidential, ATLANTA, GA

Oracle Database Administrator

Responsibilities:

• Installed and migrated databases from 10g to 11g using DBUA, Export/Import
• Discussed with QA Team before generating crystal reports as requested by end users.
• Creation of Application users and assigning the tablespaces, quotas, roles and profiles.
• Defined project requirements, analysis for best practices.
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user’s privileges.
• Written Shell scripts for day-to-day database activities for transfer files from dev server to PROD
• Responsible for designing, enhancement, maintenance, monitoring, performance tuning, configuring, object creation and backing up of databases.
• Designed OLTP & DSS systems from the beginning and provided documentation for development and analysis teams
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning.
• Database Planning, Designing and Setting up of storage parameters for segments.
• Setting up logical/physical backups for these databases. Depending on the nature of database, set up of either Full export, partial export, or export of just the structure of schema objects Using RMAN as well.
• Trained developers, management and end users regarding functionality of new products before implementation setting up Oracle disaster recovery sites using Data Guard
• Manages and maintains the data dictionaries.
• Experience in writing, modifying and executing shell scripts for database mgmt tasks
• Configured and supported databases running on remote servers using OEM Grid Control
• Experience in escalating the critical issues by rising TAR/SR to ORACLE CORP.

Environment: EBS: 11.5.9.0, 11.5.10.2 Languages: PL/SQL, Java Front End: Forms 6i/10g, Reports 6i/10g, JDeveloper Tools: TOAD8.6.0,SQL Developer Application Server: 10g AS OS: Windows XP, AIX 5.2, WRQ Reflection FTP Client Version Control: WinCVS 2.0.2.4

Confidential

Oracle DBA

Responsibilities:

• Experience in installing and configuring 10g RAC on Linux
• Migrated Oracle databases from 8i, 9i to 10g databases using DBUA, Export/Import
• Experience in implementing and supporting Oracle Streams for Replication
• Defined project requirements, analysis for best practices.
• Responsible for designing, enhancement, maintenance, monitoring, performance tuning, configuring, object creation and backing up of databases.
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Responsible for database installation, database upgrades and software maintenance
• Used 10g New Features like ADM, ADDM for producing database performance reports
• Manages and maintains the data dictionaries.
• Documented and complied with company policies and standard operating procedures.
• Creation of Application users and assigning the tablespaces, quotas, roles and profiles as per requirements.
• Experience in using RMAN utility for Hot Backups & Cold backups with various scenarios

Environment: Oracle Reports Builder 6i, Oracle Forms Builder 6i, XML publisher, Oracle 10g, SQL Loader, PL/SQL Developer, TOAD, UNIX

Confidential

Database Administrator

Responsibilities:

• Creating databases, Refreshing Testing/development databases from production.
• Implemented 10g New Features ASM, OCFS, ADM, ADDM for prod database performance
• Defined project requirements, analysis for best practices.
• Database Planning, Designing and Setting up of storage parameters for different segments.
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Tuning of rollback segments by estimating the transaction volume and transaction rates in 8i and later creating undo tablespaces in 9i and setting up undo retention parameter.
• Documented and complied with company policies and standard operating procedures.
• Responsible for database installation, database upgrades and software maintenance
• Setting up logical/physical backups for these databases. Depending on the nature of database, set up of either full export, partial export, or export of just the structure of schema objects Using RMAN as well.
• Manages and maintains the data dictionaries.
• Tuned the application for better performance by using explain plan and running the tkprof utility and Statspack.

Environment: Oracle Apps 11.5.10, GL, PO, AP, AR, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, TOAD, Discoverer 10g, Windows XP, UNIX, XML Publisher

Confidential

Oracle DBA

Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products
• Establish and maintain sound backup and recovery policies and procedures
• Defined project requirements, analysis for best practices.
• Implemented and maintained database security (create and maintain users and roles, assign privileges)
• Responsible for designing, enhancement, maintenance, monitoring, performance tuning, configuring, object creation and backing up of databases.
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance & New Features
• Worked on Oracle & Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Directing & leading a backend team for ensuring seamless operations & services to clients. Heading database administration functions and complying with all rules & regulations pertaining to the same.
• Responsible for database installation, database upgrades and software maintenance.
• Documented and complied with company policies and standard operating procedures.
• Manages and maintains the data dictionaries.
• Handled DB Operations and involved in creating / upgrading/ configuring Oracle DB
• Involved in code migration, database change management and data management through the various stages of the development life cycle

Environment: ORACLE 8i, 9i, SQL Server 2000/2005, Oracle Forms, Reports, SQL, PL/SQL, VB 6.0, Crystal Reports, Windows XP, Linux

Confidential, Sunnyvale, CA

Database Analyst

Responsibilities:

• Directing & leading a backend team for ensuring seamless operations & services to clients.
• Handling Database Operations and creating / upgrading/ configuring databases 8.0 - 8.1.6 & Oracle Software.
• Perform application tuning and performance monitoring
• Involved in code migration, database change management and data management through the various stages of the development life cycle
• Setup and maintained documentation and standards

Environment: Oracle 8i, 7.3, Forms 6i & Reports 6i, SQL/PLSQL, Linux & Windows 2000, RS6000, AIX