Subhra Roy

Email: ace9sn@r.postjobfree.com Phone: +*-

720-***-****

Resume of SUBHRA ROY

SUMMARY OF QUALIFICATIONS:

. 9 years of experience as an Oracle DBA and PL/SQL developer.

Experience in Data Modeling, Design, and Development & Production

Support on different UNIX environments like Sun Solaris, Linux and

Windows 2000/2003 /NT.

. Experience in Upgrade of oracle database 11g R1 to 11g R2 using Oracle

Database Upgrade Assistant (DBUA).

. Worked on ASM RAC and DATA GUARD. Installation of RAC databases,

Maintenance of RAC using SRVCTL and CRSCTL commands.

. Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and

handling disk failure issues.

. Datagaurd setup maintenance and log transfer.

. Strong knowledge of RMAN.Designed and implemented backup and recovery

strategies.

. Experience in using RMAN for backup and recovery. Done time based,

cancelled based recovery using Hot backup and block level recovery using

RMAN.

. Experience in implementing Hot, Cold and Logical backup plans and

experience in clonning .

. Data backup using export data pump and import data pump.

. Experience of installing, upgrading, patches. Duties included database

creation, tuning, backup/recovery, user and security management, general

troubleshooting and cloning.

. Installed and configured Oracle 11g on Linux Server on Development, Test

and Production Systems. Performance and monitoring RDBMS (Relational

Database Management System).

. Efficient in creating and managing users and objects.

. Efficient in SQL query optimization using Explain Plan, AWR, TKPROF

reports, gathering statistics, pinning the objects, and running scripts.

. Extensive Experience in PL/SQL procedures, Functions, packages and

efficient query writing.

. Specialist in functions, stored procedures, and triggers. Efficient in

Performance Tuning of database, instances, SGA, I/O, and Rollback segment

using different methods and detecting locks. Expertise in Loading data

from flat files using External Tables, SQL*LOADER.

. Good Knowledge of UNIX shell scripting and experience in Perl.

. Experience in the management of schemas, de-fragmentation and

partitioning the tables & indexes to improve the performance.

. Responsible for setting and managing user accounts, granting required

privileges to users.

. Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating System: UNIX, WINDOWS NT 4.0, Red Hat Linux 7.3, Sun Solaris

8.0, 9.0, HP-UX.

DBMS: ORACLE 8i, 9i, 10g, 11g

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR

TOOLS: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader, Data

pump, TOAD, RMAN, Export/Import, DBCA, NETCA, DBUA, PL/SQL

Developer

Languages: SQL, PL/SQL, Java, C Programming

PROFESSIONAL EXPERIENCE:

Jul '12 - Present

Century Link

DBA

Denver, MN

Century link is well known Telecom company of USA. Roles and

responsibilities are as follows.

Responsibilities:

. Backup and recovery procedures using RMAN Cold backup and data pump

Export/Import. Copying of data from by using data pump Export/Import.

. Backup of RAC databases. . Installation of RAC databases, Maintenance of

RAC using SRVCTL and CRSCTL commands.

. Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and

handling disk failure issues. Datagaurd setup maintenance and log

transfer.

. Cloning using RMAN and Cold backup. Used data pump export import for

data migration

. Created the indexes and analyzed the table for better performance.

. Restore and recovery using RMAN.

. TABLESPACE and Data block recovery using RMAN.

. Done time based, cancelled based recovery using Hot backup and block

level recovery using RMAN.

. Faced Media failure issue.

. SQL query tuning. Worked with statistics explain plan hints. Worked with

fragmentation and chaining issue. Index usage Monitoring.

Environment: Oracle 11g, RMAN, SQL Loader, Export Import, OEM, SQL

Loader, Control-M

Oct '11 - May '12 British Telecommunications (BT

Merlin)

DBA India

BT (British Telecommunications) is a well known telecommunication company

of UK.

Worked in BT Merlin as DBA as well as developer. Here have written PL/SQL

procedures, functions, packages and worked in UNIX environment. Also loaded

data using external table and partition exchange. Taken RMAN backup and

carried out various user requests. Have worked with shell scripts and

Control-M.

Responsibilities:

. Created and maintained Database objects like table spaces, tables,

indexes, views, Partitioned appropriate tables to optimize performance

and simplified maintenance work, Administered database using Oracle

Enterprise Manager, Created and executed various database queries.

. Installation of RAC databases, Maintenance of RAC using SRVCTL and

CRSCTL commands.

. Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and

handling disk failure issues. Datagaurd setup maintenance and log

transfer.

. Tuned and optimized SQL Query using hints, index, statistics of objects

and explain plan, Used External table and Partition exchange as efficient

methods of data loading, Backup and recovery procedures using RMAN

Copying of data from development to test and production by using

utilities like Export/Import, Scheduled jobs to run on

daily/weekly/monthly basis.

Environment: Oracle 11g, RMAN, SQL Loader, Export Import, OEM, SQL

Loader, CONTROL-M

Dec '10 - Sep '11

Sun America

DBA

India

Sun America, a member of American International Group, is a financial

services company specializing in retirement savings and investment products

and services. This project involves the migration of data from their

previous system Vantage, to current system Navisys. The implementation is

executed from TCS Kolkata offshore centre in India. Loaded data using SQL

loader, written procedure and functions, critical queries. Worked on

reconciliation, loading, migration an data porting.

Responsibilities:

. Extensively worked on PL/SQL procedure, functions, packages, Performed

heavy data loads using SQL*Loader, Prepared control, bat file for bulk

data load using SQL Loader, Created Test database using cloning method,

Involved in creating tables and indexes, views.

. Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL

commands. Adding disk in ASM diskgroup. ASM disk partitioning,

rebalancing and handling disk failure issues. Datagaurd setup maintenance

and log transfer.

. Created triggers, functions and procedures, Involved in RMAN backup,

Managing and creating users and assigning roles and privileges to

different users as per the requirements, created the indexes and analyzed

the table for better performance. Data backup using export data pump and

import data pump. Done time based, cancelled based recovery using Hot

backup and block level recovery using RMAN.

. Moved the tables to different table space and rebuild the indexes, Faced

issues like fragmentation and chaining, Use of table partitioning for

very large tables, Creating and managing users and objects, Took export

backup for data security, Use of table partitioning for very large

tables.

. Used different hints to write critical queries, Used flashback utility,

Performed data loads using SQL*Loader, Worked with explain plan of

queries and statistics of tables and indexes.

Environment: Oracle 10g, TOAD, PL/SQL Developer, SQL Loader, export

import.

Mar '10 - Oct '10 AXA

Japan

DBA

India

AXA Life Assurance Company of Japan is a financial services company

specializing savings and investment products and services. This project

involves development of the code in Oracle which they could use form Java.

The Client were carrying out a migration from their earlier existing PL/SQL

packages to SQL queries which would be suitable to use from Java

environment .The implementation is executed from TCS Kolkata offshore

centre in India.

Responsibilities:

. Extensively worked on PL/SQL procedure, functions, packages, Led a small

SQL team and guided them to write efficient queries using case, INSTR,

Decode, exist, not exist and other key words, Involved in creating tables

and indexes, views, Created triggers, functions and procedures.

. Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL

commands. Adding disk in ASM diskgroup. ASM disk partitioning,

rebalancing and handling disk failure issues. Datagaurd setup maintenance

and log transfer.

. Done time based, cancelled based recovery using Hot backup and block

level recovery using RMAN. Experience of installing, upgrading, patches.

Duties included database creation, tuning, backup/recovery, user and

security management, general troubleshooting and cloning. Installed and

configured Oracle 11g on Linux Server on Development, Test and Production

Systems.

. Creating and managing users and objects, moved the tables to different

table space and rebuild the indexes, Index Monitoring and dropping unused

indexes, Use of table partitioning for very large tables, used different

hints to write critical queries, used flashback utility. Experience in

the management of schemas, de-fragmentation and partitioning the tables &

indexes to improve the performance. Efficient in Performance Tuning of

database, instances, SGA, I/O, and Rollback segment using different

methods and detecting locks.

. Performed data loads using SQL*Loader, Worked with explain plan of

queries and statistics of tables and indexes, Offshore Onshore

coordination and role of a team lead.

Environment: Oracle 10g, TOAD, PL/SQL Developer, SQL Loader, export

import

Aug '09 - Feb '10 LIC International

PL/SQL Developer India

LIC International: It was Insurance domain project of Bahrain, Kuwait

region of west Asia where developed PL/SQL Procedures, Functions. Created

reports using Inline views, sub quries used bulk collectors and Ref

cursors.

Responsibilities:

. Extensively worked on PL/SQL procedure, functions, packages, written

critical queries using Rank, Dense Rank function inline views, Used Bulk

collectors and Ref Cursors, Creating and managing users and objects.

. Assigning appropriate roles and privileges for different users as per the

requirements of production, Creating and Managing stored procedures and

triggers, Performed heavy data transfer using import/export utility,

Performed heavy data loads using SQL*Loader.

. Tuned SQL Queries and guided other to write efficient queries, Data

needed to be extracted from different tables in different

schemas/databases for analysis, Worked with explain plan of queries and

statistics of tables and indexes.

Environment: Oracle 10g, Data Loading, Export Import.

Dec '07 - Mar '09 British

Telecommunications

Production support Executive (DBA)

India

SMERF means SMALL and medium enterprise reporting facility.

Here have provided 24X 7 supports for this application, produced various

reports on regular basis, carried out deployments and various client

(British Telecom) requests.

Here have worked on ORACLE 10g and UNIX. It was a 5 node RAC environment.

Also have worked on various tools such as, TOAD, OWB, PL/SQL developer,

OEM. Here mainly concentrated on performance tuning side. Used to work on

statistics, explain plan, and wait events to find out the reason for long

running queries. Have done SQL query tuning, index monitoring and

performance analysis. Used to work with hints (including parallelism) of

queries. Faced issues like fragmentation and chaining. Have also scheduled

jobs in control -M and also used various UNIX commands.

Responsibilities:

. Worked on 5 node RAC environment in a Production database, Created and

maintained Databases and their objects like table spaces, tables,

indexes, views, Partitioned appropriate tables to optimize performance

and simplified maintenance work, Administered database using Oracle

Enterprise Manager, Created and executed various database queries.

Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL

commands.

. Tuned and optimized SQL Query using hints, index, statistics of objects

and explain plan, Worked with wait events, gv$views to find out the

reason for long running queries, Backup and recovery procedures using

RMAN.

. Copying of data from development to test and production by using

utilities like Export/Import, Scheduled jobs to run on

daily/weekly/monthly basis, Extensively involved in design physical and

logical models of the database.

. Provided 24x7 production support. Willingness and flexibility to work

beyond regular hours based on business demands.

Environment: Oracle 9i, SQL Loader, Export Import, OEM, SQL Loader,

CONTROL-M

Mar '05 - Aug '07

B.S.N.L

Oracle Developer/DBA

India

DOTSOFT implementation in CG circle INDIA,DBA

B.S.N.L (Bharat Sanchar Nigam Limited) is a telecommunication company of

India. A government of India enterprise. DOTSOFT is an integrated package

of TRA, FRS, CS and DQ and it is in house built software of B.S.N.L A.P.

circle. The front end is D2K and back end uses ORACLE. We Installed ORACLE

9i, Created database and ported the data and used to take logical backup

everyday evening and cold backup every fortnight. Have written PL/SQL

programs using cursors, SQL queries during implementation of the project.

After implementation have given production support to our client by solving

the problems which they were facing and maintained the database.

Responsibilities:

. Involved in installation and configuration of Oracle 9i database on Linux

operating system, Extensively involved in writing PL/SQL programming,

Involved in Creation of tables, Partioning tables, views, sequences,

synonyms for the business application development.

. Written stored procedures, functions and packages for application

development, Involved in troubleshooting using SQL monitor.

. Backup and recovery procedures using Cold backup and normal

Export/Import. Used to take cold backup in every fortnight and export

backup every day evening.

. Copying of data from development to test and production by using

utilities like Export/Import, Loaded the flat file data into database

table by creating multiple SQL Loader control scripts, Written database

triggers for automatic insertion of tables on different schema.

. Created the indexes and analyzed the table for better performance,

Development of product, quality testing and production database for new

Oracle database 9i(Cloning), Managing and creating users and assigning

roles and privileges to different users as per the requirements.

. Moved the tables to different table space and rebuild the indexes, Use of

table partitioning for very large tables.

Environment: ORACLE 9i, SQL Monitor, OEM, SQL Loader, Performance and

Troubleshooting

EDUCATION:

B. Tech in Electronics & Communication Engineering from Kalyani University

2004

Contact this candidate