Profile Summary:
Database professional with 12 years experience in designing and implementing OLTP databases and data warehouse environment. Worked on large systems that have a size of 1.5 TB that supported up to 25000 online users. Experienced in Logical and physical data modeling using ERWIN and Designer2000. Extensive experience in PLSQL/SQL/Shell scripting as a developer as well as DBA. Have substantial experience in Performance tuning database at the instance level and SQL level. Experienced in partition maintenance, database maintenance, Database installation, cloning, database software installation and patching the database software.
Experience
Confidential,Cincinnati, OH February 2012 – Present
Sr. Oracle database administrator

• Assisted in performance tuning of oracle based applications.
• Responsible for creating change requests and follow up with the DBA resources to implement the same into database environments.
• Assisted in design review of applications developed on Oracle RDBMS platforms.

Platform: Oracle RDBMS 10g, 9.2.0.8, Sun Solaris

Confidential,Alpharetta, GA August 11– October 2011
Application Database Administrator
Responsible for performance tuning of Oracle PLSQL packages, data model review.
Platform: Oracle RDBMS 11g, PLSQL, Redhat Linux
Confidential,Tampa, FL
Sr. Database Management Analyst Oct 2008 – June 2011

• Managed production Oracle database environments
• Assisted developers and architects with physical data design to meet the performance requirements of application.
• Developed PLSQL scripts to compare data between primary and disaster recovery sites.
• Provided technical support to application teams, business analysts and QA staff.

Platform: Oracle RDBMS 9.2.0.6, 10g, oracle 11g, HP/UX, PLSQL, Shell Scripts, Oracle Streams, Oracle Partitioning.
Confidential,Warren, NJ
Senior Systems Analyst (IT) Nov 2007 - Oct 2008
Sr. Database Administrator ConsultantJuly 2006 – Nov 2007

• Responsible for providing production and development database support of mission critical applications running on Sun Solaris platform.
• Assisted in performance tuning of database environments to support platform upgrade from Sun 15K cluster to Sun 25K. Analyzed several processes using AWR reports.
• Supported Disaster Recovery implementation using Data Guard.
• Performed database migration from 9i to 10g. Analyzed the database for performance.
• Assisted application development teams with logical and physical data modeling as needed.
• Developed PLSQL scripts for data conversion.
• Provided technical support for various application development groups.
• Designed and developed ETLs to support several data loads using DM Express.
• Developed shell scripts to automate the ETL jobs and database monitoring
• Assisted in testing real application cluster environment.

Platform: Sun 15k/25K, Oracle RDBMS 9.2.0.5/10.2.0.2,ERWIN 4.1, Sun Solaris 8/10, Oracle 10g Grid, SQL, PLSQL, Shell Scripts,Data Guard.
Confidential, [Highland Park, IL]
Database Administrator - Consultant June 2004 – June2006

• Responsible for supporting mission critical databases and applications of Solo Cup on HP/UX, Windows environment as production and application DBA.
• Built the UAT database environments. Developed utilities to refresh databases from Production to DEV, QA, and UAT using PLSQL, SQL and shell Scripts.
• Assisted in migrating database changes to QA, UAT and Production database environments.
• Performed code-review, capacity planning, security review, and database design review for several OLTP applications and data warehouse.
• Designed and implemented an error handling framework using PLSQL to support OLTP and various batch jobs.
• Assisted in establishing PLSQL development standards and guide-lines.
• Upgraded Oracle database from 9.2.0.3 to 9.2.0.7 and documented the database migration procedures.

Platform: HP/UX B11.11, HP9000/HP-Superdome, Web methods, RMAN, Peoplesoft, Manugistics, Oracle Application Server 10g, ERWIN, UNIX Shell Scripts, Oracle Enterprise Manager, Oracle RDBMS [8.1.7, 9.2], tkprof, statspack, PLSQL, SQL
Confidential, [New York City, NY] Dec 2003 – Nov 2004
Database Administrator - Consultant

• Primarily responsible for supporting the MANTUS and LCD data warehouse environments used by Credit Suisse on Oracle / Sun Solaris platform. In addition, supported several OLTP databases on Sun Solaris, Linux platforms.
• Performed database upgrade from Oracle 8.1.7.4 to 9.2, and assisted in implementing latest patch set for Oracle 9i database environments
• Supported Production Oracle Database environments on a rotation basis among a team of Database Administrators

Platform: Oracle RDBMS 8.1.7,4/9.2.0.x, Sun Solaris 8 / Veritas Cluster, Red hat Linux Advanced Server 2.1, Windows2000, DB-Artisan, Unix Shell Scripts, PLSQL, SQL, Oracle Partitioning
Confidential, [Atlanta, GA] Feb 2001 – Oct 2003
Database Administrator / Physical Data Architect – Consultant

• Performed physical data modeling for Several OLTP systems used by GE Power Systems [Contractual Services Division] using ERWIN.
• Designed and implemented the backup / recovery for production database environments using Shell Scripts / SQL. Automated the database backup.
• Designed and Implemented database monitoring using Shell Scripts and SQL.
• Installed and configured database environments on Sun Solaris platforms.
• Assisted the developers in performance tuning of code written in SQL/PLSQL, Java and Visual Basic. Developed stored procedures, packages and database triggers to support Contractual Service modeling System, a Sales forecasting tool used by GE Power Systems.
• Upgraded several database environments to 8.1.7.4. Installed and Configured Oracle 9i database environments.
• Designed and implemented the Replication environment to support the reporting.
• Migrated databases from Sun 4500 to Sun -15K cluster.
• Refreshed the databases from production to UAT and QA environments
• Developed Stored Procedures / Packages and database triggers to support OLTP applications.

Platform: ERWIN 3.52/4.0, PLSQL, Oracle RDBMS 8.1.7.4, 9i, Oracle Partitioning, Sun Solaris 7/8, Sun-Fire 15000, Sun ES4500/5500, Veritas Cluster, Windows2000, Rational Clear Case/ Clear Quest, Oracle Enterprise Manager, TOAD, Tkprof, StatsPack, UNIX Shell Scripts
Confidential,Oman July 1999 – Nov 2000
Database Administrator

• Assisted a team of system engineers and database administrators in designing, building and deploying database environments on SVR4.2, Windows NT and Sun Solaris platforms for several clients.
• Supported production, QA and development databases, performed upgrades from Oracle 7.3 databases to Oracle 8. Mentored the other support staff on SQL and database Tuning.
• Assisted the development team in performance tuning of application developed using PLSQL, Oracle Forms and Oracle Reports.
• Performed capacity planning for the database.
• Designed and implemented backup recovery for the database environments using UNIX Shell Scripts / SQL.

Platform: Oracle 7.3.4, Oracle 8.0.5, Enterprise Manager, Designer2000, Discoverer2000, Developer2000 [Forms 6, Reports 3.0], SQL, PLSQL, UNIX [SVR4.2, Sun Solaris], Windows NT, TkProf
Confidential, Nov 1996 – June 1999
Confidential,CT
Software Consultant

• Developed various business processes of PULSE, a health care application used by Oxford Health Plans Inc. using Oracle Forms, Oracle Reports, PLSQL, Pro*C and Shell Scripts.
• Fine-tuned several processes written in Pro*C, PLSQL, Oracle Forms and Reports
• Re-designed several processes to meet the new business requirements of the client.
• Developed stored procedures, packages and PLSQL code to perform data conversion
• Prepared UNIT test plans and assisted the QA with integration testing and system testing.

Platform: Oracle Parallel Server [7.2/7.3], SQL, SQL Loader, PLSQL, Developer2000 [Forms4.5/Reports2.5], Designer2000, Pro*C, tkprof, SQL, IBM RS6000, AIX 4.1/4.2, Windows
Confidential,India Jun 1996 – Sep 1996
Systems Analyst

• Designed IHRS, Integrated Human Resource System as per the requirements of a manufacturing client. This system was integrated to Business/21 an ERP solution developed using power builder.
• Developed technical specification for Human Resource Module.

Platform: Oracle RDBMS 7.2, UNIX, Power Builder, SQL
Confidential,Oman Oct 1992 – June 1996
Software Engineer

• Fine-tuned the database and applications developed in SQL Forms and Reports.
• Installed Oracle Software and databases on UNIX, windows and Novell platforms.
• Implemented TIMICS – an ERP application for several customers on UNIX and Novell Netware platforms. Production supported the ERP application for W.J.Towell group companies and external clients.
• Converted data from Concurrent 3210/DMS32 platform to UNIX / Oracle platform. Developed SQL Loader scripts, SQL, P/L SQL scripts
• Supported Oracle Forms 3.0 to Oracle Forms 4.5 in Windows platform for a insurance company.
• Installed and configured the designer 2000 repository. Used designer2000 repository to generate the DDL for TIMICS application re-architecture project. Sized the tables and indexes. Maintained the designer2000 repository.

Platform: UNIX SVR 4.2, Windows NT, Novell Netware Oracle RDBMS 7, Oracle Forms [4.5/3.0], Oracle Reports2, 5, Designer2000, PLSQL, SQL, UNIX Shell Scripts, SQL Loader
Technical Skills
Databases / Tools: Oracle [7.x, 8i/8.0.x, 9.2.x, 10g], Enterprise Manager, TOAD, DB–Artisan, SQL Loader, RMAN
Data Modeling: ERWIN 3.52/4.x, Designer2000
GUI/Programming Languages: Developer2000 [Forms / Reports, PLSQL, SQL, UNIX Shell Scripts
Operating Systems: ICL UNIX SVR 4.2, AIX 4.x, HP/UX B11.11/9, Sun Solaris, Redhat Linux Advanced Server, Windows NT/ Windows XP
Education:
B.Tech,
[Major in Computer Engineering]
Professional Training
Oracle Database Administration, Oracle 10g RAC administration, Windows NT Administration, UNIX System Administration, Rational Clear Quest, Rational Clear Case, Six Sigma.