Surendra Agarwal Email & Phone Number

Noida, Uttar Pradesh, India

 Leading a team of database administrators globally for designing, implementing, and managing enterprise-level databases to support critical business applications. Develop and implement database strategies for performance optimization, data security, and disaster recovery. Managing administration of PostgreSQL, PPAS, SQL Server, Cassandra, and Astra databases in a high-availability environment. Perform database capacity planning and resource allocation to ensure optimal database… Show more  Leading a team of database administrators globally for designing, implementing, and managing enterprise-level databases to support critical business applications. Develop and implement database strategies for performance optimization, data security, and disaster recovery. Managing administration of PostgreSQL, PPAS, SQL Server, Cassandra, and Astra databases in a high-availability environment. Perform database capacity planning and resource allocation to ensure optimal database performance and scalability. Implement database monitoring and alerting systems to proactively identify and resolve issues. Collaborate with cross-functional teams to gather database requirements and design efficient database solutions. Conduct regular database performance tuning and optimization activities to improve system efficiency. Ensure compliance with data privacy regulations and industry best practices. Train and mentor junior database administrators on database management best practices and technologies. Database HA and DR planning as per RTO and RPO Shift availability planning for projects as per workload. Taking interviews for new Hiring, promotions and annual appraisals  Built a technology agnostic team to support various products (24X7)  Was awarded Best Leader of the Year 2022 Show less

Noida, Uttar Pradesh, India

 Conduct comprehensive Root Cause Analysis (RCA) for various issues to identify and address underlying problems. Ensure adherence to Service Level Agreements (SLAs) during shifts to maintain high standards of service delivery. Manage and resolve escalations in collaboration with Microsoft, Google, and other vendors to ensure timely solutions. Develop and author multiple Standard Operating Procedures (SOPs) and detailed documentation for operational efficiency. Handle… Show more  Conduct comprehensive Root Cause Analysis (RCA) for various issues to identify and address underlying problems. Ensure adherence to Service Level Agreements (SLAs) during shifts to maintain high standards of service delivery. Manage and resolve escalations in collaboration with Microsoft, Google, and other vendors to ensure timely solutions. Develop and author multiple Standard Operating Procedures (SOPs) and detailed documentation for operational efficiency. Handle escalated issues and respond to customer calls, providing prompt and effective resolution.  Created multiple reports to track KPI (key performance indicators) Overseeing the deployment, maintenance, and optimization of cloud databases on GCP. Implementing and managing containerized database environments using Kubernetes and Docker to ensure scalability and reliability. Utilizing Ansible and Terraform to automate database provisioning, configuration, and management, ensuring consistency and efficiency. CI/CD Integration: Employing GitHub Actions to streamline and automate database deployment and updates, ensuring continuous integration and delivery. Leveraging GCP tools to monitor database performance, identify bottlenecks, and implement optimizations for enhanced efficiency. Ensuring data integrity, security, and compliance with industry standards and regulations. Backup and Recovery: Implementing robust backup and recovery strategies using GCP services to protect against data loss and ensure business continuity. Collaboration and Support: Working closely with development teams to support database-related needs and troubleshooting issues promptly to maintain seamless operations. Show less

Noida, Uttar Pradesh, India

 Database server resource forecasting  Created reports and Dashboards for various monitoring and ticketing tools like Service Desk, AMDOCS, ServiceNow, JIRA, Manage Engine, Salesforce, BMC, Splunk and Grafana. Deployed Query Store on DB Servers Deployed Extended events to capture Blocking and Deadlocks Conducted Quarterly SOC and supported DR for all products. Migration to CloudSQL Database SQL Upgrade to 2014/2016/2019 Single Tenant to multitenant… Show more  Database server resource forecasting  Created reports and Dashboards for various monitoring and ticketing tools like Service Desk, AMDOCS, ServiceNow, JIRA, Manage Engine, Salesforce, BMC, Splunk and Grafana. Deployed Query Store on DB Servers Deployed Extended events to capture Blocking and Deadlocks Conducted Quarterly SOC and supported DR for all products. Migration to CloudSQL Database SQL Upgrade to 2014/2016/2019 Single Tenant to multitenant migration Database Compression deployment Show less

Noida, Uttar Pradesh, India

 On-premises and private cloud to GCP/AWS migration (Large size databases- 20TB+) Performed Database recovery after Ransomware attack. Multiple automations for routine DBA tasks like maintenance, integrity check and DB refresh Index Management (adding Missing indexes and Disabling Un-used indexes) Classroom trainings and recorded video sessions for internal teams Working on SQL Monitoring tools (SolarWinds DPA) for Performance monitoring Deployed SQL trace flags… Show more  On-premises and private cloud to GCP/AWS migration (Large size databases- 20TB+) Performed Database recovery after Ransomware attack. Multiple automations for routine DBA tasks like maintenance, integrity check and DB refresh Index Management (adding Missing indexes and Disabling Un-used indexes) Classroom trainings and recorded video sessions for internal teams Working on SQL Monitoring tools (SolarWinds DPA) for Performance monitoring Deployed SQL trace flags on multiple environments Disk space forecast report for 6K DB Servers Alert reduction (Memory and CPU) on SPLUNK PowerShell Automation for DB maintenance across environment Automation to flush Bad Query plans Long running query alerts PLE report for complete environment Deployment and tracking for DB/Server level best practices. ITSM Enhancements for improved SLA  HA-DR Planning for various projects. Alert improvements and bug fixes on SPLUNK Working with different team – Engg, SRE, Tools, Operations, DevOps, Storage, Network, ITSM, etc. Experience on Always-on with TDE and column level encryption. Experience on physical servers, private cloud, AWS and GCP Experience in performing end to end Critical Database migration from On-prem to AWS EC2. Support for 6K+ SQL Server instances on private cloud Support for 5K+ PostgreSQL instances on public cloud Managing performance for Servers having 30 TB database size Designed complex Powershell automations for various day to day tasks Show less

Noida, Uttar Pradesh, India

 Installation / configuration / maintenance and Administration of SQL SERVR 2000, 2005, 2008, 2014, 2016, 2019, 2022 Experience in designing, implementing, and managing high availability & disaster recovery solutions. Knowledge of Active Directory (user, Groups, computer management and Group Policy) Troubleshoot performance problems, fine-tuning of databases and index analysis. Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on… Show more  Installation / configuration / maintenance and Administration of SQL SERVR 2000, 2005, 2008, 2014, 2016, 2019, 2022 Experience in designing, implementing, and managing high availability & disaster recovery solutions. Knowledge of Active Directory (user, Groups, computer management and Group Policy) Troubleshoot performance problems, fine-tuning of databases and index analysis. Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. Proficiency and expertise in SQL Server Replication, Backup/Recovery Experience in using DMV and extended events for finding out long running queries. Show less

Delhi, India

 Managing a team of technicians to provide 24*7 supports for smooth running of the various projects.  Arranging/conducting meetings with vendors for Price negotiation, technical evaluation, and site acceptance Responsible for operational activities of the IT Infrastructure Conducted training sessions for end users and technical team on the new projects within units. Plan successful maintenance windows and execute system shutdowns, perform upgrades, install patches and bring… Show more  Managing a team of technicians to provide 24*7 supports for smooth running of the various projects.  Arranging/conducting meetings with vendors for Price negotiation, technical evaluation, and site acceptance Responsible for operational activities of the IT Infrastructure Conducted training sessions for end users and technical team on the new projects within units. Plan successful maintenance windows and execute system shutdowns, perform upgrades, install patches and bring the system back online.  MS SQL mail alert and notification for Tasks and Jobs Managing Transaction log and Data file size growth and shirking of databases Monitored and modified Performance using execution plans and Index tuning. Database upgrades & applied software patches to databases as per application/client requirements Configured various DB/Server level alerts for proactive monitoring. Arranging/conducting meetings with vendors for Price negotiation, technical evaluation, and site acceptance. Coordinated with vendors such as Microsoft, HP, Dell and other IT vendors for IT support/ troubleshooting and got things done on time. Show less

Bachelor Of Engineering - Be, Electronics And Communications Engineering

Education record