Education:

• Bachelors in Computer Information Science

Certifications & Trainings:

• Oracle 9i and 10g Certified DBA (OCP)
• Training on Oracle 10g RAC Administration from Oracle Corp
• Training on Oracle 10g Database Administration I from Oracle Corp
• Training on Oracle 10g Database Administration II from Oracle Corp
• Training on Oracle Database 10g: SQL Tuning from Oracle Corp
• Training on Oracle Warehouse Builder from Oracle Corp
• Training on Data warehouse design and modeling techniques from TDWI University
• Training on Informatica, DAC and OBIEE Administration from KPI
• Training on Business Objects XI from Business Objects

Technical Skills:

• Database Systems: Oracle 9i/10g, SQL Server, DB2.
• Languages: Java, SQL, PL/SQL, TSQL, UNIX shell scripts.
• Operating Systems: LINUX SUSE 9, HP-UX 11i, Red Hat Enterprise Linux 4 - X86_64, Sun SOLARIS, UNIX, Win XP, Win2K, WinNT.
• Data warehousing Tools: Oracle Warehouse Builder 10g and 9i, Informatica, OBIEE (RPD and Web Catalog), DAC, Business Objects XI.
• Oracle 10g Grid Control, DB console, Oracle Enterprise Manager, Oracle expert, Server Manager, SQL Navigator, SQL*LOADER , SQL*PLUS, PL/SQL, Toad, Data Pump, Erwin.

Experience/Skills Summary:

• 7+ years of experience as Oracle DBA in designing, administration & tuning of Oracle 9i and 10g databases (OLTP and 5+TB data warehouse)
• Built and administration of 2 Node 10g RAC environment on Linux.
• Extensive knowledge on tuning SQL queries on OLTP and Data Warehouse environment.
• Provide Production, QA and Development support for several Oracle 10g databases.
• Created and managed Oracle 10g on Linux, Solaris and HP server.
• Creation and testing DR (disaster recovery) solutions using RMAN and through SAN replication.
• Installation and setup of Oracle 10g Grid control.
• Performance tuning through scripts, AWR, and ADDM reports, SQL Trace and TKPROF.
• Database migration and applying patches.
• Administration of Automatic Storage Management.
• Database cloning, Physical and Logical Data Guard, Oracle Streams.
• Administration and management of database change control process for production implementation.
• Database Instance, Disk I/O and SQL tuning
• Writing Shell script and management of schedule using Unix scripts.
• Experience with administration and upgrade Oracle warehouse builder 10g.
• Installation, configuration and Administration of Informatica, DAC, and OBIEE on LINUX.

Experience Details:

Database Administrator
Confidential, Jacksonville, FL (11/2006 to Current)

• Designed and implemented 2 Node Oracle Real Application Cluster (RAC) for multiple databases on Linux.
• Performing database administration / data warehouse architect role.
• Installation, configuration, setup & administration of Oracle 9i and 10g databases.
• Installation, configuration, setup of Grid Control and monitoring databases
• Testing and applying patches on development as well as production databases.
• Disaster recovery (DR) planning and testing disaster scenarios using RMAN and SAN replication.
• Implementing backup solutions using RMAN(hot and cold backup) and cloning database
• Database performance monitoring and tuning using Grid Control, AWR, ADDM and shell scripts.
• Tuning of ETL programs and report SQL queries on 5 TB data warehouse environment.
• Performing reviews of data warehouse dimensional model, architecture, expert advice on ongoing data warehouse project development and tools administrator role for Business Objects and Oracle warehouse builder.
• Helping BI developers resolve day to day ETL and report performance related issues.
• Installation, configuration, administration of Oracle warehouse builder 10g.
• Applying one-off and upgrade patches to Oracle warehouse builder 10g.
• Installation, configuration, setup & administration of Informatica, DAC, OWB10g, and OBIEE (RPD and Web Catalog).
• Created partitions (list, range and hash) partitions to improve database performance.

Oracle 10g, Grid Control, Oracle warehouse builder 10.2.0.5, Informatica, DAC, OBIEE, Business Objects XI SQL Navigator, SQL, PL/SQL, ERWIN.

Oracle Sr. Database Administrator
Confidential, Jacksonville, FL (11/2003 to 10/2006)

• Responsible for installation, configuration and maintaining Oracle (9i & 10g) production databases for Department of Defense (DoD). Providing system support and management to the government clients meeting the service level agreement (SLA). Provided 24x7 on call production support to DoD clients.
• Designed, created, tested and implemented tables, functions, procedures and custom PL/SQL packages.
• Performed database migration from Oracle9i to Oracle 10g.
• Implemented Oracle Streams for replication required to support other projects.
• Database cloning to Development and QA environment as needed.
• Perform regular database maintenance such as adding space, reorg, creating partitions, tuning SQL queries and application issues.
• Testing and applying regular and upgrade patches on Development, QA and Production environment.
• Implementing cold and hot backup using RMAN.
• Database performance monitoring and tuning using Oracle Grid Control.

Oracle 9i and 10g, Oracle Database Grid Control, Toad, SQL, PL/SQL, ERWIN.

Projects Details:

MDMS Implementation
Oracle Database Administrator
Confidential,Jacksonville, FL

The purpose of this project is to create new database on 10.2.0.5 in support of MDMS meter read application.
Responsibilities: Designed database architecture for this environment. Installation and configuration of Oracle 10g RAC production on Linux Red-Hat. Configured ASM for data storage. Created users, tablespaces, roles, database links, partitions, synonyms as needed. Created shell scripts for routine database administrative duties and RMAN level0 and level1 backup for disaster recovery. Tested different disaster recovery scenarios. Create indexes and partitions as required to the application performance. Applying patches for bug fixes required to resolve performance issues.

FMIS Implementation
Oracle Database Administrator
Confidential,Jacksonville, FL

The purpose of this project is to migrate data from 9i to 10g database.

Responsibilities: Installation and configuration of Oracle 10g RAC production on Linux Red-Hat. Configured ASM for data storage. Migrated data from 9i to 10g using RMAN. Tested database and application performance and tuned as required. Applied patches to fix performance and internal bugs.

CCNB Billing
Oracle Database Administrator
Confidential, Jacksonville, FL

The source system from this data warehouse project was CCNB billing, payment and customer information. The purpose of the data warehouse is to provide fast & easy analytical reporting for Billing, Payment, and customer information stored in source system. ETL process runs every day and gets the update records from the source system.
Responsibilities: Collected requirements from the Data Architect team, designed physical and logical data models, creating capacity plan and support BI development teams. Created nightly batch scripts on UNIX to run ETL jobs. Creating Indexes (Function, B-tree & Bitmap) for report queries & load process optimization, partitioning to optimize the load and reports. Performed database upgrade from 10.2.0.3 to 10.2.0.5

Distribution System Loading (DSL)
Oracle Database Administrator
Confidential, Jacksonville, FL

The project will implement a series of new interfaces and enhancements to realize the potentials of NMR infrastructure deployment. The project will provide daily, 15-minute interval or system load snapshot (SLS) data as needed for electric system planning and analysis and new customer provisioning.
Responsibilities: Designed database architecture to be used for this environment. Installation, configuration, and setup of Oracle 10g database on HP-UX server. Created users, tablespaces, roles, database links, synonyms as needed. Created capacity plan to support terabyte databases. Wrote shell scripts for routine database administrative duties and RMAN cold backup. Created table partitions on fact tables, bitmap and b-tree indexes to optimize report performance.

Wawf Upgrade.
Database Administrator Sr.
Confidential,

Wide area workflow source application is used by department of defense for inventory purposes.
Responsibilities: Provided Oracle database administrative support. Setup Oracle database 10g environment. Migrated data from 9i to 10g. Developed Unix shell scripts to automate database operation and database monitoring. Implemented oracle streams. Created tables, functions, procedures and custom PL/SQL packages to support the application.