← Back to list ![]()
Middle
Registration: 22.03.2026
Subhasish Ray
Specialization: Database & Solution Architect
— A seasoned IT Professional with rich Functional and Professional experience in designing, developing, and administering SQL Server/NoSQL databases and DW solutions with a track record of delivering business and technology solutions within targeted SLA time and quality parameters.
Highlights:
— Highly experienced in SQL Server installation and configuration in standalone or clustered environments.
— In-depth knowledge in T-SQL programming, Always-On, and other HA/DR technologies like clustering, log shipping, and replication.
— Strong hold on backup/recovery, database security (user roles, permissions, authentication modes), security audit, capacity planning, and monitoring (activity — memory, blocking/locking, caching, disk usage, profiler).
— A turnaround specialist in handling multiple SQL instances in performance tuning and continuous enhancement.
— Collaborate with QA groups to maintain application accuracy and ensure integrity of data applications through analysis, coding, writing clear documentation, and problem resolution.
— Proven ability to coordinate testing of designed applications, design dictionaries, database structure, and layout.
— A situational and committed People Leader who has worked extensively in all phases of SDLC from analysis to delivery, development projects, and supported enhancements and maintenance of existing applications, with the capability to bridge the communication gap between business and technology groups.
— Displayed exceptional interpersonal communication and leadership skills with extensive support at all levels in the organization in the area of knowledge sharing and documentation.
— An influential, innovative thinker with an entrepreneurial mindset, capable of generating new product ideas and architecting solutions.
— Highly skilled in performance tuning of complex queries.
Functional Skills:
— Data Modeling & Integrity.
— Architecting and Designing.
— Data Migration / Management.
— Service Delivery Lifecycle Management.
— Innovation & Automation.
— A seasoned IT Professional with rich Functional and Professional experience in designing, developing, and administering SQL Server/NoSQL databases and DW solutions with a track record of delivering business and technology solutions within targeted SLA time and quality parameters.
Highlights:
— Highly experienced in SQL Server installation and configuration in standalone or clustered environments.
— In-depth knowledge in T-SQL programming, Always-On, and other HA/DR technologies like clustering, log shipping, and replication.
— Strong hold on backup/recovery, database security (user roles, permissions, authentication modes), security audit, capacity planning, and monitoring (activity — memory, blocking/locking, caching, disk usage, profiler).
— A turnaround specialist in handling multiple SQL instances in performance tuning and continuous enhancement.
— Collaborate with QA groups to maintain application accuracy and ensure integrity of data applications through analysis, coding, writing clear documentation, and problem resolution.
— Proven ability to coordinate testing of designed applications, design dictionaries, database structure, and layout.
— A situational and committed People Leader who has worked extensively in all phases of SDLC from analysis to delivery, development projects, and supported enhancements and maintenance of existing applications, with the capability to bridge the communication gap between business and technology groups.
— Displayed exceptional interpersonal communication and leadership skills with extensive support at all levels in the organization in the area of knowledge sharing and documentation.
— An influential, innovative thinker with an entrepreneurial mindset, capable of generating new product ideas and architecting solutions.
— Highly skilled in performance tuning of complex queries.
Functional Skills:
— Data Modeling & Integrity.
— Architecting and Designing.
— Data Migration / Management.
— Service Delivery Lifecycle Management.
— Innovation & Automation.
Skills
MS SQL Server
Oracle
MySQL
PostgreSQL
NOSQL
Cassandra
MongoDB
Virtualization
VMware vSphere
MS Hyper
Azure DevOps
Data Visualization
Power BI
Tableau
MS-Visio
GIT
SVN
Putty
Jenkins
Python
R
HTML
DHTML
XML
Azure
AWS
Docker
Kubernetes
Data Warehouse
ETL
Snowflake
Informatica
Work experience
DBA Project Manager
MphasiS
Azure, SQL Server, SQL
● Accountable for Data migration work stream within the Project budgets and advising the Project Manager of potential deviation.
● Capable of designing High availability/Disaster recovery & scalability plan.
● Architects design and implement solutions that run on Microsoft Azure, including aspects like computing, network, storage, and security.
● Highly skilled in configuring and maintaining Fail-Over Clustering using SQL Server 2008 R2 and above.
● Responsible for creating, administering & maintaining SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
● Handling data recovery, maintenance and data integrity and space requirements for physical databases.
● Expertise in creating SOPs and Job Aid for SQL Team and Ability to create efficient data transformation routines.
● Demonstrated capability in Performance tuning of long-running queries and stored procedures using SQL.
● Pioneered in Profiler, server-side traces, Database Tuning Advisor, and query execution plans.
● Successful in evaluating and addressing the alerts for different issues in the environment.
● Strong with detailed understanding in supporting multiple heterogeneous database instances by configuring, patching, testing, monitoring, and maintaining the database at current release and required levels.
● Advocate proactive actions to seek service improvements where needed and to eradicate any unacceptable levels of service.
● Great understanding and working experience on Customer process / procedure documentation.
● Handle escalations efficiently and ensure that all Service and Operating Level Agreements are being met and improved.
Senior Software Engineer
06.2005 - 12.2006 |Accenture Services
SQL Server, Microsoft
● Provide development and design assistance to development and other application support teams for the client Microsoft.
● Act as an expert technical resource to client and development staff in all phases of the development and implementation process.
● Implement infrastructure systems, either leading as project manager, or assisting as part of a team.
● Interface with user departments remotely and on-site to assist in the implementation of work requests and provide operational support. Code dropping and code fixing.
● Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc. Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
● Perform capacity planning and forecast of storage, database growth and server utilization.
● Implement and maintain Password change procedure.
● Management of backups, restores, recovery models, database shrink operations, Clustering.
● Participate in Cost efficiency & Service improvement initiatives, Incident Management and RCA. Tune the database stack to meet SLAs/OLAs.
Educational background
MBA
IGNOU
Languages
EnglishUpper Intermediate
