Narendra V. Redekar
Assistant Manager-SQLDBA
Kalyan
Summary
Experienced with managing intricate database environments to ensure peak performance and reliability. Utilizes SQL optimization and performance tuning techniques to support business needs. robust data security measures to safeguard critical information.
Overview
15
15
years of professional experience
3
3
Certifications
3
3
Languages
Work History
Assistant Manager
Quattro Business Support Services
09.2020 - Current
- Manage ERP & SAP databases
- Configured TDE certificate for securing PROD databases
- Configured replication from On-Premise to Azure SQL Elastic Pool
- Performed database migrations from On-Premise to Azure SQL Elastic Pool
- Space Management - Configure database mail to send an email when disk space 10%, 30% less
- Index creation (cluster, non-cluster), database jobs, maintenance planning, and Database tuning, backup policy, DTS (Export-Import) & it Monitoring Regular
- Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery
- Monitor SQL Error Logs, Schedule tasks, and database activity
- Scheduled and maintained jobs, alerts and maintenance plans and troubleshoot the failed jobs
- Supervised day-to-day operations to meet performance, quality and service expectations.
- Proactively monitor and plan storage capacity for DR infrastructure
- Configure Temp DB Disk space automation on Central server
- Management of multi-terabyte production Environment
- Deploy database change scripts provided by third-party vendors
- Planning and implementation of SQL Server Backup and Restoration
- Expert in Migration, upgrading of SQL servers
- Planning and implementation of Log Shipping, Mirroring, Replication
- Improved customer satisfaction by addressing and resolving complaints promptly.
Sr. Database Administrator
YNI Global Shared Services LLP
04.2020 - 08.2020
- Monitor SQL Error Logs, Schedule tasks, database activity
- Scheduled and maintain jobs, alerts and maintenance plans and troubleshoot the failed jobs
- Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery
- Cloud environment and Azure servers
- Configured high availability in the cloud
- Space Management - Configure database mail to send an email when disk space 10%, 30% less
- Index creation (cluster, non-cluster), database jobs, maintenance planning, and Database tuning, backup policy, DTS (Export-Import) & it Monitoring Regular
- Proactively monitor and plan storage capacity for DR infrastructure
- Deploy database change scripts provided by third-party vendors
- Installation, Configuration, Managing, Monitoring, and Troubleshooting of SQL Server 2000/2005/2008R2/2012, Azure SQL database service.
- Planning and implementation of SQL Server Backup and Restoration
Sr. Database Administrator
Cambridge Technology
05.2019 - 04.2020
- Experience in monitoring, tuning, and analyze database performance and allocates resources to achieve optimum database performance
- Having knowledge in managing the SSRS
- Providing 24*7 production support including on-call support.
- Scheduled and maintain jobs, alerts and maintenance plans and troubleshoot the failed jobs.
- Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery.
- Proactively monitor and plan storage capacity for DR infrastructure.
- Deploy database change scripts provided by third-party vendors.
- Set up and controlled user access levels across databases to protect important data.
- Created and updated database designs and data models.
- Planning and implementation of SQL Server Backup and Restoration
AM-SQL DBA
Mastek
11.2018 - 03.2019
- SQL Server Failover clustering installation, administration, and patching
- Experience in monitoring, tuning, and analyze database performance and allocates resources to achieve optimum database performance
- Monitor SQL Error Logs, Schedule tasks, database activity
- Scheduled and maintain jobs, alerts and maintenance plans and troubleshoot the failed jobs
- Space Management - Configure database mail to send an email when disk space 10%, 30% less
- Proactively monitor and plan storage capacity for DR infrastructure
- Configure Temp DB Disk space automation on Central server
- Perform Database Purging/Removing Activity with help of Dev and Application team
- Project: NHSI (UK)
Sr.SQL DBA
I-Karma Global IT Service Pvt. Ltd
08.2017 - 11.2018
- Installation, Configuration, Managing, Monitoring, and Troubleshooting of SQL Server 2000/2005/2008R2/2012/2014 & 2016, Azure SQL database service, MongoDB
- Planning and implementation of SQL Server Backup and Restoration
- Expert in Migration, upgrading of SQL servers
- Planning and implementation of Log Shipping, Mirroring, Replication
- SQL Server Failover clustering installation, administration, and patching
- Experience in monitoring, tuning, and analyze database performance and allocates resources to achieve optimum database performance
- Having knowledge in managing the SSRS
- Providing 24
- 7 production support including on-call support
- Monitor SQL Error Logs, Schedule tasks, database activity
- Scheduled and maintain jobs, alerts and maintenance plans and troubleshoot the failed jobs
- Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery
- Configure and manage MongoDB on Azure
- Cloud environment and Azure servers
- Configured high availability in the cloud
- Index creation (cluster, non-cluster), database jobs, maintenance planning, and Database tuning, backup policy, DTS (Export-Import) & it Monitoring Regular
- Proactively monitor and plan storage capacity for DR infrastructure
- Configure Temp DB Disk space automation on Central server
- Perform Database Purging/Removing Activity with help of Dev and Application team
- Management of multi-terabyte production Environment
- Deploy database change scripts provided by third-party vendors
- Project: Gulf Petrochem (Dubai), Investimonial, Clappily & Inspiratti, Paramount TPA
SQL DBA
CT (Cambridge Technology)
11.2015 - 07.2017
- Installation & Configuration of SQL Server 2005, 2008, 2008R2, 2012 and MySQL 5.6
- Ability to detect and troubleshoot SQL Server related CPU, memory,I/O, disk space and other resource contention
- Perform Database Purging/Removing Activity with help of Dev and Application team
- Installation and configuration of SSRS & SSIS
- Monitoring dashboard of SSRS and troubleshooting the server related problems
- Expert experience in implementing operational automation
- Client: Mahindra & Mahindra
SQL DBA
FinoPayTech Ltd.
08.2013 - 07.2015
- Installation & Configuration of SQL Server 2005, 2008 , 2008R2 and MySQL 5.6
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Strong knowledge of backups, restores, recovery models, database shrink operations, Replication & Log shipping
- Expert experience in implementing operational automation
- Space Management - Configure database mail to send mail when disk space 10%,30% less
- Deployed and maintain Database Disaster Recovery Site at Bangalore
- Configure log shipping on 195 databases and DB size more than 500GB to 1.5 TB
- Configure and maintain Centralize replication server
- Database Migration from SQL Server 2005 to SQL Server 2008 R2
- Index creation (cluster, non-cluster), database jobs, maintenance planning, and Database tuning, backup policy & same Monitoring Regular
- Replication, Log Shipping configuration, and monitoring
- User Management, creating a user with proper user right
- Configure SQL Check list replication automation on central server
- Configure Temp DB Disk space automation on Central server
- Participating DR Drill Activity on FMBS, AEPS & MMS project
- Perform Database Purging/Removing Activity with help of Dev and Application team
- Coordination between development and QA testing team, monitoring the issues log in the issue tracker and coordinate with the development team for fixes and patches for new releases in QA, UAT and Production environment
- Successfully deployed the systematic standard process for production server (Server Prod policies)
- Installation and configuration of SSRS & SSIS
- Monitoring dashboard of SSRS and troubleshooting the server related problems
- Achievement: Achieve Employee of the Month in FinoPayTech
IT-Manager
Keynote Capitals Ltd.
01.2013 - 07.2013
- To maintain and secure Data Centre Equipments, IBM Blade servers and rack-mountable server, Desktops for secure access to data and information on servers and secure Internet
- Experience in Performance Tuning, Query Optimization, using Performance Monitor
- Ability to identify and troubleshoot SQL Server related CPU, disk space, and other resource contention
- Strong knowledge of Installation of SQL Server 2000/2005, backups, Database restoration, database shrink operations
- Deployed and maintain Database Disaster Recovery Site at Ruby Tower (Dadar)
- Database Migration from SQL Server 2000 to SQL Server 2005
- Responsible for coordination between development and QA testing team, monitoring the issues log in the issue tracker and coordinate with the development team for fixes and patches for new releases in QA, UAT and Production environment
- Rollouts and Testing in terms of Software Application in UAT as well as production environment and Infrastructure for clients present in India and abroad
- Managing and installation of all trading application (All Exchange application) of SQL Server-based Applications
- Verifying the BOD & EOD processes and Backup Process
- Approve vendors used by the organization and monitors their financial condition
- Coordinate priorities between the IT department and user departments
Technical Consultant
Dion Global Solutions Ltd.
06.2010 - 01.2013
- Establish and maintain sound backup and recovery policies and procedures of SQL Database
- Installation & Configuration of SQL Server 2005, 2008 , 2008R2 and MySQL 5.6
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Implement and maintain database security (Create and maintain users and roles, assign privileges)
- Installing and Configuring IIS, Web server, NSE Streamers, BSE Streamers, HTTP Trading Server, HTTP Trading Server
- Migration of Online Trading application (Trade Anywhere, Trade Express-Mobile Trading, Asset Anywhere, Digital Signature, AnySign)
- Responsible for monitoring the servers scheduling of application start, databases jobs, complete monitoring of application, databases, and servers
- Customization of the application as per the need of the Client
- Testing and deployment of patches and releases
- Configured and monitoring Replication, Log Shipping
- Deployment of products/Patches and documentation of release notes
- Responsible for coordination between development and QA testing team, monitoring the issues log in the issue tracker and coordinate with the development team for fixes and patches for new releases in QA, UAT and Production environment
Education
B Com -
Mumbai University
Hardwar & Networking Administrator - undefined
CMS Computer Education
Skills
Database performance tuning
Certification
646, Windows Server 2008, Server Administrator
Personal Information
- Date of Birth: 09/06/85
- Nationality: Indian
Timeline
Assistant Manager
Quattro Business Support Services
09.2020 - Current
Sr. Database Administrator
YNI Global Shared Services LLP
04.2020 - 08.2020
Sr. Database Administrator
Cambridge Technology
05.2019 - 04.2020
AM-SQL DBA
Mastek
11.2018 - 03.2019
Sr.SQL DBA
I-Karma Global IT Service Pvt. Ltd
08.2017 - 11.2018
SQL DBA
CT (Cambridge Technology)
11.2015 - 07.2017
SQL DBA
FinoPayTech Ltd.
08.2013 - 07.2015
IT-Manager
Keynote Capitals Ltd.
01.2013 - 07.2013
Technical Consultant
Dion Global Solutions Ltd.
06.2010 - 01.2013
Hardwar & Networking Administrator - undefined
CMS Computer Education
B Com -
Mumbai University
Similar Profiles
JING SHUAI, ACCAJING SHUAI, ACCA
Staff Accountant at Business Management Support ServicesStaff Accountant at Business Management Support Services
SHRIKANT A. BHABALSHRIKANT A. BHABAL
Assistant General Manager at Calibehr Business Support Services Pvt LtdAssistant General Manager at Calibehr Business Support Services Pvt Ltd
Punitha KunasekaranPunitha Kunasekaran
PPSO Team Coordinator at Persol APAC Business Support ServicesPPSO Team Coordinator at Persol APAC Business Support Services
Bhushan Dilip SalveBhushan Dilip Salve
Senior Relationship Manager at Piramal finance limitedSenior Relationship Manager at Piramal finance limited
Aashutosh SharmaAashutosh Sharma
Data Mining Analyst at SpoctoData Mining Analyst at Spocto