Gaurang Bhatt

Service Delivery Manager

• Configuring the database for SQL Server 2012 on Multi node clustering on windows server 2012
• Implementation of SQL Server Always on High availability and GeoClustering
• Migration of Legacy system to New Environment of SQL 2012
• Perfumed performance tuning and made application compatible to 1600+ users
• Worked on the architecture changes on SQL Server
• Involved in defining and designing SQL Database management system for data consistency
• Ensured creation and maintenance of DTS and SSIS packages
• Implemented and managed transactional replication to low down the load on single instance
• Provided 24*7 supports and maintained SLAs and rendered solution within timeframe
• Developed complex logics and implemented SP’s and Triggers to meet certain functionality
• Successfully tuned lot of procedures to perform better results in terms of performance
• Coordinated with development teams to design data management and protocols
• Efficiently managed information life cycle, design infrastructure and data integration control
• Configured, implemented and administered all the database for the respective clients involved
• Resolved issues related to database systems to ensure that systems remains online without any downtime
• Charted out strategy for managing the database disaster recovery and backup techniques
• Developed new and enhance existing standards, processes, procedures and guidelines for database environments using industry experience, best practice research and business needs
• Worked on MS SQL Server 2008 implementing new features like Row and Page compression mechanism, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption
• Used SSIS & SSRS for various BI requirements
• Carried out query tuning of more than 3000 stored procedures and provided a perfect and long term solution to the product in picking the right index

• Perfumed performance tuning and made application compatible to 1600+ users
• Worked on the architecture changes on SQL Server
• Involved in defining and designing SQL Database management system for data consistency
• Ensured creation and maintenance of DTS and SSIS packages
• Implemented and managed transactional replication to low down the load on single instance
• Provided 24*7 supports and maintained SLAs and rendered solution within timeframe
• Developed complex logics and implemented SP’s and Triggers to meet certain functionality
• Successfully tuned lot of procedures to perform better results in terms of performance
• Coordinated with development teams to design data management and protocols
• Efficiently managed information life cycle, design infrastructure and data integration control
• Configured, implemented and administered all the database for the respective clients involved
• Resolved issues related to database systems to ensure that systems remains online without any downtime
• Charted out strategy for managing the database disaster recovery and backup techniques
• Developed new and enhance existing standards, processes, procedures and guidelines for database environments using industry experience, best practice research and business needs
• Worked on MS SQL Server 2008 implementing new features like Row and Page compression mechanism, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption
• Used SSIS & SSRS for various BI requirements
• Carried out query tuning of more than 3000 stored procedures and provided a perfect and long term solution to the product in picking the right index

• Perfumed performance tuning and made application compatible to 1600+ users
• Worked on the architecture changes on SQL Server
• Involved in defining and designing SQL Database management system for data consistency
• Ensured creation and maintenance of DTS and SSIS packages
• Implemented and managed transactional replication to low down the load on single instance
• Provided 24*7 supports and maintained SLAs and rendered solution within timeframe
• Developed complex logics and implemented SP’s and Triggers to meet certain functionality
• Successfully tuned lot of procedures to perform better results in terms of performance
• Coordinated with development teams to design data management and protocols
• Efficiently managed information life cycle, design infrastructure and data integration control
• Configured, implemented and administered all the database for the respective clients involved
• Resolved issues related to database systems to ensure that systems remains online without any downtime
• Charted out strategy for managing the database disaster recovery and backup techniques
• Developed new and enhance existing standards, processes, procedures and guidelines for database environments using industry experience, best practice research and business needs
• Worked on MS SQL Server 2008 implementing new features like Row and Page compression mechanism, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption
• Used SSIS & SSRS for various BI requirements
• Carried out query tuning of more than 3000 stored procedures and provided a perfect and long term solution to the product in picking the right index

• Perfumed performance tuning and made application compatible to 1600+ users
• Worked on the architecture changes on SQL Server
• Involved in defining and designing SQL Database management system for data consistency
• Ensured creation and maintenance of DTS and SSIS packages
• Implemented and managed transactional replication to low down the load on single instance
• Provided 24*7 supports and maintained SLAs and rendered solution within timeframe
• Developed complex logics and implemented SP’s and Triggers to meet certain functionality
• Successfully tuned lot of procedures to perform better results in terms of performance
• Coordinated with development teams to design data management and protocols
• Efficiently managed information life cycle, design infrastructure and data integration control
• Configured, implemented and administered all the database for the respective clients involved
• Resolved issues related to database systems to ensure that systems remains online without any downtime
• Charted out strategy for managing the database disaster recovery and backup techniques
• Developed new and enhance existing standards, processes, procedures and guidelines for database environments using industry experience, best practice research and business needs
• Worked on MS SQL Server 2008 implementing new features like Row and Page compression mechanism, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption
• Used SSIS & SSRS for various BI requirements
• Carried out query tuning of more than 3000 stored procedures and provided a perfect and long term solution to the product in picking the right index

Mar '09 - Nov '09: ITC InfoTech, Bangalore as Sr.SQL DBA ( Production Support/ETL Development) -Contract to hire

Jul '08 - Mar '09: Diaspark (Suvi Infotech), Indore as Sr.SQL DBA ( Development DBA) -Contract to hire

Feb '08 - Jul '08: Emirates Bank of Group, Dubai as Sr.SQL DBA ( Database Migration Expertise)

Apr '07 - Feb '08: Eclipsys Corporation, Vadodara (Gujarat) as Sr.SQL DBA (Production Support 24X7) --Contract

Jan '07 - Apr '07: Marlabs Software Pvt. Ltd., Bangalore (Avankia LLC) as Team lead ( Database Development) --Contract

Oct '06 - Jan '07: IBM Global Services India Pvt. Ltd., Bangalore as SQL Developer--Contract

Jun '06 - Oct '06: Aegis BPO Services (Essar Enterprise), Bangalore as SQL Architect ( ETL Developer -SSIS Designer) --Contract

Sep '05 - Jun '06: Manthan Software Services, Bangalore as Database Programmer/DBA

Nov '03 - Jun '05: Micron Software Development & Education Center, Mysore as Software Engineer

Key Result Areas
• Handling end to end project management activities inclusive of planning, effort, design, scope, estimation, resource coordination and delivery as per specified timeframes
• Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters
• Extending Production System Support for multiple mission-critical applications, steering system integration, cloud computing and managed services
• Troubleshooting problems pertaining to Performance Tuning, Application Conflicts & System Bugs
• Leading & managing project teams throughout the project lifecycle, providing them support & guidance on technical and project-related issues
• Managing code deployment, change management and quality assurance; creating indexes, views, triggers, stored procedures, functions and packages
• Providing technical support to Application Development Teams and setting / maintaining standards
• Creating tables paces, user maintenance, database security imposition by creation and granting of roles, performance tuning, backups, tuning of SQL statements and support for oracle toolsets and utilities

Highlights (please segregate company wise)
• Received Best Performance Team Award & Best Deliverable Award for software development