Oracle Engineer

[pic][pic] JOHN XAVIER [pic] [pic]

***, ****** ****, ****

Greenwich,

RI - 02818, U.S.A

401-***-****(M),

401-***-**** (H)

E-Mail:

*********@*******.***

SUMMARY:

> Over 16 years of experience in database administration in various

versions on various platforms in USA, Canada, UK, Qatar & India.

> Experienced in implementing and maintaining commercial (Trading &

Manufacturing), Banking & Finance and Airline applications and

databases.

> Excellent and extensive experience in Database Administration, Design,

Development, IT Readiness, Project Management, System Administration &

Hardware& Software Support, System Analysis/Design, Implementation of

Commercial Application and Testing on Oracle 7.x/8.x/9i/10.x/11.x and

Ingres databases using Erwin, Developer 2000/4.5, PL/SQL Developer,

Toad, Test Director and Shell Scripting on Various plat form like

Windows NT/2K / Sco Unix / HP Unix / Solaris and Z/os. Strong trouble

shooting, problem solving, re-engineering, Project Management and

analytical skills. He also has hands on experience with oracle 9i, 10g

Real application cluster (RAC) installation and maintenance. A Team

player and managed teams with good communication and leadership

skills.

EDUCATION:

> Master of Business Administration in Systems (Alagappa University,

India)

> Honors Diploma in Software Engineering (APTECH, India)

> Bachelor of Science (Bharthidasan University, India)

CERTIFICATION:

> ITIL (Information Technology Infrastructure Library)

> OCA DBA 9i (Oracle Certified Associate)

> MCSE 2000 (Microsoft Certified Systems Engineer)

> CompTIA A+ (Hardware Engineer)

TRAINING:

? Project Management Professional ? ITIL ? MCSE ? Oracle DBA

PRIMARY SKILL:

> Oracle 7.x / 8.x / 9.x/ 10.x/ 11.x Database Administration,

Monitoring, Backup & Recovery, Tuning & Security of DB, Export /

Import, RMAN, SQL Plus, Statspacks & AWR, ASM, SQL loader and Real

Application Cluster (RAC), Oracle BI and Oracle Grid.

> Hardware Sizing and Capacity Planning, Shopping List, Installed

Environments (Dev, Training, Live), Communication Network, Operational

& Support Procedures, Localization of Data & Detailed (Architecture)

Technology Analysis.

> Maintaining Safe Environment by resolving IT Infrastructure issues

such as Software, Hardware, Database, IT Security, Operations and etc.

PROJECT PROFILE

March 2007 TO Present - IT Consultant (INFOSYS)

KEY COMPETENCIES AND EXPERIENCE: INFOSYS CLIENTS

Production Support DBA (CITIZENS Bank, RI, US):

John Xavier's responsibilities include handling all kinds of DBA request,

Single point of contact for onsite/offshore communication, DR Excise, Data

Guard, 24X7 on call support, providing the recommendation for process/

Technical enhancement, mentoring and transferring knowledge to the team.

Handling the 650 database on various platforms.

DBA LEA (Viterra, SK, Canada):

John Xavier's responsibilities include handling all kinds of DBA request,

Single point of contact for onsite/offshore communication, 24X7 on call

support, providing the recommendation for process/ Technical enhancement,

mentoring and transferring knowledge to the team. Handling the 175 database

on various platforms.

Oracle Project DBA (Royal Bank of Scotland, London/ India):

John Xavier's responsibilities included the following activities

> Configure, Test and implement enterprise oracle database

infrastructure solution for Unix or Windows systems, which support

business system requirements.

> Configure appropriate Oracle Infrastructure components and help

define appropriate DR / Recovery steps for all Unix or Windows

systems( Regardless of Size, SLA and recovery time)

> Ensure that test backups and recoveries happen before projects go

live and make sure that backup designs fir the business

requirements and SLAs

> Ensure that full capacity and performance testing is completed for

all components of the Oracle design, when appropriate, for oracle

RAC and NON-RAC environments.

> Ensure all Oracle Components are designed to meet security

standards and use encryption where appropriate.

> Ensure we deliver Fit-For-Production systems with all required

supporting documentation.

> Work with operational Services Oracle Support Team to ensure any

new Oracle technology is fully productionised and documented.

> Work with Oracle Development DBA team to ensure all Oracle Systems

meet development standards

> Provide ongoing consultancy to projects where there is an Oracle

component.

> Maintain the Oracle 10g RAC environment and troubleshoot

performance problems.

Transition Coordinator (NORDSTORM, India):

John Xavier's responsibilities include to support Transition for Various

small accounts like Oracle, SQL Server, Solaris and Windows with respect to

Knowledge Transfer / Due Diligence / Transition Plan / Execution / Steady

State

Project Experience (Other Organisations):

Description:

Project involves to support 16 x 5, 24 x 7 Production, Development &

Testing Oracle Database which is running on various platforms like Windows,

SCO Unix, Solaris &HP Unix. It involves Database server installation,

upgrade, patches management, backup and recovery, maintenance, monitoring,

disaster recovery and Support to User requests

Responsibility:

> Maintaining the large no of 100 (20 X5) databases in various

environment

> Installation of Oracle 9.x / Siebel / BO/ Toad / Test Director and

other applications

> Design, Creation, Optimisation, Backup & Recovery, and Security of

database

> Performing Tuning activities

> Provides technical support on problems in an operational

environment.

> Monitoring growth of the database to take proactive action

> Keep updating the database standards and adhering the same.

> Managing OS backups, RMAN Backups and logical backups.

> Monitor and use diagnostic files (Alert log & Trace Files)

> Daily monitoring of data reports for space usage, fragmentation

issues, daily backups, alert logs for typical oracle errors.

> Oracle installation, configuration, upgrade, migration, patch

management and Capacity planning

> Proactive maintenance of databases for high availability and

performance

> Database Refresh, re-org, Export/Import, SQL*Loader, Analyze system

and session level waits & Locks and clear bottlenecks

> Application and memory tuning using TKPROF & STATSPACK

> Creating the database, tablespaces, schemas, rollback segments,

tuning of logical and physical Oracle structures

> Creating and managing users, profiles, privileges and roles

> Configuring Listeners, TNS names and SQL*net.

> Maintain the Oracle RAC environment

> IT Readiness, Environment Admin, Development & Implementation of

commercial Application

Contact this candidate