Ancy Joseph

Senior Database Developer

RedBlack Software Pvt Ltd

Kochi, Keralka

07.2018 - 12.2022

Project : Order Rebalancing Application
Collected User Requirements by participating in meetings with and studying existing System.
Evaluated, designed, implemented and modified databases and database applications.
Created technical documentation for database technologies, providing updates.
Delivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversight.
Developed and updated databases to handle customer data.
Identified issues within databases, performed troubleshooting and implemented effective solutions.
Set up and controlled user access levels across databases to protect important data.
Designed data models for complex analysis needs.
Collaborated with system architects, design analysts and others to understand business and industry requirements.
Planned and installed upgrades of database management system software to enhance database performance.
Proficiency in handling SQL scripts, analyzing and resolving application issues with strong debugging skills
Modifications and enhancements of existing T-SQL stored procedures to improve performance.
Deploying environments/applications fixes, patches, improvements
Expertise in Diagnosing and Resolving Deadlocks, performance issue and timeouts
Experienced in developing the applications using T - SQL (DDL, DML and DCL)
Experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions and cursors.
Experience in providing Logging, Error handling by using Event handler.
Involved in all phases of the SDLC from analysis, design, development, testing, implementation ands maintenance with timely delivery against aggressive deadlines
Worked in support for directly tackling the client issues
Experience in writing sql unit test for complex queries for better code quality.
Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
Implemented BI solution framework for business intelligence projects.
Wrote and maintained technical and functional specifications to document database intentions and requirements.
Implemented security measures to protect vital business data.

Summary

Overview

Work History

Senior Database Developer

Education

Bachelor of Technology - Computer Science & Engineering

Computer

Skills

Timeline

Senior Database Developer

Bachelor of Technology - Computer Science & Engineering

Computer

Similar Profiles

Srikanth GudlaSrikanth Gudla

Ankur AryaAnkur Arya

Bhargav KirneBhargav Kirne

Vishnu R MenonVishnu R Menon

WILSON DCRUZWILSON DCRUZ