Database Developer Senior

Skills & Tools

• SQL Server

• PostgreSQL

• PL/SQL

• MYSQL

• TSQL

• Sybase ASE

• UNIX Shell Scripting

• Database Design

• Data Modeling

• Performance Tuning

• Query Optimization

• Indexing Strategies

• Execution Plan

Analysis

• Exception Handling

• Job scheduling

• Agile Methodology

RUPALI PATIL

SENIOR DATABASE DEVELOPER

Results-driven Senior Database Developer delivering enterprise-grade database solutions that improve performance, scalability, and security. Known for streamlining data workflows, optimizing queries for large datasets, and enabling data- driven decision-making through efficient database engineering. Seeking to contribute technical expertise to innovative, growth-focused organizations..

Profile Summary

• 7 years of professional experience as a Senior Database Developer, specializing in data modeling, database design, performance tuning, and query optimization.

• Proven track record of delivering secure, scalable, and high-performance database solutions across Finance, Construction, Legal, and Medical domains.

• Expert in relational database systems including Microsoft SQL Server, PostgreSQL, MySQL, Sybase ASE, and Oracle.

• Skilled in SQL programming with hands-on expertise in T-SQL, PL/SQL, complex stored procedures, functions, triggers, and indexing strategies.

• Strong experience in data modeling techniques, including ER diagrams, normalization/ denormalization, and junction tables for optimized schema design

• Proficient in performance engineering — query optimization, execution plan analysis, and index tuning to improve application responsiveness.

• Experienced in automation using SSIS, UNIX shell scripting, and SQL Server Jobs for efficient data workflows.

Core Competencies

Database Design & Architecture – Expertise in conceptual, logical, and physical modeling for transactional & analytical systems; ER diagrams, normalization/denormalization, junction tables, and scalable schema design. SQL Development & Optimization – Advanced T-SQL/PL-SQL, stored procedures, functions, triggers, views; query optimization, execution plan analysis, and indexing strategies for high performance. ETL, Data Integration & Automation – SSIS,UNIX Shell Scripting, job scheduling, and automated workflows. Performance Tuning – Indexing, partitioning, query plan optimization, caching, and database tuning to improve scalability. Data Security & Compliance – Role-based access control, encryption, data masking, and adherence to GDPR, HIPAA, and similar regulations.

Database Administration – Backup/restore strategies, replication, clustering, failover, and high-availability setups. Data Migration & Modernization – Migrating legacy systems to modern database platforms. Reporting & Analytics – SSRS, Crystal Reports, ad-hoc reporting, and operational/analytical dashboards. Scripting & Automation – Shell scripting for database operations. Troubleshooting & Root Cause Analysis – Rapid identification and resolution of database performance bottlenecks and operational issues.

Tools & Utilities – SSMS, SQL Profiler, PgAdmin, PgAgent, SSRS, SSIS, Crystal Reports, JIRA, SVN. Domain Expertise – Capital Markets, Banking, Finance, Construction, Legal Contract Management, Medical systems. Collaboration & Leadership – Cross-functional teamwork, mentoring junior developers, code reviews, documentation standards, and best practices enforcement.

• 2014-2018: BE in Information Technology (Shivaji University Kolhapur) (70%)

• 2012-2013: HSC(12th Science) (72%)

E-Mail: ***************@*****.*** Phone: +91-830******* Location: Pune Education

JULY 2023 – Present Senior Database Developer ITCube Solution, Pune

• Project: Contract Legal Management (CLM)

• Built a centralized Contract Life cycle Management system to streamline contract creation, approvals, renewals, and terminations.

• Integrated real-time dashboards, clause deviation tracking, and automated email & in-app (bell) notifications.

• Implemented secure, role-based access to improve transparency, compliance, and operational efficiency.

• Tools & Technologies: PostgreSQL, JIRA, SVN, PgAgent MAR 2022 – JULY 2023 Senior Database Developer Hexaware Technologies, Pune

● Project: Contract Management System

● Developed an end-to-end Contract Management (CM) solution to centralize contract data, documentation, and key conditions across departments.

● Implemented dispute and legal case tracking with arbitration workflows, structured communication logs, and hearing records.

● Built role-based access controls with OCR-enabled advanced search and seamless DMS integration.

● Designed intuitive interfaces to review historical contracts and outcomes, enabling informed decision-making.

● Provided admin functionalities for unified management of users, permissions, and project-wide documentation.

● Skills: PL/SQL, JIRA

● Project: SPACE

● Developed a web and mobile-based construction domain application for process efficiency and quality improvement.

● Managed database design, complex queries, stored procedures, and performance tuning.

● Implemented change requests, mentored team members, and handled UAT & production deployments.

● Tools & Technologies: SQL Server 2018, JIRA, SVN, SSRS, SSIS

● Project: Acutrans

● Developed a stage-based case management system for QME evaluations ensuring transparency, efficiency, and compliance.

● Implemented role-based access, automated workflows, and controlled stage transitions to minimize errors.

● Optimized operational performance with audit-ready database solutions.

● Technologies: PL/SQL, JIRA, SVN

NOV 2018 - MARCH 2022 l Database Developer l DBCOM Systems Software India Pvt. Ltd.

● Project: Paperless Compliance System (PCS)

● Developed database components for paperless trade compliance.

● Applied query optimization and indexing to improve trade surveillance report generation times.

● Designed schema's for BETA/FIDESSA/Bloomberg trade data and implemented data models supporting compliance workflows.

● Developed high-performance stored procedures, functions, and triggers for financial applications.

● Created ETL workflows to process NYSE/NASDAQ trade data and generate compliance reports.

● Skills: SQL Server, Sybase ASE,T-SQL

● Project: EQube Control Room

● Designed and developed optimized database modules for trade surveillance and event logging.

● Enhanced scalability and maintainability of compliance-related database components through efficient design and documentation.

● Collaborated with compliance teams to align data structures with industry regulations and client-specific rules.

● Skills: SQL Server, Sybase ASE,T-SQL

Personal Details:

Date of Birth: 06/04/1996

Languages Known: English, Hindi & Marathi

Permanent Address: At Bashachamola Post Anaph khurd, Taluka- Bhudargad, District- Kolhapur, MH-416210 Mobile: 830-***-**** / 758-***-****

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

Employment Details

Contact this candidate