SHANOJ KUMAR V

Mobile: +* (***) *** - **** Email: ac7xjs@r.postjobfree.com

* ***** ****, ******** ****, ON, L4S 2R2

Summary:

• Oracle Certified Professional with over 15 years of IT experience in database administration and support.

• Certifications: OCP (12c, 11g & 10g), Oracle Database 11g Performance Tuning Certified Expert (OCE), ITIL V3 Certified and LPIC-1(Linux).

• Oracle Certified Expert in oracle database performance tuning has solved over 100 database performance problems.

• Quality oriented IT professional with notable success in Banking, Airlines, Retails, FMGC, Telecommunication and Media projects.

• Maintaining an online technical blog - contributed more than 54+ articles based on ‘Database Administration’ real life scenarios on http://shanojkumar.wordpress.com/ – 258,429 visitors all over the world.

• Supervised a team of database administrators and technical infrastructure team members. Created documentation on best practices for database performance tuning and Oracle application installation practices.

• Instructor of one of the most appreciated courses (Oracle Dataguard 12c) on Udemy with an average rating of 5 star.

Skills :

Databases (10 years), Oracle (10 years), RMAN (10 years), GoldenGate (5 years), Oracle DataGuard (8 years), Oracle Performance & tuning (5 years), MS SQL (5 years), Oracle RAC+ASM(8 years), MemSQL (2 years) and MySql (3years).

Technical Expertise:

Database : Oracle (9i,10g,11g, 12c), MSSQL Server (2012/14/16), DB2, MemSql & MySql

High Availability : Oracle RAC, Dataguard and ASM

Data replicatiion : Oracle Golden Gate and Dataguard.

Operating Systems : Solaris, Linux, Microsoft Window and AIX

Tools : Oracle EM(13c, 12c, 11g), Toad and Oracle SQL Developer and IntroScop.

Storage Systems : ASM, HP SAN EVA 4000, Dell PowerVault MD3000, EMC, IBM DS8700

Helpdesk Tools : HP Service Manager, Jira, ServiceNow

Cloud : AWS, Oracle Cloud.

Specialties : Senior level Oracle production DBA, RAC/DataGuard, Oracle Golden Gate, Oracle Performance & tuning, and Oracle pluggable and multitenant architecture. Good understanding of Exadata

Experience:

Sept ’18 – Present : Polaris Consulting & Services Ltd., 130 King St W, Toronto, ON M5X 1E3.

Roll & Designation: Lead Consultant – database technologies

Project/ Client Details:

Bank of Montreal (BMO): The Bank of Montreal, operating as BMO Financial Group, is a Canadian multinational banking and financial services corporation. One of the Big Five banks in Canada, it is the fourth-largest bank in Canada by market capitalization and assets, as well as one of the ten largest banks in North America.

Responsibilities:

• Supports to production databases (Standalone/RAC/Datagaurd/ASM).

• Extensive Performance Tuning using OEM/AWR/ADDM/ASH/IntroScop.

-Tune database code (Query Tuning, packages, procedures, functions, triggers, etc) for the application as required.

• Backup and recovery and RMAN

• Upgrades and Patches

• Provide support to the customers/developers to resolve their technical problems with the data and/or database

Jun ’16 – Aug ‘18: Wipro Technologies.

Roll & Designation: Lead Administrator (Senior Production Oracle Database Administrator)

Project/ Client Details:

Mastercard Incorporated: Is a leader in global payments and a technology company that connects billions of consumers, thousands of financial institutions, and millions of merchants, as well as governments and businesses around the world.

Comcast Corporation: Is an American multinational mass media conglomerate and is the largest broadcasting and largest cable television company in the world by revenue.

Responsibilities:

• Provided 24 x 7 supports to production databases (Standalone/RAC/Datagaurd/ASM).

• Perform duties of a Database Administrator of Oracle & MS SQL Server in Development, QA & Production environments.

• Trouble shooting and being able to mentor database specialists and handle Escalated calls.

• Cloning PDBs from local and remote PDBs including the refreshable PDBs

• Performing backup and recovery, PITR and flashback database in a multitenant container

• Managing the applications, application containers, application PDBs, and common objects

• Database Migration - form oracle 11g to 12c.

• Unix/Linux/Solaris scripting for environment operations using ksh, bash, python, awk, and perl with Oracle backend.

• Designed, developed, and tested merge automation scripting (bash, ksh).

• Implement hot, cold & logical backup plans. Customization & development of cron jobs, shell scripts.

• Managing very large production database environments.

• Oracle 11g & 12c Grid/ASM and RAC/Standalone Installation, Configuration & Administration.

• Applying Patches to RAC/Non-RAC databases.

• Setup and configured OEM 12C and 13C: Setting up OMS Servers, agent installs on servers,configure new databases for monitoring, Setup jobs, alerts, setting metrix values for notifications etc.

• Monitor and troubleshoot an Oracle GoldenGate configuration, implement the security options

and apply oracle GoldenGate patches.

• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.

• Install, Configure and Maintain Oracle Database 12C in AWS Cloud

• Deploy Oracle Database 12c in Multiple Availability Zone in AWS Cloud

• Backup and Restore Oracle Database 12c in AWS

• Tune Oracle database 12c running AWS Cloud

• Monitor Oracle database running in AWS Cloud

• Proficient in installation/ configuration/ Deployment RAC on Exadata machines.

• Hands on experience on ASMCMD,IORM,DBFS,Flash Cache, DCLI and ADRCI

Jun ’14 – May '16: HCL Technologies.

Roll & Designation: Senior Production Oracle Database Administrator.

Project/ Client Details:

PepsiCo, Inc. : Is an American multinational food and beverage corporation headquartered in New York, United States.

Responsibilities:

• Provided 24 x 7 supports to production databases (Standalone/RAC/Datagaurd/ASM).

• Database administration worked with Oracle (9i,10g,11g, 12c) and maintaining Oracle server on HP-UNIX, AIX, Linux and Windows.

• Database Migration - form oracle 11g(11.2.0.0.0) to 11g(11.2.0.4.0).

• Database/Schema/table refresh of/in Dev and QA databases from production databases on client request.

• Tablespace management: Creating/dropping/adding/resizing of tablespace/data files.

• Experience in Performance tuning of oracle databases using OEM, AWR, ADDM and ASH.

• Backup,cloning,refresh and recovery using RMAN Methodologies Datapump and EXP/IMP.

• MS SQL Server administration and management of the entire development, QA and production environment.

• Day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), Oracle Spatial, scheduling jobs.

April ’12 – Jun ‘14: Future Focus Infotech.

Roll & Designation: Senior Production Oracle Database Administrator.

Project/ Client Details:

Malaysia Airlines: Is the world famous Airline system.

Target Corporation: Is an American retailing company, It is the second-largest discount retailer in the United States.

Sony Pictures Entertainment, Inc.: Is the American television and film production and distribution unit of Japanese multinational technology and media conglomerate Sony.

Responsibilities:

• 24 x 7 production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

• Upgraded oracle databases from 9i to 10g, 9i, 10g to 11g, upgraded all production databases to oracle 11gr2(11.2.0.7) along with the grid upgrades in a rac environment.

• Applied patches to oracle databases and oracle applications.

• Responsible for optimizing the queries and application tuning. Perform sql tuning.

• Management of users, schemas, objects partitioning the tables & indexes.

• Implemented disaster recovery exercises using oracle data guard technologies including fail-over and switchover operations.

• MS SQL Server administration and management of the entire development, QA and production environment.

• Managing/troubleshooting MySQL in production and developer environments on linux (Level one tasks)

May’08 – Feb’12: Colours Group of Companies, Abu Dhabi, Dubai, U.A.E

as Database Administrator

Responsibilities:

• Responsible for life cycle development, testing and production performing 9i, 10g & 11g, RAC installations, configuration, tuning and troubleshooting

• Monitoring and administrating oracle rac databases on oracle 11g clusters .

• User accounts creation and table space creation and managing the table spaces using the oracle default compression.

• Performed patch set updates, CPU patches on rac databases to minimize the security issues and provide bugs fixes and configured and upgraded to oracle 11gr2 from 10g.

April’03 – May’08: Colours Group of Companies, Abu Dhabi, U.A.E as Software Support Executive (ERP).

Responsibilities:

• Experienced software engineer with fine knowledge of ERP customization, implementation, support & troubleshooting of applications.

• Good quality presentation with strong analytical and problem solving skills.

Professional Training:

• Oracle DBA 10g OCP Certification, ORACLE UNIVERSITY, 2007.

• Oracle 11g RAC, Grid Infrastructure & ASM Administration Training – TCS ILP,2013

• Oracle GoldenGate 11g: Fundamentals for Oracle Ed 2 PRV ORACLE UNIVERSITY, 2016.

• AWS Certified Solutions Architect - Associate 2017 by A CLOUD GURU – UDEMY, 2017.

• Oracle 12c Data Guard Administration - UDEMY, 2017.

Education:

• Post Graduate Diploma in Computer Application (AICTE & NCVT).

• Bachelor of commerce (Business), M.G. University, Kerala.

• Diploma in Computer Office Automation (NCVT Approved).

• Diploma in GUI's- Ms Windows (NCVT Approved).

Additional Information:

• Blog: http://shanojkumar.wordpress.com/

• LinkedIn: http://www.linkedin.com/pub/shanoj-kumar/14/845/343

Contact this candidate