Manager Oracle
Resume:
BRIJ LAL
Total IT Experience: 14.8yrs.
Total DBA (Oracle, MSSQL, MONGOdb) experience: 14.8yrs.
Total Hadoop Administrator experience: 2.5yrs.
Linkedin Profile : http://in.linkedin.com/pub/brij-lal/22/398/b67
Facebook Profile : http://www.facebook.com BrijLKapoor
Twitter : https://twitter.com/BrijLKapoor
Skype id : brijlalk
CONTACT : +91-982-***-****
****.***@*****.***
Email ID :
CAREER SUMMARY: A quick learner, an experienced Oracle/MSSQL DBAs with vast experience on
deployments/support of Oracle RAC (9i,10g,11g,12c)/non-RAC (7,8i,9i,10g,11g,12c) and MSSQL 2008
environments, a well-founded ITIL V3 processes awareness, and a very cognitive in finding ways to innovate
which helps automate maximum processes for better system monitoring and support. Quite a vast experience
in many domains such Technology (Datacenter Infrastructure (DCS) Services), Banking, Finance and
Security, Manufacturing, Jewelry, Retail etc.
INDIAN National Skills Registry IT PIN: 891*********
VALID VISA: B1 – US (valid UPTO 2024)
CURRENT DETAILS:
LOCATION: PUNE CITY (INDIA)
DESIGNATION/LEVEL: Team Lead – Database Support
ROLES & RESPONSILITY: Oracle DB capacity planning and forecasting
Oracle SME
Team Lead (Oracle DBA) providing support in Infrastructure (Data-Center) services
environment
Handling multiple critical clients
Managing multiple projects deployments
Implemented the PCI-DSS audit requirements and DATA hardening guidelines.
MSSQL server support
MONGO DB Support
ONSITE EXPERIENCE: KENYA (AFRICA - 2003-2004) - 1 Yr. onsite assignment from ESS for ERP
implementations
US (San Francisco-CA and PHOENIX-AZ) – 3 months knowledge Transition and
Training
US (Redwood Shores – San Francisco) – 3 weeks visit to meet customers to
understand Business requirement and ongoing issues.
KEY ACHIEVEMENTS DURING THE EXECUTIVE ROLE
In SABA (during Dec’14),
I have received appreciations in migration project that involved moving customers from one
datacenters to another.
In SABA (during Feb’15),
Won a “STAR TEAM AWARD” for our migration team for best collaboration and meeting timelines.
In Mphasis (during 2008-2013 period), I have won many rewards on maintaining the “Winning
Attitude” and hence keeping the customer happy by following the innovative path and implementing
multiple improvements in day to day DB support activities.
In WIPRO Technologies (during Apr’06), the team was awarded with “BEST SQUAD” in the
whole BFSI (Banking, Finance, Securities and Insurance) vertical .
KEY STRENGTHS
Quick learner
Self-Motivated
Strong communication and interpersonal skills
Ability to handle simultaneous projects and meet deadlines effectively
Able to perform better under work pressure
Adapting easily to new protocols & changing environment
Proficient in building computer logic using PL/SQL & SHELL programming
Perseverance, innovative ideas and continually looking for better ways to accomplish tasks
SPECIALTIES:
Oracle Database technologies with RAC (9i, 10g, 11g, 12c)
Oracle RMAN
Data Guard (Disaster recovery setup)
Enterprise Manager Grid Control
Database handling on VCS (Veritas Clustering System)
Unix environments
HADOOP Administrator
Database Backups using Tivoli Storage Manager (TSM) and HP Data Protector (HPDP)
Managing Oncall in 24*7 Production Support Environment
PCI-DSS audit participation
Mongo DB deployment and administration
MS SQL deployment and administration
EDUCATION
A) Basic:
Degree Details & Year of passing
1. Masters (PG) Master in Computer Applications (MCA) – Jun’2000
2. Bachelors (Graduation) Bachelor in Science (B.Sc.) - Physics, Chemistry, Mathematics –
Jun’1997
3. Any Other Certificate Course in French, Jun’1999
B) Professional Certifications:
Certification Details (Institute & Year)
OCP 9i DBA Oracle Corporation, 2009
C) Trainings Attended:
Course Name Conducted By
Oracle10g RAC Oracle University, India (1 week regular Training)
Oracle Apps DBA Genesis Hyderabad, India (1 week regular Training)
ITIL V3 Mphasis Ltd.
HADOOP – Administrator Cloudera (OSSCube)
PERSONAL DETAILS:
PASSPORT ID: J9775574 (valid until Sep’2021)
MARITAL STATUS: Married
JOB PREFERENCE: Permanent (Full Time)
2nd AUG 1976
DATE OF BIRTH:
LANGUAGES KNOWN: English, Hindi
JOB OBJECTIVE
Apply my extensive DBA experience in achieving organization goals in line with future growth prospective. My
expertise in Relational Database Technologies and in-depth knowledge of DB Administration and Unix Shell
programming with my strong analytical knowledge can be fully tapped to help organization exceed in its core
competencies and achieve growth objectives. Always keen on learning new things quickly which help organization
remains competitive.
AUTOMATIONS AND INNOVATIONS
I have successfully completed few own creations alone using Shell Scripting programs on automating few
DBA tasks such as,
1. Automatically resizing datafiles after certain size range
2. Automatically adding new datafiles into tablespace to maintain the free space threshold without any
manual intervention.
3. Monthly DB reporting – db growth, capacity planning etc.
4. Few internal implementations to alert oncall DBA in advance on the backup failures due to tape server
maintenances
5. Automation of db creations
6. Automated administration tasks – backup cleanup, db locks, alert log monitoring, temp space and
tablespace monitoring, audit and trace file cleanup etc.
7. In-house Central monitoring of all databases – (In-progress)
EMPLOYMENT HISTORY
Company Name Designation Start date End date
12th Aug 2013
Team Lead – Database Support Till to date
1. Saba Software Pvt. Ltd.
22nd Apr’2013 09th Aug’2013
Associate Manager (Database)
2. Electracard Services - ECS (an Opus
company)
19th Apr’2013
Sr. Principal Infrastructure Engineer 21st Apr’2008
3. Mphasis Limited (an HP company)
03rd Jul’2006 10th Apr’2008
Lead Consultant
4. Computer Sciences Corporation
(CSC)
02nd Aug’2004 26th Jun’2006
Project Engineer
5. Wipro Technologies
13th Jul’2000 30th Jun’2004
Software Specialist
6. ESS (Eastern Software Systems
Ltd.)
EXECUTIVE SUMMARY
Major Job Responsibilities Includes:
A) ORACLE System/Application DBA
Acted as mentor for different application teams – data modeler/architect
Oracle Installation (non-RAC/RAC/VCS) & Configurations
Oracle patching (Apply/Rollback)
Database Creations (Manual/DBCA)
Upgrade Expertise (8.0.5 8.1.7 9i 10g 11g)
Migration Expertise (UNIX Env: Solaris RHEL, RHEL RHEL)
Administration - Real Application Cluster (RAC-9i,10g,11g,12c) / High Availability (HA)
OLS (Oracle Label Security) Implementation and Administration
TDE (Oracle Transparent data encryption) implementation & administration
Data Extraction using SQL *Reports
Data Uploading using SQL *Loader
Capacity Planning
Backup and Recovery Solutions (RMAN/normal hot backup or restore)
RMAN recovery (backup taken disks, tape using HPDP & TSM clients)
RMAN Cloning
Non-RMAN (normal) Cloning from last successful hot backup
Disaster Recovery methodologies (Physical standby) /DATAGUARD expertise
UNIX Shell Scripting
OEM/GRID control
PLSQL
Typical Day to Day Production Support activities
Implementing customer requests for database changes
Database Alert Monitoring & Issue Resolving
Performance Monitoring & Tuning (DB / SQL)
Recommendation on database parameter changes to customers based on db performance levels
Customer requests to setup export/imports (exp/imp, expdp/impdp)
Resolve backup Failures
Work with vendors/storage/network/UNIX teams
Resolve db space requirements
Identify/investigate the impacts of ORA-600/ORA-7445
Search knowledge base/Articles/bugs etc. on Oracle Support site.
Oracle Support interaction using Oracle web conferences for any P1/P2 production issues
Engaging Oracle Support on critical/other db problems by creating SRs
Approaching Oracle Duty Manager for escalations or to raise/change SR priorities
Typical Monthly database management activities
Oracle Patching (one-off bug fixes (if any), emergency security fixes (CPU/PSU) (if any))
Database growth reporting month on month basis
Capacity reviews
Forecasting to management
Typical Quarterly database management activities
Oracle Patching (one-off bug fixes (if any), security fixes (CPU/PSU) (if any))
Database management while OS upgrade/patching
Database growth reporting quarter on quarter basis
Capacity reviews
Forecasting to management
Typical Yearly database management activities
Oracle Patching (one-off bug fixes (if any), emergency security fixes (CPU/PSU) (if any))
Database growth reporting on yearly basis
Capacity reviews
Forecasting to management
B) MySQL DBA
Optimizing the server for performance which includes, space management, monitoring memory
usage, and diagnosing problems
Administering the server on a daily basis to ensure server availability and the ongoing health of
the system
Disaster prevention and recovery including creating consistent backups and restoring databases
in case of network, application, or hardware failure
C) MSSQL server DBA
Deployment of new sql instance
Backup setup
Day to day administration
D) Mongo DB
Deployment, Backup, Day to day administration
EDUCATION
A) Basic:
Degree Details & Year of passing
1. Masters (PG) MCA, Jun 2000
2. Bachelors (Graduation) B.Sc. (Physics, Chemistry, Mathematics), Jun 1997
3. Any Other Certificate Course in French, Jun 1999
B) Professional Certifications:
Certification Details (Institute & Year)
OCP 9i DBA Oracle Corporation, 2009
C) Trainings Attended:
Course Name Conducted By
Oracle10g RAC Oracle University, India (1 week regular Training)
Oracle Apps DBA Genesis Hyderabad, India (1 week regular Training)
ITIL V3 Mphasis Ltd.
HADOOP – Administrator Cloudera (OSSCube)
TECHNOLOGY EXPOSURE
Technology Details Experience
(No. of Months)
PROGRAMMING SQL/PL SQL 150
LANGUAGES UNIX Shell Scripting 101
C Familiar
C++ Familiar
JAVA Familiar
DATABASE (DBA) Oracle 7.0/8i 48
9i (RAC/nonRAC) 90
Oracle 10g (RAC/nonRAC) 100
Oracle 11g (RAC/nonRAC) 100
Oracle 12c (RAC/nonRAC) 12
MySQL 5.5.x 24
Mongo DB 24
MS SQL Server 24
MAINFRAME Creation of Tickets(INFO, SCHD, SPRs) 22
/ISPF/changeman (Preparation of JOBDOC and packaging) 22
ERP/ERM Oracle Applications (11.5.10.2) 36
EBIZFRAME 6i 40
MAKESS 5.0 ON THE NET 08
AVALON 9.2 Introduction
OPERATING SunOS (Generic)/Solaris 58
SYSTEMS Linux/RHEL 36
Windows XP/NT/2000 112
IBM AIX 15
HP-UX 11
DOS Familiar
Unisys UNIX U6K / 520 Familiar
H/W PLATFORM HP Compaq 60
HP Compaq Proliant 60
HP-UX 36
IBM p-series 15
Dell 36
GUI Oracle Forms 48
Oracle Reports 48
Oracle Discoverer 12
TOOLS and Nagios 24
ENVIRONMENTS NewRelic 24
VSS 54
CVS 30
PL/SQL Developer 36
SQL Navigator 24
TOAD 100
Oracle Enterprise Manager (OEM) 96
Oracle GRID Control 48
RMAN (Recovery Manager) 96
SQL Developer 60
Putty 112
WinSCP 50
HARVEST R7 (PEC 4.6.1) 03
vi Editor 50
IBM Clear Case Familiar
FTP 112
TELNET 41
secureCRT 43
Tivoli Storage Manager (TDPO) Familar
Veritas Cluster System (VCS) Familar
APPLICATION IIS 36
SERVERS Oracle 9iAS 19
WEB SERVERS Apache 11
CHANGE EMS – Remedy 43
MANAGEMENT USD 20
TOOLS Service Center Trained
HP Service Manager Trained
CRF - Forms (built in winword) 3
Jira- Atlassian 18
BIG DATA Hadoop (HDFS) 18
DOMAIN EXPERTISE
Securities - Banking, Finance, Securities & Insurance (BFSI) Domain
A High Level Expertise in Inventory Management, Manufacturing (Electrical High Tension Cables, Chemicals)
Point of Sale
Hire Purchase Management System (HPMS)
Development and Implementation of commercial Applications (Finance – Account Receivables, Account Payables,
General Ledger, Cost Management, Cash Management, Bank Reconciliation, Credit Card Reconciliation, Cheque
Reversal, Sales, Payroll, Purchase, Production Planning and Control)
Domain Specific Area in Domain
Payment & Card Industry (faced PCI-DSS audits and have implemented the guidelines in
1. Banking
production environments)
Production Planning & Control, High Tension Cable manufacturing
2. Manufacturing
Point of Sale (POS), Hire Purchase Management System (HPMS), Inventory management
3. Retail
AR, AP, GL, Cost Management, Cash Management, Bank Reconciliation, Credit Card
4. Finance –
Reconciliation, Cheque Reversal, Data Processing job
Securities
(BFSI)
Client Interactions, Initial Deployments Methodologies, Installation, DB Monitoring &
5. SYSTEM Core
Administration, Backup & Recovery strategies (RMAN backups, Classic hot backups,
DBA
BCV/BC bacups), Performance Tuning, Dataguard setup, Grid Control (OEM) setup,
Upgrades & Migrations, Cloning & Patching etc.
DBA Support to customers using SABA products (Saba Enterprise Cloud, Saba People
6. Learning and
Cloud, Saba Meeting (Centra), Saba Comartis, Saba Human Concept, Saba Pedagogue)
Talent
Management
PROJECT DETAILS
SABA Software Pvt. Ltd.:
Project(s) Installations (New Deployments) for SQL server, Mongo-DB, and Oracle databases, Capacity
Description Planning, Database table partitioning, Query tuning, Identifying performance bottlenecks and
fixes, Setting up monitoring tools/scripts, Database Migrations/Upgrades, Data-Guard setup
& Administration, Hot Backups & Recoveries, Relinking Oracle Binaries, RMAN Backups and
Recoveries, RMAN cloning, Refreshes using Hot Backups, TSM (Tivoli Storage Manager)
Backups, Exports, Imports, Data-Pump, Production Support and Handling client requests.
Enhancement/Development of scripts to automate processes for database monitoring and
taking actions. House-keeping of production databases. Checking Fragmentation & De-
fragmenting of database objects and Implementing solutions using Oracle PL/SQL
programming, SQL *Plus/ADRCI and UNIX Shell Programming. A tool based on checking all
monitoring aspects in datacenter and investigating issue from the past logs stored in HDFS
(administrator role).
Client(s) American Airlines, McDonalds, Yum, US Army, Pearson, Allina Healthcare .. to name a few as
there is a long list of customers.
Start Date August, 2013
End Date Till to date
Role / Database Team Lead Cloud Operations Lead
Responsibilities
Contribution Data purging solutions, Partitioning, Performance enhancements, Production 24*7 ONCALL
Support, Database Deployment (Installations, db creations), DB Administration & Monitoring,
Backup and Recovery strategies implementations, Housekeeping of all databases, db
Cloning, Applying Quarterly CPU patches, DB upgrades and Migrations, Interactions with
Oracle Support.
Environments & Oracle 10g/11g/12c, PL/SQL, secureCRT, SQL *Plus/ADRCI, UNIX Shell Scripts, vi Editor,
Tools winSCP, Filezilla, Putty/mRemote, JIRA, Parature
Operating System UNIX (Linux (centOS/RHEL), Windows XP 7/8
Project Location Pune, India
Team Size 6
Electracard Services- ECS (an Opus company):
Project(s) Experience in building data purging solution, database table partitioning, Query tuning,
Description Identifying performance bottlenecks and fixes, Experience in initial deployments such as
Database Installations/Setting up monitoring tools/scripts, Database Migrations/Upgrades,
Dataguard setup & Administration, Hot Backups & Recoveries, Relinking Oracle Binaries,
RMAN Backups and Recoveries, RMAN cloning, Refreshes using Hot Backups, TSM (Tivoli
Storage Manager) Backups, Exports, Imports, Datapump, Production Support and Handling
client requests. Enhancement/Development of scripts to automate processes for database
monitoring and taking actions. House keeping of production databases. Checking
Fragmentation & De-fragmenting of database objects and Implementing solutions using
Oracle PL/SQL programming, SQL *Plus/ADRCI and UNIX Shell Programming.
Client(s) Indusind Bank, LIC, Corp Bank, Capitol Bank, Nabil Bank, Sidharth Bank ltd. etc.
Start Date April, 2013
End Date August’ 2013
Role / Associate Manager (Database) – PCI-DSS audit, Implementing audit and security guidelines.
Responsibilities
Contribution Data purging solutions, Partitioning, Performance enhancements, Production 24*7 ONCALL
Support, Database Deployment (Installations, db creations), DB Administration & Monitoring,
Backup and Recovery strategies implementations, Housekeeping of all databases, db
Cloning, Applying Quarterly CPU patches, DB upgrades and Migrations, Interactions with
Oracle Support.
Environments & Oracle 10g/11g, PL/SQL, secureCRT, SQL *Plus/ADRCI, UNIX Shell Scripts, vi Editor,
Tools winSCP
Operating System UNIX (AIX 5.3/6.1), Windows XP/7/8
Project Location Pune, India
Team Size 3
Mphasis Ltd. (an HP Enterprise Services Company):
Project(s) Experience in initial deployments such as Database Installations/Setting up monitoring
Description tools/scripts, Applying quarterly Patches/One off patches. Monitoring using remote
administration scripts, Database Migrations/Upgrades, Dataguard setup & Administration, Hot
Backups & Recoveries, Relinking Oracle Binaries after OS patching, RMAN Backups and
Recoveries, RMAN cloning, Refreshes using Hot Backups, TSM (Tivoli Storage Manager)
Backups, Exports, Imports, Datapump, Production Support and Handling client requests in
the form of tickets in BMC-remedy tool. Enhancement/Development of scripts to automate
processes for database monitoring and taking actions. 11g/10g RAC environment
Administration, Adding/Removing nodes. House keeping of around 150 customer production
databases. Checking Fragmentation & De-fragmenting of database objects and
Implementing solutions using Oracle PL/SQL programming, SQL *Plus/ADRCI and UNIX
Shell Programming.
Client(s) Wells Fargo (ClearXchange), JP Morgan, Nike, Elli-Lilly, Nissan, Cablevision,
GlaxoSmithKline, Biogen, SHELL, Vodafone (UK), Palmone, Orbitz, Statefarm & various
EDS/HP Internal Application Database servers.
Start Date April, 2008
End Date Till to date
Role / Oracle SME/Lead DBA/Sr. Principal Infrastructure Engineer
Responsibilities
Contribution Production 24*7 ONCALL Support, Database Deployment (Installations, db creations), DB
Administration & Monitoring, Backup and Recovery strategies implementations,
Housekeeping of all Client databases, db Cloning, Applying Quarterly CPU patches, DB
upgrades and Migrations, Interactions with Oracle Support.
Environments & Oracle 9i/10g/11g, PL/SQL, secureCRT, SQL *LOADER, SQL *Plus/ADRCI, UNIX Shell
Tools Scripts, vi Editor, winSCP, BMC-remedy
Operating System UNIX (sunOS 5.8/9/10), Linux:rhel5 (Kernel: 2.6.18-53.1.21.e15), Windows XP
Project Location Pune, India
Team Size 6
Computer Sciences Corporation (CSC) Limited:
Project(s) Migration project Oracle Apps 11.5.10.2 databases from HP-UX to IBM-AIX, Oracle Apps
Description redirection to AIX database and services movement from one node to another.
Adding/Removing nodes into/from the Oracle RAC env. House keeping for Oracle 10g
databases. Checking fragmented db objects and de-fragmenting the database objects and
Production Support. Oracle DBA to support Oracle apps enhancements, maintenance,
security, cloning, patching and Implementing solutions using Oracle PL/SQL programming,
SQL *Plus and UNIX Shell Programming. Have worked on MySQL environments support too.
Client(s) General Dynamics Land Systems – Virginia (US), Whitbread (UK)
Start Date Jul, 2006
End Date Mar, 2008
Role / DBA Lead/Deputy Consultant
Responsibilities
Contribution Worked on OLS (Oracle Label Security) implementation. Defining paths for Coding, Test
Cases, Reengineering of code, Creating and managing Tablespaces, Managing and
administering RAC dbs. Creating and Managing UNIX Shell Programming using vi editor,
SQL *Plus Reports, Data uploading using SQL *Loader/External Tables, FNDLOAD,
Administrating Discoverer EULs and Discoverer Reports, Capacity Planning, DB Security,
Backups and Recoveries using RMAN, db cloning
Environments ERP (Oracle Apps11i (11.5.10.2)), Oracle 9.2.0.6/9.2.0.8/10g, PL/SQL, TOAD 6.5, SQL
*LOADER, SQL *Plus, UNIX Shell Scripts, UNIX vi Editor, Putty, USD, HARVEST R7 (PEC
4.6.1)
Operating System UNIX (IBM AIX version 5), HP-UX11i, UNIX (SunOS 5.8 version Generic), Windows XP
Project Location Hyderabad, India
Team Size 4
WIPRO Technologies:
Project(s) DBA support to application developments and Implementing solutions using Oracle PL/SQL
Description programming, SQL *Plus, SQL Navigator 4.3.1, UNIX Shell Programming, Clearcase
(Command Prompt) used to maintain Oracle and UNIX Shell Scripts versions and Web
based IBM Clear quest (BERT/PRISM) for generating EBTs (Electronic Bug Tracking) and
PRISM releases to support applications for their database related issues.
Client(s) Charles Schwab & Co. – San-Francisco (SFO & Phoenix - US), State-Street Corporation -
Boston MA (US)
Start Date Aug, 2004
End Date Jun, 2006
Role / Oracle DBA/Project Engineer
Responsibilities
Contribution Created a shake hand backend process with Java frontend (developed by Java Developer) to
upload excel file directly into the database using SQL*Loader. Maintenance support for
Oracle Databases, Database Backups and Recoveries using RMAN, Creating and managing
Procedures, Functions, Packages, Triggers, Tables, Indexes, Constraints and Tablespaces,
User Roles/Privileges, UNIX Shell Programming using vi editor, Performance Tuning
Environments Oracle 9i, PL/SQL, SQL Navigator 4.3.1, TOAD 6.5, and SQL *LOADER, SQL *Plus, UNIX
Shell Scripts, UNIX vi Editor, Clear Case
Operating System UNIX (SunOS 5.8 version Generic), Windows XP/2000
Project Location(s) Bangalore, India
Team Size 3
EASTERN Software Systems Limited:
Project(s) ERP (MAKess, eBizframe) implementation and databases support. A new national spare part
Description center (NPC) system has been developed. New production planning systems has been
developed for Cable/Chemical Industries. A new system of Hire Purchase Management
System has been developed. has been developed. A new system of point of sales and debtor
integration has been developed for vehicle servicing and selling of tyres for their 9 branches.
Client(s) Chemital Rai Ltd. – Mumbai (India), Iftex Petrochemicals Ltd. – Mumbai (India), Aryavart
Chemicals Ltd. - Mumbai (India), Bluestar Ltd. – Mumbai (India), Multimode Enterprises Ltd.
– Mumbai (India), Torrent Cables Ltd. – Ahmedabad (India), African Retail Traders (KENYA)
Ltd. – Nairobi, Kingsway Tyres (KENYA) Ltd. – Nairobi,
Start Date Jul, 2000
End Date Jun, 2004
Role / Oracle DBA/Sr. Software Specialist
Responsibilities
Contribution Installation and Deployment of ERP system. Database designing, ERD, Functional
Specification, Coding, Test Cases, Reengineering of code. Database tuning, VSS Control,
Client Interaction, handling ERP database support, Developing complex forms and reports,
Packages, Triggers, Procedure and Functions, Responsible for Database backups and
recoveries, Export/Import, Optimizing the Database performance at all times
Environments Oracle 8i/9i, Oracle 9iAS, PL/SQL, Developer/2000 ((Forms 6i, Reports 6i), (Forms 5.0,
Reports 3.0), (Forms 4.5, Reports 2.5)), PL/SQL Developer 5.0, IIS, Designer 2000 release
2.1.2, ERPs (MakESS 5.0, eBIZframe 6i)
Operating System Windows2000/NT 4.0, Unisys U6K / 520
Project Location(s) Mumbai, Ahmedabad, Nairobi (Kenya)
Team Size 3
Contact this candidate