oracle core dba
Resume:
CURRICULUM VITAE
Swapan Kumar Samaddar
Database Administrator (DBA)
Kolkata
Email: **************@*****.*** Cell phone: +91-983*******
A challenging career in an organization that offers an excellent opportunity for professional growth, which allows me to use my strong technical, analytical and knowledge of Oracle DBA can be utilized for completing projects successfully with high quality, on time and within budget.
Over 4.3 years’ experience in Oracle DBA with Includes database Installation, Creation, Configuration, Troubleshooting with Oracle 10g, 9i, 8i, 7x on Linux and Windows environment. Fulfills DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence, etc.); space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
Technical Skill
Oracle 10g,9i,8i,7x(Linux and Windows)
Working in ITIL Framework(Incident Management, Change Management, Problem Management)
Monitoring Production databases
Installing and Patching (Bug Fixing Patch and CPU Patch) of Oracle 8i, 9i, 10g Binaries and Creation of databases using DBCA.
Administration and management of Backup of databases using RMAN in Disk.
Configure and manage Physical Standby database using oracle Data Guard.
Database Cloning through RMAN and refresh testing database using export, import.
Recover databases (Point in Time Recovery, Full Recovery and block corruption) as per requirement.
Troubleshoots (locks, ora-600, ora-7445, problem users, etc) and documents database problems as they arise.
Monitoring database performance and generate Statspack and AWR Report.
Project Profile
Experience
Organization Designation Duration
Genpact India Pvt. Ltd Senior Associate 2008-Till Date
Project 1 : Max Bupa India
Company : Genpact
Duration : 10/2010-Till Date
Role: : Team Member
Team Size : 5
Description: Production databases are in India. This group is responsible to maintain those production databases more than 10 databases and also test and development databases.
Tools Used: - Oracle Export/Import (To take Logical backup of Oracle Database and restore), RMAN (Oracle Utility to manage Oracle Backup), Data Pump, Statspack (To gather performance Statistics for database in 8i & 9i).AWR (in 10g), Putty, Data Guard.
O/s : Win XP
Responsibilities:
Providing Level1 and level2 support.
Fulfill SLA in ITIL framework with BMC Magic.
Supporting 24*7 of Production databases.
Fulfill DBA daily activities like User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, etc.
Collecting Stats pack (8i & 9i) and AWR (10g) report and analyze the reports. Based on those report Tune databases.
Troubleshooting oracle errors (ORA-600, etc) and providing support and helps to the clients"
Applying Bug fixing patches on oracle software.
Configure and manage physical Standby database using Data Guard for DR setup.
Recovery of production databases at the crisis situation in time
Refreshing Preproduction, Development databases from production databases through export/import, data pump, RMAN.
Project 2 : PLL Energy India
Company : Genpact
Duration : 03/2009- 10/2010
Team Size : 8
Role: Team Member
Description: -
Production databases are in India for whole Asia-Pacific countries. This group is responsible to maintain those production databases more than 20 databases and also test and development databases.
Tools Used: - Oracle Export/Import (To take Logical backup of Oracle Database and restore), RMAN (Oracle Utility to manage Oracle Backup), Data Pump, Statspack (To gather performance Statistics for database in 8i & 9i).AWR (in 10g), Putty, Data Guard.
O/s : Win XP
Responsibilities:
Providing Level1 and level2 support.
Supporting 24*7 of Production databases
Fulfill DBA daily activities like User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, etc.
Collecting Statspack (8i & 9i) and AWR (10g) report.
Troubleshooting oracle errors and providing support.
Applying patches for oracle databases.
Managing Physical Standby database using Oracle Data Guard.
Recovery of production databases at the crisis situation in time.
Administration of Backup and Recovery using RMAN.
Managing backup pieces and backup sets using RMAN.
Shell Scripting on various Unix Servers for automation of day to day database jobs like Start up – Shutdown, Export Backups etc.
Managing User Policies, Roles and Profiles for production Databases.
Alert log monitoring of Oracle Database.
Managing Users: creating users, synonyms, privileges, roles, quotas
Managing table spaces, objects, profiles, storage parameters.
Project 3 : Sunrise
Company : Genpact
Duration : 06/2008- 03/2009
Team Size : 5
Role: : Team Member
Production databases are in India. This group is responsible to maintain those production databases more than 10 databases and also test and development databases.
Tools Used: - Oracle Export/Import (To take Logical backup of Oracle Database and restore), RMAN (Oracle Utility to manage Oracle Backup), Data Pump, Statspack (To gather performance Statistics for database in 8i & 9i).AWR (in 10g), Putty, Data Guard.
O/s : Win XP
Responsibilities:
Providing Level1 and level2 support.
Supporting 24*7 of Production databases
Fulfill DBA daily activities like User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, etc.
Collecting Statspack (8i & 9i) and AWR (10g) report.
Troubleshooting oracle errors and providing support.
Applying patches for oracle databases.
Managing Physical Standby database using oracle Data Guard.
Recovery of production databases at the crisis situation in time.
Administration of Backup and Recovery using RMAN.
Managing backup pieces and backup sets using RMAN.
Shell Scripting on various Unix Servers for automation of day to day database jobs like Start up – Shutdown, Export Backups etc.
Managing User Policies, Roles and Profiles for production Databases.
Alert log monitoring of Oracle Database.
Managing Users: creating users, synonyms, privileges, roles, quotas
Managing table spaces, objects, profiles, storage parameters.
Master Of Engineering, July, 2009, with a DGPA of 84.4% from West Bengal University Of Technology in CSE.
Skills Proficiency Exp Level of Interest Year Last Used
Windows 2000 Advanced Server
Advanced 3+ yes 2012
Red Hat Enterprise Linux,
Advanced 3+ yes 2012
IBM AIX 4.3 to 5.3, Advanced 3+ yes 2012
Oracle 7x,8x,9i,10g
Advanced 3+ yes 2012
RMAN Advanced 3+ yes 2012
Data Guard Advanced 3+ yes 2012
Training Company/Vendor
OCA in Oracle9i Oracle
OCP in Oracle 9i Oracle
Name: Swapan Kumar Samaddar
Father’s Name: Late Dilip Kumar Samaddar
Date Of Birth: 08-01-1982
Marital Status: Single
Languages: Bengali, Hindi, English
Hobbies: Playing Cricket, Reading Books, Music.
Address for Communication: B-13,T-1/T-2, Khadim Bidyakut Abason, Narayanpur Battala, Kolkata-136
Notice period: 45 days
Willing to Relocate: YES
Contact this candidate