Deepak S.

Deepak S.

Database expert, Project management,Database Admin , Program Management

, India

Experience: 22 Years

Deepak

Database expert, Project management,Database Admin , Program Management

41142.9 USD / Year

  • Immediate: Available

22 Years

Now you can Instantly Chat with Deepak!

About Me

A professional with 22 years of diverse experience in Travel , Logistics ,Financial Markets, Credit Cards, capital market, Banking, Telecom and Distributi..., capital market, Banking, Telecom and Distribution in end to end project management and supoort. Very good exposure to infrastructure management system. Domain in functional roles ranging from software development, solutioning, program management to pre-sales. Leading DBA Practice for last 3.5 yrs for Application & Infrastructure management Service. Providing DBMS Solution for new accounts.

My Core competencies:

§  Sound knowledge in Cloud Technologies AWS, Azure, Three Tier Cloud platform

§  leading a team of developers engaged in product development to deliver quality product in a fast-paced dynamic environment of Logistic business

§  Mentoring the team of Analytics to build successful projects in Supply Chain management & Finance & Risk Analytics

§  Design, Architecture and performance management of the application in Finance, T&T, insurance domain

§  Managed one of large and complex database operation project for large insurance company

§  Increased competency headcount from 200 DBA to 350 DBA in span of 1.5 years

§  Perform as IBM Solution Manager at IBM fetched more than $50 millions of business in year 2008-09.  Work with various clients in different IMT/IOT. 

§  Performance as IBM Program Manager at American Express has contributed to IBM new business

§  Managed multi million dollar portfolios for IBM as a Delivery Manger supporting its engagements with American Express and Duskin.

§  Led project teams of nearly 50 consisting of Senior Architects, Project Managers, Tech Leads and Developers in both Application Development and Application Support.

§  Successfully implemented a highly optimized 24 x 7 Production Support team providing application maintenance for 10+ applications by successful cross trainings, shift management and high employee satisfaction levels thereby contributing to low attrition.

§  Guided, mentored, coached and evaluated performance of a team of 100+ as People Manager & Database Guru.

§  Took on the responsibility of Project Manager in 2002 with barely 4+ years of work experience

§  Delivery manager, Program Management, problem management and Project Management in larger engagement.t

§  DBA Practice Head to manage all the databases technology.

§  Database Solution Architect and pre-sales manager in getting new business.

§  Technology expertise in Oracle 12c, 11gR2, MS SQL Server 2014, 2012, 2008 R2, DB2 UDB 9.5, 8.x, Sybase 15.7, 12.5.x, Replication Server 12.5

§  Very good exposure on Oracle Ebiz

§  Sound knowledge of BIG Data technology

§  Disaster Recovery solution using RAC, MS Cluster, Replication, RMAN

§  Migration and upgradation of database technologies,

§  Datacenter consolidation

§  Expertise in Data Masking technology – OPTIM, DMSuite

§  Client Relationship management, Vendor Management

§  Virtualization and Cloud management of database technology

§  Posses’ good knowledge on providing estimation for database efforts.

§  Pre-Sales, Customer Orals, Customer briefings, Staffing, Training and Recruitment, Department and Organizational initiatives.

§  Driven by new challenges and adept at adapting to any cultural and business environments.

Show More

Portfolio Projects

Contribute

Developed new product using Java and MySQL. Created entire database design and front end design.

Description

Working as independent consultant for last few years to work on different database technologies like MySQL, MS SQL Server, DB2 UDB and Oracle. Developed the product for India based market in Logistic domain.

· Managing team of developers to build the product in Logistic environment using Cloud platform

· Build Always-on for one of the esteem client in USA in Azure platform

· Architect and code highly scalable cloud application on most reliable technologies

· Database design & implementation as per need of CRM

· Performance management on database as well as front end development

· Troubleshooting of MS SQL Server, Sybase MySQL & DB2 UDB

· Performing daily backup

· Optimization of database to suit application

· Developing stored procedure and training the Jr. Resources to write the effective code.

· Production problem solving and database design changes as per the project requirement.

· Actively participating in the Database groups in LinkedIn.

· Consultation with different company on new prospects.

Expertise in Social media Analytics , Web mining and text mining.

Show More Show Less

Contribute

Working Database practice head. Build Goto Market strategy and solution in Database technology

Description

· Program management and delivery management for complex project

· Participated in RFP and RFI for database solution

· Client management.

· Managing DBA practice of around 300+ practitioners

· Building new offerings in DBA area

· Participating in Pre-sales activity

· Resource management

· People management

· Managing the new and potential customer

· Establishing the new relationship with database vendors

Show More Show Less

Contribute

Database Administrator

Description

Involved in DBA activity of Real time system.

§ Working under 7X24 Production support.

§ Setup Log Shipping in SQL Server 2000.

§ Involved in performance, tuning, data modeling, installation and troubleshooting.

§ Installed Sybase SQL Server 11.0.3.3, 11.5.1 & 11.9.2.x & Replication Server 11.0.3 & 11.5.1.

§ Installed MS SQL Server 7.0 & 2000.

§ Setup warm standby replication

§ Troubleshooting of Replication server.

§ Stored Procedure Audit

§ Writing shell script to automated DBA activity.

§ Created web page for the dump and load process.

§ Migration of the Sybase Server to SQL Server

§ Performance Tuning using HPOV(HP Open View) data

§ Supporting Autosys database . Mainly used for application job scheduling.

§ Cron management for scheduling DBA maintenance job.

Environment : Sybase 11.0.3.3 , ASE 11.5.1 , ASE 11.9.2.x & ASE 12.x Replication Server 11.0.3 & 11.5.1, MS SQL Server 2000, MS SQL Server 7.0, SQL BackTrack 4.x, ER-Win 3.5 , Microsoft Project, Microsoft Office,Hp-Ux 1020, Sun Solaris 2.51,Perl ,apache 3.1

Show More Show Less

Contribute

contributed many ways in project management, database management etc

Description

§ Onsite/offshore coordinator. Work assignment to Offshore DBA.

§ Knowledge sharing of application

§ Schedule training on Sybase Replication Server & Performance & Tuning.

§ Working under rotating On Call DBA.

§ Responsible for planning and implementing upgrade of MS SQL Server (6.5, 7.0 & 2000), UDB 7.x & Adaptive Sybase Server 11.9.x , 12.x

§ Transact SQL Programming

§ Installing/Upgrading SQL Server

§ Creating and managing databases.

§ Integrating SQL Server and NT Security.

§ Build Disaster recovery environment using tran sync, copydb or replication

§ Backup and restoration plan.

§ Disaster recovery of SQL Server, Sybase & DB2-UDB

§ Extensive use of data and object migration tools such as DTS and DBArtisan.

§ Setup Log Shipping in SQL Server 2000.

§ Involved in performance, tuning, data modeling, installation and troubleshooting.

§ Creating Tablespace & Tables in UDB DB2

§ Migration of database from Sybase to DB2 UDB.

§ Performance Tuning using BMC Patrol data

Show More Show Less