Data Engineer

Hong Guo

Mclean, VA Phone: 240-***-**** E-Mail: adj7ez@r.postjobfree.com

PROFESSIONAL SUMMARY

Focused on enterprise data platforms with years of experience in managing RDBMS(SQL Server,Oracle) and data warehouse from design, implementation, performance tuning to business data analysis and integration

Passionate problem solver supporting business process improvement leveraging latest technical feature and innovative solution, developed detailed project plan following CI/CD DevSecOps pipeline &Agile methodologies

Highly motivated/organized team leader with strong communication skills collaborating with business customers and partner teams, making critical decisions with commitment under deadlines delivering best of services

Successfully migrated SQL databases to cloud with AWS services and Azure tools, including ETL/ELT framework configuration for NoSQL data transformation EXPERTISE

● SQL HA &DR with AlwaysOn Failover/AG clustering (SQL 2012-2019)

● SQL Server security/TDE/auditing

● SQL Server replication/mirroring/partitioning

● SQL Server monitoring/alarming/system maintenance

● SQL Server Power BI/SSRS/SSAS/SSIS development

● SQL Server failover clustering installation/upgrade/migration/patching

● SQL Server performance tuning and optimization

● Web applications with SharePoint/JavaScript/Python/C#/R

● Metadata database design/implementation/enhancement/automation

● Project management with DevSecOps pipeline &Agile methodology

● Collaboration with business/developers fulfilling development/operational tasks

● Operational processes/alarms/maintenance jobs Automation

● Cloud migration/data transformation with AWS, Azure solutions SKILLS

SQLClustering AG/AlwaysOn

T-SQL/PowerShell/Python scripting

XML/Java/C#/.NET/VBScript

ERWin/Toad

Foglight/PRTG/Dynatrace

MySQL/MongoDB/DynamoDB

AWS RDS/DMS

CI/CD DevSecOps

Azure Data Factory

ServiceNow

Jira/Git/Confluence

Workday

CERTIFICATIONS

AWS Certified Cloud Practitioner

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified Systems Engineer (MCSE)

ITIL® Foundation Certificate in IT Service Management 1

Hong Guo

Mclean, VA Phone: 240-***-**** E-Mail: adj7ez@r.postjobfree.com WORK HISTORY

2014 – 01/2021 Senior Database Administrator NRECA -Arlington, VA

● Designed and implemented SQL Server high availability and DR strategy with SQL Server AlwaysOn Availability Group (AG) or Failover Clustering (FCI)

● Led data transformation and archiving project,collaborated with business and IT partner teams facilitate entire UAT activities by preparing documentation (test plan, schedule, participants, scenario and test cases) until achieving sign-off

● Led SQL virtualization task,consolidated DBs to multi-instance virtual cluster environment and saved 30%SQL licensing cost

● Designed/developed a metadata system with automated updates of live data

● Led database/application performance tuning/monitoring effort with Foglight tool

● Implemented database encryption with TDE since SQL2016

● Self-developed/implemented system alarms monitoring cluster failover/disk space/blockings/health check &maintenance jobs

● Influenced management to use an innovated daily-differential backup strategy which reduced huge network traffic and I/O waits

● Migrated SQL database from on-premise to cloud with AWS/Azure tools

● Experienced in cloud database management infrastructure in RDS and EC2

● Configured AWS CloudWatch dashboards/alarms monitoring critical events 1999 – 2014 Lead Database Analyst Marriott International -Bethesda,MD

● Supported 200+SQL DBs in clustering across data centers in different domains

● Guided app teams converting DTS to ETL-SSIS,provided solutions for issues

● Supported Marriott/Ritz Carlton sites with SQL Server replication/log shipping

● Developed/enhanced/tested SQL database DR plan annually at Data Center

● Participated 24x7 open-system DBA on-call rotation,responded for all SQL Server/Netezza/Oracle/UDB related emergency issues 1997 – 1999 SQL DBA/Developer Financial Insight System -Rockville,MD

● Worked as a developer & a DBA with cutting-edge web technology - real time stock analysis online site www.nasdaq-amex-online.com

● Created scheduled jobs/alerts monitoring nightly pricing data load; created stored procedures to reflect real-time stock analytic charts

● Performed leading role in the Y2K testing for nasdaq.com EDUCATION

MS in Computer Science Southeastern University -Washington DC 1997 BA in Education Beijing Languages and Cultures University -China 1989 2

Contact this candidate