GOPINATH MATHAN

Database Developer

Behind Hyundai Showroom, Bangalore,KA

Summary

SQL Developer with 5+ years of progressive experience in Microsoft SQL Server, databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst, and problem solver known for continuous delivery of quality products across diverse business environments.

Overview

years of professional experience

Work History

SQL Developer – MS SQL Server / MySQL/PostgreSQL

Smart APP

01.2024 - 01.2026

Smart App Planner is a real-time digital planning and project collaboration platform supporting scheduling, dispatching, tracking, and field communication.
Developed database objects such as Tables and Stored Procedures based on client requirements.
Optimized Stored Procedures to improve database performance.
Managed code deployment using GitHub.
Verified and validated data displayed in UI applications.
Worked closely with application teams for database integration and support.

MS SQL SERVER / MYSQL Developer

Empulse Global

01.2022 - 01.2023

Restaurant ordering and seat management application for customers using smart devices. Also worked on NR Group business applications.
Interacted with frontend and .NET developers to gather business requirements.
Created Tables, Views, Functions, and Stored Procedures in SQL Server.
Developed complex SQL queries involving multiple databases.
Optimized stored procedures for production deployment.
Performed database migration from MS SQL Server to MySQL.
Implemented data masking and encryption techniques in SQL Server.
Developed Backup and Restore scripts.

SQL Developer-MS SQL SERVER

Anlage infotech

01.2021 - 01.2021

Provider Lifecycle Management (PLM) solution for healthcare payers and providers to improve provider workflow efficiency, data quality, and operational transparency.
Implemented database business logic based on client requirements.
Developed database objects including Tables, Views, Indexes, Stored Procedures, and CTEs.
Wrote complex SQL queries using Joins, Nested Queries, and Subqueries.
Used TRY-CATCH exception handling for debugging and error handling.
Developed SQL Server Backup and Restore scripts
Participated in query optimization and performance improvements.

Education

Master of computer Application (MCA) - Computer Science

Bharathiar University

Coimbatore, Tamil Nadu

01-2014

Skills

Databases: MS SQL Server 2012/2019, MySQL, PostgreSQL

SQL Skills: T-SQL, Stored Procedures, Functions, Views, Triggers, Joins, CTEs

Tools: MySQL Workbench, JIRA, GitHub, JMeter

SQL development

Accomplishments

Developing a High-performance Database
Designed and developed a high-performance database that increased query speed.
Successfully Migrating Data
Successfully migrated a large amount of data to new database, minimizing downtime and ensuring data integrity.

PROFESSIONAL SUMMARY

Over 5+ years of experience as a SQL Developer using MS SQL Server 2012/2019 and MySQL.
Strong experience in database development, query optimization, backup & restore, and performance tuning.
Expertise in creating database objects such as Tables, Views, Stored Procedures, Functions, Triggers, and Indexes.
Hands-on experience with SQL Queries, Joins, Subqueries, CTEs, and Complex Query Debugging.
Practical knowledge in writing MS SQL SERVER tables and stored procedures and hands-on MS SQL Server authoring.
Experience in database migration from MS SQL Server to MySQL and deployment from Development to Production environments.
Good knowledge of Clustered and Non-Clustered Indexes for database optimization.
Experience working with SQL Server Agent Jobs and MySQL Workbench 8.0.
Familiar with JIRA Ticketing Tool and GitHub version control.
Strong understanding of SDLC, requirement analysis, coding, testing, and technical documentation.
Ability to work independently and collaboratively in team environments.

RESPONSIBILITIES

Installation and configuration of MS SQL Server 2019 and MySQL 8.0.
Development of database objects and coding standards.
Query optimization and performance tuning.
Database migration from Development to Production environments.
Weekly backup maintenance for Production and Development servers.
Requirement analysis, coding, testing, and deployment support.
Optimized Stored Procedure to improve Database performance
Managed code deployment using GitHub
Experience with JIRA Ticketing Tool and Agile support activities.

Timeline