Venkatesh K

Associate Development Manager

ZeOmega Infotech Pvt Ltd

Bangalore

07.2013 - Current

Extremely involved in Organization Release Meetings and Roadmap Planning.
Having experience in SQL Server patching, upgradation, and maintenance.
Having good experience in creating a new SQL Server instance with end-to-end setup.
Work with our developers and business analysts to create and modify our database structure as per requirements.
Creating or restoring databases for requested DB versions, and upgrading existing database versions to requested release versions.
Having good experience in creating a new SQL Server high availability setup and debugging issues.
Worked on linked server configurations and creating new logins and users from the instance and database level.
Having good experience in SQL Server replication setup and synonyms database setup for product instances.
Having good experience in writing queries, views, and synonyms.
Manage physical database design, implementation, and performance tuning.
Create standards and best practices for database design and development.
Having good experience in creating database objects, like stored procedures, functions, and triggers.
Advise team members to improve the performance of poorly performing queries by tweaking or modifying stored procedures, views, and indexes.
Orchestration on Jenkins and CodePipeline with Continuous Integration, Continuous Delivery, and Continuous Deployment.
Experienced in working in Agile Sprints for product development, with coordination between cross-functional teams to ensure the delivery of a high-quality product.
A good team player, team builder, with excellent written and verbal communication skills.
Designed databases in accordance with industry best practices for scalability, security, reliability, and performance.
Performed daily maintenance tasks such as backups, restores and log shipping operations.
Provided technical support for applications that use the database system by troubleshooting errors or providing advice on optimizing queries.
Developed scripts to automate routine administrative tasks.
Performed root cause analysis when diagnosing issues with database systems.
Created tables, views, functions, stored procedures and other database objects.
Collaborated with project teams on developing solutions that integrate SQL Server databases into larger architectures.
Coordinated with developers on schema design decisions related to application development projects.
Analysed existing databases for opportunities to improve efficiency through restructuring or re-indexing.
Automated routine tasks using PowerShell scripting language to streamline processes and reduce manual workloads.
Implemented replication between multiple servers to ensure high availability of the system.
Reviewed query execution plans to identify inefficient code or recommend index changes for improved performance.

Summary

Overview

Work History

Associate Development Manager

Education

MCA (Master of Computer Application) -

Skills

Personal Information

Timeline

Associate Development Manager

MCA (Master of Computer Application) -

Similar Profiles

Adil SiddiquiAdil Siddiqui

Rohit KumarRohit Kumar

Madhusudhan Rao GMadhusudhan Rao G

Avinash SubramanianAvinash Subramanian

Shaik SadiqShaik Sadiq