Conner Chen Email & Phone Number

Azure SQL Managed Instance, SQL Server on Azure VM, PostgreSQL Replication, Dell Boomi Integration with Salesforce and NetSuiteDevelop and implement data strategies aligned with the organization's goals, ensuring the design and architecture support business objectives.Design, develop, test, and implement ETL processes for data extraction, transformation, and loading to meet business requirements.Integrate data from various sources, including databases, APIs, files, and other systems, ensuring data consistency and quality.Define and enforce data standards, policies, and procedures to maintain data integrity, security, and quality.Manage the integration of various data sources, ensuring consistency and compatibility across systems.Work closely with stakeholders, including data analysts, ETL developers, and business users, to understand data requirements and design appropriate solutions.Evaluate new technologies, tools, and methodologies related to data management and make recommendations for their implementation.Establish data governance frameworks and ensure compliance with data privacy regulations and industry standards.

San Diego, California, Us

SQL Server 2022 Always On High Availability, migration, configuration, implementation and maintenanceAdvanced database performance tuning, System DMV, Query StoreETL, SSIS, PowerShell, VisualCron

Sandy, Utah, Us

• Design, configure and implement SQL Server 2019 databases, large volume clinical dataresearch and analysis, terabytes databases and billion records tables.• Database capacity planning, backup to Azure storage solutions, security access control.• (TDE)Encryption and PHI data scrambling.• Performance monitoring and tuning, utilizing query store to capture and analysis execution plans,index structure analysis and adjustments to meet advanced application requirements. File groups,partitioning.• ETL data loading, raw flat file, csv, Excel and many other data sources, with bulk insert,openrowset, dynamic sql, SSIS, liked server, cross database platforms• DevOps source control, release management.

Fort Washington, Pennsylvania, Us

• Design, configure and implement SQL Server 2014/2017/2019 AlwaysOn high availability,consolidate 30+ SQL Server instances. Manage Windows Fail over clusters.• Database capacity planning, security access control, disaster recovery.• Performance monitoring and tuning, TFS integration, coding standard and documentation.• Enterprise Data Warehouse SQL Server to Salesforce, AWS and Snowflake integration.• Implement and manage Dell EMC Avamar backup for SQL Server• Migrate SQL Server on Prem to cloud planning (AWS EC2, RDS, Azure VM, Azure SQL...)• Mentoring mid-level DBA and developers for advanced SQL Server management anddeveloping.• Integrate with mission critical mortgage data processing application.• 24x7 production environment on call support, after hour database maintenance and upgrade.

• Design, configure and implement SQL Server 2012 Always On high availability, migrated fromSQL Server 2008 R2 cluster and SQL Server 2005 standalone instances• Data modeling, diagram, ETL, SSRS and SSIS developing.• Integrate Salesforce to SQL Server data processing for medical data management.• Mentoring junior DBA and developer for advanced SQL Server management and developing.• Complex performance analysis and tuning. Database capacity planning, licensing management.Enforce database access security control policy, SDLC in Dev/Test/UAT/Prod environment.• Manage database management and application configuration documentation process.

• Medical claim data warehouse, data modeling, ETL, SSRS. Manage and maintain corporate SQLServers. Backup and disaster recovery planning, performance monitoring and troubleshooting,security access control.• TSQL code in-depth analysis and review, advice to development teams on database designingand high performance delivering, design and implement high availability on large volumedatabase environment.• Interact with Senior Management in the articulation, vision and planning of MS SQL Serversolutions.• Automate monitoring of system performance, identification of throughput bottlenecks; advancedperformance tuning, recommend and implement best practice to ensure optimum systemperformance.

• Manage and maintain corporate SQL Servers (100+ Servers, 1000+ databases). Disaster andbackup recovery planning, performance tuning, security access control.• Database log shipping, mirroring, replication. RedGate backup customization, Double Takedatabase backup design.• Multi/Cross domain Windows authentication configuration (SPN, Kerberos authentication,double hop linked server implementation…).• In-house design Multi-SQL Server management system with Reporting Service, VB.Net andASP.Net, SMO, WMI and Power shell, performance bench mark and other customized serverusage reporting. Customized SQL Server trace data collecting on database engine and Analysis.• Server consolidation and licensing, Service pack and system upgrade testing and installation,• Third party software installation, configuration, support and maintenance

• Manage and maintain company SQL Servers (20+ Servers, 1000+ databases, 200+ TB onlinedata of all major banks finical data processing). Disaster and backup recovery planning,performance tuning, security access control.• Massive volume finance data warehousing, data modeling, ETL, front end dashboard reportingwith SSAS and SharePoint.• Multi/Cross domain Windows authentication configuration (SPN, Kerberos authentication,double hop linked server implementation…). SAN configuration and management.• SSAS star/snowflake schema design, with MOLAP, HOLAP and ROLAP implementation. BCPETL, Partition function design. MDX query developing.• In-house design Multi-SQL Server management system with SSRS, VB.Net and ASP.Net, SMO,WMI and Power shell, performance bench mark and other customized server usage reporting.Customized SQL Server trace data collecting on database engine and Analysis.• Server consolidation and licensing, Service pack and system upgrade testing and installation

• Manage and maintain corporate SQL Servers. System installation and configuration,performance tuning, security access control, system upgrade and service pack testing andinstallation. Server management automation.• TSQL coding review and performance tuning. SSIS developing (Old DTS packages conversionand new SSIS packages developing). Server management utilizing WMI.• Windows Server maintenance, corporate internet and intranet web application support,deployment and developing

• Manage and maintain company SQL Servers. System installation and configuration, performancetuning, security access control, system upgrade and service pack testing and installation.• Analyze business requirement to design data warehouse and create logical and physical databasemodels. Develop and improve complex ETL process from multiple data sources.• SQL Server 2005 Business Intelligence (SSIS, SSRS, and SSAS) implementation, administration,and maintenance. Develop business budget planning and management system with Share PointPortal and SQL Server BI. Advanced OLAP cube design and developing, complex MDXprogramming

• Manage and maintain backend SQL Server, upgrade SQL Server 2000 to SQL Server 2005. Dataexchange/ETL with Sybase, DB2 and mainframe with DTS, SSIS and .Net application.• Develop health insurance enrollment and management web application with VB.Net, ASP.Net,C#.Net, Ajax, ASP, HTML, XML, Web Service• Develop insurance application data transfer and quoting web service with ASP.Net and XML• Manage application source code and documentation with MS Visual Source Safe, IBMClearCase and ClearQuest

Evanston, Illinois, Us

• Manage and maintain school wide about 20 SQL Servers, databases size of 1+ Terabytes.• Design and implement SQL Server 2005 in Windows Server 2003 Cluster with SAN storage.• SQL Server upgrade (7.0 to 2000, 2000 to 2005), service pack testing and installation. Serverconsolidating and Licensing.• Design database maintenance plan, capacity and disaster recovery planning, performance tuning,setup security and database access control standard.• Set up and maintain SQL Server Reporting Service (SSRS), SQL Server Analysis Service(SSAS), and SQL Server Integration Service (SSIS).• Overview SQL developers’ coding, assist advanced database design and performance improving.• Design customized tools for centralized SQL Server management with .NET and DMO.• Coordinate with MS Visual Source Safe (VSS) and Team Foundation Server utilization, setupcoding standards, naming conventions and deployment procedures. Developed in-houseapplication deployment tools integrated with VSS with VB.Net and DMO.• Coordinate with MS Share Point Service (WSS3.0) and System Center Operations Manager (SCOM)2007 SQL Server installation and configuration, management pack installation and customization.• Initiate, design and communicate with senior level personnel internal and external to the unitregarding database administration, junior DBA tutoring.

• Administrate and maintain corporate SQL Server databases, data warehouse. Data modeling usingER/Studio tools. Data conversion from Sybase and Oracle to SQL Server.• Overview, improve and approve SQL developers’ coding. Develop and optimize storedprocedures, triggers, and DTS packages.• Develop ISIS Pro facility management information System with VB.Net and ASP.Net. Prepareand release application upgrade and service pack release package.• Provide operational database support for 3000+ clients including SQL Server design, installationand maintenance, deal with production data quality issues reported by users• Develop and maintain client data transfer web service with ASP.Net and XML. Design corporatedata reporting with SQL Server Reporting Service (SSRS), data analysis with SQL ServerAnalysis Service (SSAS) and OLAP.

• Administrate and maintain Company SQL Servers. Responsibilities include implementing datamodels and database design; database maintenance and performance optimization; databasebacking up, restoring. Set up SQL Server Replication at remote office; SQL Server upgrade (7.0to 2000) and service pack installation and testing. Database access setup and security control;developing DTS packages and setting up scheduled jobs for daily data import and process;developing stored procedures, user defined functions, triggers for database applications.• Design and maintain company’s internet and intranet website with ASP.Net and Crystal Report.• Design in-house ACH system, Merchant Management system, Bank report system using .NET,VB 6.0, Crystal Report, MS Access. Backend databases are Access and SQL Server.• Designed business automation system using VB.Net and Automate.