Shankar Kumara Alagappan Subbulakshmi Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Denton, Texas

Client : Sally Beauty Holdings• Orchestrated Sql server Datacenter Migration Activities• Orchestrated on Environment Stabilization • Designing and creating database solutions.• mplementing new features and technologies to enhance database performance.• Collaborating with developers to integrate databases with other applications.• Enabled database encryption features like TDE, Always Encrypted, Dynamic Data Masking and Row Level Security• Strategic planning for the database server infrastructure• Worked on Audit related activities like evidence gathering, remediation of audit findings. • Designing and implementing data distribution and data archiving solutions.• Mentoring junior DBAs and acting as a consultant for database-related issues.• Leading database-related projects and initiatives.• Architectural decisions and long-term strategic planning.• Research and development of new database technologies and features.• Senior leadership responsibilities, such as defining the vision and direction for the database team.• Cross-functional collaboration with other departments to align database strategies with organizational goals.• Implemented custom update statistics based on level of modification and implemented Index maintenance automation.• Implemented SQL Server Monitoring using Idera Diagnostics Manager • Implemented and Automated Database partition techniques • Tuned Server/DB/Application Performance by analyzing various metrics gathered using Performance Monitor, Data Collector, Who-Is-Active table data and by implementing industry best practices.• Automated Collection of top worst queries from query store across all servers and fine tune queries• Performed Benchmark testing of Service packs, hot fixes, and rollout to all environments methodically.• Directed Always on Availability groups as High Availability solution with automatic failover within same datacenter.

Greater Denver Area

Employer : Cognizant• Worked on Datacenter Migration Activities• Installed and configured different versions of Microsoft SQL Server• Performed Capacity Planning (Resources like : Disk Space, CPU and memory)• Forecasted Monthly/yearly performance/usage of SQL Server• Handled Regular, Baseline Backups and Archival Processes – manual or using SQL Lite speed• Developed programmatic way to Identify and fix index Fragmentation automatically.• Developed and implemented DBA Maintenance plan (Error log cycling, job mail alert, file group size critical alert, database consistency check and index defragmentation).• Configured and maintained Failover Clustering, AlwaysOn, Database Mirroring, Peer-to-Peer Replication• Designed DR Activation and performed Testing • Worked with various teams to resolve and test all ongoing/new issues.• Worked on implementing database standards across all the environment• Performed POC’s on newer Products/versions and identify Pros and Cons • Provided Documentation, Guidelines, Trained subordinates and development teams• Performed Benchmark testing of Service packs, hot fixes and rollout to all environments methodically• Provided technical Guidance and mentoring to teams for developing conceptual and logical database design and the physical databaseAccomplishments• Migrated 87+ TB of Warehouse Database • Migrated 47+ TB OLTP Database without downtime using golden gate replication• Created Centralized Performance Monitoring Dashboard• Automated Addition of File group and files in VLDB’s• Automated Partition Swapping • Automated job to identify and fixing performance issues with statistics• Created reports for identifying the performance of Server Health, Cluster Health, Database Mirroring & Backup• Automated job to identify and fixing performance issues with statistics• Created reports for identifying the performance of Server Health, Cluster Health, Database Mirroring & Backup

Chennai Area, India

Employer: Cognizant• Worked on Datacenter Migration Activities• Installed and configured different versions of Microsoft SQL Server• Performed Capacity Planning (Resources like : Disk Space, CPU and memory)• Forecasted Monthly/yearly performance/usage of SQL Server• Handled Regular, Baseline Backups and Archival Processes – manual or using SQL Lite speed• Developed programmatic way to Identify and fix index Fragmentation automatically.• Developed and implemented DBA Maintenance plan (Error log cycling, job mail alert, file group size critical alert, database consistency check and index defragmentation).• Configured and maintained Failover Clustering, AlwaysOn, Database Mirroring, Peer-to-Peer Replication• Designed DR Activation and performed Testing • Worked with various teams to resolve and test all ongoing/new issues.• Worked on implementing database standards across all the environment• Performed POC’s on newer Products/versions and identify Pros and Cons • Provided Documentation, Guidelines, Trained subordinates and development teams• Performed Benchmark testing of Service packs, hot fixes and rollout to all environments methodically• Provided technical Guidance and mentoring to teams for developing conceptual and logical database design and the physical databaseAccomplishments• Migrated 87+ TB of Warehouse Database • Migrated 47+ TB OLTP Database without downtime using golden gate replication• Created Centralized Performance Monitoring Dashboard• Automated Addition of File group and files in VLDB’s• Automated Partition Swapping • Automated job to identify and fixing performance issues with statistics• Created reports for identifying the performance of Server Health, Cluster Health, Database Mirroring & Backup• Automated job to identify and fixing performance issues with statistics• Created reports for identifying the performance of Server Health, Cluster Health, Database Mirroring & Backup

Chennai Area, India

Employer: Cognizant• Performed Installation and Configuration of various versions of SQL Server and its related services• Performed Installation of Service packs, hot fixes and rollout to all environments methodically• Migrated of databases using In-place and Side-by-side upgrade• Configured and maintained Failover Clustering, Log-Shipping• Handled Restoration and Recovery Processes• Handled Regular, Baseline Backups and Archival Processes – manual or using SQL Lite speed• Performed database management including Performance Tuning using DBCC SHOWCONTIG, DBREINDEX, INDEXDEFRAG, update statistics and Execution Plan, capacity planning and database continuity • Identified the processes causing blocks and rectifying the cause for Blocks • Created alerts for Server Performance Bottlenecks, Long running Queries.• Performed Security Administration (i.e. Adding logins, database users, roles, granting permissions through roles, managing Schemas) on SQL Server• Worked with various Development/User team to resolve and test all ongoing/new issues.• Handled On Call Issues and IncidentsAccomplishments• Automated install and upgrade of SQL server using Perl Scripts• Automated the post installation for Cluster Installation• Awarded as “Tech Wizard of the Month” Twice• Conducted Training on High Availability

Chennai Area, India

• Installed and configured SQL Server 2000/2005 server on Production and development environments.• Migrated Databases from SQL Server 2000 to SQL Server 2005• Installed Service pack and hot fixes for all environments• Configured and maintained Database Mirroring, Log Shipping and maintained Replication• Handled Regular, Baseline Backups and Archival Processes – manual and using TSM• Handled Restoration and Recovery Processes• Handled blocking issues and rectifying the cause for Blocks • Performed Security Administration (I.e. Adding logins, database users, roles, granting permissions through roles, managing Schemas)• Managed databases including Performance Tuning using DBCC SHOWCONTIG, DBREINDEX, INDEXDEFRAG, update statistics and capacity planning• Configured alerts, notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach using SQL Server Agent Jobs.• Imported data to Sql from other RDBMS (Postgres, MS-access) for reports• Deployed scripts for enhancements for each build on Production, QA and Staging environments• Developed and implemented DBA Maintenance plan (Error log cycling, job mail alert, file group size critical alert, database consistency check and index defragmentation).• Configured notifications for Server Performance Bottlenecks, Long running Queries• Worked with various Development teams to resolve and test all ongoing/new issues.• Provided Training to development team

Chennai Area, India

• Handled Capacity Planning• Handled Regular, Baseline Backups and Archival Processes – manual or using TSM.• Handled Restoration and Recovery Processes• Handled User Management and Security Processes• Created and Maintained Jobs• Created Alerts for Server Performance Bottlenecks, Long running Queries.• Identified Processes causing Blocks and rectifying the cause for Blocks• Handled Performance Monitoring and Query Optimization based on requests• Configured and maintained Log Shipping and Replication• Worked with Development/User team to resolve and test all ongoing/new issues• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach• Deployed scripts for enhancements for each build on QA, Staging and Production environments

Chennai Area, India

• Installed and Configured SQL Server• Performed Database design and implementation areas like creating tables, views, indexed Views, Stored Procedures, Functions and Triggers • Managed backup and recovery• Managed security of database structures and corporate data• Created and Maintained databases based on specifications• Monitored databases for errors and fixed issues • Implemented and managed Jobs and various database maintenance plans• Maintained database changes in various stages like Development, QA and Production• Provided assistance for maintaining database standards

Master Of Computer Applications - Mca, Computer Science

B.I.T, Information Technology

Activities and Societies: Gruduation Bachelor of Information Technology

Higher Secondary School, Mathematics

School