- Managing and maintaining Microsoft SQL Server on-premise/Cloud relational database management systems(RDBMS)- Installing and upgrading Database Servers, including applying service packs.- Collaboration with healthcare client to design visually compelling Power BI reports and dashboards to convey business insights and metrics while ensuring compliance with HIPAA regulations and data privacy standards. - Design, implement, and optimize end-to-end data pipelines for efficient and scalable data processing and storage.- Proactively tuning and optimizing database performance.- Expertise in Investigating and resolving database performance issues.- Strong understanding of database security principles and best practices.- Implementing and maintaining database security measures to meet industry compliance standards (e.g., HIPAA, GDPR).- Configured and enforced SQL Server facets to manage properties of databases, tables, servers, and logins.- Managing database backups and recovery processes to meet RPO & RTO.- Proficiently using scripting languages (e.g., SQL, Python, PowerShell) for automation tasks.- Utilizing configuration management tools for effective database automation.- Hands on experience with cloud-based database services, such as AWS, Azure SQL.- Managing High Availability and Disaster Recovery sites.- Quickly troubleshooting and resolving database-related incidents.- Proficient in developing advanced SQL queries, including CTEs, window functions, and recursive queries.- Utilized Jira for tracking and managing database-related tasks, including software releases, bug fixes, and change requests.--

- Successfully implemented Data Warehouses for healthcare, marketing, and finance, including payroll, HR, and Operational Data Store systems- Led the migration of on-premise SQL Server databases to Azure SQL, orchestrating a seamless transition with minimal disruption to operations. - Designed, implemented, and maintenance of complex database solutions.- Design, architect, implement, and support key datasets, creating scalable data pipelines using Python, SQL, and cloud-based technologies such as Azure Data Factory.- Performed database design and data modeling tasks, including gathering business requirements, facilitating information gathering sessions, and documenting data analysis services.- Developed scripts to automate complex or repetitive DBA tasks and managed automation of system maintenance tasks such as database backup, indexes, and scheduled jobs.- Conducted design and code audits of all database development, and tuned performance of live databases to avoid deadlocks, blocking, and contentions.- Implemented Transparent Data Encryption (TDE) to secure sensitive data at rest.- Implemented high availability and disaster recovery solutions.- Establish and enforce data quality standards and governance policies to ensure accuracy, consistency, and compliance with relevant regulations.- Managed SQL Server Transactional and Snapshot Replications.- Tune database server configurations to fix performance issues.- Lead the design and development of data analytics projects and data pipelines using Postgres, and Snowflake.- Implement Integration with Google Analytics, Nice-InContact and other third-party APIs.- Clinical & Financial Healthcare Data Migration from ECW, Modernizing Medicine and Athena Health - Conducted regular training sessions on database administration and optimization techniques for the team to improve their technical skills and knowledge.

- Designed, developed, and deployed a US Medical Billing and Electronic Medical Record system that complies with HIPAA regulations for patient data confidentiality and privacy.- Worked on database normalization, indexing, and optimization.- Developed and maintained efficient ETL processes to extract and transform data from various sources and load it into a data warehouse. - Implemented Reporting Server using SQL Server Reporting Services- Run VACCUMM Operations to fix bloating issues in Postgres Tables and indexes.- Proactively fine-tuned and optimized database performance to ensure optimal functionality.- Developed efficient and scalable data pipelines.- Work with different columnar file formats like RCFile, ORC, and Parquet formats.- Perform Data Analytics on Structured and Semi-Structured data using Snowflake.- Worked on Healthcare data migrations with includes Financial as well as Clinical Data from ModMed System.- Actively participated in the seamless migration of on-premises databases to cloud environments- Implemented table partitioning on large tables and use partition switching for working on subset of data.- Implemented data quality checks and validations, monitored ETL processes for issues, documented processes, maintained version control, and ensured data integration and compatibility across systems.- Restored databases with point in time recovery.- Mentored team members to improve their technical and interpersonal skills, resulting in enhanced productivity, job satisfaction, and retention rates.- Implemented Transactional and Snapshot replication between databases.

- Responsible for the administration, maintenance, migration, and upgrade of Microsoft SQL Server servers, providing 24/7 technical support- Additionally, responsible for rebuilding and monitoring indexes, reviewing SQL Server configurations, and recovering databases from backups in disasters.- Creating database structures, tables, and relationships.- Writing efficient and optimized SQL queries for data retrieval and manipulation.- Documenting database designs, processes, and procedures for future reference.- Implement data partitioning and data extraction to manage and scale database size effectively.- Worked on Micro financing banking application which was built in C# and SQL Server.- Managing database backups, recovery, and Implemented SQL Server replications.- Troubleshooting and resolving database-related issues and errors.- Created and scheduled SQL Server Jobs to perform database maintenance acidity.- Involved in Data Integration by identifying the information needs within and across- functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.- Working closely with cross-functional teams to integrate data from various sources into the database.

- Creating database structures, tables, and relationships.- Writing efficient and optimized SQL queries for data retrieval and manipulation.- Documenting database designs, processes, and procedures for future reference.- Troubleshooting and resolving database-related issues and errors.- Administered, maintained, and periodically optimized the performance of all Microsoft SQL Server servers.- Designed and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints- Developed stored procedures, triggers, and functions to support business logic in applications.- Worked with developers to troubleshoot and resolve SQL-related issues in applications.- Imported data from Oracle databases to SQL Server using SSIS packages and implemented auditing and DDL triggers to enhance data security and integrity.- Managed SQL Server disk space to ensure storage is properly utilized.