ARUN VIJAYAKUMAR

***-*** ****** **. ****, MISSISSAUGA, ON L5A 1W6 PHONE: 647-***-**** EMAIL: acw17b@r.postjobfree.com

CERTIFIED ORACLE DATABASE ADMINISTRATOR

Highly accomplished detail oriented, Oracle 10g certified DBA with 8 years of expertise in 10g, 11g, 12c and SQL Server 2012/2014 databases, performance tuning, Database upgrade, Unix Shell scripting and Database security.

Experience in crisis management, Disaster Recovery and High Availability to increase reliability and maximize productivity.

Proficient in Oracle12c database, Cloud Control, Container and Pluggable database creation, heat map and automatic data optimization, Query Optimizer and Data redaction.

Proficient in Backup and Recovery and Database upgrade from 10g to 11g and 11g to 12c.

Excellent communication and problem solving skill with ability to work independently and within a team environment under pressure and meet tight deadlines.

SKILLS AND KNOWLEDGE

Backup/Recovery RMAN, IBM Tivoli Storage Manager

Database Technologies 12c Enterprise Manager Cloud Control, 11g Active Data Guard, DG Broker, RMAN,ASM, RAC, Database Upgrade, 12c Multitenant Container database management, Flashback CDBs and PDBs, Performance tuning, Cloning, Security Patches, Auditing, Datapump, Statspack, AWR, ADDM, SQLT, ASH

Operating Systems IBM AIX, HP UX, Solaris, RHEL and Windows Server 2008/2012

Databases Oracle 10g, 11g, 12c, SQL Server 2012/1014, Postgres

Tools /Utilities TOAD, OEM, IBM Director

Programming Languages SQL/PL SQL,TSQL, Shell Scripting

Incident/Change Management Remedy, Managenow

PROFESSIONAL EXPERIENCE

ORACLE Consultant, Canadian Business College, Toronto 2014 – Present

Perform Database and Query Tuning.

Worked on Oracle 11g RAC database, Backup & Recovery, online/offline backups, Physical and logical backups (Import/Export), Oracle Datapump, complete recovery with and without RMAN complete/incomplete recovery with archiving, Recovery manager and recovery catalog maintenance, configured Dataguard physical standby / logical standby database for High Availability (HA) database environment.

Working with Oracle Support, creation of Service Requests for Oracle Software, database, Grid Control, RAC related issues.

Ability to demonstrate multi-tasking capability, contingency planning, risk assessment and cost benefit analysis.

Conducting workshops for 12c database upgrade and new features.

Managing training program for Oracle Database 12c, 11g, 10g, 9i in accordance with business needs.

Senior ORACLE Database Administrator, IBM 2009 - 2013

Implemented, Tested and Maintained Oracle 11g Active Data Guard as a disaster recovery solution and ensured maximum database uptime.

Developed UNIX shell scripts to schedule database refresh using RMAN, expdp and impdp.

Implemented database upgrade from 10g to 11g for 350 databases with size up to 3 TB.

Created materialized views, database links for data replication and distributed transactions.

Designed and Implemented Disaster recovery drills.

Utilized OEM, SQLT, ADDM to identify potential performance bottlenecks.

Applied Security, CPU and PSU Patches on standalone and RAC databases.

Configured and maintained RMAN backups through Tivoli Storage Manager (TSM) tapes for all the production databases.

Collaborated with other team members in high availability production environment providing on-call support and worked with systems architects and Development team to design, Create database objects, deploy into production environment

Analyzed and audited Databases and Implemented best security policy.

Troubleshoot, Resolved and provided root cause analysis for issues with Database servers and suggested /applied fixes.

Database Consultant Clover Infotech, Mumbai, India 2007 – 2009

a) CLIENT: SBI Life Insurance, India.

Ensured appropriate backup and recovery procedures are in place for faster restore & Recovery and are properly executed

Automated and performed Oracle database backups and database refreshes (impdp, expdp, and RMAN) using Unix Shell scripting and windows scripting

Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements.

Performed and monitored Routine maintenance, Alert log file and addressed Tablespace issues.

Evaluated storage structures and worked with Oracle Support to resolve performance issues.

Implemented user security policies to Control Resource Usage.

Attended day-to-day problems in the Oracle database and took suitable actions for trouble shooting.

b) CLIENT: ING Vysya Bank

Planned, Implemented and tested Data Guard.

Installed, Maintained and Supported Oracle 9i and 10g Production and development databases on Linux, UNIX and Windows Platforms.

Applied Security, CPU and PSU Patches.

Handled Backup and recovery using RMAN and Tivoli Storage Manager (TSM).

Refreshed and cloned database using Export/Import and RMAN backup.

Nascent Technologies, Kerala, India 2005 – 2007

CLIENT: VivaMed Health Care

Managed Oracle Storage Structure and Configured Database for faster restore & Recovery.

Performed Routine maintenance, Tablespace management, Performance monitoring and tuning

Configured User Profiles and Monitored disk usage and tablespace usage

CERTIFICATIONS

Oracle Certified Associate 9i

Oracle Certified Professional 10g

EDUCATION

Workplace Business Communication, Ryerson University 2016

Master of Computer Applications (MCA), Mahatma Gandhi University, India 2005

Bachelor of Science – Computer Science, Mahatma Gandhi University, India 2002

Contact this candidate