Shilpa Ghosh-Hajra

Tel: +91-981*******

aboins@r.postjobfree.com

C ur r iculum Vitae

Objective

Pursue my career as an Oracle DBA utilizing my knowledge and skills.

Experience Summary

• 5+ years of experience in Information Technology. This has involved in Oracle

Database Administration, Application Support and Maintenance (ASM) projects.

• Over 3 years of Database Administration Experience including Installation,

Configuring,

Monitoring, Implementing Backup and Recovery Strategies, User Administration and

Tablespace Management.

• Significant knowledge in Unix Administration, Shell scripting and Database related

concepts like SQL, PL/SQL.

• Exposure to L1, L2 and L3 support and experience in working directly with the

development team and the customers to fulfill their needs and produce quality

solutions within time.

• Quick learner and excellent team player having the ability to work under pressure

and meet deadlines effectively.

• Expertise in t rouble shooting and good in communication skills.

Education

• B.E. in Electronics from Shri Ramdeobaba College of Engineering and Management.

Shilpa Ghosh-Hajra

Tel: +91-981*******

aboins@r.postjobfree.com

P rofessional Certification

• Oracle Database 10g Administrator Certified Associate ( OCA DBA)

• Oracle PL/SQL Developer Certified Associate

T echnical Summary

Operating System :Solaris, Windows, HP-UX

Databases :Oracle 10g / 9i

L anguages :SQL, PL/SQL, Unix Shell Scripting

Tools :Oracle Enterprise Manager, Import /Export, Toad, SQL Developer,

SQL Loader, D D BCA, DBUA, Bridge Clarify, SVN, Vi

E ditor, Putty, WinScp, Filezilla

Achievements

Received Long Service Award – 5 Years (15-Jun-2012) in T ech Mahindra

Projects Summary

Project Name : Landmark –BPA

C lient : H utchison Telecommunications I nternational Limited (HCPT)

Domain : Telecom

Role : Database Administrator

Company : Tech Mahindra

Duration : 14th J uly, 2009 – till date .

R esponsibilities:-

Shilpa Ghosh-Hajra

Tel: +91-981*******

aboins@r.postjobfree.com

• Basic Database Administration which included Tablespace Estimation and

M anagement, Statistics Collection, Alert log monitoring, User Management and

Schema Management.

• User Management which includes creates, drop database users, grant and revoke

p rivileges.

• Testing of successful backups and monitoring of alert logs and t race files.

• Reorganization of the database segments through Storage Parameters.

• Database refreshment using export/import and datapump.

• Database Designing analysis and Creation as per the requirements.

• Analyze AWR, ADDM and Statspack report to optimizing the performance of the

database.

• Server Monitoring viz. CPU utilization, File system growth, Memory utilization etc.

• Define and implement Backup and Recovery strategies for the Database Servers.

• Tracking down CPU consumption of the most highly used SQL statements.

• Reviewing and tuning SQL and PL/SQL code.

• Writing shell scripts for Database monitoring of routine DBA activities, alerts and

e rrors.

• Configuration of listener and establishing connectivity of the database.

• Loading and Configuring data into the database

• Resolving adhoc request from user like blockers, session kill, dead lock etc.

• Create and maintain documentation specific to DBA activities of the project.

• Proactively give DBA support to projects in TM as per the requirement of projects.

• Troubleshooting and resolving any ORA- errors.

• Schedule, analyze and implement Database Change Requests.

• Data file reorganization to save on disk space and improve DB performance.

• Export and Import

• In addition normal DBA activities I have provided value added services like automated

entire database monitoring system using UN IX shell scripts, sql scripts.

• Provide business knowledge to other team members.

P roject Name : Tiscali Application Development and Maintenance

C lient : T iscali UK Ltd

Shilpa Ghosh-Hajra

Tel: +91-981*******

aboins@r.postjobfree.com

D omain : Telecom

Role : Application Support / Developer

Company : Tech Mahindra

Duration : 29th April, 2009 – 15th J une, 2009

Project Description:-

Tiscali Systems consist of several applications developed in many technologies. Perl based

systems are DSLRP, Prequal, CPS, VMS, CDR Mediation, C4, BOSEEXT and N I M. Each of

t hese systems communicate among them and also communicate with external like BT

Systems for order provisioning (new provide, cease, regrade).

Order f lows from reseller portal to Prequal systems, gets validated then f lows to Ecare and

t hen to DSLRP for order provisioning. Dslrp communicates with Prequal, VMS, BTH and

N I M, based on the order type and product type. Each Tiscali system communicates with

other internal systems and external BT systems for getting relevant information on Order

P rogress.

Responsibilities:-

• Bug fixing, enhancements and maintenance.

• Fixing the sql queries and stored procedures.

• Providing support while deployment activities.

• Unit Testing and release documents.

• Raising Change Requests for data change in the production severs and closing the

requests after completion of work.

• Documenting all the technical changes or work done on the production server.

• Following all the processes and knowledge sharing with other team mates.

Shilpa Ghosh-Hajra

Tel: +91-981*******

aboins@r.postjobfree.com

P roject Name : Anticipation Fault Manager- Test and Diagnostic data store (AFM-

TADDS)

C lient : B ritish Telecom (BT)

Domain : Telecom

Role : Application Support / Developer

Company : Tech Mahindra

Duration : 15th J une, 2007– 27th A pr, 2009

Project Description:-

My ASG team is the support team for AFM-TADDS. AFM-TADDS is the Anticipation Fault

M anager- Test And Diagnostic Data Store, part of the Access Network Improvement

P rogramme (ANIP). I t supports proactive maintenance of access network by analyzing the

routine line test data captured overnight. Line Test Data is retrieved from Line Test

Systems located at Leeds, Manchester, Harmondsworth and Derby. The data sent to AFM is

p rocessed and utilized at ANIP Control Centers for determining the r isk of potential faults

on customer lines. AFM is the application, which provides facilities to analyze Line Test

Data, present the results of the analysis to a User to aid the generation of Soft Faults and

H ard Faults and record information relating to Network Health and individual circuits.

A FM receives data from the GILTS servers at Teradyne.

R esponsibilities:-

• Provide second and third line support for AFM including handling faults raised by users

and carrying out various proactive maintenance activities, to minimize fault levels.

• Carried a company laptop and mobile phone for 3 yrs for BT for 24*7 support work.

• Pro-active maintenance of the application

• Supporting AFM Live Boxes.

• Developed scripts in UN IX and ORACLE to automate daily ASG housekeeping work.

• Writing SQL Loader control file for adhoc data insertion.

• Writing codes as when required in UN IX and PLSQL.

• Going through the existing codes and making modifications as required.

Shilpa Ghosh-Hajra

Tel: +91-981*******

aboins@r.postjobfree.com

• Providing support while deployment and ensuring there smooth completion on

P roduction server.

• Creating and modifying various reports, documents as per the User requirements and

for the project requirement as per BAU.

• Building up a very strong customer support and communication structure.

• Maintaining the standards set by BT

Personal Details

Name : Shilpa Ghosh-Hajra

DOB : 17th M ay, 1985

Email : aboins@r.postjobfree.com

Address : F-62, BPCL Apts, B – 9/5, Sector 62, Noida -201301

Shilpa Ghosh-Hajra

Contact this candidate