Ancy Joseph - Senior Database Developer

Summary

Successful Database developer with 4.5 year's of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems.

Overview

4

years of professional experience

6

years of post-secondary education

Work History

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.

Education

Bachelor of Technology - Computer Science & Engineering

SCMS School Of Engineering andTechnology

01.2014 - 01.2018

Computer

Science St Mary’s Kochi

01.2012 - 01.2014

Skills

Methodologies : AgileTools : SQL Server Management StudioSSISSQL profilerQuery AnalyzerJenkisLanguages : TSQL, C# Basic

Database objects creation

Database uploading

Database monitoring

SQL database expertise

Testing of database objects

Managing databases

Developer collaboration

Timeline