Shailesh S Email & Phone Number

Mumbai Area, India

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.

Mumbai, Maharashtra, India

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.

Mumbai Metropolitan Region

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.

Mumbai, Maharashtra, India

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.

Mahape, Navi Mumbai

• 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

Millenium Business Park, Navi Mumbai

• 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

Sakinaka,Andheri

• 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

Andheri

• 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

Mumbai, Maharashtra, India

Mumbai, Maharashtra, India

Bachelor'S Degree, Software Systems, Second Class

Subjects- Discrete Mathematics,MS Office,C,C++,VB6,Oracle 8i & Java Project on Electronic Voting Program done on VB and MS-Access

High School Diploma, Science, 2Nd

Science subjects(Physics,Chemistry,Biology),Maths alongwith English,Hindi

Ssc, All, A - First Class

Activities and Societies: Kabaddi,Kho-kho,Running,Marble Spoon race Basic all school subjects alongwith languages

Education record