b
balajidarapared

Balaji D

@balajidarapared

Senior MS SQL Developer

India
Inglese, Hindi, Telugu
Alcune informazioni sono riportate in lingua inglese.
Chi sono
Senior MS-SQL Developer, overall 9 Years of experience in MS SQL Server environment, with through knowledge of SQL Server 2012, 2016 & 2019 databases. Good in designing, developing, optimizing and maintaining database solutions. Skilled in T-SQL, performance tuning, automation scripting, and backend process optimization. Strong ability to understand business logic and convert requirements into scalable database components. Proven track record of collaborating with frontend developers to ensure seamless data flow and user experience. Experienced in GRC, Health Care & Publications Domains.... Continua a leggere

Competenze

b
balajidarapared
Balaji D
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Data engineer
I will optimize sql server queries and stored procedures
A partire da10 USD / progettoMaggiori dettagli

Esperienza lavorativa

Freelance

Senior MS SQL Developer

Freelance • Full time

Apr 2017 - Present • 9 yrs 6 mos

• Very well experienced in writing Simple and Complex SQL Queries using Sub Queries and Joins, and having very good experience in creating Temp Tables, Derived Tables, Table Variables, CTE. • Quick understanding of Relational Source Database Systems for building accurate transformation logic that can be used in Data Integration. • Very good experience in Designing Database with proper relationships and Database Schemas. • Used Sub-Queries and Joins to simplify Complex Queries involving multiple tables. • Effectively used Views to improve the Performance when the base table involved huge number of records. • Proficient in writing T-SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Functions, Triggers, Views, Cursors and Query Optimization. • Worked on functions like Ranking functions, String Functions, Date Functions, Aggregate Functions. • Very good exposure in Creating Stored Procedures and User Defined Functions (UDF’s) and also involved in Troubleshooting. • Team player with good interpersonal and problem solving skills, ability to work in team and also work independently. • Deadlocks Analysis and implementation of proper techniques to reduce the occurrences of Dead Locks in Stored Procedures. • Effective use of SQL Query Execution Plan Explorer. • Notify through Email for Long Running Jobs more than a specified time. • Notify the SQL Job Status running behind though Email script automatically. • Using SQL Profiler to find out the query that has been supplied to DB from UI. • Automation of Log Files resize in Development & Testing environment and send notification through Database Email. • Implementation of Backup Plans as suggested by the Business needs through automation Scripting and push the backup to Cloud Storage Account automatically through Script. • Index rebuilding to boost the performance whenever needed. • Taking Backup of Transaction Log files as well as Differential Backups as a part of backup plans. • Restoration of Backups