Krishna Praveen

● Designing databases & ensuring stability, reliability & performance of the same

● Contributing in creating complex functions, scripts, stored procedures and triggers to facilitate application development

● Performing performance tuning; physical server level, database level (database settings & options) and query tuning

● Designing and implementation of SSIS packages

● Develop and Deploy SSRS Reports

● Designing databases & ensuring stability, reliability & performance of the same

● Contributing in creating complex functions, scripts, stored procedures and triggers to facilitate application development

● Performing performance tuning; physical server level, database level (database settings & options) and query tuning

● Designing and implementation of SSIS packages

● Develop and Deploy SSRS and Power BI Reports

● Data ingestion from Python à Azure blob storage à Snowflake

● Create Users and assign permissions based on the level of database access the user would need

● Managing various activities like developing scripts for monitoring & maintaining databases, automating back-end tasks by creating SQL jobs, writing custom scripts

● Facilitating the process of creating & maintaining indexes, database shrinking, memory settings, monitoring CPU usage and disk I/O activity

● Monitoring installation, administration & maintenance of SQL Server Instances; maintaining failover cluster, designing database backup and restoration strategy

● Implementing standards in database development

● Ensuring process improvement while working in coordination with end users and senior management

● Designing databases & ensuring stability, reliability & performance of the same

● Contributing in creating complex functions, scripts, stored procedures and triggers to facilitate application development

● Maintain and Monitor Failover Cluster

● Managing various activities like developing scripts for monitoring & maintaining databases, automating back-end tasks by creating SQL jobs, writing custom scripts

● Facilitating the process of creating & maintaining indexes, database shrinking, memory settings, monitoring CPU usage and disk I/O activity

● Monitoring installation, administration & maintenance of SQL Server Instances; maintaining failover cluster, designing database backup and restoration strategy

● Implementing standards in database development

● Ensuring process improvement while working in coordination with end users and senior management

● Managing various activities like developing scripts for monitoring & maintaining databases, automating back-end tasks by creating SQL jobs, writing custom scripts

● Merit of travelling to UK to gather business requirements and automate the existing processes

● Bagged new projects after successful completion of process automation

● Facilitated automation of “Proglog” (spreadsheet consists of payroll information of various clients maintained in a shared drive)

● Played a pivotal role in developing a web application in ASP which can post the valuable ideas/suggestions to fine-tune the processes

• PL/SQL Tech Support
• Build test cases and fix bugs in the VOSS application - Barwil (VOSS Maintenance Project)