Richard Ding Email and Phone Number

Help client to improve VLDB SQL Server farm. Re-architecture AlwaysOn based business continuity solution. Plan SQL Server 2019 migration. Formulate standards and best practices in all SQL areas, including but not limited to database and resource settings, file management, index management, backup tuning, query performance tuning, index, partitioning, ETL, service broker, PowerBI and Azure integration.

• Senior SQL DBA in a multi-national team supporting 100+ SQL Servers 2019 to 2000 instances. Support in-house and customer applications, including Kronos’ flagship Workforce Central• Support Corporate's confidential financial HR/Payroll systems• Migrate corporate CRM data from Siebel to Salesforce Cloud. Salesforce backups with SQL Servers.• Support DR solutions with SQL Server 2016 AlwaysOn• Support IBM Cognos including content management and emergent fix.• Design and deploy SQL Server consolidation through VMware virtualization.• Design, build and support SQL 2017/2019 failover clusters on Hyper-V.• Design, build and support Master Data Service and Data Quality Service on SQL Server 2017 AlwaysOn Availability Groups.• Migration Reporting Service from SSRS 2008 to SSRS 2017• Design, code and implement SSIS 2017/SSRS 2017 based dashboard supporting non-prod SQL Server/Oracle environment refreshes.• Top-notch SQL Server performance tuning resulting in huge business gain, e.g., transactional replication replacing OPENROWSET fixing customer web site timeout, and multi-layer subqueries investigation bringing nightly calculation from 17+ hours down to 1.5 hours.• Azure DBA for MS SQL Synapse migration from Oracle EDW project.• PostgreSQL Ver. 12 DBA• Tableau, JASON, Postman, Apache HTTP server, Apache Tomcat, Java SDK, RESTAPI, SSL, SSO

-Architecture design, migrate, and support production SQL Server 2012 with AlwaysOn Availability Groups-Migrate and support production SSRS 2012 servers-Develop RSS based RDL mass upload solution for SSRS 2012/SSRS2008 R2-Develop SSIS 2012 packages to assist ETL process-Routine SQL Server 2005/2008R2/2012 and SSRS 2008R2/2012 support in DEV/TEST/QA/PROD-SQL Server 2012 data modeling

-Technical account manager providing primary DBA support for multiple clients. Proven customer-facing experiences and skills to keep clients satisfaction. -Support SQL 2012/2008R2/2008/2005/2000 OLTP/OLAP.-Implement AlwaysOn HADR and multi-node multi-instance clusters. -Help clients achieve huge disk space saving and better performance by designing and implementing data and backup compression.-Design, test and implement Resource Governor to control run-away user queries.-Design corporate level audit solution with SQL Server 2008 R2 Audit.-Complete analysis of database performance with execution plans, DMVFs, traces, DETA and perfmon logs.-Investigate and provide proof for virtualization of SQL server instances in VmWare.-Experiences of working with databases for Sharepoint 2010, ERP, CRM, BSM, Kronos, Altiris, SCOM, Websense, FAS, Team Foundation.-Experiences of working with DBA tools, including IDERA Suite, SQLLiteSpeed, Sitescope monitors, and Best Practice Analyzer.-Design and implement logon trigger for auditing and DDL trigger based alert system.-Performance tuning for SQL 2008 Log Shipping troubled with out-of-sync issues. -Performance tuning of SQL 2008 R2 transactional/merge replications that suffered huge latency.-Design, test, implement and support a SQL 2008 R2 partitioned VLDB including periodical spliting and merging partitions to archiving, filegroup based partial backup and piecemeal restore.-10 TB OLTP support experience in prod environment.-Design and build a DBA specific data mart using scheduled jobs to archive DMVF data.-Experience of working in mixed environments with Oracle 10/11 g, Sybase, and MySQL.-Solid experience in UTIL based ticketing system. -SQL 2012/2008 BI: Develope/migrate SSIS packages and SSRS reports. Administer SSAS server. XMLA/ASSL/MDX query. Backup/restore AS dbs. Process cube objects. Concepts of dimensional modeling. T-shoot ETL. Engage in DBA to DWA transition. Data warehouse performance tuning.

-Help client setup database HA solution. Design, build, configure and support SQL Server 2008 cluster on Windows server 2008 with DELL hardware. Design migration of SharePoint and CRM applications to clustered environment.-Develop SQL Server 2008 SSIS packages to ETL data between Oracle 10g databases, and between Oracle and SQL 2008 databases. Tune ETL performance in indexes, source data loading, lookup, merge join, and data conversion. -Configure SSRS 2008 production server and migrate test reports. Develop reports for PeopleSoft data warehouse. Standardize report template. Help end users work smoothly in BIDS.-Support SQL Server 2008/2005 mixed OLTP environments. Focus on disk space saving with backup compression and data/index page compression. Improve server performance through Resource Governor.-Acquire entry-level Oracle experience. Install Oracle 10g client, set up connection, write PL/SQL scripts, Attunity and OLE DB Oracle connector. Daily use of Oracle admin tools (Toad, Navicat, and SQL*Plus).

Support a dynamic business system with hundreds of SQL Server 2005/2008/2000 servers.Database tech lead in building data warehouse using SQL Server 2005/2008 BI technology. Assist database architect to design data warehouse/data mart architecture. Establish deployment procedures and security requirements for SSIS and SSRS. Define hardware and software specifications. Present architecture design.Evaluate new mission critical projects with SQL Server 2008 technology. Assessed CDC (Change Data Capture), CT (Change Tracking), backup compression, TDE (Transparent Data Encryption), and auditing.Serve as SME in multiple database projects.Author SQL Server and Database Standard. Performance tune transactional replication with high throughput and low latency.Design hardware and software specification on Windows 2003. Use HP Blade server with SAN storage.Design filegroups, partitions and partial file backup strategy for VLDB data warehouse. Design and implement a customized Online Index Rebuild process.Design production SQL Server monitoring and notification process Spearhead building SQL Server 2005 based clustering to provide HA solution.Design, test, deploy and maintain highly performed SQL Server 2008 Reporting Server. Author on-demand reports.Reinforce SQL Server security standards and best practice.

Support around 60 SQL 2005/SQL 2000 active/active clustered instances. Perform backup and restore routines.Migration of SQL 2000 to SQL 2005 servers on a Windows 2003 clustered platform. Design automation of database routines including but not limited to backup/restore, refreshing testing/dev/QA boxes, monitoring on server status, login failures, error log event check, disk and database space growth.Research and implement SQL 2005/2008 new features.

Support the highly transactional main site; with emphasis on performance. Monitor, detect and fix SQL server issues that contribute to site slowness. Expert on using SQL profiler, server side traces, system stored procedures and tables to pinpoint database issues caused by recompilations, outdated statistics, use of wrong indexes, blocks, shortage of worker threads, uncached stored procedures, and heavy procedure calls.Support multiple SQL server 2000 64-bit on Windows 2003 64-bit platforms, full instance of 1.5 TB data with rapid growth, 50 dev/int/QA/prod SQL instances. Apply service packs and patches. Maintain and refresh QA/INT/DEV environments through backup/restore. Resolve disk space issues on multiple servers. LUN upgrades to add more space for QA, and work with in-house NT group to add extra disk arrays in various environments. Write T-SQL scripts to monitor and calculate disk space usage in daily operation and routine refresh process.Write complicated DTS packages to cope with cross server joins and to increase performance. Examples are massive data modifications, release hot fixes, rebuild tables, monitoring SQL error logs, and so on. Support complicated transactional replications. Resolve replication errors in a timely fashion. Support fail-over sites in Indianapolis through log shipping.Support a semi-production reporting server via log shipping and backup/restore.Work with Rational ClearQuest ticket system. Review schema and data kits for projects. Interact with developers to fix errors, give proposals and tune SQL statements. Serve as last line of defense of protecting bad and/or under performed codes getting into production.Coordinate between DBA, networking, QA, developer and shift groups. Delegate DBA to attend project meetings. Document database related procedures and rules. Evaluation of SQL Server 2005. Installation and upgrade, database mirroring, database mail, service broker, XML, CTE, SSMS, and new security features.

Support SQL Server 2000 databases for fund and stock trading system.Design a system to find disk IO usage to assist relocation of database files.Serve as a central SQL knowledge base for developers and system group. Try best effort to reinforce database best practice and rules despite reluctance and resistance.Redesign database backup/restore architecture. Implemented disk based backups.Automate SQL server processes including disk space alerts, schema changes, critical errors, and blocks.Performance tune production SQL server by reviewing stored procedures, replacing cursors, table variables, index tuning, user-defined functions and file groups.

Support a mixed environment of more than 50 SQL 2000 and 7.0 servers with over 1 TB databases. Support applications written with .NET, Power Builder, Crystal Report. Support 4000 end users. Design full database and log backup and restore. Automate daily restore of refreshing testing server. Implement SQLLiteSpeed backup and restore in addition to Microsoft native backup and restore for large databases. Automate regular refresh of development and test SQL servers using production backups.Tune application performance due to slow SQL queries via profiler, query execution plan, hints, index, and hardware resources. Automate SQL server maintenance jobs including reindexing, integrity checking, error log checking, table fragmentation checking, block and lock checking, etc.Manage security of SQL logins, roles, and user accounts; Grant/revoke permissions for objects.Install/uninstall SQL servers. Apply service packs and security patches for Slammer virus. Synchronize SQL servers. Moving databases to upgraded SQL servers.Performance monitor of baseline and daily usage of SQL resources including processor, memory, disk I/O, paging, cache, locking and blocking, etc. Automate SQL monitoring via SQLmail, alert, and scheduled jobs. Notifications via Outlook and pager. Distributed queries via linked servers and remote servers to interact with Sybase, SQL, and Active Directory. Transactional replication between primary and report/remote production servers; Customize replication stored procedures; Automate create/drop replications without snapshot. Troubleshoot replication errors.Implement Log shipping on local/remote warm standby servers.Develop stored procedures, triggers and other T-SQL scripts and help developers optimize and trouble shoot codes.Evaluate, spec and build hardware for SQL server machines including DELL PowerEdge 6650, Compaq Proliant 8500, and Compaq Proliant DL380 G2. Exposure to EMC Clariion 4700, 4500 and HP StorageWorks msa1000 SAN.

Support a Power Builder web application to administer student loans and grants.Write T-SQL ad hoc queries for State staff against educational databases.Set up a testing SQL 7.0 environment and restore production databases. Database performance tuning.Assist JAVA consultant to develop, debug and upgrade financial aid (pFAIDS).Data export and import.Generate rosters and letters for schools and students using PowerFAIDS software.Create and trouble shooting ODBC connections for users using TCP/IP.Generate reports using MS Access and Crystal Reports.

Maintain over 200 school databases on tera-byte SQL 7.0 servers. Backup and restore databases. Create and maintain customized standby server.Fulltext catalogs and index performance tuning.Create, modify, maintain and trouble shoot scheduled jobs. DTS packages for data import and export of various formats: SQL, Excel and csv.One-way and two-way transactional replications.T-SQL programming of stored procedures, triggers, etc. Extensive use of cursors.Manage database and transaction log files and auto shrink log files.Work closely with ASP and JAVA developers on Internet business projects. Install, uninstall and upgrade SQL servers and service packs.Install SQL Server 6.5 and 7.0, service packs and upgrade to SQL 7.0. Create and maintain databases, views, stored procedures, and indexes.Backup and restore databases and transaction logs using Backup Exec. Check database consistency and integrity using DBCC statements. Manage logins, roles, user accounts and permissions.SQL Mail with Exchange server to automate alerts for events and scheduled tasks.MS Access 97/2000 tables, queries and linked tables for data on SQL server.

• Manage Windows servers and configure domain trust relationship.• Install SQL Server 6.5 and 7.0, service packs and upgrade to SQL 7.0. • Backup and restore databases and transaction logs using Backup Exec. • Check database consistency and integrity using DBCC statements. • Manage logins, roles, user accounts and permissions.• SQL Mail with Exchange server to automate alerts for events and scheduled tasks.• MS Access 97/2000 tables, queries and linked tables for data on SQL server.