Deepak S.

About Me

Deepak is a Senior Database Administrator

Backend

Database

Database Administration (DBA) DBA Database Management Systems (DBMS) Microsoft SQL Server Database Development MySQL MySQL Workbench SQLyog SQL Stored Procedures MySQL Performance Tuning Oracle

DevOps

QA & Testing

Data Integrity Testing

Other

ITIL Business Process Re-engineering Agile Project Management Installation Lean Manufacturing Customer Experience Management Sales Management Program management Project Management Office (PMO) Data Loading SFTP Data Validation Data Quality ServiceNow IT Service Management (ITSM) SecOps ICMP Warehouse Management Sybase Performance Tuning

Work history

Freelance
Freelance
Senior DBA
2020 - Present (5 years)
Pune, India
  • Working on database development in MySQL using Workbench client and SQLyog.

  • Developing data layers for applications and writing data validation scripts for data integrity and quality check.

  • Writing data load scripts to pull data from multiple sources like SQL Server database, spreadsheets uploaded on a SFTP, etc.

  • Developing stored procedures to support the application's database operations and generate confidential reports.

Database Administration (DBA) MySQL DBA MS SQL Performance Tuning MySQL Performance Tuning Database Development MySQL WorkbenchSQLyog Data Validation Data ScrapingData Integrity Testing Data Quality SFTP SQL ServerData Loading Spreadsheets SQL Stored Procedures
Serviceberry (now Accion Labs)
Serviceberry (now Accion Labs)
Project Manager
2019 - 2021 (2 years)
Mumbai, India
  • Analyzed the scope of the project based on competitive analysis and customer feature requests, also in perpetuating strong customer relationships.

  • Accomplished the pioneering ServiceNow module, ITSM, SecOps, ITOM, and CMP.

  • Communicated progress and roadblocks to the executive management, making proactive recommendations for robust resolutions to drive projects toward on-time and on-budget completion.

  • Chaired projects, managed costs, and worked on scheduling and performances.

  • Initiated methodologies to rein in project costs while meeting key milestones.

  • Formulated insightful practices for individual project budgets, ensuring projects get an acceptable profit margin and ROI.

Project ManagementServiceNow IT Service Management (ITSM) SecOpsITOM CloudICMP Cost Management ROI Project Budget Management
PS IT Solution
PS IT Solution
Managing Director
2014 - 2019 (5 years)
Pune, India
  • Developed regular WSR and management reporting and key metrics for the board of directors and executive management to evaluate performance, adjust strategies, and maintain Agile, sustainable operations.

  • Administered proactive guidance for long-term business success by identifying risk and control measure, increasing profit levels to more than 50%.

  • Established new review processes and implemented improvements to existing practices to enhance the effectiveness of project operations.

  • Enhanced daily operations of warehouse management organization, orchestrating in-depth strategies to accomplish profit and expansion goals.

Management Reporting MetricsWarehouse Management Agile Project Management
IGATE
IGATE
DBA Practice Head
2011 - 2014 (3 years)
Mumbai, India
  • Advanced DBA services and increased customer satisfaction in finance, manufacture, and insurance by solving performance problems in MS SQL, Sybase, and other database issues.

  • Generated profitable margins and savings by resolving database resource problems, improving operations and client support.

  • Negotiated and resolved conflicts between parties, monitored quality assurance programs, onsite evaluations, internal audits, and customer surveys.

  • Provided end-to-end database solutions, skill-building, people management, and business development.

Database Administration (DBA) MS SQL Sybase New Business Development Quality AssuranceInternal Audits People Management
IBM
IBM
Senior DBA | Program Manager | Solution Manager
2003 - 2010 (7 years)
Pune, India
  • Created optimal technical solutions, high-standard database solutions, complex T-SQL queries, MS SQL, Sybase, Oracle, and DB2 UDB for data management and backup recovery.

  • Orchestrated proactive adjustments to operations, recruitment, office & inventory maintenance, quality standards, technical production & performance, collaborating with cross-functional teams and regularly meeting stakeholders.

  • Maximized technical support for database solutions and applications-related RFP.

  • Formulated and initiated strategies, troubleshooting, problem-solving, risk management, and technical integration with customer support and project management.

  • Provided DBMS solutioning for new and existing clients, with In-depth knowledge of how IBM do their business in application maintenance and innovation service.

Database Administration (DBA) Program managementT-SQLMS SQL Sybase OracleDB2Data ManagementRequest for Proposal (RFP) Technical SupportRisk ManagementProject ManagementDatabase Management Systems (DBMS)
Wipro
Wipro
Senior DBA
2002 - 2003 (1 year)
Bangalore, India

Worked as a consultant for American Express, designing, developing, and administering various database technologies like Sybase, MS SQL Server, and DB2.

Database Administration (DBA) Sybase Database DesignDatabase Development MSSQL ServerDB2

Education

MS SQL 2014 Database Administrator | MySQL 5.7 Database Administrator
MS SQL 2014 Database Administrator | MySQL 5.7 Database Administrator
Brainbench Technology - Nigeria
2021 - 2021
PGPBA Business Analytics
PGPBA Business Analytics
Great Lakes Institute of Management - India
2016 - 2017 (1 year)
B.Tech Computer Technology
B.Tech Computer Technology
Watumull Mumbai - India
1992 - 1995 (3 years)
BSc Mathematics
BSc Mathematics
SIES Mumbai - India
1989 - 1992 (3 years)