Manager Oracle

Benu DUTTA

Email: *******@*****.***

(Permanent) Kolkata, India

(Current) Dubai, UAE

Cell: +971*********

Professional Summary

Oracle DBA Expertise:

An OCP 9i, 10g and 11g. around 14 years of experience in Information technology as an Oracle Database Administrator for 7,8i,9i,10g and 11g and UNIX, Shell Scripting, Pro*C & Windows platform with OS administration.

Proficient in Oracle installation and patching, configuration, database administration including planning, implementation, backup & recovery strategies. Involved in SDLC for any new Development.

Successfully maintained various databases of varying database sizes, Proficient in I/O tuning and experienced in memory and application tuning.

Experience in backup and recovery by utilizing Recovery Manager (RMAN), Export / Import, Datapump etc. Exposure in Oracle10G and 11G, RAC, Exposure in OEM and TOAD, Auditing the database.

MYSQL & SQL Server DBA Expertise:

Maintaining database backup and recovery using GUI tool.

Maintaining user, group, assigning privileges

Creating & Maintaining Replication server

Housekeeping

Professional Organizations

• EMARATECH, Dubai, UAE, TEAM LEAD DBA, August 2011 Till Date

• GLOBACOM LIMITED, Lagos, Nigeria, Head System & Servers, September 2007 Till July 2011

• RELIANCE TELECOM LIMITED, India, Manager IT (DBA), March 2006 Till September 2007

• NEXTECH SOLUTIONS (P) LTD, Kolkata, Senior Consultant, Jan 2002 till Feb 2006.

• Albatross Software Services (P) LTD, Kolkata, Oracle DBA, Aug 1999 Till Dec 2001

• Singtel, Singapore June 1998 Till Jul 1999

• CHOICE SOFTWARE SYSTEMS (P) LTD. Sydney, DBA, Aug 1996 till May 1998

Certifications

• Oracle Certified Professional (OCP) in Oracle Database 9i – March 2007

• Introduction to oracle 9i: SQL

• Oracle 9i Database: Fundamental I

• Oracle 9i Database: Fundamental II

• Oracle 9i Database: Backup / Recovery

• Oracle 10g RAC

• Oracle 11g

Education

MBA (IT and Project Management), IIBMS, India

B.Sc Comp Science CPTI, Sydney (Australia) ONSITE 4 Years

Graduation from St. Xaviers College, Kolkata 3 Years

Technical Skills Profile

Operating Systems : Digital unix4.0D, HP Tru 64 Cluster, AIX, Linux, Sun Solaris, Windows

Domain : Telecommunications, Software Development, BI and Client/Server, Mutual Fund, Banking, Pharma and Client specific Internal Legacy support.

Database : Extensive Level Support on Oracle 11g, 10g, 9i, 8.x and 7.x and Basic level Support on MySQL / SQL Server Database.

Other Technologies : Exposure on SYBASE DBA, Export / Import Utility, PL/SQL, shareplex replication manager, EMC, Veritas Volume Manager, Clarion, OmniBack backup tool, TOAD, OEM, Data guard, RAC

Functional Skills

Management and Leadership Skills

Currently working as Head Systems & Servers for a team of 16 members.

Worked as DBA Team lead in RELIANCE Telecom for a team of 6 DBAs.

Training & Development

Conducted various training program on New Oracle Tech and conducted seminars on various Technical aspect of Oracle for Client, Pre Sale Demo for client of all Oracle Products

Professional Experience

POSITION Team Lead DBA

COMPANY NAME EMARATECH, Dubai, UAE

EXPERIENCE Sep 2011 – TILL DATE

Over all team management with the team size 10 members with the following activity.

• Worked for a Software Development company who manages all Govt. related activity.

• Main databases are Emirates ID, VISA Processing, Emirates e-Gate, Streaming replication etc.

• Successfully installed DR solution using Dataguard.

• Databases are more than 480 in Numbers and in size of total 70 TB or more.

• More details are available at http://www.emaratech.ae/

POSITION HEAD Systems & Servers / Oracle DBA Team Lead

COMPANY NAME GLOBACOM LIMITED, Lagos, NIGERIA

EXPERIENCE Sep 2000 – TILL DATE

Over all team management with the team size 16 members with the following activity.

• Worked for an in-house Telecommunication company. (2nd Largest in Nigeria)

• Backup and restoration using RMAN on Symantec backup utility.

• Performing recommended actions based on the health checks, analysis to fix the database /server problems if any.

• Performing the system study to implement the DR site setup.

• Worked on implementing oracle 10g new features at UK for Submarine Cable IT Project.

• Involved in preparing proof of concept for the same.

• Database design and implementations.

• Implementation of Standby / RAC

• Knowledge of Oracle Streaming

• Co-ordination with Vendors for PO, billings and timesheet etc.

• Databases are more than 280 in Numbers and in size of total 100 TB or more.

POSITION Manager IT / Oracle DBA Team Lead

COMPANY NAME RELIANCE TELECOM LIMITED, Kolkata, INDIA

EXPERIENCE Mar 2006 – Sep 2007

• Worked as Team lead for a team of 5 Members.

• Supporting approximately 100 SUN legacy Databases (Both Oracle 7,8,9i,10G and SYBASE).

• Supporting first level support on Oracle, Sybase database and shareplex.

• Performing periodical check of alert and trace files to verify for any abnormal activities in the database.

• Solving the O/S and database related issues and monitoring memory and CPU utilization.

• DB upgrade from 9i to 10G Database.

• Management of Standby Database for data transfer including Rebuild of Standby Databases.

• Performance tuning, raising oracle SR for any hot issues, export and import, Hot and Cold backup, generation AWR report, creation of user, DB links creation, production and standby DB instance sync monitoring, analyzing the tables and indexes for gather statistics.

• Creation, addition and Monitoring of TBS, RBS and temp table spaces when a huge load is running, monitoring UNIX level server performance top, sar, prstat, psrinfo, iostat etc.

• Unix level Cron jobs are scheduled to perform and check various activities on UNIX server and DB server like file system space, DB space monitoring, DB status, COLD and HOT backup, logical backup etc.

• Work allocation to team members. Managing the resources. Maintaining resource plans, shift rotation, regular meeting with vendor for regular enhancement of the SLA/project and team.

•Systematic Approach, Willing to learn and quick adaptability to new technologies.

•Excellent interpersonal skills, hard working and result oriented and as a team lead timely help and guidance to team members technically and for their carrier growth.

POSITION Senior Consultant / Database and System Administration.

COMPANY NAME NEXTECH SOLUTIONS, Kolkata, INDIA

EXPERIENCE Aug 1999 Till Dec 2001

Database and System Administration.

- Maintaining very high-level performance tuned for different users accessing database from various parts of country.

- Analyzing Sqls running from different clients - their performance hit/miss ratio/rollback segment usage/locks monitoring.

- Monitoring tuning locks, sorts, rollback segment usage, object storage, free space usage, fragmentation of database having size more than 2 TB.

- Monitoring activities session wise including performance. Maintaining high level of security as database contains live call details.

- Taking different types of oracle database backup e.g. Export, Archival, RMAN and Hot Backup. Restoring those backups.

- Providing necessary subscriber related information from the system to the higher management. Solving different types of system problems.

- Generating various reports related to performance monitoring like stats-pack etc. Writing and tuning PL/SQLs. Data migration for large tables and shell scripting.

Migration of application software. Assigning backup strategy, Monitoring of Server processes. Access control of more than 200 users from all over India. As this is three-tier architecture, performance of web-server is also to be monitored. Overall support of the total Billing System.

- Lead for a Team of 5 members

POSITION Senior Consultant / Database and System Administration.

COMPANY NAME CHOICE SOFTWARE SYSTEM (P) LTD, SYDNEY, AUSTRALIA

EXPERIENCE Aug 1996 till May 1999

Worked as an Assistant manager system department in Sydney Branch office handling 700 GB database .My role and responsibility were as follows.

• Installation of Oracle software on DIGITAL UNIX and SCO UNIX environments and setting up database instances for production and test environments.

• Migration of legacy systems data into Oracle 8.x on Digital UNIX from Fox plus / FoxPro databases using SQL * LOADER.

• Monitoring the resource utilization in the database.

• Creation and administration of users and allocation of roles to the users.

• Performing periodical check of alert and trace files to verify for any abnormal activities in the database.

• Performing regular offline, online and export backups of the data and testing the backups.

• Monitoring the database performance using Oracle provided utilities and tuning the database for optimum performance.

• Database sizing, creation and addition of TBS, RBS, DB Tuning.

• Software replication, application of patches and maintaining static & dynamic tables

• Creation of DB Links, synonyms, snapshots etc

• Tuning SQL Statements using SQL Trace, tkprof and EXPLAIN PLAN Utilities.

• Tuning of Library Cache, Data Dictionary Cache and Database Buffer Cache.

• Pinning the large procedures in Library Cache.

• Optimizing the size of Database Buffer Cache.

Personal Details

Date Of Birth : 19-May-1973

Marital Status : Married

Benu DUTTA

Email: *******@*****.***

(Permanent) Kolkata, India

(Current) Dubai, UAE

Cell: +971*********

Professional Summary

Oracle DBA Expertise:

An OCP 9i, 10g and 11g. around 14 years of experience in Information technology as an Oracle Database Administrator for 7,8i,9i,10g and 11g and UNIX, Shell Scripting, Pro*C & Windows platform with OS administration.

Proficient in Oracle installation and patching, configuration, database administration including planning, implementation, backup & recovery strategies. Involved in SDLC for any new Development.

Successfully maintained various databases of varying database sizes, Proficient in I/O tuning and experienced in memory and application tuning.

Experience in backup and recovery by utilizing Recovery Manager (RMAN), Export / Import, Datapump etc. Exposure in Oracle10G and 11G, RAC, Exposure in OEM and TOAD, Auditing the database.

MYSQL & SQL Server DBA Expertise:

Maintaining database backup and recovery using GUI tool.

Maintaining user, group, assigning privileges

Creating & Maintaining Replication server

Housekeeping

Professional Organizations

• EMARATECH, Dubai, UAE, TEAM LEAD DBA, August 2011 Till Date

• GLOBACOM LIMITED, Lagos, Nigeria, Head System & Servers, September 2007 Till July 2011

• RELIANCE TELECOM LIMITED, India, Manager IT (DBA), March 2006 Till September 2007

• NEXTECH SOLUTIONS (P) LTD, Kolkata, Senior Consultant, Jan 2002 till Feb 2006.

• Albatross Software Services (P) LTD, Kolkata, Oracle DBA, Aug 1999 Till Dec 2001

• Singtel, Singapore June 1998 Till Jul 1999

• CHOICE SOFTWARE SYSTEMS (P) LTD. Sydney, DBA, Aug 1996 till May 1998

Certifications

• Oracle Certified Professional (OCP) in Oracle Database 9i – March 2007

• Introduction to oracle 9i: SQL

• Oracle 9i Database: Fundamental I

• Oracle 9i Database: Fundamental II

• Oracle 9i Database: Backup / Recovery

• Oracle 10g RAC

• Oracle 11g

Education

MBA (IT and Project Management), IIBMS, India

B.Sc Comp Science CPTI, Sydney (Australia) ONSITE 4 Years

Graduation from St. Xaviers College, Kolkata 3 Years

Technical Skills Profile

Operating Systems : Digital unix4.0D, HP Tru 64 Cluster, AIX, Linux, Sun Solaris, Windows

Domain : Telecommunications, Software Development, BI and Client/Server, Mutual Fund, Banking, Pharma and Client specific Internal Legacy support.

Database : Extensive Level Support on Oracle 11g, 10g, 9i, 8.x and 7.x and Basic level Support on MySQL / SQL Server Database.

Other Technologies : Exposure on SYBASE DBA, Export / Import Utility, PL/SQL, shareplex replication manager, EMC, Veritas Volume Manager, Clarion, OmniBack backup tool, TOAD, OEM, Data guard, RAC

Functional Skills

Management and Leadership Skills

Currently working as Head Systems & Servers for a team of 16 members.

Worked as DBA Team lead in RELIANCE Telecom for a team of 6 DBAs.

Training & Development

Conducted various training program on New Oracle Tech and conducted seminars on various Technical aspect of Oracle for Client, Pre Sale Demo for client of all Oracle Products

Professional Experience

POSITION Team Lead DBA

COMPANY NAME EMARATECH, Dubai, UAE

EXPERIENCE Sep 2011 – TILL DATE

Over all team management with the team size 10 members with the following activity.

• Worked for a Software Development company who manages all Govt. related activity.

• Main databases are Emirates ID, VISA Processing, Emirates e-Gate, Streaming replication etc.

• Successfully installed DR solution using Dataguard.

• Databases are more than 480 in Numbers and in size of total 70 TB or more.

• More details are available at http://www.emaratech.ae/

POSITION HEAD Systems & Servers / Oracle DBA Team Lead

COMPANY NAME GLOBACOM LIMITED, Lagos, NIGERIA

EXPERIENCE Sep 2000 – TILL DATE

Over all team management with the team size 16 members with the following activity.

• Worked for an in-house Telecommunication company. (2nd Largest in Nigeria)

• Backup and restoration using RMAN on Symantec backup utility.

• Performing recommended actions based on the health checks, analysis to fix the database /server problems if any.

• Performing the system study to implement the DR site setup.

• Worked on implementing oracle 10g new features at UK for Submarine Cable IT Project.

• Involved in preparing proof of concept for the same.

• Database design and implementations.

• Implementation of Standby / RAC

• Knowledge of Oracle Streaming

• Co-ordination with Vendors for PO, billings and timesheet etc.

• Databases are more than 280 in Numbers and in size of total 100 TB or more.

POSITION Manager IT / Oracle DBA Team Lead

COMPANY NAME RELIANCE TELECOM LIMITED, Kolkata, INDIA

EXPERIENCE Mar 2006 – Sep 2007

• Worked as Team lead for a team of 5 Members.

• Supporting approximately 100 SUN legacy Databases (Both Oracle 7,8,9i,10G and SYBASE).

• Supporting first level support on Oracle, Sybase database and shareplex.

• Performing periodical check of alert and trace files to verify for any abnormal activities in the database.

• Solving the O/S and database related issues and monitoring memory and CPU utilization.

• DB upgrade from 9i to 10G Database.

• Management of Standby Database for data transfer including Rebuild of Standby Databases.

• Performance tuning, raising oracle SR for any hot issues, export and import, Hot and Cold backup, generation AWR report, creation of user, DB links creation, production and standby DB instance sync monitoring, analyzing the tables and indexes for gather statistics.

• Creation, addition and Monitoring of TBS, RBS and temp table spaces when a huge load is running, monitoring UNIX level server performance top, sar, prstat, psrinfo, iostat etc.

• Unix level Cron jobs are scheduled to perform and check various activities on UNIX server and DB server like file system space, DB space monitoring, DB status, COLD and HOT backup, logical backup etc.

• Work allocation to team members. Managing the resources. Maintaining resource plans, shift rotation, regular meeting with vendor for regular enhancement of the SLA/project and team.

•Systematic Approach, Willing to learn and quick adaptability to new technologies.

•Excellent interpersonal skills, hard working and result oriented and as a team lead timely help and guidance to team members technically and for their carrier growth.

POSITION Senior Consultant / Database and System Administration.

COMPANY NAME NEXTECH SOLUTIONS, Kolkata, INDIA

EXPERIENCE Aug 1999 Till Dec 2001

Database and System Administration.

- Maintaining very high-level performance tuned for different users accessing database from various parts of country.

- Analyzing Sqls running from different clients - their performance hit/miss ratio/rollback segment usage/locks monitoring.

- Monitoring tuning locks, sorts, rollback segment usage, object storage, free space usage, fragmentation of database having size more than 2 TB.

- Monitoring activities session wise including performance. Maintaining high level of security as database contains live call details.

- Taking different types of oracle database backup e.g. Export, Archival, RMAN and Hot Backup. Restoring those backups.

- Providing necessary subscriber related information from the system to the higher management. Solving different types of system problems.

- Generating various reports related to performance monitoring like stats-pack etc. Writing and tuning PL/SQLs. Data migration for large tables and shell scripting.

Migration of application software. Assigning backup strategy, Monitoring of Server processes. Access control of more than 200 users from all over India. As this is three-tier architecture, performance of web-server is also to be monitored. Overall support of the total Billing System.

- Lead for a Team of 5 members

POSITION Senior Consultant / Database and System Administration.

COMPANY NAME CHOICE SOFTWARE SYSTEM (P) LTD, SYDNEY, AUSTRALIA

EXPERIENCE Aug 1996 till May 1999

Worked as an Assistant manager system department in Sydney Branch office handling 700 GB database .My role and responsibility were as follows.

• Installation of Oracle software on DIGITAL UNIX and SCO UNIX environments and setting up database instances for production and test environments.

• Migration of legacy systems data into Oracle 8.x on Digital UNIX from Fox plus / FoxPro databases using SQL * LOADER.

• Monitoring the resource utilization in the database.

• Creation and administration of users and allocation of roles to the users.

• Performing periodical check of alert and trace files to verify for any abnormal activities in the database.

• Performing regular offline, online and export backups of the data and testing the backups.

• Monitoring the database performance using Oracle provided utilities and tuning the database for optimum performance.

• Database sizing, creation and addition of TBS, RBS, DB Tuning.

• Software replication, application of patches and maintaining static & dynamic tables

• Creation of DB Links, synonyms, snapshots etc

• Tuning SQL Statements using SQL Trace, tkprof and EXPLAIN PLAN Utilities.

• Tuning of Library Cache, Data Dictionary Cache and Database Buffer Cache.

• Pinning the large procedures in Library Cache.

• Optimizing the size of Database Buffer Cache.

Personal Details

Date Of Birth : 19-May-1973

Marital Status : Married

Contact this candidate