INDUSTRY EXPERIENCE HELD
: Banking ( Mauritius Commercial Bank), Finance ( DCDMC,
Representing
Andersen Worldwide ), Telecom ( British Telecom), Shipping ( P
& O Nedlloyd Ltd) and Sugar
Industry.
SKILLS
PROFILE
Relational
DatabasesOracle 9i, Oracle 8i, Oracle 8.0.x, Oracle 7.x (
Administration of Oracle involving Installation, Configuration,
Security Management, Performance Monitoring &
Tuning, Backup and Recovery, Schema Manager, Storage Manager, Net8
Configuration Assistant, Database Assistant, Security Manager and
other applications of Oracle’s Enterprise Manager. Also hands-on on
Export and Import
Utilities)
Thorough exposure on the Advanced OEM utilities
for carrying out various DBA activities like Oracle Expert,
Diagnostic Packs)
Middle Tier
ToolInternet Application Server 8i/9i ( iAS 9i Rel1/
Rel2)
along with necessary configuration to support multiple
databases/Intermediate Servers with extensive Forms Server
Configurations supporting socket and http
modes.
Oracle Application Server (4.0.8.1, 4.0.8.2)
installation and administration. Also Web-enabling Oracle Databases
using PL/SQL following Argents Security for the
web.
Deployment of Applications on the web using the
combination of Oracle Portal, Single Sign-On and Oracle Login
Server.
CASE
TOOLDesigner 2000 / 6i (Repository
Administration) mainly concerning imports, exports and managing
workareas and
containers.
Operating
SystemsCompaq Tru64, IBM AIX, SUN SOLARIS, HP-UX, SCO
UNIX Rel 5.0,
UNIX SVR4, Windows NT/2000, NOVELL NETWARE 4.x, Linux- SuSe, Red
Hat, Jool.
SoftwaresSQL
*PLUS, Procedure Builder, Oracle supplied Database packages,
Developer 2000 v2.1(Forms 5.0, Reports 3.0), Developer 2000
v1.5(Forms 4.5, Reports 2.5),
Developer 2000 v6.0( Forms 6.0, Reports 6.0), SQL forms 3.0, SQL
Reportwriter 1.0, Forms 4.5 under UNIX., Jdeveloper
3.0.
Programming
Languages
PL/SQL, Shell
Programming
Oracle
Utilities
SQL Loader
MiscellaneousOMS installation and configurations to
support management and administration of databases using OEM admin
tool. Statspack Viewer, iFS Manager
etc.
All of these coupled with
decent user interface skillsExperience Summary ( Onsite
Clients)
United Kingdom - Senior Oracle DBA with P & O
Nedlloyd Limited (Feb’01 – Till Date)
United Kingdom – Oracle DBA/ Web Administrator with British
Telecom (2000- 2001)
Mauritius,
Malawi, South Africa – Oracle Analyst (DBA/Developer) with DCDM
Consultings Representing Andersen Worldwide, SC. (1999 –
2000)
Mauritus – Oracle Programmer/Analyst with State
Informatics Limited, Partner Oracle Corporation (1998 –
1999)Major
Assignments include·Oracle DBA /Web Administration for PONL in a
development cum 24/7 environment for mission critical OLTP
databases. ( LONDON, United Kingdom)·Database Administration and Web Security
Administration for British Telecom Plc.
in
(SWINDON, LONDON –United Kingdom )·Application support and Database
Administration
for Mauritius Commercial Bank(client) in MAURITIUS.·Sugar Estate Management Information System
customization for the Cash Book Module of DCDM Consulting
(Representing Andersen Worldwide, SC ) in MAURITIUS.·On-site administration and support
for
various modules of GRAMIS system in MALAWI.·Coding and Design of Project Control and Resource
Management System for State Informatics Ltd ( Partner, Oracle
Corporation ) in MAURITIUSEXPERIENCE :
Crains Technology Limited ( Mauritius)
- Employer
Mahindra
British Telecom ( INDIA/UK) -
EmployerBirlasoft (UK)
Ltd ( United Kingdom)
- EmployerEDUCATION (Academic
and Professional ) &
CERTIFICATION
·Bachelor of Computer Engineering(First Class throughout)
from Bombay University , Fr. Conceicao Rodrigues Institute of
Technology, INDIA
·Diploma in Computer Engineering from M.H.SS Polytechnic
with Distinction
throughout.
·Oracle Certified Database Administrator for 9i/ 8i ( OCP
DBA 9i/8i).
·Sun Solaris 8 System Administration I course from Sun
Microsystem’s Authorized Education
Centre .
·Brainbench Certified Master Oracle Developer 2000
Programmer
·Brainbench Certified Oracle 8 Database
Administrator
·Instructor Led High Availability Course on ( Real
Application Clusters, Data Guard
& Advanced
Replication).
·OLN Course on Apps 11i
DBA.
·Ranked Among Top One Percent Certified
Professionals in the world on Oracle Developer 2000.(
1999-2001)
·Oracle Enterprise Certified Professional Course from
Oracle Edn, India covering Oracle DBA, OAS Administration, Oracle
Developer, Jdeveloper and Designer Case Tool for Oracle Application
Developer and Web Deployment Master
Program.
·Sun Solaris 8 System Administration I course from
Sun Microsystem’s Authorized Education
Centre .
·NetG CBT Courses for OCP
7/8/8i/9i
·CBTS Systems Courses for OCP
8/8i
·Training on Advanced Oracle 8 DBA from DBA Consultants
LTD, INDIA.
·Training on Administering MS Windows NT Server version
4.0 at Microsoft TEC.( 3 days
)
·Training on MS Windows NT Core Technologies vercion 4.0
at Microsoft TEC.( 5 days
)
·Techniques for an Empowered Workforce by
DEVELOPMENT DIMENSIONS INTERNATIONAL(DDI)
EXPERIENCE SUMMARY
Feb 2001- Present : Birlasoft (UK) Limited
(United Kingdom )Position
: Oracle Database Administrator /Web Security
AdministratorClient Site
: P & O
NedlloydCountry
: United KingdomEmployer
: Birlasoft (UK ) Limited ( United
Kingdom)Project
: FOCUS4 (OLTP System )
P&O Nedlloyd is world’s second
largest shipping company. The company’s IT infrastructure is spread
over two major hubs USA and Europe and has got 300+ production and
development databases with 520+ sites world-wide. Company's
complete IT related activities including development, testing and
production support are centrally controlled from London
Hub.
As an Oracle
DBA main responsibilities are
:§Manage production and development of distributed
database environments (40+) meeting the service level
requirements.
§Setup multiple databases and web servers(iAS
8i/9i,Apache,Forms Server,portal) environment.
§Keep 24*7 mission critical databases up and
running.
§Propose and Evaluate the use of RAC, Shareplex
&
Dataguard for the existing
systems.
§Installation, configuration and
upgrade/migrate
of Oracle and Web
Servers.
§Monitor database and application performance and
perform tuning as required using Statspack and other
utilities/tools like SQLLAB, I/Watch
etc.
§Implement replication techniques using
snapshots.
§Carry out extensive cloning of database
environments injcluding databases making use of
replication.
§Setup Oracle Management Server for Remote
Administration of multiple bases serving OEM
clients.
§Designer 6i repository
management.
§Make sure system resources are optimally used and
load is evenly balanced.
§Manage database backups and make sure a sound and
fast disaster recovery is
possible.
§Prepare capacity plans for production
databases.
§Advise management on all issues concerning Oracle
software.
§Lead DBA in Design and Implementation of new
Database and Applications
systems.
§Design Database backup and recovery procedures
and strategies.
§Help developers in tuning the application using
efficient SQL techniques.
§Installation and administration of Internet
Application Server and monitor their
performance
§Liase with vendors, especially Oracle for Bugs
fixes and TARs.
§Analyze the infrastructure requirements for new
projects and manage the environment build
process.
§Setting up technical standards and procedures and
ensuring their
implementation.
§Streamlining the existing processes and writing
scripts for automation of routine
tasks.
§Database
enhancements
Install Oracle Software and patches – (Oracle
7, 8, 8i)
Install and configure Internet Application
Server 8i /9i for Web
Deployment.
Install and configure Oracle Management Server
for administering remote
nodes.
§To investigate implementing new Oracle8i/9i
features with in the database environment (Table partitioning,
Resource Manager, Dynamic SQL
etc.)
August
2000- February 2001 : British Telecom (United Kingdom
)Position
: Oracle DBA /Web Security Administrator
(Team Leader)Client Site
: British TelecomCountry
: United KingdomEmployer
: Mahindra British Telecom
(INDIA)Project
: Central Data Store (Warehousing Application)
British Telecom is the world’s third largest
telecommunication company. The company’s IT infrastructure is
spread all over United Kingdom and has got 600+ development and
production bases in a shared as well as distributed environment.
Company’s IT related activities including development, testing and
production support are controlled from their various offices spread
all over
Resposibilities:
§Keep 24*7 mission critical databases up and
running.
§Install and configure Oracle software and
database instances on Compaq Tru 64 and Sun
Solaris.
§Installation, configuration and upgrade of Oracle
server software and related
products.
§Review requirements for new database objects for
enhancement projects.
§Maintain Production and Development environment
bases consisting of multiple datamarts.
§Setup Oracle Management Server for Remote
Administration of multiple bases serving OEM
clients.
§Designer 6i repository
management.
§Lead the team of four DBA/technical
specialists.
§Make sure databases are tuned for best
throughput.
§Make sure system resources are optimally used and
load is evenly balanced.
§Manage database backups and make sure a sound and
fast disaster recovery is
possible.
§Prepare capacity plans for production
databases.
§Lead junior DBAs and developers on all database
issues and provide them necessary help and
guidance.
§Advise management on all issues concerning Oracle
software.
§Design Database backup and recovery procedures
and strategies.
§Help developers in tuning the application using
efficient SQL techniques.
§Installation and administration of Internet
Application Server and monitor their
performance
§Liase with vendors, especially Oracle for Bugs
fixes and TARs.
§Analyze the existing environments and plan for
upgrades and enhancements.
§Database/MT
enhancements
Install Oracle Software and patches – (Oracle
7, 8, 8i)
Install and configure Internet Application
Server 8i /9i for Web
Deployment.
Install and configure Oracle Management Server
for administering remote
nodes.
§To investigate implementing new Oracle8i features
with in the database environment (Table partitioning, Resource
Manager)
June 1999-
March 2000 and May 2000 -June 2000: De Chazal Du Mée Consulting,
Mauritius ( Representing Andersen Worldwide
SC)Client
Site
: Mauritius Commercial Bank.Position
: Oracle DBA/ Business Analyst (Grade
A)Country
: MauritiusEmployer
: Crains Technolgies Ltd.
(Mauritius)Project
: Banking Information System –
BEST2000.
DCDM
Consulting represents Andersen Worldwide in Mauritius, Malawi and
South Africa and is a leading institution in the field of
Accounting and related consultancy. It is the leading IT solution
provider in the region.
Resposibilities:§Keep 24*7 mission critical databases up and
running.
§Manage production and development database
environments meeting the service level requirements.
§Make sure databases are tuned for best
throughput