SUMMARY

• Over 5+years of experience as an Oracle Database Administrator in a variety of database environments like Online Transactional, Data Warehousing and General purpose database and having expertise in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, auditing and designing databases.
• Good experience in Installation, Upgradation and performing Backup of Oracle 10g RAC clusterware databases.
• Expertise in Installation, Configuration, Up gradation, Patching, Migration, Trouble shooting and Performance tuning of oracle 8i/9i/10g/11g databases on UNIX, LINUX and Windows environments.
• Good experience in writing UNIX Shell scripts to automate business process and daily backup.
• Proficient in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader, SQL Navigator, TOAD, Export, Import and SQL*PLUS.
• Good experience in writing UNIX Shell scripts to automate business process and daily backup.
• Oracle 11i experience includes, installing 11.5.2 and then upgrading to 11.5.3, 4 instances run on 3 IBM AIX nodes.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table spaces.
• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g.
• Excellent Communication skills, co - ordination and communication with system administrators, business data analysts and development teams

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g Enterprise/Standard Edition, MS SQL Server 2008,2005,2000

Platforms: Sun Solaris, Suse Linux, AIX, Red hat Linux, HP-UX 11i, Win2K

Languages: SQL, PL/SQL, XML, HTML, Visual Basic

Tools: SQL*PLUS, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Knoxville Tennessee

Oracle Database Administrator

Environment: Oracle 9i/10g/11g, PL/SQL Developer, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, UNIX and Windows

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, Oracle 10g & 11g databases.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Scheduling jobs through Oracle Job Scheduler.
• Applied CPU patches and Upgraded Oracle 10g RAC databases.
• Created documentation for Building the RAC and Testing the RAC.
• Worked on implementing new backup procedures using RMAN.
• Refreshed the DEV, Testing and UAT using RMAN and tradition hot backup method.
• Helped the Production teams in Applications Performance Tuning and providing 24*7 Production Support.
• Performed documentation wherever necessary.
• Performed capacity planning required creating and maintaining the database environments.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Responsible for Oracle9i and 10g logical and physical databases design, implementation and maintenance on UNIX and NT.
• Managed and resolved design issues during development.
• Adding a Disk group, removing a disk group, movement of data between disk groups in a ASM storage platform
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Explain Plan, Toad and Enterprise Manager.
• Created users, table spaces, tables, indexes, views, triggers, synonyms and sequences.
• Setup of Standby Database using Data guard for faster Disaster Recovery.

Confidential

Oracle Database Administrator

Environment: Oracle 9i/10g, MS Sql Server 2005 & 2000,OEM

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, Oracle 10g databases.
• Managed ASM instances and performed upgrade in Oracle 10g R2 Clusterware environment.
• Designed the database access and security.
• Supported MS SQL server databases for internal databases.
• Implemented Materialized views to replicate data from OLTP database into data warehouse.
• Monitored Database Sizing, Table space Management, Transaction Management, and Security Administration.
• Supported Data warehousing team for configuring ETL tools.
• Modified and defined database objects as per requirements.
• Wrote procedures, triggers and shell scripts. system utilization, table space and DB Objects monitoring.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Supported Data Marts in 9i and 10g versions using Replication feature.
• Planning and conducting Database upgrades/Database Migrations.
• Assisted application development team with database design and support.
• Performed heavy data loads using SQL *Loader.
• Worked in an environment where both OLTP and OLAP database types were used.
• Implemented UAT (User Acceptance Testing) to ensure that they met the user requirements.
• Preparing Backup and Recovery plan.
• Adding a Disk group, removing a disk group, movement of data between disk groups in a ASM storage platform.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth.

Confidential

Oracle DBA

Environment: Oracle 8i/9i, PL/SQL, Developer 2000, Windows NT 5.0/ UNIX

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Wrote various scripts to automate data loads, performance monitoring and backup.
• Database physical/logical layout design and procedures for production, development, test servers.
• Guided the Operations team in Creating, Cloning and trouble shooting Oracle Databases, Database Objects Designs, partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
• Helped the Production teams in Applications Performance Tuning and providing 24*7 Production Support.
• Performed capacity planning required to create and maintain the database environments.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*loader.
• Involved in creation of different data base objects like Tables, Triggers, Indexes, Views, Constrain, and Stored Procedures using PL/SQL and SQL and also performed table partition of the table space on different schemas.
• Monitored Database Sizing, Table space Management, Transaction Management, and Security Administration.
• Performance tuning for Oracle day-to-day maintenance and management on various types of databases like in development, test, regression and production environments. Proactively monitoring production environment for any exceptions/ issues.
• Performed migration on database, schemas and table basis using SQL loader and utilities like import/export and data pump of Oracle database 10g.
• Applying necessary patches and TAR support with Oracle Metalink
• Performance tuning of application using Query Optimizer and Toad to reduce execution time of the query and check joins used by queries.
• REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of Stand by database.
• Conducting sizing & capacity planning for Oracle databases.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments