Oracle DBA with 9+ Years experience

NICE KURIAN

Cell: 818-***-****

Email: aceolg@r.postjobfree.com

SUMMARY

. Strong experience in Information Technology industry specializing in the

arena of Oracle Database Administration and developed core skill sets in

installation, configuration and maintenance of Oracle Server 9i/10g/11g

on various operating systems includes Linux, Solaris and Windows Servers

in 24/7 productions.

. Good experience in handling multiple portfolios including DB

administration and IT infrastructure management which includes building

of server architecture for production, testing and development

environments.

. Strong experience in 24/7 production, testing and development

environments.

. Experienced in installing, upgrading and configuring various Oracle

software packages, troubleshooting and development tasks on various

platforms and performing advanced replication method using Streams.

. Experience in migrating Oracle 11g DB from Windows to Linux platform.

. Experience in creating and deploying ETL packages using SSIS to load

various format data into a data warehouse for OBIEE.

. Experience in data transfer between SQL Server and Oracle databases.

. Good experience in data loading utilities like SQL*Loader, logical

backups using full export, import and DATAPUMP.

. Experienced in performing installation and configuration of VMware ESXI

for Server Virtualization.

. Experienced in database migration from 9i to 10g and 11g and migrating

existing databases into RAC configuration.

. Good experience in conducting performance tuning specializing in SQL

tuning and database/instance tuning.

. Maintain focus on implementing the most cost effective deliverables for

specific client needs.

. Experienced in cable TV and telecom domain and also in Amazon RDS (Cloud

Service).

. Scripted & automated RMAN backups for databases on windows, Linux &

Solaris.

. Extensive experience in Oracle Dataguard and Grid Control.

. Experienced in performing database replication using snapshots,

materialized views and advanced replication methods with extensive

knowledge of Oracle Workspace concept and table versioning process.

. Experienced in developing and implementing backup and recovery strategies

and working on Oracle 11g R2 Spatial for GIS development.

. Good experience in migrating VM's between VMware platforms.

. Experienced in setting up rack based servers and associating SAN storage

in co-ordination with hardware team.

. Proficient in using shell scripts, batch & windows scripting.

. Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS

Names, V$ and DBA views.

. Experienced in performance monitoring using Dynamic Performance Views, EM

Performance Monitor and Statspack.

EDUCATION

. Master of Science in Information Technology and Management, Periyar

University, Salem, Tamilnadu, India.

2003

. Bachelor of Science in Electronics, Bharathiar University, Coimbatore.

CERTIFICATIONS

. Oracle Certified Associate DBA (9i).

TRAINING

. Linux Administration and Networking, Govt. Polytechnic, Kalamassery,

Kerala.

TECHNICAL SKILLS

Operating Windows NT/2000/XP/2003, Oracle Enterprise Linux, RHEL 5,

Systems Fedora 14 and Cent OS.

Language SQL.

GUI Tools PowerBuilder, Visual Basic 6.0 and Seagate Crystal

Tuning Tools Reports 8.

ETL Tools TKProf, Explain Plan, SQL Trace, Spotlight, AWR/ADDM

Reports

SSIS

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

Others Oracle DBA Studio, Backup Scripts and TOAD,OEM, DBCA,

GRID CONTROL

AWARDS

. Awarded Model Employee of the Year 2010 by the previous employer.

EXPERIENCE

Client: City Of Vancouver, Washington Feb 2014

- Present

Oracle Database Consultant

. Responsible for analysis, upgrade, maintenance and implementation of

database in client location.

. Executed cross platform migration of databases.

. Performed Oracle database upgrades from 10g to 11gR2.

. Automated RMAN Backup and Recovery through UNIX Shell Programming and

CRON.

. Installed OBIEE on RHEL and configured RCU.

. Created ETL using SSIS for implementing Oracle BI.

ISpace Inc., CA

Nov 2013 - Feb 2014

Senior Oracle DBA

Responsibilities:

. Provide Oracle and SQL Server database technology consulting services and

solutions.

. Design and modify database architecture to suit the project requirements.

. Reviewed queries for performance and provided recommended solutions.

. Create and assign roles, privileges and profiles to users.

. Configure database backup (hot backup, cold backup and export/import).

. Involve in performance tuning based on issues reported.

Immco Software Solutions Pvt Ltd.

Mar 2013 - Sep 2013

Senior Database Consultant

. Utilize Oracle Automatic Storage Management (ASM), Oracle Managed Files

(OMF) and Recovery

Manager (RMAN) to improve I/O performance, reduce administration overhead

and provide a

comprehensive backup and recovery strategy.

. Worked on implementing and testing disaster recovery system, using

RMAN/Dataguard (physical standby) and custom written scripts.

. Performed resizing of SGA and tablespaces, added data files as when

needed.

. Managed disk and disk groups in ASM 10g/11g.

. Performed Oracle database upgrades from 10g to 11gR2 .

. Maintain focus on implementing the most cost effective deliverables for

specific client needs.

. Automated RMAN Backup and Recovery through UNIX Shell Programming and

CRON.

. Cloned databases from production to test and development environments

using RMAN.

Immco Software Solutions Pvt Ltd., Cochin, India

Dec 2010 - Mar 2013

Assistant Manager Database and Information Technology Infrastructure

Client: Time Warner Cable, USA

Feb 2012 - Mar 2013

Senior Oracle DBA (Cable TV and Telecom)

Project: IBISS

Environment: Oracle 11g (Spatial).

Time Warner Cable Inc is among largest providers of video, high-speed data

and voice services in United States, connecting more than 15 million

customers to entertainment, information and each other. IBISS (web based

GIS Solution) is a Java, web-based, GIS-enabled decision support system

(using Oracle Mapviewer) allowing import of static engineering drawings

into a Data Warehouse enables faster updates. The current version provides

an attractive and user-friendly interface for enterprise-wide use and

access of latest network asset information. The primary advantage of

project is faster; more efficient and more convenient service to client.

Responsibilities:

. Involved in Oracle Spatial database configuration and schema creation.

. Provided technical expertise and support in designing database systems.

. Responsible for analysis, support, maintenance and implementation of

database in client location.

. Created databases and modified database structure.

. Migrated 11g database from windows to Linux platform.

. Involved in database backup (hot backup, cold backup and export/import).

. Involved in complete and incomplete recovery options using User Managed

and RMAN.

. Created and assigned roles, privileges and profiles to users.

. Monitored database security by enabling database auditing feature.

Client: Comcast Cable, USA

Dec 2010 - Feb 2012

Project: PCE

Senior Oracle DBA Level 2 (Cable TV ad Telecom)

Comcast Corporation is largest mass media and communications company in

world by revenue. It is the largest cable company and home internet service

provider in United States and nation's third largest home telephone service

provider. PCE (Project Cost Estimator) is a web-based application for

estimating and managing labor and material costs for cable TV construction

projects. PCE integrates resources from engineering, construction,

warehouse and finance into a single project outline.

Responsibilities:

. Designed and modified database architecture to suit project requirements.

. Migrated existing data from Oracle 10g to 11g.

. Provided technical expertise and support in designing database systems.

. Deployed database in cloud based server architecture.

. Involved in Oracle database configuration and schema creation.

. Responsible for analysis, support, maintenance and implementation of

database in client location.

. Created databases and modified database structure.

. Configured database backup (hot backup, cold backup and export/import).

. Executed complete and incomplete recovery procedures using custom scripts

and RMAN.

. Created and assigned roles, privileges and profiles to users.

. Monitored database security by using database auditing feature.

Environment: Oracle 11g.

Saranga Broadband Communications Pvt Ltd., Cochin, India

Aug 2008 - Dec 2010

Senior Oracle DBA

Client: KDHP

Project: DR using Oracle Dataguard

The Kanan Devan Hills Plantations Company Private Limited (KDHP) succeeded

Tata Tea Limited to focus on growth of its branded tea business. It is

largest tea producer in South India. The project was based on requirement

of client to setup a disaster recovery database using Oracle Dataguard

technology in Cochin location and US Cloud server for production data based

in head office.

Responsibilities:

. Conducted environment study to analyze present configurations.

. Performed required steps to enable environment as DR ready.

. Setup dedicated VPN between client and remote locations in US.

. Managed installation and configuration of Oracle on Linux 5.6 for

recovery DB.

. Configured Dataguard using Oracle 10g.

. Created custom scripts to monitor log apply and performance of DR.

. Configured database backup (hot backup, cold backup and export/import).

Environment: Oracle 10g.

Datamate InfoSolutions, Cochin, India

May 2006 - Aug 2008

Oracle DBA

Client: Various Hospitals

Project: Mediware HMS

Environment: Redhat Enterprise Linux 4 and Oracle 10g.

Datamate InfoSolutions (P) Ltd is a software development and service

company, with a client list of over 800 in five countries, catering mainly

in fields of healthcare and hospitality. Mediware provides quick hospital

management system with utmost accuracy and transparency enabling to manage

projects in the best possible way.

Responsibilities:

. Analyzed present database architecture and provided suggestions for

improvement.

. Co-ordinated the DB team in various installations and migrations.

. Performed sample data migration for testing purpose.

. Installed, configured and maintained Oracle database.

. Migrated the existing system data into new architecture.

. Configured backups using automated scripts.

. Created standby servers based on requirements and criticality of data.

. Setup dedicated VPN between client and home office.

Anna Group/Anna Aluminum Company, Cochin, India

Sep 2004 - Sep 2005

Software Support Engineer

. Installed, configured and maintained Oracle database on windows and

Linux.

. Migrated the existing system data from 8i to 9i .

. Configured backups using automated scripts.

. Created new security groups and roles for easier user administration.

[pic][pic][pic]

Contact this candidate