Manager Oracle

SANDEEP CHHABRIA

Middleburg Heights, OH *****

Mobile: 917-***-**** Email Id: accji7@r.postjobfree.com

QUALIFICATIONS:

• OCA/OCP Certified(10g, 11g)

• 2 years of extensive experience on10g, 11g on Linux & UNIX Platforms.

• 8 years of Professional Experience in IT Industry.

• Experience with Oracle 10G/11G Installation, Administration, Monitoring, Performance Tuning,

Database Backup and Recovery.

• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with

Export/Import)

• Strong written & communication skills.

• Multi Lingual(English/Hindi)

• USA CITIZEN – OPEN TO RELOCATION

TECHNICAL PROFILE:

Databases: Oracle 10,11g

Operating Systems: Win XP SP2 & SP3, Red Hat LINUX, UNIX

Dba Tools/Utilities: OEM,Data Guard,RMAN,GRID CONTROL,TOAD, SQL Loader,Plus

EDUCATION & CERTIFICATIONS:

Forest Hills High School, Forest Hills, NY

Stony Brook University, Stony Brook, NY

Oracle Certified Professional Certifications (10g, 11g OCP)

PROFESSIONAL EXPERIENCE:

Prem Computing Solutions, New York, NY July 2013 – Present

JR Oracle Database Administrator

• Troubleshoot tickets raised on live environments by the application and development teams for

production support and various other tasks from increasing size of a table space, analyzing a

schema, reset password or create new user account, debugging an database transaction error,

defragmenting and reorganizing DB Objects, raising CRS change requests and implement them.

• Resolving root cause assignments for long or reoccurring issues in production environment.

• Managing Control files, Data files, Databases Job Queues, Redo Logs, Archiving, Rollback

Segments, Undo Segments, Table spaces, Table, Indexes.

• Understand Memory Requirements

• Internal error handling, Use of materialized Views, SQL Tuning, Handling Locks

• Understand and troubleshoot Oracle Internal Errors

• Handling of database corruption, setting the environment variables.

• Work on permissions and authorizations (User creation, Roles & Privileges)

• Knowledge of using Export/Import utilities also using 11g data pump (expdp / impdp)

• Knowledge of using SQL*Loader

• Using RMAN as a recovery manager to schedules backups and perform recoveries.

• Installation of Oracle 11g

• Configure and manage Standby systems

Case Western Reserve University, Cleveland, OH August 2012 July 2013

Technical Support Analyst

• Performed hardware and software installations in accordance with university standards.

• Increased Customer satisfaction ratings.

• Provided first level contact and problem resolution for users with hardware, software and

application problems.

• Provided desktop support, troubleshooting desktop, hardware, software, applications and related

problems for onsite and remote users.

• Communicate with University staff to understand problems and resolve in a timely manner.

• Provided accurate and timely logging of problems and resolution for problems in the Help Desk

ticket system.

• Troubleshoot campus faculty & staff computers when problems are reported; both software and

hardware issues.

Software Pundits, Valley Stream, NY April 2011 July 2012

JR Oracle Database Administrator

• Installed Database depending on the requirement of Client.

• Worked on Oracle 10g Database.

• Worked closely with Production Support team

• Monitor databases for troubleshooting & tuning.

• Upgrading Databases as per requirement.

• Running HOT/COLD backups.

• Used RMAN as a recovery manager to schedule backups and perform recoveries.

• Actively participated in design & implementation team.

• Performed database administrator tasks including installation, upgrades, backup/recovery,

monitoring, optimization & tuning.

Blue Cross Blue Shield, Little Rock, AR Dec 2006 – Feb 2011

Programmer Analyst

• Identify the Database objects that would be needed to create and deliver them to the development

team.

• Monitor the changes in requirement and constantly keep the database model in sync with the

changing requirement.

• Fix performance issues identified by the QA team.

• Created many Indexes for better performance.

• Created PERL scripts for data migration.

• Used PERL, DBI/DBD for SYBASE connection.

• Created documentation for the performance testing.

• Designed and developed many SYBASE Tables, Stored Procedures and Triggers.

References: Available Upon Request

Contact this candidate