Shailesh S

Experience

• 

  ICICI Bank

  Aug 2005 - Nov 2005

  Phone Banking Officer
• 

  Sreyanjali International

  Dec 2005 - Dec 2006

  Documentation Executive
• 

  Super Religare Laboratories Ltd.

  Jan 2007 - Jan 2010

  IT Officer

  • Support to DBA team in ensuring Backup of Oracle 9i Database using import & export utility as well as Space Management• To ensure the implementation and management of the ERP application • Data Synchronization of all centralized locations• Database support to users for troubleshooting Application related issues• Creation & management of access rights of various users • To ensure installation/reconfiguration/reinstallation of applications, diagnosing and providing solutions to users difficulties• To prepare a monthly activity report (MIS)• Integration & Functional testing of ERP & various application Show less

• 

  PCS Technology Ltd.

  Feb 2010 - Sept 2011

  Jr. Implementer

  • Installing and maintaining all LIS/database software using SQL Server 2000 and SQL Server 2005 Database technologies at Client site as well as management of the application and database• Managing all Backups and Recovery plans using available backup sets or Datafiles & Log files – Recovery of a suspect database • Import and Export of Database objects like tables,views,procedures,functions,triggers between databases• Database Migration from SQL Server 2000 to SQL Server 2005 • Troubleshooting of Database – Creation/Restoration of Database alongwith testing of Data source• Implementing database objects (tables, procedures, functions, triggers)• Front-end as well as Database support to users for troubleshooting Application related issues using SQL Server Profiler Show less

• 

  Advance Computer Services Limited

  Jul 2012 - Apr 2013

  SQL Database Administrator

  • Maintenance of all Client Databases using SQL Server 2005,SQL Server 2008 and SQL Server 2012 in a 24X7 environment• Backup and refresh of databases between Production and Testing/Development servers as per request• Monitoring the database status,disk space, logs, space utilization • Monitoring and maintaining all jobs running & troubleshooting it on failure • Monitoring Replication jobs and troubleshoot it on failure• Monitoring Database Mirroring and troubleshoot it on failure• Report causes of Replication latency issues to client by checking running queries,jobs on the server • Assigning db rights or modify existing rights to users • Prepare a Daily SQL Report mentioning the space details,job schedule,job status,backup details,log space and average runtime of all servers Show less

• 

  Panoramic Universal Ltd.

  May 2013 - Jun 2015

  SQL Server DBA

  • Installation & Configuring of SQL Server 2008/2008R2,SQL Server 2012 & SQL Server 2014 CTP2• Setup & Configuring Linked Server,Logshipping,Replication,Mirroring and Clustering on production/test servers as per requirement• Maintenance of all Inhouse Website Databases using SQL Server 2008,SQL Server 2008R2 & SQL Server 2012• Backup and refresh of databases between Production and Testing/Development servers as per request• Monitoring the database status,disk space, logs, space utilization • Monitoring and maintaining all jobs running & troubleshooting it on failure • Administering Logshipping,Replication,Mirroring,Clustering & troubleshooting it on failure • Database migration from SQL Server 2008 to SQL Server 2012• Managing Database Users and security• Creation,Configuring & Deployment of SSIS • Script execution,Checking db with DBCC Commands and db object changes as per request Show less

• 

  Mahaonline Limited

  Jun 2015 - Feb 2016

  Database Administrator

  Worked in this Joint Venture between State Govt. & TCS, reporting to the Manager and supervising 2 resources, participating in multiple (9) portals for automating functions of the organization - cscservices, revenue, aaplesarkar, lms, molpg, excise, e-challan, yashada and suvidha.

• 

  Wipro

  Feb 2016 - Dec 2018

  Senior Administrator

  Reported to the Project Manager and supervised Prod Support resources, in a project for an international banking client (Citi Bank).Drove an L3 team on database servers (with different versions), performing daily health-check of all database servers and send a report. Performed DBA tasks as per the CMP order and executed incident resolution and change requests.Executed Change management & Incident resolution as per ITIL processes along with CMP (market order), using ServiceNow and coordinated with all teams for completion of Tasks.Directed Continuity of Business (COB) drill activity of performing a fail-over/fail-back of database servers-Logshipping & Database Mirroring, as per RBI guidelines.Implemented SQL service Packs, Audit, Migration, VTM patching of MS SQL server 2008/2008R2/2012.Worked on Clustering and patching on cluster servers.Participated in Audit setup, Management of audit reports, coordination for implementation of SCOM and Autosys.Guided Production Support team in delivering database resolutions within the pre-set timelines. Show less

• 

  CeX Webuy.com

  Dec 2018 - Jul 2020

  Database Administrator

  Reported to the Manager as an individual contributor for multiple DBA responsibilities - migration of servers (400+) from MS SQL Server to MySQLFurther provided responsibilities - Replication issues, monitoring/checking data sync from AWS MS SQL server to client databases and provided remote support, during lockdown period.Engaged in new server build in MySQL & MS SQL Server databases, while created change requests and executed JIRA requests.Created database health-check reports as well as provided support to users for deployment and other Database issues. Show less

• 

  Netxcell Limited

  Aug 2020 - now

  Database Administrator

  Currently serving Notice Period with LWD 02/04/2022Participating in SBI Project, to provide oversight to Production & UAT servers for MS SQL Server database on Windows Platform.Providing oversight to SQL Server Patching, working on Azure Cloud platform and implement MySQL in Linux platform (on a different project).Worked on SSIS and SSRS reportsConfigure different types of Azure SQL Database and setup monitoring and alerts and troubleshoot the performance issues.Working with Developers for creation of new database objects,application issuesDirecting deployment/implementation of application releases both in Production DB and App servers.Detecting & resolving App issues, coordinating with Developers and implementing changes in IIS & folders. Further resolved Security vulnerabilities & Database issues, by automating maintenance tasks.Driving remote support, on-call guiding of team members/Production support team. to perform Database activities achieving required SLA. Implementing/Auditing Database Activity Monitoring Tool, Transparent Data Encryption (TDE) as well as maintaining security standards. Show less