Data Maintenance
Resume:
Subhra Roy
Email: ***********@*****.*** Phone: +*-
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