Rohit Paliwal Email & Phone Number

Noida, Uttar Pradesh, India

Designed solutions for more than 60 deals, amounting to a Total Contract Value (TCV) exceeding USD 2 billion. Effectively converted 18 deals totaling over USD 300 million in Total Contract Value (TCV). Offered consulting assistance to delivery teams for more than 5 projects experiencing underperformance and challenges. Contributed to the solution of two large deals with an estimated Total Contract Value (TCV) exceeding USD 600 million over 5 years. Contributed to the Development of Cloud BlazeTech integrated solution for end-to-end cloud transformation. Proficient in running process operations with exposure in developing procedures/processes, service standards for business excellence and service delivery.

Hyderabad Area, India

Cloud Data Retention Testing, Cloud Disaster Recovery, Synthetic Monitoring in Cloud, Azure Migration. Support PAREXEL Global Hosting and Enterprise Infrastructure Team for delivering projects in Azure Infrastructure Support, Automation, Managing CI/CD Tool Chain and Database services. Driving the DevOps and Automation efforts by building Automation Kits to be consumed by application team to build infrastructure in Azure. Working closely with application migration to get their feedback, bugs and working on multiple iterations of Automation Kits by adding new features and making product better. Expertise on solution designing for applications in cloud comprising of end-to-end Infrastructure design, Performance and cost management, Security and compliance, DevOps Strategy and IaC practices, Operational management and maintenance, future modernization etc.

Hyderabad Area, India

Hyderabad Area, India

EXPERIENCE SUMMARY• Server/Database Migration or Upgrades – Extensive experience in SQL Server Migration/upgrade.• Capacity Planning for database servers as per running load and plan estimation of future resource requirement based on available matrices.• ETL/DB Programming creation, management, scheduling and migration to DTS/SSIS packages across instance, and from SQL 2000 to Legacy DTS (SQL 2005) and SSIS in SQL 2005/2008/2008R2/2012/2014. Expertise in troubleshooting DTS/SSIS package. Performance tuning of DTS/SSIS packages, Extensive experience in writing Stored procedures, Views, Functions, CLR Stored procedures, Triggers, Cursors, SQL programming. Writing extended stored procedures for application purpose.• Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc. Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or sometime change in query logic on need basis. Extensive experience in helping/mentoring development team in optimization of the sql code.• Database Modelling - Designing and modelling the databases for business application needs, using MS Visio, DB Deign & Erwin for database design and SQL Clarity for database comparison.• Vendor Management/Transition – Lead the vendor transition for my company and successfully completed the vendor transition from 6 different vendors to 2, extensive experience in vendor management currently handling a team of 50+ SQL DBA’s.• Service Delivery Lead – Responsible for our delivery through outsourced vendor(s) for technical support, spread across four different geographical locations in India. Making me accountable for technical readiness, CPE, MPI, Operational logistics, Utilization, Headcount and process awareness

Hyderabad Area, India

Application performance is a critical success factor to RealPage product. My team is responsible for overall performance of the SQL code, application indexing architecture and table data partitioning. We proactively analyze production trace data to determine problem areas and then tune the SQL code to perform optimally. In addition, I work with the product groups to make any needed schema changes to allow for optimal code performance and stability.

Watford, United Kingdom

This is a 24X7 production project. Where we are managing around 30+ production servers of our client GE Money Home Lending UK.Responsibilities include. Working with developers & testers in performance issues, Index Planning etc.Performance monitoring of the databases (Query optimization, Indexing)Monitoring and Daily Log checking on Production, Development & Testing servers.Planning backup & restore strategies for client databases.Providing 24X7 database support

Hyderabad Area, India

Presently working at client location in UK as Database Consultant

Bengaluru Area, India

In this project we are automating the in store marketing concept. This project will take care of the entire in store marketing concepts i.e. Plainograms, Banners, and Pamphlets etc.Responsibilities includeWriting new SSIS packages & tuning the existing SSIS packages as per the client business requirements.Working with developers & testers in performance issues, Index Planning etc.Writing stored procedures, function & triggers.Writing migration scripts for client databases.Monitoring and Daily Log checking on Production, Development & Testing servers.Planning backup & restore strategies for client databases. Providing 24X7 support and working with onsite DBA team.

Hyderabad Area, India

In this project we had to maintain 12 servers running different databases for our own application KnoahSoft and Cisco Call Manager.Responsibilities include.Working as a only DBA and maintaining all the production database of the client where applications like KnoahSoft Harmony 2.0 & Cisco Call Manager was running.Working closely with development teams.Writing stored procedures, complex reports.Tuning & optimizing complex stored procedures and queries. Monitoring production servers i.e. Daily checking of sql logs, event viewers, maintenance plans history, backup jobs history, free space etc.Monitoring production, Dev & test servers for performance and resolving production & development issues.Planning backup & restore strategies, checking the database backups.Providing on call 24X7 support.

Jaipur Area, India