Daniel Chi

Experience

• 

  JPS Health Network

  Nov 2019 - Dec 2021

  MS SQL DBA / AZURE DBA

  • Implement SQL Server installations and configurations in line with Microsoft Best Practices, ensuring optimal performance, security, and adherence to industry standards. • Deliver expert DBA support across development, test, QA, and production environments. Collaborate closely with clients, application teams, and project managers to design, implement, and maintain tailored database solutions that meet specific client requirements. Develop and implement long-term strategies for data storage and capacity planning, ensuring scalability, efficiency, and future growth in database management.• Create and maintain automated maintenance plans for administrative tasks, including index rebuilding, index reorganization, and statistics updates to optimize database performance.• Develop and manage comprehensive database backup and restore strategies in accordance with company SLAs, focusing on Recovery Time Objective (RTO), Recovery Point Objective (RPO), and Retention Policy guidelines to safeguard data integrity.• Execute database refreshes from production to test and development environments, ensuring data integrity, consistency, and availability for testing and development purposes.• Provide expert guidance on database performance tuning, performance baselining, and query optimization. Utilize SQL Server tools such as Query Store, Extended Events, SQL Server Profiler, and SQL Server Tuning Advisor, along with thirdparty tools like IDERA Database Analyzer and Spotlight.• Set up and manage advanced high availability and disaster recovery solutions, including Always-On Availability Groups, Log Shipping, Database Mirroring, Traditional Failover Clustering, and Replication.• Plan and execute SQL Server and Windows patches across various servers, ensuring system integrity, security, and minimal downtime. Upgrade and migrate databases from SQL Server 2012 to SQL Server 2019,2022. Show less

• 

  Dell Technologies

  Dec 2021 - now

  MS SQL DBA / AZURE DBA

  • Developed and implemented robust database backup, restore, and disaster recovery strategies aligned with company SLAs, ensuring data integrity and business continuity. • Minimized downtime and resolved database access and performance issues by identifying and addressing anomalies during patching and database upgrades. • Monitored SQL Server performance using extended events and SQL Profiler to ensure optimal database operation.• Executed routine database changes, including upgrades and migrations, such as transitioning from SQL Server 2012 to 2017 (in-place) and from SQL Server 2016 to 2022 (side-by-side), meeting deadlines with precision.• Performed SQL automation, installations, Azure configuration, site recovery, and backup tasks, prioritizing optimal performance and disaster recovery readiness.• Developed innovative solutions for addressing slow-running queries, deadlocks, and blocking issues, enhancing overall database productivity and efficiency.• Administered databases across various SQL Server versions (2008, 2012, 2014, 2016, 2017, 2019, and 2022), ensuring security through Transparent Data Encryption, Dynamic Data Masking, and Always Encrypted techniques.• Ensured accuracy of input data, conducted thorough testing of new database systems and software updates, and maintained data recovery, integrity, and space requirements as part of contingency planning.• Managed database response times in 24/7 production environments, ensuring high availability and optimal performance through continuous monitoring and tuning. Led comprehensive database design and code reviews, advocating for system reliability and efficiency by implementing industry best practices and standards.• Pioneered the development of complex ETL processes and advanced reporting solutions using SSIS, SSAS, and SSRS, leveraging Azure Data Factory and Azure Synapse for sophisticated data integration and analysis. Show less