Samir Sarkar
9121226853332 +91 9823453367
Current Location: Pune
Title: / Senior Oracle DBA Lead / DBA Project ManagerWork Experience: / 12.5 years
Skills: / Oracle DBA, Unix
Current Organization: / Electronic Data Systems (India) Pvt. Ltd.
Previous Organization(s): / P&O Nedlloyd IT Services, Atos Origin UK, Steel Authority of India Ltd.
Industry: / IT Enabled Services
Highest Degree Held: / B.E/B.Tech (Civil) ,Gauhati University
Gender: / Male
Date of Birth: / 1st April 1969
Current Annual Salary (Rs. in Lacs): / 12.0
Detailed Resume:
Curriculum Vitae of Mr. Samir Sarkar
Flat No. B2/904
Rose Parade
Near Salunke Vihar Road
Kondhwa
Pune - 411048
Email :
Phone : (+ 91) 9823453367
Summary
Samir is a very experienced Oracle DBA with more than ten years in the IT
Industry and two years in marketing. As a Senior DBA, he has an excellent
experience of Oracle 9i/8i/8, SQL Plus, PL/SQL and other Oracle development
tools in HP-UX, SUN Solaris and IBM-AIX environments. He also has a very
good knowledge of Oracle9i Real Application Clusters (RAC), Data Guard,
Oracle9i Advanced Replication, Oracle Advanced Security and the new
features of Oracle 10g.
Samir has in-depth practical knowledge of implementing RAID 0+1/5 database
models. He can enforce a structured systems development discipline and
understands the Oracle internal architecture very well.
He has been actively involved as a Senior DBA and Team Leader/Project
Manager in managing DBA projects and administration and maintenance of
large and distributed Oracle databases up to 3000 GB and is very proficient
in his job.
Key Experience
Oracle Database Administration / Database Migration from Oracle(8.0.5/7.3, 8i Releases 1, 2 & 3, 9i / 7.3 to Oracle 8, 8i and 9I
Release 1 & 2 and 3 and Oracle 10g / Implementing Standby Databases
Release 1) / for Disaster Recovery (Data
Designing of database and database / Guard)
space management / Implementing Oracle9i RAC
Database & Application Tuning for / Upgrading to Oracle 10g RAC
optimizing performance (Performance / (Release 1)
Tuning) / Oracle9i Advanced Replication
Backup and Recovery (physical using / Oracle9i Advanced Security
RMAN and logical viz. Export and / Team leading (managed teams from
Import) / 10-12 people)
Database Security & Auditing / DBA Project Management
Technical Experience
Operating Systems / RDBMSSun Solaris, HP-UX 9000 Series, / Oracle 7.3, 8.0.5, 8.1.5, 8.1.6,
IBM-AIX, HP-Tru64 Unix, Windows 2000/NT / 9.2.0, 10.1.0
Enterprise,/Desktop, Windows 95/98,
MS-Dos
DBA Tools and Utilities / Front End
SQL Trace, TKPROF, SQL*Net/Net8, RMAN, / Developer 2000 - Release 1/2
Oracle Procedural Gateway for IBM MQ / (Forms 5.0/ 4.5, Reports 3.0,
Series, Solstice, Enterprise Manager / 2.5.)
(OEM), TOAD, Export, Import, Oracle 10g
Data Pump, SQL Loader, Listener
Controller (LSNRCTL), Oradebug,
DBVerify, Oracle STATSPACK, Oracle
8i/9i Logminer, Oracle9i Data Guard &
Data Guard Broker, Oracle9i RAC,
Veritas Netbackup, Veritas DBE/AC etc.
Knowledge of TCP/IP Protocols / Programming Languages
SQL, PL/SQL, C++
Education : Bachelor of Engineering / Contact
(B.E.) / Please call +91 9823453367
or
Date of Birth / Email: or
01/04/69 /
Relevant Professional Experience
Jan 2005 - continuing..
Role : Information Specialist
Company : EDS, India Solutions Centre, Pune
Client : ABN Amro Bank
Hardware : IBM-AIX 4.3/5.1 RS6000 servers, HP-UX servers (HP 9000 series)
servers
Software : AIX 4.3.3/5.1, HP-UX 11/11i, Oracle 7.3/8/8i/9i/10g
Role Profile :
EDS is the second largest IT company in the globe. They started their India
Solutions Centre as a part of their expansion into the Asia Pacific region.
Capabilities include expertise in software development, maintenance and
assessment in a range of technical platforms spread over a variety of
functional areas. The Centre has rich experience in offshore migration with
a matured migration model and a proven Service Excellence and Metrics
programme. The entire Centre was assessed at SEI CMMI Level 5 in February
2004, earning the distinction of being the first EDS organization to
achieve this milestone of quality excellence. The centre also has the ISO
9001:2000 certification.
As an Information Specialist (DBA Project Manager & Senior DBA) my role
includes :
Creating proposals and providing DBA effort and cost estimates for various
projects to the client.
Tracking DBA project metrics and ensuring smooth progress of the project.
Installation of Oracle server and client software, performing database
upgrades, migration and installing relevant Oracle server and application
patches.
Management and maintenance of more than 50 different production and
development databases.
Database space management
Performing detailed database performance checks and analysis using
STATSPACK and other scripts and optimizing performance if necessary.
Formulating Backup and Recovery strategies using RMAN with HP Omniback &
Legato Storage Manager
Implementing the use of External Tables and Online Table Redefinition
Troubleshooting backup & recovery and other database issues including use
of Flashback Database features in Oracle 10g.
Using Oracle 10g Data Pump utility.
Upgrading Oracle9i RAC environment to Oracle 10g (Release 1) RAC
environment for online trading application.
Using Oracle 10g Job Scheduler to schedule and monitor Oracle jobs.
Implementing physical Standby databases for Disaster Recovery with Oracle9i
Data Guard
Configuring and managing Oracle9i Advanced Replication between distributed
databases.
Implementing Oracle Advanced Security for data encryption between client
and database server.
Managing database security and performing database auditing using Oracle9i
Logminer
Performing SQL query performance tuning and advising the applications team
accordingly.
Implementing Database Resource Management for optimizing CPU utilization.
Managing all database issues associated with the project and ensuring that
all project deliveries are made on time.
Maintaining appropriate change control procedures using Remedy.
Mentoring and training other DBAs working with me.
Carrying out performance appraisals and reviews along with time tracking of
team members.
May 2004 - December 2004
Role : Senior Oracle Database Administrator
Company : P&O Nedlloyd, Pune
Hardware : IBM-AIX 4.3/5.1 RS6000 servers, HP-UX servers (HP 9000 series)
servers
Software : AIX 4.3.3/5.1, HP-UX 11/11i, Oracle 7.3/8/8i/9i
Role Profile :
P & O Nedlloyd is a premier MNC into the container shipping business. The
back office for their IT services are based at Pune. The company has
several products for maintaining their global operations starting from
documentation to shipment tracking and invoicing. The entire gamut of
operations is highly complex and the database services need to be
maintained round-the-clock with minimum outages or downtime.
As a Senior Oracle DBA, my role includes :
Installation of Oracle software, performing database upgrades, migration
and installing relevant patches.
Management and maintenance of more than 900 different production and
development databases.
Database space management and database auditing.
Performing detailed database performance checks and analysis using
STATSPACK and other scripts and optimizing performance if necessary.
Formulating Backup and Recovery strategies using RMAN with Tivoli Storage
Manager.
Troubleshooting backup and recovery and other database issues.
Implementing physical Standby databases for Disaster Recovery with Oracle9i
Data Guard
Configuring and managing Oracle9i Advanced Replication between distributed
databases using Read Only and Updateable Materialized Views and also Multi
Master Replication.
Using Temporary Tables and Online Table Redefinition features in Oracle9i.
Managing database security and performing database auditing using Oracle9i
Logminer
Performing SQL query performance tuning and advising the development team
accordingly.
Implementing Database Resource Management
Implementing and managing Oracle replication between the transaction and
reporting databases using Shareplex (Quest product).
Maintaining appropriate change control procedures using Remedy.
Mentoring and guiding other Junior DBAs working with me.
September 2001 - May 2004
Role : Senior Oracle Database Administrator
Company : Schlumberger UK / Atos Origin, UK
Hardware : SUN Servers (SunFire 10K 15K), HP-UX servers (HP 9000 series),
IBM-AIX 4.3
servers
Software : Solaris 2.8/2.9, HP-UX 11/11i, AIX 4.3.3, Oracle 7.3/8/8i/9i
Role Profile :
Atos Origin is a very large software services MNC headquartered from
Holland and France. In the UK where I was based, the company had several
large clients viz. Network Rail, Deptt of Work and Pensions, Vehicle
Inspectorate, National Health Services, Labour Party etc. whose databases
were wholly managed by us on a 24X7 basis.
As a Senior Oracle DBA, my role was :
Installation of Oracle software, performing database upgrades, migration
and installing relevant patches
Designing and creating databases for OLTP and DSS systems
Management and maintenance of more than 100 different production and
development databases for 10 different clients.
Database space management
Performing detailed database performance checks and analysis using
STATSPACK and other scripts and optimizing performance if necessary.
Formulating Backup and Recovery strategies using RMAN with Veritas
Netbackup, HP Omniback, Networker with NSR-DBM-ORA.
Troubleshooting backup and recovery and other database issues.
Implementing physical Standby databases for Disaster Recovery with Oracle9i
Data Guard
Configuring and managing Oracle9i Replication between distributed databases
using Read Only and Updateable Materialized Views.
Managing database security and performing database auditing using Oracle9i
Logminer
Advising clients as regards Application tuning.
Installation and Configuration of Oracle Procedural Gateway for IBM MQ
Series
Implementing Database Resource Management
Configuring and Implementing Oracle9i RAC (Real Application Clusters) on
Sun Solaris systems with Veritas cluster (Veritas DBE/AC).
Maintaining appropriate change control procedures using Remedy and Vantive.
Implementing the use of External Tables and Online Table Redefinition
Team leading and team management and mentoring 7 other junior DBAs working
with me.
September 1999 - June 2001
Role : Oracle Database Administrator
Client : Steel Authority of India Limited, India
Hardware : SUN Sparc 450 Server, HP Netservers
Software : SUN Solaris, UNIX (Shell Scripting), Oracle 8 /
8i, SQL, PL/SQL, TCP/IP Developer 2000, (Forms 5.0/Reports 3.0)
Project Profile:
This Project consists of designing, creation, administration and
maintenance of two databases that are linked by a satellite network all
over India. The Integrated Employee Management System has been developed
on Oracle. These are accessed and used by various users of the HR
Department. The Payroll System of the Company has been migrated from COBOL
to Oracle . These are accessed by the Finance Department. Design,
Implementation, Administration and Maintenance of both the above databases
were on a SUN Solaris platform in a TCP/IP environment for LAN and X.25
Networked environment for WAN using Eicon card software.
Role:
As the lead Oracle DBA, I was solely responsible for the Oracle database. I
had a team of 12 Oracle Developers.
As an Oracle DBA my role included:
Installation of Oracle software, Administration and Maintenance of Oracle
Databases.
Designing and Creation of Databases, schema and schema objects as per
design and plan
Database space management
Backup and Recovery
Planned and implemented physical Backup and Recovery strategies for the
production database including logical backup procedures like Export and
Import.
Database & Application Tuning for optimizing performance.
Used Explain Plan for query Optimization.
Migration from Oracle 7.3 to Oracle 8 and 8i including installation of
relevant patches.
Creating Triggers for validations and auditing (security)
Shell Scripting for automating Oracle backup processes.
Implementing Standby databases for High Availability.
Developing Backend scripts for implementation of Payroll and Employee
Management Systems using PL/SQL and SQL.
Installation and maintenance of SUN Solaris and SCO UNIX Operating Systems.
Eicon Card installation and configuration for maintenance of WAN across the
branches.
Maintaining Data Flow across the country from the various branches using
TCP/IP.
Creating procedures, functions and packages
Oct 1995 - August 1999
Role : Jr. Oracle DBA
Company : Steel Authority of India Limited
Hardware : HP Netservers
Software : SUN Solaris, UNIX(Shell Scripting), Oracle 6/7.3/8 / 8i,
Developer 2000
Project Profile:
Administration and Maintenance of the Oracle Database System of the
marketing network of the largest company of India, which spans over 42
branches, which are linked, by a satellite network. All order booking;
indents to the factories, supply and distribution of material and sales are
stored in the respective Databases of the branches and are transmitted to
the Centralized Database at Mumbai where the data is populated onto various
tables from flat files using scripts. Further scripts are then written to
get the data in our desired form by generating additional tables and
populating them from the tables of the Centralized Database for use by the
end users.
Role :
As a Junior Oracle Database Administrator, I was involved with twelve other
team members in the
following activities:
1. Installation, Administration and Maintenance of ORACLE Databases at
the Western Region office, Mumbai in a 24 X 7 production database
environment comprising:
2. Installation of Oracle software including patchsets
3. Database Space Management
4. Daily Backups and implementing Recovery procedures in case of
outages.
5. Disaster Recovery involving Standby Databases
6. Implementing database Security including Auditing
7. Application & Database Tuning if necessary
8. Replication involving Snapshots between databases.
9. Migration from Oracle 7.3 to Oracle 8
10. Using SQL Loader for populating data from flat files to the
database objects
11. Developing Backend scripts for populating the tables of the main
centralized database.
1. Installation and maintenance of SUN Solaris and UNIX Operating
Systems.
2. Eicon Card installation and configuration for maintenance of WAN
across the branches.
3. Maintaining Data Flow across the country from the various branches
using TCP/IP and X.25 protocols.
October 1993 - Sept 1995
Worked as a Marketing Executive in Steel Authority of India Ltd. I was
actively involved in market research and market development for the
marketing of the steel products manufactured by the company and assisting
in the maintenance of the Oracle databases and Unix systems of the branch.
Resume of Samir Sarkar Page XXX