Back to Developers
Rakhal Chandra Roy

Rakhal Chandra Roy

SQL Server DBA | Data Analyst

Kolkata, India $15/hr Remote Full-time 26+ yrs exp 100 · Outstanding

About

SQL Server DBA, Data Analyst and MIS professional with 25+ years of progressive experience across database administration, SQL development, financial systems, reporting and IT operations. Hands-on experience with MS SQL Server, T-SQL, performance tuning, indexing, backup and recovery, SSIS, SSAS, SSRS, Power BI, Tableau, Tally ERP and Windows Server environments. Experienced in building reporting solutions, automating data-processing workflows, supporting business-critical applications, and translating operational and financial data into management insights. Strong background in Accounts Payable/Receivable, reconciliations, payroll, MIS and executive reporting.

Skills & Expertise (35)

T-SQL Expert
9.0/10
26
Years Exp
MS SQL Server Expert
9.0/10
26
Years Exp
Query Optimization Advanced
8.8/10
26
Years Exp
Indexing Advanced
8.5/10
26
Years Exp
Dashboards Advanced
8.0/10
10
Years Exp
Complex queries Advanced
8.0/10
26
Years Exp
Stored Procedures Advanced
8.0/10
26
Years Exp
Data Warehousing Advanced
8.0/10
26
Years Exp
Tableau Advanced
8.0/10
26
Years Exp
Power BI Advanced
8.0/10
26
Years Exp
SSRS Advanced
8.0/10
26
Years Exp
Data Modelling Advanced
8.0/10
26
Years Exp
SSAS Advanced
8.0/10
26
Years Exp
partitioning Advanced
8.0/10
26
Years Exp
security Advanced
8.0/10
26
Years Exp
Disaster Recovery Advanced
8.0/10
26
Years Exp
OLAP Advanced
8.0/10
26
Years Exp
ETL Advanced
8.0/10
26
Years Exp
SSIS Advanced
8.0/10
26
Years Exp
Triggers Advanced
7.5/10
26
Years Exp
Views Advanced
7.5/10
26
Years Exp
Microsoft Excel Advanced
7.0/10
15
Years Exp
Windows Server 2016 Advanced
7.0/10
10
Years Exp
Windows Server 2019 Advanced
7.0/10
10
Years Exp
Server Administration Advanced
7.0/10
10
Years Exp
VB.NET Intermediate
6.5/10
10
Years Exp
ASP.NET Intermediate
6.5/10
10
Years Exp
Microsoft Access Intermediate
6.0/10
10
Years Exp
Vendor Reconciliation Intermediate
6.0/10
10
Years Exp
Payroll Intermediate
6.0/10
10
Years Exp
Financial Reporting Intermediate
6.0/10
10
Years Exp
Tally ERP Intermediate
5.5/10
10
Years Exp
Automation Backup Recovery

Work Experience

Data Analyst

Independent Contractor / Freelance Data Analyst

Aug 2025 - Present

Provide SQL analysis, query optimization and custom reporting solutions for commercial clients. Develop ad-hoc T-SQL scripts to identify operational bottlenecks and produce clean datasets for business analysis. Audit legacy database structures, investigate data anomalies and support relational database restructuring.

Manager (IT, Data Systems & Accounts)

Pallishree Limited

Feb 2024 - Jul 2025

Managed IT infrastructure, data security, database administration, MIS and technical operations. Administered and performance-tuned MS SQL Server databases, including indexing, backup/recovery and security controls. Managed IBM Windows Server 2016 Data Server and Lenovo Windows Server 2019 Application Server environments. Developed Tableau dashboards and visual analytics to support executive decision-making. Designed and modified in-house applications to improve financial and HR workflows. Developed IT policies and data-management best-practice guidelines. Prepared daily, weekly and monthly financial MIS dashboards and performance summaries for management. Supervised payroll processing, statutory reporting and employee financial-record compliance.

Officer (IT, MIS & Accounts)

Birbhum Chemicals and Fertilisers Ltd

Sep 2019 - Feb 2024

Managed IT infrastructure, MIS, financial database records and technology-related operational controls. Conducted network and data-security reviews to identify risks and strengthen access controls. Coordinated software upgrades and enhancements to legacy systems and in-house data-capture tools. Maintained core company database records and developed automated routines for financial statements, bank reports and trend analysis.

Database & Reporting Developer

Tech-Next Infosys

Nov 2015 - Aug 2019

Designed and developed database solutions and end-to-end data pipelines for commercial clients. Built and deployed SSIS packages and ETL processes for large data sets. Designed multidimensional analytical models and SSAS OLAP cubes for reporting and analysis. Investigated database defects and production queries and worked with client-facing teams to resolve technical issues.

Consultant – Database Administration

Amrit Projects Ltd

Feb 2003 - Oct 2015

Provided database administration, performance tuning and database engineering support. Optimized poorly performing T-SQL queries and reviewed execution plans to address CPU and I/O bottlenecks. Designed and implemented database backup, business-continuity and disaster-recovery procedures. Supported capacity planning covering storage allocation, database sizing and memory-management issues.

Payroll & Accounts Assistant

Fruit Fare Ltd.

Sep 2001 - Sep 2002

Designed and maintained standalone payroll databases and tracking tools. Reconciled ledger discrepancies and improved bank-deposit processing workflows.

Junior Programmer

Tech-Next Infosys

Jan 1999 - Jan 2001

Translated logic charts into procedural instructions and supported software testing, code refactoring and database schema design.

Education

Oracle Workforce Development Diplomas - SQL Star International Ltd.

2007 - 2008 · India

Network Centered Computing & Application Development Diplomas - NIIT Technologies

1996 - 1998 · India

Bachelor of Commerce (B.Com), Accountancy - University of Calcutta

1994 - 1996 · India

Certifications

Microsoft Certified Professional (MCP)

Microsoft Corporation · 2008

SQL Server

Oracle Database Administrator Certified Professional (OCP)

Oracle Corporation · 2008

Oracle 9i Database Administrator

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 5/5
🏆 Certs 5/5
Verified 5/5
Total Score 100/100

Profile Overview

Member sinceSep 2026
Work ModeRemote
AvailabilityFull-time

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer