Summary
Overview
Work History
Education
Skills
Projects
Languages
Key Achievements
Timeline
Generic
KISHORE Kumar Indiran

KISHORE Kumar Indiran

Chennai,India

Summary

Results-driven professional with 15 years of experience in database administration and development, specializing in SQL optimization and ETL solutions. Achievements include a 50% increase in query performance and a 70% reduction in ETL extraction times. Extensive expertise in managing SQL Server and Azure databases, enhancing system performance and data security. Committed to delivering high-quality technological solutions through astrong work ethic and adaptability.

Overview

18
18
years of professional experience

Work History

MSSQL DBA Consultant

BlueRose Technologies
Chennai
10.2023 - 03.2025
  • Achieved 30% improvement in query performance, optimizing critical workload processing times.
  • Reduced server downtime by 15% through proactive database management and optimization techniques.
  • Managed over 150 database instances across multiple cloud platforms, ensuring seamless operations.
  • Led team of 10 database administrators across five regional offices to sustain operational efficiency.

Lead Technical Consultant

Celsior Technologies
Chennai
06.2022 - 10.2023
  • Executed database backups using Rubrik Backup Tool to ensure data integrity.
  • Automated ETL processes, resulting in a 30% increase in client satisfaction.
  • Monitored SQL Server health both on-premises and within Azure VM environments.
  • Enhanced database and query performance by resolving critical memory and CPU issues.
  • Redesigned data integration processes utilizing SSIS, boosting operational efficiency by 25%.
  • Configured secure backup solutions via Rubrik and Azure Backup Center.
  • Assisted with SQL Instance installations, migrations, and upgrades to optimize system performance.
  • Deployed migration scripts and managed Informatica Repository according to ticketing system requirements.

SQL DBA Consultant

Sensiple Software Solutions
Chennai
05.2020 - 09.2021
  • Migrated on-prem instances to Azure Managed, including production environments.
  • Increased data processing efficiency by 25% through ETL pipeline optimization for major clients.
  • Reduced query execution time by 15% using advanced indexing techniques.
  • Designed automated backup and restoration procedures for enhanced reliability.
  • Maximized database efficiency with performance tuning, cutting query execution times by 40%.
  • Streamlined database replication processes, reducing system downtime by 25%.
  • Troubleshoot SQL Server issues, enhancing overall performance with tuning tools.

Lead DBA

Sensiple Software Solutions
Chennai
07.2019 - 01.2020
  • Optimized queries to minimize application performance impact.
  • Implemented SQL Server 2012 features, including data compression and online indexing.
  • Coordinated database installation, upgrades, and storage planning activities.
  • Controlled user access to ensure compliance with system security standards.
  • Maintained database performance through effective indexing and data replication strategies.
  • Established backup, recovery, and disaster recovery procedures to safeguard data.

Chennai SQL Server DBA

Sysbiz Technologies Pvt Limited
Chennai
06.2014 - 05.2019
  • Led technical direction for database projects, managing a team of 15 developers.
  • Executed over 30 ETL projects, overseeing data migration across multiple systems.
  • Reduced data processing time by 40% through enhanced ETL solutions.
  • Optimized database performance using SQL Profiler and Database Engine Tuning Advisor.
  • Documented designs, guided the team through development cycles, and managed testing processes.
  • Troubleshot database issues, ensuring log space management, and query optimization.
  • Improved application performance by 25% through optimized database queries.
  • Achieved 99.9% system uptime by implementing advanced monitoring and maintenance protocols.

Associate -Projects

Cognizant Technologies Solutions
Chennai
12.2011 - 05.2014
  • ,Managed development, release management, documentation, testing, and training activities with stakeholders.
  • Trained new joiners and suggested value improvements within projects.
  • Optimized SQL scripts to increase data processing efficiency by 30%.
  • Coordinated with developers and production teams to identify needs and solutions.
  • Ensured compliance with security policies during project execution.
  • Directed change management for code releases from sandboxes to production.
  • Developed unit tests ensuring accurate business logic functionality.
  • Customized back-end activities using Oracle APEX and presented features to management.

Database Developer

Sysbiz Technologies Pvt Limited
Chennai
03.2007 - 12.2011
  • Compiled requirements and prepared documentation for functional and technical design specifications.
  • Designed and implemented application database code objects, including stored procedures and Oracle packages.
  • Conducted unit testing, debugging, and bug fixing of developed application components.
  • Maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Created E-R diagrams for projects while performing quality testing and assurance on SQL servers.
  • Executed logical and physical database design, implementation, and maintenance in Oracle 9i on Windows NT.
  • Collaborated with stakeholders, developers, and production teams to identify business needs and solution options.
  • Ensured compliance with best practices while participating in daily customer interactions.

Education

B.E - Electrical & Electronics

Ranipettai Engineering College
Chennai
05.2006

Skills

  • MSSQL and T-SQL
  • Database management
  • Performance tuning
  • Backup solutions
  • Query optimization
  • Data integrity
  • SQL troubleshooting
  • Disaster recovery
  • Effective communication
  • Problem solving
  • Stakeholder collaboration
  • Issue resolution
  • Problem-solving
  • ETL and data migration
  • Performance tuning and replication
  • Extended events and SQL Profiler
  • Shell scripting and XML
  • AWS and Azure
  • Unit testing and automation

Projects

Kone Elevators (MES), 10/01/23 - 03/31/25, Worked as T-SQL Developer and Core DB Extended events, which help to reduce 80% of finding the queries during slowness, increase the performance of the expensive queries by 60% by handling the table joins and indexes in place. Implemented replication to reduce the load of the production database by 50% for the report generation 

F&G Annuities & Life, 06/01/22, 10/31/23, Application DBA – Deploying scripts, performance tuning,and restoring backups from Prod to lower environment. 

Horizon Retail, 07/01/19, 09/30/21, Developer cum DBA to manage and delivery the solutions as Independent Managing On-prem SQL server with replication. Expertise in T-SQL writing stored procedures, triggers, and functions. Improved data processing efficiency by 20% using SSIS and BULK INSERT ETL operations. 

GTN Forecasting - R2 | RM, 06/01/14, 05/31/19, Managed DB Developers team – 15. Business requirement discussion with clients. Improved data processing efficiency by 20% by designing the schema and tables for optimized data flow. Implementation of business logic in stored procedures and abstract functions for reusability. Monitoring the DB server and performing tuning based on expensive queries. Performed day-to-day DBA activities such as monitoring SQL Server health, job status, and addressing user requirements. Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression – CTE.

Languages

  • Telugu, Native
  • Tamil, Native
  • English, Advanced

Key Achievements

Increased query performance by 50% through SQL optimization., Reduced ETL data extraction times by 70% implementing new solution., Enhanced system performance by 15% through data cleansing efforts., Implemented security algorithm improving data confidentiality by 80%.

Timeline

MSSQL DBA Consultant

BlueRose Technologies
10.2023 - 03.2025

Lead Technical Consultant

Celsior Technologies
06.2022 - 10.2023

SQL DBA Consultant

Sensiple Software Solutions
05.2020 - 09.2021

Lead DBA

Sensiple Software Solutions
07.2019 - 01.2020

Chennai SQL Server DBA

Sysbiz Technologies Pvt Limited
06.2014 - 05.2019

Associate -Projects

Cognizant Technologies Solutions
12.2011 - 05.2014

Database Developer

Sysbiz Technologies Pvt Limited
03.2007 - 12.2011

B.E - Electrical & Electronics

Ranipettai Engineering College
KISHORE Kumar Indiran