Database Developer Sql Server

KASTHURAIAH VATTURU

DataBase Developer

Phone: 945-***-****

Email: *******.*******@*******.***

LinkedIn: www.linkedin.com/in/kasthuraiah-vatturu-1030b8364

ABOUT ME

Experienced and detail-oriented Database Developer with over 12+ years of expertise in designing, developing, and optimizing database systems for mission-critical applications. Skilled in SQL Server, MySQL, and Maria DB, with a strong command of Data modeling, Data Migration, stored procedures, User Functions and performance tuning. Proven track record of delivering scalable database solutions in agile and DevOps environments, ensuring data integrity, security, and performance

Core Competencies

12+ Years of Experience: Proven expertise in Database development, focusing on design, development and deployment

Database Development: SQL, PL/SQL, T-SQL, Stored Procedures, Triggers, Functions, Views

RDBMS Expertise: Microsoft SQL Server, MySQL, Maria DB

Data Modeling & Design: ER Diagrams, Normalization, Dimensional Modeling

Performance Tuning: Query Optimization, Execution Plans, Indexing, Partitioning

Data Warehousing: Design, Implementation, Maintenance

Tools & Technologies: SQL Developer, SSMS, Power BI, Tableau, Git

Cloud: Azure SQL, AWS RDS

Soft Skills:

Strong analytical and problem-solving skills

Effective communication and documentation

Cross-functional collaboration with Dev, QA, and BI teams

Agile/Scrum development methodology

EDUCATION

•Masters in computer science from Sri Venkateswara University.

ACHIEVEMENTS

•Achieved Pursuing Excellence Award for consistently develop and deploy the application on time with customer high satisfaction.

•Achieved Stellar award from the Client where we delivered committed item with bug free and close the existed PROD defects.

•Achieved Commitment Award for developed and deployed the project on time without issue.

PROFESSIONAL EXPRIENCE

•Worked as a Senior Lead DB Developer in Samsung, from Jan 2022 to Apr 2025

•Worked as a Lead DB Developer in SLK Software Services Pvt. Ltd, from Dec 2019 to Jan 2022

•Worked as a DB Developer in Samsung R&D institute Pvt. Ltd, from June 2013 to Dec 2019

•Worked as a Programmer in Montage InfoTech Pvt. Ltd, from October 2011 to June 2013

PROFESSIONAL EXPRIENCE

Project: HRMS

Client: Samsung (SDA America)

Role: Senior Lead Full Stack Developer

Duration: Jan 2022 to Apr 2025

Description:

Developed a comprehensive Human Resource Management System (HRMS) to streamline HR operations such as employee onboarding, payroll processing, leave management, and performance tracking. The system allows HR administrators to manage employee records, departments, roles, attendance, and generate reports with ease.

Key Features:

Employee registration and profile management

Attendance tracking and leave request workflow

Payroll calculation with tax and deduction modules

Role-based access control (Admin, HR, Employee)

Performance review and appraisal history

Integrated email notifications for approvals and alerts

Secure login system with JWT-based authentication

Responsibilities:

Designed normalized and denormalized data models using ER diagrams for transactional and reporting systems.

Automated data into Graphical view using Power BI and SQL Server Integration Services (SSIS).

Implemented database schema, Stored Procedures, Functions, Views and DB Jobs

Tuned high-load queries and improved stored procedure performance in large data environments.

Worked with application developers to optimize database interactions and reduce I/O bottlenecks.

Participated in database migration from MS-SQL 2016 to MS-SQL 2019, ensuring zero data loss and minimal downtime.

Participating into Client meeting and understanding the requirements and bring into solution implementation

Analyzing and implementing new changes in existing code

Project: Online Backing (OLB)

Client: Regions Bank, USA

Role: Lead Dot Net Developer

Duration: Dec 2019 to Jan 2022

Description:

Developed a secure and scalable Online Banking System to facilitate digital banking services such as account management, Consumer, Personal, Business, NRA and Retail Banking. The platform allows customers to perform real-time transactions and access account services from any device, while administrators manage users, approve transactions, and monitor system activities.

Responsibilities:

Led the design and development of high-performance database architectures supporting business applications with over 2M+ monthly users

Improved overall query performance by up to 30% through indexing strategies and query refactoring.

Developed complex stored procedures, views, triggers, and user-defined functions to meet dynamic business needs.

Implemented database schema, Stored Procedures, Functions, Views and DB Jobs

Migrated legacy systems to cloud-based platforms (AWS RDS and Azure SQL), reducing infrastructure costs and improving reliability

Supported database governance by implementing access controls, auditing, and encryption measures.

Project: PRISM

Client: Samsung, India

Role: Lead Engineer

Duration: Jan 2019 to Dec 2019

Description:

Samsung PRISM is a student program offering students a chance to work on real-world projects, interact with Samsung’s top technical experts and provide hands-on experience in core technology domains. As part of this program, Students and Professors will form teams. Each team will be assigned a work-let* and a mentor from SRI-B. The team will be required to deliver project in a specified timeframe and earn exciting benefits. Samsung collaborates with college departments and identifies areas of interest. Professors collaborate with Samsung technology leaders.

Responsibilities:

Designed normalized and denormalized data models using ER diagrams for transactional and reporting systems.

Automated data into Graphical view using Power BI and SQL Server Integration Services (SSIS).

Implemented database schema, Stored Procedures, Functions, Views and DB Jobs

Tuned high-load queries and improved stored procedure performance in large data environments.

Worked with application developers to optimize database interactions and reduce I/O bottlenecks.

Participated in database migration from MS-SQL 2016 to MS-SQL 2019, ensuring zero data loss and minimal downtime.

Participating into Client meeting and understanding the requirements and bring into solution implementation

Analyzing and implementing new changes in existing code

Project: My Galaxy & My SRI-B App

Client: Samsung, India

Role: Team Lead

Duration: Feb 2016 to Dec 2018

Description:

The goal of My Galaxy is inter-connect between various business deals or offers like entertainment, Services, Convenience…Etc. My Galaxy give you a unique all-in-one experience that will delight you with amazing content, unparalleled convenience and expert care. You also get personalized coupons and offers on leading brands for the most commonly used categories like cabs, movies, travel, recharge & bill payments.

The goal of My SRIB is simplification of SAPNA (Samsung R&D Advanced Process and Information System) is an automated solution for the organizational Business processes. System gives an intelligent inter- connect between various business Processes across functions.

Responsibilities:

Designed normalized and de-normalized data models using ER diagrams for transactional and reporting systems.

Automated data into Graphical view using Power BI and SQL Server Integration Services (SSIS).

Implemented database schema, Stored Procedures, Functions, Views and DB Jobs

Tuned high-load queries and improved stored procedure performance in large data environments.

Worked with application developers to optimize database interactions and reduce I/O bottlenecks.

Participating into Client meeting and understanding the requirements and bring into solution implementation

Analyzing and implementing new changes in existing code

Project: SAPNA

Client: Samsung, India

Role: Sr. Software Engineer

Duration: Jun 2013 to Jan 2016

Description:

SAPNA (Samsung R&D Advanced Process and Information System) is an automated solution for the organizational Business processes. System gives an intelligent inter-connect between various business Processes across functions. Based on the scalable platform, it generates various business Intelligence reports for different groups of users like Engineers, RM, PM, GH, HOD, HR Manager, CFO, MD etc. System is based on the concept of workflow where in the data is driven automatically based on organization structure. The modules of this project are Finance, GA, HR, IP, Outsourcing, Project Management, Engineering, Purchase Dept., Innovation, System Admin, Info security etc. SAPNA includes many applications like Workflow, SPIN, HRIS, and Adhoc. Main Advantage of SAPNA is its database architecture it has been designed in perfectly and it is scalable and all the tables are normalized.

Responsibilities:

Designed normalized and de-normalized data models using ER diagrams for transactional and reporting systems.

Automated data into Graphical view using Power BI and SQL Server Integration Services (SSIS).

Implemented database schema, Stored Procedures, Functions, Views and DB Jobs

Tuned high-load queries and improved stored procedure performance in large data environments.

Worked with application developers to optimize database interactions and reduce I/O bottlenecks.

Participating into Client meeting and understanding the requirements and bring into solution implementation

Analyzing and implementing new changes in existing code

Project: Golden Fruit Capital

Client: Montage InfoTech, India

Role: Programmer

Duration: Oct 2011 to Jun 2013

Description:

Golden fruit capital (GFC) is the business oriented application like chain marketing system which applies the concept binary tree. For an investee to invest money in GFC that person require a sponsor who is already a member in GFC and will be honored with gold, silver or zero based on the investment. A person can sponsor only two direct investees and any more sponsors will be under his investees just like a typical binary tree. Now each investee has to meet their defined target to get awards and promotions. If a child investee introduces any person the profit would be shared to all his parents in the tree. At any point if the tree discontinues the tree will be converted as union tree from that point.

Responsibilities:

Understanding and analyzing business requirements

Involved in designing, Analysis of existing system flow and code

Enhancement and Development to coding standards, Defect review and fixing

Involved in Writing Stored Procedures and developing reports

Preparation, review and execution of UTC

Skill Info:

ASP. Net, C#.Net, RDLC Report, SQL Server 2008, CSS, Ajax.

Contact this candidate