IT Delivery Manager
Tech Mahindra
Total years of experience :17 years, 0 Months
Manage the performance, integrity and security of donor and constituent databases and related management information systems and communication systems.
Help develop and execute against a global strategy for database technologies in the firm.
Provide reporting and technical expertise as necessary for the development and maintenance of organizational processes.
Keeps senior technical management informed by preparing reports on system performance and problems.
Assist with the development and tracking of alumni engagement statistics and reporting.
Provide monthly activity report to the program manager.
Establish individual performance goals, review performance against goals and provide coaching for associate development.
Respond to database issues and inform management. Follow through and establish permanent fixes.
Manage database budget, licenses and vendor management relationship.
Provide guidance, direction and managerial leadership to junior resources.
Develop and manage both long and short-term goals for department and staff.
Help develop and execute the department roadmaps.
Create, track and update project schedule, communicate project status to the team members and to management.
Independently Installed SQL Server 2014, 2016 and configured Always On
Planning, Installation and configuration of SQL Server 2000, 2005, 2008, 2008 R2, 2012 Cluster servers, 2014 & 2016 Always On
Installation of Service packs and Hotfixes.
Very Strong Experience in Performance Tuning, Indexing.
Managing the change document
SQL Server 2008 R2 to 2012, 2012 to 2014, Etc. migrations
Monitoring backup of daily backup to drive
Performance Tuning of slow running query, tuning up the query how can we improve the performance
Monitoring server performance and memory activities
Configuring SQL Server alerts, jobs and operators via SQL Server agent.
Handling User Management and Security Processes
Worked on table changes - Version Change
Worked on Database Access and Security Management, Inquiry, Scheduled backup and Restoration Management, Data Management, Object Management, Software Management, Emergency Data Management Break Fix Incident, Etc.
Worked with SSIS, SSRS and SSAS
Handled a two members team for training and administration
Worked on power shell automation for multiple complex scenarios
Independently Installed windows server 2008 and SQL Server 2008R2 and configured clustering
Planning, Installation and configuration of SQL Server 2000, 2005, 2008, 2008 R2 & 2012 Cluster servers
Installation of Service packs and Hotfixes.
Very Strong Experience in Performance Tuning, Indexing.
Managing the change document
SQL Server 2008 R2 to 2012 and 2012 to 2014 migrations
Worked on SSMA (SQL Server Migration Assistant) on many databases from Oracle to SQL Server
Monitoring backup of daily backup to drive
Performance Tuning of slow running query, tuning up the query how can we improve the performance
Monitoring server performance and memory activities
Managing SQL Server databases of HR, E-Document, Council, Missiles etc.
Configuring SQL Server alerts, jobs and operators via SQL Server agent.
Handling User Management and Security Processes
Worked on table changes - Version Change
Training Soldiers in SQL Server Management studio, SQL query language and SQL Server Administration
Creating logins for soldiers
Helping Soldiers in creating T-SQL statements for their crystal reports
Worked with SSIS, SSRS and SSAS for Department
Handled a four members team for training and administration
Performance Tuning of slow running query, tuning up the query how can we improve the performance
Worked extensively on Log shipping, replication, DB Mirroring and clustering
Execution plan analysis, index suggestion, memory crunches, CPU high usage bottleneck
Monitoring backup of daily backup to drive and networker
L3 Support for the Issues Which Can’t be resolved by the team
Sev1 calls and RCA for priority one ticket handling
Handled a six members team for training and administration
Performance Tuning of slow running query, tuning up the query how can we improve the performance
Execution plan analysis, index suggestion, memory crunches, CPU high usage bottleneck
Monitoring backup of daily backup to drive and networker
Autosys job failure, BMC Impact explorer alerts
Root Cause for the problem which is happened
Filing a case with Microsoft for the unresolved issue on production
Login failure, ETL job analysis, network TCP/IP trace
Working with Microsoft for the performance issue on the critical high/high priority tickets
SQL Server 2000 to 2005 and 2005 to 2008 migration failures
Finding a root cause for the SQL Server Service packs failures.
Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
Backup and Restore through Lite speed, table level restores using lite speed
Configure memory for best performance results
maintaining Cluster Servers both windows and sql server side perfection
Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
Handling performance issues and tuning queries.
Creating and scheduling Autosys job for Backup, rebuild index,
DR copy etc
Monitoring server performance and memory activities
Handling User Management and Security Processes
Worked on table changes - Version Change
Responsible to Troubleshoot SSIS jobs
Providing on-call support to ensure that all environments are regularly maintained
Managing a team of two in member on the work and giving feedback
SSIS, SSRS & SSAS Package
Have experience on the package deployment, troubleshooting and migration on the environment
Troubleshooting the package on failure, slow extract and upload
Performed Database Administration activities to ensure safety and optimal performance.
Install and configure SQL Server 2005
Installation of Service packs, hot fixes and rollout to all environments methodically.
Responsible for Full Backups and Transaction Log Backups. planning back up strategies and scheduling them
Configure memory for best performance results
Created schedules for Backups and Replication
Backups and restoration
Configuring and Administering Log shipping
Running Index tuning wizard, implementing Log Shipping.
Using the Database Maintenance Wizard to make some necessary changes
keeping the performance of the server up to date
Import/export data, backup restore database, managing servers, and managing clients.
Monitoring server performance and memory activities
Maintain Data Integrity by using Constraints, Data Types and Triggers
Handling User Management and Security Processes
Creating and Monitoring the Jobs and Maintenance Plans
Writing Stored Procedures and Views for reporting purpose
Implementing Business rules using Triggers
Maintain Data Integrity by using Constraints, Data Types and Triggers
Create and Maintain databases based on specifications
Installing new instances of SQL Servers 2000 and 2005
Configuring the user permissions
Implementing Security in both windows and SQL
Perform Database backups and restoration operations
Perform Database Administration activities to ensure the optimal operation of all database environments
Export and Import data from text file to SQL Server 2005 using BCP and Bulk Copy Insert utility.
Resolving various performance issues by running DBCC commands and SQL Profiler
Administering Replication
Maintain and troubleshoot Replication issues.
VLSI Design & Embedded System
Bachelor of Engineering Eleectronics and Communication Engg University : Monamaniam Sundarnar University,Tirunelveli,TamilNadu % : 67.55