Krishnakumar S

About Krishnakumar S

Database is my passion! Be it SQL Server, MySQL, PostgreSQL, or any RDBMS, I am eager to help businesses to improve the performance and scalability of their database applications.I am a senior database architect with 20 years in IT of which 17 years in providing database solutions to companies in varied domains like, finance, banking, and wealth management. Since the year 2003, I am working with various databases such as Microsoft SQL Server, MySQL, Oracle and PostgreSQL.CAREER HIGHLIGHTS• Remodeled an asynchronous auditing system using SQL Server Change Data Capture (CDC) and Service Broker that replaced existing auditing, reduced application\'s CPU use by 30% and memory by 20%, minimized database locking • Revamped the custodian delta change capture process that improved the time from 6 hours to 1 hour, an 80% improvement• Redesigned the file processing using table and index partition, so that the various custodian files can load in parallel without causing locks and deadlocks that improved the process time 60%• Incorporated a high availability and disaster recovery (HADR) solution for large banking application running in MySQL 5.7 database and CentOS 6 using NDB Cluster engine• Designed and developed custom query monitoring solutions for PostgreSQL clusters that helps to improve the query and server performance in long term.• Formulated and executed a plan for backup, restore, and routine maintenance of a large financial application that spread across 10+ databases in 5+ SQL Server instances that finally reduced the disk storage 30%EXPERTISE• Query optimization• Database performance tuning• Administration• Server monitoring and maintenance• Query development in SQL Server (TSQL & SQL-CLR), MySQL, PostgreSQL, and Oracle• Transactional Replication• Business Intelligence using SSIS, reporting with SSRS• Functional knowledge in NoSQL, concepts and graph databases (neo4j)• Coaching and Mentoring in database technologiesMY SIDE INTEREST:• Learning - Database internals, and new database technologies • Reading - This could be literature, technology books, blogs and web articles• Writing - I enjoy writing. So have a blog here (http://krishnakumarsql.wordpress.com/)• Sharing - So I regularly participate in Microsoft’s SQL Server forums. My MSDN profile (http://social.msdn.microsoft.com/Profile/krishnakumar%20s)I’m always happy to discuss about databases and technology. Please feel free to connect with me or mail me at k••••••••@gmail.com.

Experience

1. Senior Architect - Database Architecture, Development

   Envestnet

   Apr 2016 — Present · Thiruvananthapuram, IN

Education

• Mahatma Gandhi University

  Bachelor's degree, Chemistry

  1998 — 2001

• Institute Of Human Resources Development (IHRD), Kerala

  Post Graduate Diploma in Computer Application, Computer Science

  2001 — 2002

Skills

• Agile Methodologies
• Ssis
• Requirements Analysis
• Sql
• Mysql
• Software Development Life Cycle (Sdlc)
• Project Estimation
• Databases
• Xml
• Database Design
• Project Management
• Mentoring
• Etl
• Project Planning
• T-Sql
• Wcf
• Pl/Sql
• Microsoft Sql Server
• Oracle Database
• Sdlc
• Transact-Sql (T-Sql)
• Software Project Management
• C#
• Resource Management