Oracle DBA, DB2 DBA, SQL, PL/SQL, Unix Shell Scripting, Rac

DBA

PROFILE

Having over ** years of Database Administration experience working with database like DB2 LUW, Oracle and SQL Server over Unix and Windows platform supporting global clients. I am experienced in database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. I am proficient in Database Software Installations, Migrations, Database Capacity Planning, Data Security, Backup & Recovery and Performance Tuning, RAC / ASM administration for Oracle databases. I closely work with the architect group in designing the logical and physical model of the databases for optimal performance. I have an excellent proficiency in Unix shell scripting which lead me to develop various automation tool for daily DBA work thus maximizing proactivity and efficiency in daily database Administration activities.

SKILLS

Unix Shell Scripting

Design and implement Backup and recovery strategies.

Database / table / tablespace level recovery of online Production databases point in time.

HADR Implementation and setup.

Data Guard Setup and implementation.

Installations and Upgrades of databases

Cloning databases

Database Migration

Performance tuning of Databases both production and Development.

Capacity/Storage Planning of Databases

SQL Tuning.

Troubleshooting databases.

SQL, PL/SQL.

IBM Certified Advanced DB2 DBA.

IBM Certified IT specialist.

Oracle Certified 9i DBA.

SANJIB GANGULY

SENIOR DATABASE ADMINISTRATOR HTTPS://WWW.LINKEDIN.COM/IN/SAGANGULY/

EXPERIENCE

SENIOR DATABASE ADMINISTRATOR AND PEOPLE MANAGER • IBM (GLOBAL BUSINESS SERVICES) • MAY 2006 – PRESENT

I am working as a Senior Database Administrator supporting both Development and Production databases of Oracle [hosted on Oracle HAS Cluster version [12.1.0.2.0]] and DB2 hosted on Linux, Windows and AIX environments supporting Clients across the Globe. I am involved in Database Design and Modeling working closely with the Architects. Maintaining Production Databases by Working on Performance Tuning, Backup Recovery Strategies, Disaster Recovery setup and maintenance, managing user Securities. I also lead a team of DBAs, where I am involved in assigning and tracking the tasks across the team based on skill matrix for smooth and successful delivery of the work products and resolving conflicts. I also work as a mentor and a People manager for members of the DBMS competency. Achieved wonderful results by automating regular DBA tasks using shell scripting in the Projects to minimize the cost and efforts for the deliverable and increase efficiency by at least 60 to 70% in terms of man hours pro-activity. As an active member of the DBMS competency I have leveraged my knowledge and skills across the Competency to cross train DBA members and resolving Database issues across all projects. I have also been regular presenter representing IBM in the IDUG sessions where I’ve presented sessions on DBA Tips and Tricks using DB2 tools from 10.5 and New Features of DB2 10.5 BLU. I am associated with multiple projects within IBM [MBPS assets, Marriott, Nestle, Coca Cola, Myer, Aldo, Ericsson]. I have more than 12 generic assets for supporting the Database environments in Oracle and DB2 which are used by DBAs across IBM Global. Currently working with Design Thinking Approach for addressing Client requirements.

ORACLE DBA (CLONING SPECIALIST) • ORACLE INDIA PVT. LTD • DECEMBER 2005 – APRIL 2006

I worked in Oracle India as a Cloning Specialist in OHSREFRESH team where my responsibilities involved Apps Instance and database instance Cloning for the instances hosted at Oracle Datacenter at Austin as well as at client place. I have cloned both RAC and non RAC Apps instances in Oracle 9i and 10g. I have converted Non RAC to RAC instances Supported tars raised concerning client issues with database cloning. Achieved as the best Team member recognition by resolving maximum number of tar successfully per day.

SENIOR TECHNICAL SUPPORT ENGINEER (DBA)• MICROLAND INDIA PVT. LTD. • MAY 2005 – DECEMBER 2005

I worked as an Oracle DBA Supporting Clients Database in India and Europe. The major client supported was SERCO. My responsibilities as a Database Administrator involved Database monitoring [All database components], maintenance and reporting on the database components, Performance Tuning and Analysis using StatsPack reports, Monitoring CPU usage, troubleshooting database incidents and problems on a 24 X 7 mode, handling Service Request, change raised by the customers. Implemented monitoring scripts in the databases which proactively monitored the database hence reducing the number of Remedy / BMC tickets.

PROJECT MANAGER AND DBA•123 INDIA L.T.D • DECEMBER 2004 – MAY 2005

I was involved in Communication with the Clients in understanding the requirements, Prepare the SRS, Model the data architecture and Data flow diagram, Design the Database and designate tasks to the Development team to develop the software based on the customer requirements, coordinate with the QA team to ensure Quality of the deliverable. Tools and technologies used to perform my tasks were MS Project, MS Visio, Oracle 9i, MS Access, MySQL.

PROJECT MANAGER AND DBA • INAVIGATORS INDIA PVT. LTD • JUNE 2004 – DECEMBER 2004

I was involved in Project Management, Preparing SRS and SOW, Database design (Logical and Physical) and Data Flow diagram, designate tasks to the Development team to develop the software based on the customer requirements. I have also developed the database stored procedures and functions to encapsulate the Data Access logic within the database to ease the Development process. I had designed the entire database [ physical and logical] for Brosil Glass Works Pvt. Ltd in Oracle 9i database suiting to the security and performance requirements for the supply chain management solution.

TEAM LEAD / DEVLOPER/ DBA• BASE SYSTEMS PVT. LTD • JANUARY 2004 – APRIL 2004

I was involved in gathering requirement from the client and forming Database design (Logical and Physical) and Data Flow diagrams, designate tasks to the Development team to develop the software based on the client requirements. I have also developed the database stored procedures and functions to encapsulate the Data Access logic within the database to ease the Development process. I implemented biometric security solutions in many of the clients of Base systems including Bangalore Club [ Point of same system] and Ramesh flowers Thoothukudi [ attendance management system].

SENIOR DEVLOPER AND DBA •AMI INDUSRIES [TCS VENDOR] • APRIL 2003 – OCTOBER 2003

I was responsible in developing the Modules in Microsoft VB and maintaining the Development database, tune the SQLs being used in the Module, Creating and Managing the Database objects and the Tablespaces. Tuning the Database to ensure optimal performance. Among the major clients were NHPC and HPCL [Power plants. govt. of India undertaking].

SOFTWARE DEVELOPER /DBA • OHI SSL LLC MUSCAT • DECEMBER 2001 – JANUARY 2003.

I was responsible in developing the Modules in Developer 2000 with the Database as Oracle 8i. I was also responsible to maintain and create the Database objects. The major clients handled included Ministry of Defense Oman [Inventory Management, HRMS], Ministry of manpower Oman [Oman Census capturing System developed in C for Palm OS]. The databases were Oracle 8i hosted in windows NT server.

SOFTWARE DEVELOPER • PENTASOFT TECHNOLOGIES LTD. • JUNE 2000 – DECEMBER 2001

I was responsible in developing the Modules in Developer 2000 with the Database as Oracle 8i. I was also responsible to maintain and create the Database objects. The Majour Client Handled was Metro Railway Kolkata [Transaction accounting system].

I have also worked as a Freelance Software Developer and Corporate Trainer for Creative Solutions Kolkata (India) where I had developed many Software for small scale Companies in Kolkata single handed where I was the only person responsible in gathering the customer requirements, design the data flow and modeling and designing the database and developing the software in VB, FoxPro with database like Oracle and MS Access as the backend

EDUCATION

MBA INFORMATION SYSTEMS • 2013 • SIKKIM MANIPAL UNIVERSITY

B.SC (MATH) • 1998 • MADURAI KAMRAJ UNIVERSITY

Contact this candidate