Oracle Project

Neal Joseph

Phone: 314-***-****

E-mail: jna36d@r.postjobfree.com

OBJECTIVE

To Lead, Challenge and be Challenged in an Esteemed Organization for its increased

Productivity and Benefits where both my Professional and Personal Skills are Contributed,

Valued and Rewarded.

SUMMARY

12.6 Years of Experience in IT industry, extensively on Database Administration.

Involved as a Senior Oracle DBA & Data Architect on projects with Oracle RAC

Databases, Golden Gate and EDW(Enterprise Data Warehouse - Data Replication)

Installations, Upgrades, Migrations, Administration of Oracle 11g/10g/9i/8i/7.3 both

RAC & Non RAC Databases on UNIX (AIX/HP/Sun Solaris) and Windows machines.

Experience in collecting ASH, ADDM & AWR reports on Oracle 11g/10g Databases

towards Performance Tuning, Database Tuning and Tuning at OS level.

Experience in Capacity Planning, Oracle Flexible Architecture Conventions, I/O tuning,

Memory Tuning, Performance Tuning, Backups(RMAN, SQL Back Track, BCVs, Avamar &

Net backups), Recoveries, Optimization, Networking, Troubleshooting.

Well versed with Tools for Installing, Configuring, and Managing Oracle RAC such as

Oracle Universal Installer (OUI), Server Control (SRVCTL), Cluster Ready Services

Control (CRSCTL)

Experience in setting up Disaster Recovery Sites/Fail-Over Testing.

Technically sophisticated with Oracle Enterprise Manager (OEM), Grid, Statspack

Reports, Explain Plans, SQL Trace and TKPROF.

Configuration and administration of Standby Databases and applying redo logs to

protect enterprise data from failures, disasters, errors, and corruptions using Oracle’s

Data Guard Feature.

Disk Space Management involving managing archives, space allocation to various

table spaces and also capacity planning for various objects in databases.

Experienced in OS performance monitoring tools like tar, vmstat, iostat, sar, ulimit.

Worked with External & Internal Audit Compliance Teams to Enforce and Maintain the

Integrity & Security of the Databases.

Strong design skills with Logical Data Modeling, Physical Data Modeling and

Metadata Management for OLTP (Relational) and OLAP (Dimensional) systems. Proficient

in Data Normalization and De-Normalization methods.

Expertise in Batch Monitoring, automated many jobs using CRON, DBMS Scheduler.

Strong experience in using PL/SQL, SQL Loader, in designing, implementing and

performance tuning SQL queries / views

Implemented Industry Standards & Best Practices relating to enterprise metadata

management, data modeling standards, naming conventions and impact analysis.

Reporting and Investigating the Alert Log Messages, Grid Alerts and various advance

checks to prevent outages.

Quick response to production outages, Periodic performance analysis & instance tuning

24x7 On-Call Production Support DBA working on a primary/ secondary pager

rotation; and supported on holidays, weekends and beyond regular hours.

2

EXPERIENCE PROFILE

Wipro Technologies Ltd., USA

Satyam Computer Services Ltd., USA

Wesley Institutions., Hyderabad, India

– Jan’2011 to Till Date

– March’ 2004 to Jan’2011

– March’ 2000 to Feb’ 2004

TECHNICAL PROFILE

Operating Systems

RDBMS

Programming

Languages

Scripting Languages

Tools

Database Utilities

AIX 5.1, 5.2, 5.3, 6.1, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8,

9, 10, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/

2000/XP.

Oracle databases 11g R1 & R2 / 10g R2 / 9i / 8i / 7.3, SQL

Server 2005, FoxPro, FoxBASE, dBaseIII+

SQL, PL/SQL, Java, C, C++, Fortran, COBOL.

Shell Programming, HTML, CSS, JavaScript, VB Script

Oracle SQL Developer, Toad, Putty, Remote Desktop

Connection, VNC, Tivoli, Remedy, Clearcase, MKS, Ms-Visio,

Team Viewer, HP Mercury, ResolveIT, Infoman, VirtualTech,

Virtual System, Exceed. Perigrine, Autosys, Maestro..etc

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster,

ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump,

Export, Import

PROJECT #1

Client: CITI BANK, St Louis, MO.

Role: Senior DBA, Oracle

Responsibilities

Installations, Upgrades, Migrations, Administration of Oracle 11g/10g/9i/8i/7.3 both RAC

& Non RAC Databases on UNIX (AIX/HP/Sun Solaris) and Windows machines.

Performing Upgrades from 9i/10g to 11g and Applying VTM Patches.

Involved in Migration Process of huge Databases across the Data Centers.

Performance Tuning of Various Applications running on Oracle 11g/10g/9i databases.

Worked with External & Internal Audit Compliance Teams to Enforce and Maintain the

Integrity & Security of the Databases.

Maintenance and monitoring of 150 oracle 11g/10g/9i database instances.

Job scheduling for creating and refreshing materialized views, materialized view logs

and dimensions for Oracle Data Mart.

Managing the DST Patch Schedule and Applied DST patches on more than 25 servers.

Performed switchover to standby database during fail-over Testing.

Attending all Project Meetings with all Teams for any new Project to be initiated.

3

Nov’ 2006 - Till date

Planned for contingencies, security, risk assessment, patch upgrades and standard

operating procedures for mission critical systems.

Coordination with the team and ORACLE Support for troubleshooting the issues.

Maintain and plan for Disaster Recovery Process and Backup Policies in coordination with

Infrastructure Team.

Initializing monthly maintenance schedules and implementing the schedules.

Expertise in Batch Monitoring, automated many jobs using CRON, DBMS Scheduler,

Autosys, AbInitio and Maestro Schedulers.

Tuning the Oracle RDBMS (database initialization parameters, redo log files, archiving,

recommendations as per CPU or Memory utilizations etc.)

Maintenance of separate Production/Quality/Development/Test regions and monitoring

health check on daily basis.

Scheduling All Backups, Producing Backup Report of All Databases and Reporting to Sr

management with Daily Status.

Conducting Team Meetings, Publishing Meeting Minutes with updated Issues & Concerns.

Maintenance and support (24x7) for mission-critical databases and servers

Environment

Oracle11g/10g RAC, Grid, OEM, Clearcase, AIX 5.3, Sun Solaris, Windows 2003, Remedy

Erwin R7 (Model Mart, Data Modeling), SQL Developer, Toad, Putty, Remote Desktop

Connection, VNC, Tivoli, Remedy, Clearcase, MKS, Ms-Visio, Team Viewer, HP Mercury,

ResolveIT, Infoman, VirtualTech, Virtual System, Exceed, Perigrine, Autosys, Maestro

PROJECT #2

Client: GE, CT

Role: DBA, Oracle

Responsibilities

Production support and Database System infrastructure development for 8i/9i/10g.

Installed and Configured Oracle RAC on AIX, Sun Solaris and Windows 2003 Server with

2 node cluster on OCFS2 and ASM.

Upgraded 9i to 10g RAC on Windows 2003 environment.

Planned, redesigned and reorganized various Oracle databases.

Migrated SQLServer 2000 Databases to Oracle 10g -- All stored proc's, shell scripts and

jdbc programs

Recovery management and supervision of the technical team to restore the database in

case of system failure.

Migrate Oracle to Linux from HP-UX PA-RISC and ITANIUM RAC Environment using

Service Guard and ASM

Implementation of backup and recovery, monitoring procedures, on-going support and

performance tuning.

Handling various technical aspects like product documentation, software designs, coding

of modules, quality compliance, monitoring critical paths & taking appropriate actions.

Developed automated scripts (Eg: check Database usage, Table space usage,

Generate statistics for tables and indexes, check fragmentation, check roles and their

privileges..Etc)

4

Mar’ 2004 – Nov’ 2006

Analyzed the reporting needs of these areas - reviewed the source system database

designs; reviewed lists of data elements developed by I.T. and business people;

interviewed analysts responsible for the areas; and reviewed existing reports.

Tuned Complex SQL Queries using Explain Plan statistics and Tkprof Utility.

Co-ordinate with development Team on all aspects of Technical Development of the

Project with adherence to Six Sigma methodology for Quality Assurance.

Design and develop new Forms and reports for the application.

Recommended

architecture standards and principles. Recommended industry and technology best

practices

Approve all production schema changes, Approve changes to database design

Control all migrations of Oracle schema objects, Design and implement a backup &

recovery system

Environment:

Oracle 10g/9i, Grid, OEM, Clearcase, Sun Solaris, Windows-2000, Linux, SQL Developer,

Toad, Putty, MKS, Ms-Visio, Team Viewer, Exceed

PROJECT #3

Client: VOLVO Engineering & Co, Bangalore, INDIA

Role: DBA, Oracle.

Responsibilities

• Creation of Database as per the requirement and monitoring the same.

• Maintenance of separate test/production regions.

• Planning and Taking regular logical backups using Export and physical backups.

• Software Installation, Patch installation, migration, software updates, configuration

• Managing Database Structure, Storage Allocation, Table/Index segments, and

Rollback segments, Constraints, Database Access, Roles and Privileges.

• Backup & Recovery, import and exports

• Created various PL/SQL packages, procedures and functions used by application.

• PL/SQL coding for jobs automation, SQL loader to load data.

• Tuning the Oracle RDBMS (database initialization parameters, redo log files,

archiving etc.)

• Provide guidance and technical support for developers on accessing Database.

• Database resource monitoring (table space usage and fragmentation, I/O loads,

rollback segments, space planning etc.).

• Creating users/roles, granting privileges, auditing

• Developed automated scripts (Eg: check Database usage, Table space usage,

Generate statistics for tables and indexes, check fragmentation)

• Prepare documentation on best practices for backup and recovery.

• Installing and upgrading the Oracle server and application tools

• Creating primary database storage structures (tablespaces) after application

developers have designed an application

• Modifying the database structure, as necessary, from information given by

application developers

• Allocating system storage and planning future storage requirements for the database

system

• Creating primary objects (tables, views, indexes) once application developers have

designed an application

• Ensuring compliance with your Oracle license agreement

5

Mar’ 2002 - Feb’ 2004

Planning for backup and recovery of database information, Backing up and restoring

the database

Contacting Oracle Corporation for technical support

•

•

Environment:

Oracle8i, D2K, TOAD, SQL*Navigator, Microsoft Project, Visual Source Safe, MKS, UNIX, MS

Windows.

PROJECT #4

Client: G.S.I (Geological Survey of INDIA),Hyderabad, India - Mar’2000-Feb’2002

Role: Developer

Responsibilities

• Involved in Requirement Analysis towards preparing the SRS.

• Involved in preparing LDD, PDD (Logical & Physical Design Documents).

• Creation of Database as per the requirement and monitoring the same.

• Created various PL/SQL packages, procedures and functions used by application.

• PL/SQL coding for jobs automation, SQL loader to load data.

• Crystal Reports & Reporting through Active X Controls.

• Wrote and tuned hundreds of complex SQL scripts and SQL queries, procedures and

functions for various application packages of different releases in Billing, distribution,

and other customer related categories.

• Queries from users regarding complicated processes, acronyms, column source and

definition, description of tables are being answered and problems were solved.

Environment:

Oracle 7.3/8i, PL*SQL, SQL*Server, TOAD, SQL*Navigator, VB6.0, Microsoft Project, Visual

Source Safe, Rational Clear Case Linux, UNIX, MS Windows.

EDUCATION PROFILE

•

•

Masters in Computer Applications(M.C.A)

Bachelors in Computer Science (B.Sc Computers)

Contact this candidate