SUMMARY:

• 16 years of experience in SQL Server Database Architectural Design, Implementation and Administration. Specialized in Performance Tuning, Process Automation, HA & DR Design, Security Management and Operations Management.
• Intensive experience in designing and building dashboard reports for Business Analysis, Operations Insights, System Health Check and Financial Profitability.
• Exposure to the entire life cycle of Product Development, which includes Requirement Analysis, Design, Development, Testing, Deployment, Support, Maintenance and Reporting for Mission Critical Enterprise Systems in Healthcare, Finance and Product Engineering.
• Proven track in successfully leading the completion of several large - scale enterprise system integration, upgrade, and migration projects with 100TB+ data.
• Exceptional problem solving, customer servicing, and communication skills and great work ethics. Well respected by customers for focusing on details, quality, and root causes analysis.

SKILLS & TOOLS:

• Confidential Azure, Azure Database, Azure SQL
• SQL 7-2016, Oracle, MySQL, Lotus Notes, Access
• TSQL, SSRS, SSIS, SSAS, ETL, SQLCMD, BCP
• Always On, Replication, Mirroring, Log Shipping
• TDE, SSL Encryption, Data Compression, DB Security
• SQL Profiler, PSSDiag, Log Parser, Plan Explorer
• Netmon, Fiddlers, Debug View, Sys Internals
• Cluster, NLB, AD, ADFS, FTP, SAN, DAS, RAID
• SCOM, SCVMM, Hyper V, Orchestrator
• Power BI, Tableau, Splunk, Power View
• SSRS Report, Crystal Report, Pivot Table
• App Insight, IIS Log Parser, Query Store
• SCOM, Idera, SQLSentry, Red Gate, Dynatrace
• Hadoop, Hive, MPP, Data Warehouse, BI
• MS Project, Visio, Excel, Word, OneNote
• Power Shell, C#, Java, Perl, Java Scripts, VB, VBA,
• Visual Studio, TFS, Test Manager, SharePoint, IIS
• Project Management, Agile, Scrum, SDLC

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Engineer

Responsibilities:

• Managed and maintained hundreds of SQL instances in SQL Server and Azure for many critical insurance applications. Responsible for database development, deployment, upgrade, monitoring and support.
• Communicated with application users to analyze business requirements and examine workflow. Developed Database Scripts and SSIS packages to automate and enhance business processes.
• Worked on designing, planning and implementation of complicated insurance system migration from On-premise data center to Azure IaaS and PaaS.
• Managed multiple database projects including SQL Upgrade, Application Release, Service Account Update, Automatic Deployment, System Health Check, etc.
• Worked as the Primary Database Coordinator in the annual Confidential DR Exercise and Auditions. Communicated with a large number of database owners, application owners and department leads to plan and perform DR Exercise for over 100 Enterprise Applications.
• Designed and built business and operations reports to help analyze and improve database system performance, configuration, utilization, data quality, security, and profitability.
• Trained junior DBAs to troubleshoot and identify root cause for day to day database related issues. Educated team on how to tune queries and optimized SQL environment for better performance.
• Took proactive actions to improve availability, security and profitability of the SQL Server environments.

Confidential

Senior Software Engineer

Responsibilities:

• Managed over 100 TB of mission critical data hosted in Azure and On-Premise for different customers. Exposure to the entire life cycle of a high-performance Healthcare Application (CIP - Confidential Intelligence Platform), which includes Requirement Analysis, Design, Development, Testing, Deployment, Support, Maintenance, Operations Reporting and Business Analysis.
• Proposed, designed and created series of dashboards, tools and reports for Business and Operations Analysis:
• An intelligent Splunk dashboard (originally with Power BI) that gets feeds from all customers and provides insights for Tenant Profile, Availability, Health, Security, Operations, Profitability, etc.
• Provided in-depth performance tuning for mission critical large healthcare systems:
• Optimized configurations at Windows, SQL, DB, File, and Page level for better performance.
• Investigated Memory, CPU, IO, Network, and other factors to identify SQL system bottlenecks.
• Speeded up systems through query tuning, database optimization, partitions or code design changes.
• Evaluated index utilization patterns, identify missing/duplicate indexes and optimize existing indexes.
• Successfully led the migration of three hosted customers (100+ servers) out of the Confidential datacenter. Designed an Amalga migration tool to automatically extract clustered services, databases, and application configurations from one environment to another. The migration tool shortened the project cycle significantly by enabling junior engineers to quickly clone a complex environment at ease.
• Investigated Designed SQL Server High Availability and Disaster Recovery strategy based on customer needs. Familiar with SQL Server Failover Clustering, Always On, P2P Replication, and Mirroring.
• Established Database Security best practices in auditing, encrypting data at rest (TDE) and data on transit (SQL SSL), password management, access control, and change control.
• Collaborated with network, SAN, and system engineers to troubleshoot cross-domain issues and design best configurations based on different customer’s IOPS pattern.
• Developed Storage Provisioning strategy for customers of various sizes to support business needs from other teams such as Sales, Procurement, Development, and Hosting.
• Created ETL, Bulk Copy, and reporting solutions for customers using SSIS, BCP, and SSRS.
• Documented Azure and SQL best practices in design, configuration and maintenance. Hosted a DBA Forum promoting knowledge sharing, peer supporting and group learning.

Confidential

Senior Database Engineer

Responsibilities:

• Participated in the initial releases of Confidential Amalga (V1, V1.5 and V2). Investigated software issues and provided recommendations to the product team in areas such as storage provisioning, SQL disk layout, HADR (High Availability & Disaster Recovery), scalability, performance, security, and supportability.
• Launched the first hosted Amalga customers. As one of the key members in the hosting team, created a series of processes, procedures, tools, and documentations to ensure smooth customer deployment, onboarding, support, and production change control.
• Acted in multiple roles as a DBA lead, Project Manager, and Application Expert in a small startup team supporting multiple clinical systems on a 24x7 schedule. Developed strong troubleshooting and problem- solving skills to isolate problems’ root cause and deliver long-term remediation solutions.
• Led a team of 5 DBAs in designing, testing and deploying Medstar’s Amalga Enterprise Database System, which aggregated over 100TB of patient data from 7 hospitals. Developed methodology to synchronize the old systems and the new system with no downtime.
• Built an automated Amalga System Smoke Testing Tool using Power Shell, TSQL and DMVs, which checks overall system health and sends alerts to on-call team for critical issues. Also created many scripts and tools to automate major database maintenance and application support activities.
• Conducted numerous efforts on large scale deployment in areas such as database development, performance tuning, online migration, training, DR Failover test, operationalization, etc.
• Successfully upgraded all SQL Servers in 7 Medstar hospitals from SQL 2000 to 2005 with zero downtime. Moved from transactional replication to peer-to-peer replication. Built up standards for monitoring and maintaining Amalga databases to ensure smooth operations.
• Created a team wide Knowledge Base to promote documentation, best practice sharing, and collaboration. Helped in building the tier 1 and tier 2 support teams and created a series of Troubleshooting Guides instructing them how to respond to alerted issues.

Confidential

Clinical Informatics Developer

Responsibilities:

• Designed, developed, deployed and maintained and supported applications in the Azyxxi platform for 7 Medstar hospitals with 20,000+ users.
• Developed backend databases, tables, views, triggers, functions, and stored procedures based on business requirements.
• Performed database administration activities such as database replication, backups, monitoring, maintenance, and reports.
• In-depth Performance tuning for the Azyxxi system with Terabytes of data.
• Designed and built customized dashboard and applications for clinical users: ED daily surge dashboard, Nephrology dialysis tracking app, OBGYN scheduling, Managed Care Insurance Denial, MR Audit, Operation Katrina, etc.

Confidential

Database Manager

Responsibilities:

• Managed PHO’s Finance System and Claims Processing System including installation, upgrade, enhancement, monitoring, and maintenance. Provided comprehensive analysis on case payment, incentive payout, and AR/AP status.
• Designed an internal operations system which interfaced with all existing systems needed by end users to complete their work - AR, Confidential, Azyxxi and Invision, etc. The new system greatly automated the daily operations of PHO, simplified workflow, and reduced financial loss caused by billing errors.
• Implemented a web-based EDI (Electronic Data Integration) system that provides complete solutions for sending and receiving HIPAA-ready e-transactions in standard claims formats. Successfully upgraded Confidential from SQL Base to SQL Server 7.
• Created business reports using Pivot Table and Crystal Reports for management and General Ledge to help with decision-making, payer auditing, contracts negotiation, and account reconciliation.