Core Competencies

Oracle Database Administration

Cloud-Stack Expertise

Data Analysis/Modelling

Cost optimization Projects

Risk Assessments and Control

Unix/Linux Administration

Client Relationship Management

Solutions Consulting

Performance Tuning

Cross-functional Coordination

Team Leadership

CERTIFICATIONS

Amazon Solution Architect -Associate

Oracle Certified Professional (OCP) in 9i Database Administrator

Brain bench Certified Oracle PL/SQL Programmer

High-energy technocrat with the distinction of executing prestigious projects of large magnitude within strict time schedules, targeting senior level assignments as Database Administrator

Profile Summary

Enterprising DBA administrator with 15 years of experience in Oracle Database Administration (DBA), Oracle Parallel Server, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design

Leveraged expertise in end-to-end data management interactions and dependencies across complex data pipelines and data transformation and how they impact business decisions

System Design, Object-Based Design, Data Modeling, PL/SQL, Unix, NT, Shell Scripting, Installation, Configuration, Development, Administration, Oracle Architecture

Experienced in optimization, backup and recovery, performance monitoring and Tuning of Oracle 9i/10g/11g/12c & Oracle 11g RAC databases in IBM AIX, Red Hat Linux, Oracle Enterprise Linux and windows environment for production system support leading global teams in a wide variety of cutting edge environments

Expertise in Upgrades, Patches, SAR support, Cloning, Backup and Recovery, performance tuning, capacity planning, disk space management, script development, database security, auditing, troubleshooting, database reorganizations, high availability (RAC implementation, Dataguard), RMAN, & expdp, impdp and documentation

Efficient in cloning, backup, and recovery, performance tuning by analyzing AWR, ADDM, and ASH reports

Hands on experience with logical backups, Hot/Cold backups, RMAN incremental backups. Conducted recovery and cloning of databases using (RMAN) Recovery Manager

Performed collecting performance statistics using ASH, Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor)

Technically sound in PL/SQL programming, functions, packages and database triggers and troubleshooting

Exposure to Amazon web services such as EC2 instances, EBS volumes, S3 bucket and Amazon RDS (Oracle, Postgres)

Successfully worked on oracle utilities Opatch, EXPDP/IMPDP, Oracle Enterprise Manager (OEM)

Led data collection, cross-channel data integration, reporting and insights, dashboards, data visualization, data mining, competitive intelligence, and site surveys

Success in leveraging end-to-end perfection across Incident, Service, Problem, Escalation & Project Management with excellent in managing issues that could impact end-to-end delivery operations, performing root-cause analysis for remedying technical difficulties & providing direction

Career Timeline

IT SKILLS

RDBMS: Oracle 12c, Oracle 11g Release 1 & Release 2, Oracle 10g Release 1 & Release 2, Oracle 9i, AWS Services

High Availability, Tuning & Monitoring Products: Oracle 10g RAC, Oracle 11g RAC

Tools & Utilities : ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader

Operating Systems : Solaris 9/10, Linux RHAT 4/5,6, AIX 5.2/5.3, Microsoft Windows NT, 2000/2003/2005

Programming Languages : PL/SQL

Version Control Software : IBM Clear Case

WORK EXPERIENCE

Jul’18-Present

Itron India Pvt. Ltd., Bengaluru as Technical Support Engineer

Key Result Areas:

Providing database support for the IEE MDM (Meter Data Management) & helping the team in resolving the database

related tickets raised by customer

Installing Oracle Database (11.2.0.2) and Oracle Database (12.1.0.2) Unix/Windows environment and migrating the

Oracle 11G database to 18C

Producing the custom script in Oracle PL/SQL for customer as part of billable service and billed for 72 hours &

responsible for IEE MDM product related enhancement and fixes

Performing basic DBA activities such as creating schemas, managing users, assigning roles & privileges, space

management & backup of the database by using RMAN for large databases and import/export for schema backup

Observing daily and weekly database backup (HOT, COLD, Logical, RMAN backups) and again running if a job fails or

take appropriate measures to fix the problem

Monitoring the database performance (DB and SQL) related issues during PE testing of IEE MDM product by using

AWR, ASH, and TKPROF and clarified plan utilities

Jun’14-Jul’18

Pega Systems, Bengaluru as Principal System Engineer

Project: PegaCloud-Operations

Key Result Areas:

Worked as an Oracle DBA Administrator/Cloud Engineer in UNIX environment

Managed 100 + enterprise-level Oracle 11g/10g database systems & achieved the goal of 99.99% availability at an acceptable level of performance in Amazon cloud

Deployed the DB health monitoring & analyzed, re-index, statistics, block corruption, index status, tablespace

management which reduced the S1 incident by 50%

Programmed the scripts to DB growth which helped to plan the database space required & ORA- errors in the

mail, to proactively work on those errors

Led the project to convert Oracle database storage from NON-ASM to ASM & transferred the customer’s in-house

databases over 10TB to Amazon cloud

Implemented the Oracle database changes required for migration of database from Oracle to Postgres (RDS instance)

Functioned together with product support and engineering teams when cross-functional coordination is required

and implemented performance tuning like WAL, explain plans, OS/server/connection/memory settings

Monitored OS, DB, application alerts through Zenoss and CSC, internal ticketing tool

Organized databases, planning, and testing stages through implementation, go live and support Phases

Jun’12-Jun’14

Oracle Financial Services Software Limited, Bangalore as Senior Principal Consultant

Client: Wells Fargo

Period: Jan’14-Jun’14

Key Result Areas:

Delivered the DBA support for the bank for FLEXCUBE 12.0 implementation & database health monitoring scripts

Maintained Oracle cluster and Oracle ASM database

Monitored UAT, development, testing, and simulation database environment & provided the backup and

recovery recommendation for the database

Organized the tablespace layout for Flexcube databases

Provided DBA support mock migration and tuned the migration process of FCUBS and FCDB by analyzing the AWR

Oracle 11g Rel2

Performed Oracle table partitioned for the tables with huge data for performance benefit for the online and

batch processing system and reports & performance tuning of Flexcube EOD batch process

Onsite Project:

Client: Mashreq Bank, Dubai

Period: Jul’12-Oct’13

Key result Areas:

Provided the DBA Support for the bank for FLEXCUBE implementation

Aug’10-Jun’12

Manhattan Associates, Bengaluru as Senior Database Administrator

Key Result Areas:

Provided technical services to monitor and maintain environment of Oracle production, development, and test

databases that includes:

oInstallation of Oracle Database (11.2.0.2) and grid (11.2.0.2) in Unix/Windows environment

oConfiguration and maintenance of Oracle ASM database

oMigration the Oracle (11.1.0.7) database to Oracle (11.2.0.2)

oConversion of Non ASM database to ASM database

oLiable for DOM product related enhancement and fixes

oPatching database for an upgrade or bug fixing

Monitored, identified and fixed the database performance (DB and SQL) related issues during PE testing of DOM product by using AWR, ASH, and TKPROF

Tracked all database changes during development life cycle by using IBM ClearCase as version control software

Apr’07-Aug’10

Oracle Financial Services Software Limited, Bangalore as Associate Consultant

Key Result Areas:

Carried out installation of Oracle database in Unix/Windows environment

Identified the performance issue, maintained TKPROF and AWR report and examined the report to find the blockage

Formed users and roles and maintained system security & estimated storage requirement, creation of tablespaces

and other database primary objects

Executed deployment of proof of concept and feasibility testing of Oracle Enterprise Manager 10g data masking pack

for Flexcube product & Oracle Streams on Flexcube product

Project Executed:

Client: Dhanlakshmi Bank, Bengaluru

Period: Apr’10-Aug’10

Assignments:

Upgrade Oracle (9.2.0.4) database to Oracle (9.2.0.8) database

Upgrade Oracle (9.2.0.8) database to Oracle (11.1.0.7) database

Convert NON-RAC database to RAC

Performance tuning for Flexcube

Onsite Projects:

Client: Respublika Bank, Azerbaijan

Period: Oct’09-Jan’10

Assignments:

Oracle 11g database server/client installation (On AIX)

Oracle 11g application server in installation (On AIX)

Implemented RMAN Utility for database backup

Performance tuning of the Bank database

Oracle 11g Dataguard Setup

Flexcube deployment on Oracle SOA Suite

Client: Kabul Bank, Dubai

Period: Jun’09-Jul’09

Client: International Bank of Azerbaijan, Azerbaijan

Period: Sep’08-Dec’08

Client: Dubai Islamic Bank, Dubai

Period: Sep’07-Nov’07

Assignments:

Oracle 10g database server/client installation (On AIX)

Oracle 10g application server in installation (On AIX)

Implemented RMAN Utility for database backup

Performance tuning of the bank database

Oracle 10g Dataguard Setup

Upgraded production database from Oracle 10g release 1 to 10g release 2

Jul’05-Mar’07

iCodeSoft Pvt. Limited, Bangalore as Software Engineer

Project Executed:

Client: VRL Travel

Project: WTS (Waybill Tracking System)

Product: HMS (Hospital Management System), School Management System

Technology: VB .NET, C#, Oracle 9i, Crystal Reports, Windows 2000

Team Size: 4

Role: Developer

Key Result Areas:

Designed, analyzed & coded modules & involved in capturing system requirements, database design and

performance tuning

Recognized the stored procedures and normalized the Oracle Server database

ACADEMIC DETAILS

B.E. ( Computer Science) from M.I.T College, Mandsaur, RGPV Bhopal in 2005

PERSONAL DETAILS

Date of Birth: 19th July 1983

Address: No. 32, Samrudhi Nilaya, Flat No. 204, 15th Main, Hal 2nd Stage, Indiranagar-560008, Bengaluru

Languages Known: English & Hindi

Tushar Jajoo

adg8rb@r.postjobfree.com +91-988*******

Itron India Pvt. Limited

2018-Present

Pega Systems

2014-2018

Oracle Financial Services Software Ltd.

Oracle Financial Services Software Ltd.

2012-2014

Manhattan Associates

2010-2012

2007-2010

ICodeSoft Pvt. Limited

2005-2007

Contact this candidate