Devendra Bhilare

Currently working for Lloyd’s bank (UK) project. Lloyds Banking Group was established in 2009 when Lloyds TSB acquired HBOS.

· Working as SME for production support RTB team and responsible for handling high and critical issues by coordinating with different infra teams, application teams and Microsoft.

Configure and troubleshoot Always On configuration on new migrated servers on SQL 2014/2016. Also handling AG related issues on production which are configured on windows failover clusters across geographies.

· As a part of Service Introduction, responsible for inspecting new server is built as per LBG standards and approving migrations or new builds as a part of gateway process.

· Security Assessment and Deployment i.e addressing non-compliance.

· Assisting DBA teams in Database performance analysis, diagnosis, tuning (SQL Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load balancing etc.). Tools such as extended event, DMV’s, perfmon, Sentry used on regular basis for the above activities.

· Responsible to work on high impact problem records and fix them.

· Responsible for reviewing and approving high and critical changes.

· Forecasting space requirement for next 2 years for critical applications having space crunch and ensuring space gets added on the servers proactively.

· Mentoring L2 and L3 DBA’s during incident, problem investigation and change implementations. Handling of escalations.

· Working as on call support for critical issues.

· Responsible for hiring new members, providing KT, onboarding them on the project.

· SQL server migrations from SQL 2008/R2 to SQL server 2014/2016. Implementation of TDE on new server and servers whose certificate is expiring.

· Design the Backup/Restore strategy for disaster recovery as per requirements from app team.

· Design HA for critical applications.

· Responsible for TSQL development and upgrading the in-house tool used for maintaining and monitoring SQL databases.

· Responsible for decision making on various tasks entrusted by higher management to me.

Regular representation of critical tasks done to client and internal management on weekly basis.

NEXUS AMS: Amlin is a leading independent insurer and reinsurer with over a hundred years’ experience in the insurance market.

· Setup offshore team of 11 members and involved in knowledge transitioning of the Insurance, re-insurance domain and the system developed by Deloitte for the client. Involved in the understanding of activities from offshore perspective.

· Doing enhancements in stored procedures toward performance tuning.

· Assist the team in driving Continuous Improvement. Assisting the junior team members in writing code.

· Lead the automation module for automating various day to day tasks using TSQL and SSIS which saves 90-man hours per month.

· Month end reporting.

Got ACE award (Accenture Excellence award) for leading the smooth transitioning of business to Accenture.

Talisman (Repsol): Repsol, one of the world’s leading integrated oil and gas companies, spans the entire energy value chain including exploration, production, refining, marketing and new energy R&D.

· Working on SQL Server and Oracle.

· Performed in place upgrade of SQL Servers from 2005/ 2008 to 2012.

· Implement HA solutions (Mirroring, Always On, Clustering etc). Implement maintenance plan (index defrag, stats update, DBCC etc)

· Refreshing Test/Dev environment from production when needed by the client.

· SQL Server patch management on standalone, clustered and mirrored servers.

· Providing permanent fixes for SQL Server alerts that are received via SCOM.

· Incident handling Change request implementation.

· Working experience in ITIL Process.

· Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.

· Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

· Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, DMV’s, extended stored procedures.

· Documentation skills for processes and procedures (Creating KBs, runbooks, topology etc). Closely work with developers and document implementations, technical documentation.

· Oracle schema refresh, addressing table locking issues, schema creation, increasing table space etc.

· Monitor backup job using OEM, re-executing them in case of failure.

· SQL Server inventory automation using VBScript, implemented SQL Server instance migration, SQL Server Patching, Login tracking etc using PowerShell.

Symantec: they make the world a safer place by helping people, businesses, and governments protect and manage their information, so they can focus on achieving their goals.

· Provide 24 x 7 support for any Emergency Calls.

· Getting opportunity to work on Vertias cluster.

· Getting opportunity to work on HPSA tool used from SQL Server patch management.

· SQL Server installation, configuration, upgrading, troubleshooting, backup and recovery.

· Incident handling, Change request implementation.

· Addressing issues related to high Memory utilization, blocking, long running queries.

· Perform DBA duties like backups, maintenance, user access and security, ensure that all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.

· Install security patches and hot fixes on all the servers as applicable.

· VBS and T-SQL Scripting for generating reports related to SQL Servers inventory.

Working experience in ITIL Process.

BMC Software, Inc. is an Software company specializing in Business Service Management (BSM) software. Headquartered in Houston, Texas, BMC develops, markets and sells software used for multiple functions, including IT service management, data center automation, performance management, virtualization lifecycle management and cloud computing management.

BMC Remedy is industry’s leading ITSM solution now available via Software as a Service (SaaS) which includes integrated best-practice ITIL workflow, an intuitive, easy-to-learn user interface, and proven scalability and reliability.

Remedy OnDemandOperations started to leverage the capability of accessing the ITSM Suite on the Cloud as a SaaS (Software as a Service) offering to the customers. Managing a fleet of 90+ customers using their Service Management System online

· Migrated 600+ databases to new datacenter in less than 40 days.

· Supporting around 400+ live customers in an OnDemand operating Environment.

· Setup Mirroring between two datacenters for DR testing as a service offering to the customer. Setup a process to Create DB Snapshot over the mirrored Databases to suffice the reporting capabilities of the Production Database.

· Provide 24 x 7 support for any Emergency Calls.

· Microsoft SQL Server 2012, 2008 R2 Cluster Installation.

· SQL Server installation, configuration, upgrading, troubleshooting, backup and recovery.

· Incident handling, Change request implementation.

· Addressing issues related to high Memory utilization, blocking, long running queries.

· Refreshing TEST/DEV environment from production when needed by the client.

· Perform DBA duties like backups, maintenance, user access and security, ensure that all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.

· Install security patches and hot fixes on all the servers as applicable.

· T-SQL Scripting for automating tasks, creating SSRS Reports.

· Writing scripts for Remedy upgrade team which migrate’ s Remedy software and data to higher versions. This needs to be done when Remedy upgrade tools fail to migrate data from lower versions to higher versions. Scripts which help to estimate the amount of time required to migrate before and during the process of migration different types of reports need to be generated to ensure that entire data is migrated successfully.

· Creating users, Granting rights, Credentials, Proxy accounts. Configure Database Mail and use them extensively for sending mails on completion of SSIS jobs, report of production job history giving details of start time, end time and duration.

Worked for a Life Sciences project – Japanese Drug manufacturing company whose data center is located in USA.

· Use SQL Server DBA Dashboard reporting tool that provides reporting and monitoring capabilities for a single instance of SQL Server 2005. The report shows charts showing CPU utilization, Signal Wait Percentage, Tasks Wait Percentage, Tasks Waiting for Scheduler, Blocked Processes, SQL Agent Job Failures, Backup’s in Last 24 hours and Disk Space Utilization.

· Use of Dynamic management views and functions. Index Related Dynamic Management Views and Functions, Database Related Dynamic Management Views, I/O Related Dynamic Management Views and Functions

· Monitor SQL logs and take steps to ensure minimum disk space usage.

· Ensure the all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.

· SQL Server installation, configuration, upgrading, troubleshooting, backup and recovery.

· Migration of Databases from older version to new version using tools such as SQL Server upgrade advisor.

· Responsible for applying latest SQL Server Service packs on production, development, UAT servers.

· Learning Oracle from colleagues, and assisting them in activities such of monitoring of backup jobs etc.

· Database Refresh, addressing table locking issues, schema creation, increasing table space etc.

· Database creation using DBCA.

· Creation of Control files.

· Atomization for oracle using SQL Servers SSIS package, e.g – Backup Log reader for Oracle on windows machines.

· Represent SQL DB team during the process of bidding for new clients visit. Present the achievements and challenges encountered during the bidding process. Also represent the team when existing clients use to visit the facility.

The Financial Group’s mission is to develop and create an integrated financial services organization. SSIS is being used for extraction, transformation, and loading the filtered data into their database and BO reporting technology to present their data to business and to analysts.

· Use SQL Server DBA Dashboard reporting tool that provides reporting and monitoring capabilities for a single instance of SQL Server 2005. The report shows charts showing CPU utilization, Signal Wait Percentage, Tasks Wait Percentage, Tasks Waiting for Scheduler, Blocked Processes, SQL Agent Job Failures, Backup’s in Last 24 hours and Disk Space Utilization.

· Use of Dynamic management views and functions. Index Related Dynamic Management Views and Functions, Database Related Dynamic Management Views, I/O Related Dynamic Management Views and Functions

· Assist the development team in query tuning.

· Address issues related to high CPU utilization and poor performance of applications.

· Responsible for memory allocation to SQL Server.

· Use Profiler tool to trace queries responsible for high CPU/Memory consumption.

· Monitor SQL logs and take steps to ensure minimum disk space usage.

· Ensure the all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.

· Aware of Log-shipping, Clustering, Mirroring.

· SQL Server installation, configuration, upgrading, troubleshooting, backup and recovery.

· Migration of Databases from older version to new version using tools such as SQL Server upgrade advisor.

· Addressing issues faced when deploying Packages from Development to Production.

· Creating users, Granting rights, Credentials, Proxy accounts. Configure Database Mail and use then extensively for sending mails on completion of SSIS jobs, report of production job history giving details of start time, end time and duration.

· Responsible for data load job in Data Warehouse and in case of failure identify the reason for failure.

· Optimize data warehouse by using partitioned tables. Use query execution plan to analyze the performance of a specific query and look for warning signs and investigate them for potential performance problems.

· Comfortable in SSIS package development and trouble shooting.

· Implemented Central Management Server to store server groups and registered servers centrally so that we have easier access to the registration properties of a group of servers, we can execute queries against each of the servers in every group.

· Responsible for applying latest SQL Server Service packs on production, development, UAT servers.

IDBI Intech Ltd is a technology-led business transformation organisation for BFSI vertical. Incorporated in the year 2000, it serves as a wholly-owned subsidiary of IDBI Bank, a leading bank in India.

· SQL Programming

• Helping the development team in query development and fine tuning them in case they find difficulty in fixing it.
• Addressing issues related to high CPU utilization and poor performance of applications. Use Profiler to trace queries responsible for consuming more time.
• Most of the applications had been developed by Infosys and customization is done in house, hence whenever there are performance issues have to co-ordinate with vendor and Microsoft support to resolve the issues.
• Daily monitoring of Databases and Sql logs to ensure there is no problem and if any identify the same and fit it.
• Ensure the all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.
• Aware of Logshipping, Clustering etc.
• To manage SQL Server 2000 by using administrative tools like Enterprise Manager, Query Analyzer, Import and Export Data, Profiler and SQL Server 2000’s Components like Replication, DTS.
• Maintenance and monitoring of Databases using wizards, DBCC commands.

· SQL Server administrator – installation, configuration, upgrading, troubleshooting, backup and recovery.

· Maintaining the high availability of the system, mirroring, log shipping.

· Experience in defining and writing utilities and scripts for day to day DBA activities.

· Performance tuning.

Working on SQL Server 2005 administration too as IDBI capital databases had been migrated to 2005 from SQL 2000.

ERP – (Modules - Sales, Purchase, Inventory, Manufacturing, Accounts, Excise, Standard cost)

Role

• Each module was studied using Value Stream Map (VSM). Regular Kaizen events were organized involving all the concerned persons during analysis. We as a team use to map the current state, identify / define waste (i.e rigid flow in old system) and define future state, where in we tried to eliminate rigidity in the new system.
• Coordinated with the ERP Team in Analysis of Dos based system, complete study of processes involved and fix / point out loop holes in previous system.
• Coordinate with various departments and ERP team for continuous improvement, changes in the modules.
• Working on SQL/CR/VB6 to resolve problems arising during on line implementation at initial stage.
• Contribution in development of modules independently, developed reports using crystal reports.
• Develop queries, procedures, reports for finding out problems arising during creation of documents in various modules & provided proper solution.
• Helped the ERP team in Excise module and also developed excise reports like AR4, ER6, RG1 & other Export / Import documents.
• Contributed in development of Test certificate based on material used for manufacturing of valve giving detailed pressures & various test performed.
• Devote time in Study of SQL, Crystal Reports tools for developing adhoc applications / reports.
• Responsible for updating / correcting data using stored procedures, cursors etc externally in case of data mismatches, improper balances.
• Coordinated in creation of various masters eg: Item Master, Supplier Masters, Rate slab master, Taxation master etc.
• I had to do DBA activities. At times of emergency have restored the database successfully. Responsible for Backup.
• I had to trace out poor performing procedures and queries which are responsible for slow performance. (I.e. Complete performance tuning & Optimization.)
• Also had opportunity to visit our vendors and study their Erp systems, shown keen interest in MOVEX, SAP system. Got exposure to new ideas.

We as a team had to attend all the Kaizen events organized in the company on regular basis and many a times suggest good business solutions as expected by our management.