SUMMARY

• An Oracle DBA with around 7 years IT experience in Oracle (7.x, 8.0.5, 8i, 9i, 10g, 11g), streams, data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning various industries like insurance, banking, wireless, financial etc. in variety of environments like UNIX, LINUX, (Solaris, HP - UX, AIX), Windows NT 4.0/2000/2003 in production as well as development databases.
• Expertise in oracle 8i/9i/10g/11g, (ASM and OCFS2) installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting and documentation.
• Installed oracle database server on Solaris 8/9/10, HP-UX, Tru64 Unix, IBM AIX 5.2/5.3 Linux and Windows environment and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g, 10g to 11g applied oracle patches.
• Expert implementing ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases
• Expert in implementing development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Comprehensively analyzed business function using ERP and performed changes for the better utilization of resources.
• Worked on very large database (VLDB) of 2TB with 23 servers including 5 productions, 12 development databases.
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Implemented development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise
• Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and rational rose.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager.
• Implemented and delivered core edge technologies of Oracle 10g (TOAD 9.5, OEM, Grid Control)
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
• Expert in SQL* Loader, export/import and data pump import to load data in to tables.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Experience 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, 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.

TECHNICAL SKILLS

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

RDBMS: Oracle /11g/10g/9i/8i.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting.

DB Management: TOAD 9.5, Enterprise Manager grid

Tools: /Utilities: RMAN, OEM, Sql Navigator, Oracle Management Service(OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup, MS Access.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling: Erwin 4.1.2, rational rose, visio

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM C server p5 model 590, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Fl

Database Administrator

Responsibilities:

• Configured Streams to capture propagate; apply changes in multiple databases.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection
• Used shell scripting for RMAN and hot backup and recovery.
• Performed upgrades from Oracle 10.2.0.3 to 11.2.0.1 on Intel and HP boxes.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Wrote extensive Sub Queries, PL/SQL procedures, cursors, functions, database triggers and packages.
• Monitored the various database activities such as backup, error logs, AWR reports, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• 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 running
• Providing technical expertise in the areas of Database installation, configuration, capacity planning, troubleshooting and problem resolution
• Develop/implement/oversee database policies & procedures for integrity/availability of databases & software
• Effectively soliciting and gathers requirements (user, business process, performance requirements, etc.) from business users using appropriate mechanisms and following company standards.
• Performing tablespartitioning, replication and gather statistics.
• Provide 24 X 7 on call support dealing any productions issue immediately with high efficiency
• Optimizing ETL procedures and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL trace .
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Utilized SQL*loader and data pump import to load data into tables.

Environment: Oracle 10g, Red hat Linux 5.X, Solaris 10, Toad, Sql-navigator, PL/SQL, SQL*Loader, ODBC, ASM, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access.

Confidential, Tampa, Fl

Oracle Database Administrator

Responsibilities:

• Installation, Configuration and tuning of Oracle 10g and 9i on redhat-4, IBM-AIX 5.3
• Supported bi-directional replication using oracle streams and designed the conflict resolution.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Closely monitoring and administrating log transport services and log apply services in physical/logical databases.
• Up gradation from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
• Used shell scripting for RMAN 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.
• 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 applications, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Used export/import for schema, table and database refresh.
• Implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• 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.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).

Environment: Oracle 10g, 9i, Red hat Linux 4.x, Solaris 10, SUN V480, HP-UX11, AIX 5L, Windows NT/2000, Toad 8.6, ASM, Oracle Enterprise Manager, ERWIN 4.x, warehouse builder.

Confidential, Jacksonville, FL

Oracle Database Administrator

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle 9i, 10g, 11g database.
• Use of Data Guard Manager, 9i and 10g Data Encryption
• Data Migration as part of enterprise data warehouse project.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Data Modeling, Database Design and Creation using ER-Win, visio.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF),RAW Devices
• UNIX shell scripting in csh, ksh to be controlled from Crontab
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Daily Health Check Up of the Database using statspack, AWR, ADDM, TKPROF, explain plan.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases
• Designing the security and database access strategies using tools like ESM

Environment: Oracle 10g, Red hat Linux 5.X, Solaris 10, Toad, Sql-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access.

Confidential, Wilmington, DE

Oracle Database Administrator

Responsibilities:

• Installation of Oracle 10.1.0.2 on Sun Solaris as well as Windows Servers.
• Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms like HP-UX, Solaris - SUN SPARC & Intel, MS Windows 2000.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• 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 & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments
• Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Applying Patches 9.2.0.6 on Oracle database.
• Used shell scripting to automate all RMAN jobs.
• Ran the Oracle 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.

Environment: Sun Solaris, SUN SPARC, HP-UX, Windows 98/NT/2000, IBM X Series Server, Oracle 9i, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN, Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, Explain plan, STATSPACK, SQL* Loader, Windows NT/2000.

Confidential

Pl/SQL Developer/Oracle Database Administrator

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.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity. .
• 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.
• Writing Pl/Sql procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.