Incident Manager Database Administrator

Technically Sophisticated with career reflecting strong leadership qualifications with

hands-on ex. Database Management – core and business intelligence,project operations. BISWARUP GHOSH

Database Architect (DBA) / Operational Specialist (10 + Years Exp.) SQL SERVER ORACLE DR ADMIN AWS AZURE VEEAM POWER BI AUTOMATION

+971-********* / +971-*********

**********@*****.***

Dubai

EDUCATION

• B.Tech.(Electronics Engineering)

from RTMN University (RCOEM),

India with 68% in year 2011.

TECHNICAL SKILLS

• Databases: MS SQL Server -SQL 7.0,

2000,2005,2008,2008R2,

2012,2014,2016,2017,2019

Oracle -19c, 12c,11g

Cloud - AWS RDS, AZURE DB,Aurora

• Tool:SSMS,SSRS,SSIS,SharePoint,

SVN,Qubole,HPSM,Automic,PoweBI,

SNOW

• High Availability: Always ON,

Mirroring, Logshipping,Clustering,,

Data Guard, Replication

• Cloud: AWS, Azure

TRAININGS

• Trained on AWS solution architect

• ITIL V3, V4 Foundation

• ITP training given by Tech

Mahindra which including

C Language, UNIX, Java,

J2EE,BasicTelecom,OSS/BSS

Oracle 10G PL/SQL, DBMS,

SoftwareEngineering, VVT

CORE COMPETENCIES

PROFILE SUMMARY

• Hands on experience of high availability features in RDBMS (Implementation and Support).

• Implemented Disaster Recovery at client side for Majid AL Futtaim Properties (Dubai).

• Proficient in SQL 2019/2017/2016/2014/2012/2008R2/2008 setup and installing hotfixes and SPs in clustered environments.

• Capacity planning, sizing and complete understanding of SQL Server/Oracle architecture, sound knowledge of T-SQL coding.

• Experience in SQL Server installation, configuration and maintenance also restore databases from backups for break fix and point in time.

• Extensive knowledge as Microsoft Business Intelligence DBA (Analysis Services & Reporting Services).

• Upgrade/Migration of SQL Server from earlier versions to the latest version’s hands on experience.

• Expert in MS SQL Server performance tuning using tools like SQL Profiler/DTA.

• Proactive at work, self-motivated with natural leadership traits, expressive communication skills, adaptable to any situation.

• Strong experience in working in customer facing role and onsite-offshore delivery model.

• On field experience in data center and disaster recovery operations.

• Hands on experience Oracle database cloning, granting user access, database patching, table space management.

• Extensive support as incident manager, capacity planning, assets billing.

• Ensured the availability of the Database Server in a 24x7 Environment through the setup of HA options and automated jobs.

• Export & Import data from Flat file, CSV file Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS.

• Hands on experience in implementing backup and recovery strategies using Hot/Cold backup, RMAN, Logical (Import/Export).

• Good Interpersonal communication, Documentation Skills and direct interaction with client/users on various issues.

• End to end site setup management with all network connections and telephony in Kingdom of Saudi Arabia (Riyadh).

• Power BI dashboard, Chat Bot, Digital Signature, Server Automation, EUS CSAT Mechanism and new initiative implementation like Security Score card (Power BI).

• Expertise in OS (HP/Linux/Windows) & OS issues monitoring & troubleshooting.

• Defined service delivery standards, ensured adherence to delivery model, built the roadmap using AWS roadmaps & maximizes adoption of new services and products.

• Knowledge of AWS and led enterprise architecture, information management and cloud computing product architectures, implementation and delivery.

• An enterprising leader with excellent negotiation, analytical, organizational, troubleshooting and interpersonal skills.

• Handling 450 + SQL Server with 5000 + Databases which includes Designing, Planning, Implementation and support.

Database Administration (DBA)

AWS Cloud Architecture

Business Intelligence (BI)

Database Architecture

Data Migration

Disaster Recovery

Incident / Problem Management

Vendor Management

Database Capacity

Inventory/ Asset Management

Team Management

DC Infrastructure Management

A

PERSONAL DETAILS

Date of Birth: 9th August 1989

Languages Known: English,Hindi,Bengali

Permanent Address: c/o Naba Kumar

Ghosh, Station Road, Fashion House Lane,

Katwa - 713130, West Bengal, India

Marital Status : Unmarried

License Details : India, UAE

SOFT SKILLS

CERTIFICATION

• Microsoft Certified Professional (MCP)

in SQL Server 2008

• Microsoft Certified Solutions

Associate (MCSA) in SQL Server 2012

• Microsoft Certified Solutions Expert

(MCSE) in SQL Server 2012

• Microsoft Certified Solutions Expert

(MCSE): Data Management and

Analytics

• Oracle Certified Associate (OCA)

• ITIL V3 Foundation Certified

• AWS Certified Solutions Architect -

Associate

ACCOMPLISHMENTS

• Awarded as RISING STAR award in

FY12-13-Q1.

• Represented National in Badminton

2006-2007 and Kho-Kho in 2004-

2005.

• Elected as a PRESIDENT (Electronics

Branch) in 2010-2011.

• Awarded as BRAVO award in FY15-

16-Q2 and FY 16-17-Q4.

• Awarded as Pat on the Back award in

FY15-16-Q4, FY17-18-Q4, FY18-19-

Q4, FY19-20-Q2 and FY20-21-Q4.

• Awarded as Standing Ovation Award

in FY16-17-Q2, FY18-19-Q4 and

FY19-20-Q3.

• Awarded as Best AQTivist Award for

Automation and Digital Initiatives in

FY18-19-Q3

WORK EXPERIENCE

Since May’11

Tech Mahindra Ltd.

as Database Technology Lead

Key Result Areas:

• Playing a key role as Technical Lead with an expertise in engaging, challenging and motivating individuals; ensuring that the team provided a responsive and efficient service to internal and external customers.

• Undertaking strategy planning and implementation which had an impact on technology direction for the division and business segment; managing workload and multiple priorities in a fast-paced environment.

• Designing, installing, upgrading, administering, monitoring, patching, and cloning various boundary systems.

• Identifying, recommending, and implementing new database technologies and database license management.

• Collaborating with end-users and department managers for capacity planning and development of long-term strategic goals for production databases.

• Working with application support staff in developing database architectures, coding standards, and quality assurance policies and procedures.

• Coordinating with network engineering, business application, & systems administration functions to implement desktop and server systems that utilize industry best practices to meet corporate objectives.

• Performing extensive follow-up procedures to obtain, update, and validate information; maintaining an exceptionally high accuracy rate through data verification, attention to detail, and regular quality control checks.

PROJECT MANAGED:

Projects at Tech Mahindra

Period: Since May’11

Client: Majid Al Futtaim Properties (Dubai), Tigo Telecom (Ghana) Role: Lead DBA (SQL & Oracle) and DR Admin

Key Result Areas:

• Designing, architecting, building and maintaining high performance and highly available database infrastructure.

• Subject Matter Expert for Database Administrator team and leading team of 7 people.

• Gathering of system information for all database/application servers, monitoring server performance and tuning.

• Responsibilities as a SME to gather all information has and upload updated documents versions to SharePoint.

• Handling role of Incident manager, capacity planning coordinator and project billing.

• Full responsibility over the “DB change management” process on the production environment (deadlock/locking, rebuilding Indexes, Performance tuning).

• Establish disaster recovery testing methodologies, plans and business resumption procedures in different functional areas.

• Works with vendors for disaster recovery services, facilities and recommends outside services for use during a disaster situation.

• Works with management to ensure that new equipment, facilities, services and systems are installed to address the disaster recovery issues.

• Responsibilities of SLM reports and achieving SLA’s as per service level management agreement.

• Performed BI- Annually DR Drill (March 2019, Sep-2019, March 2020, Sep-2020 etc.) activity successfully.

I hereby declare that the above-furnished details are true to the best of my knowledge & belief. Looking forward to having in hand an opportunity to work in your esteemed organization and use my potential to serve to your full satisfaction. Biswarup Ghosh Strategic

Customer

Centric

Planning

Problem

Solving

Team

Leader

Versatile

Professional

Contact this candidate