Charles Guo
Associate Database & Data Engineer Lead at Think Capital
Based in Aurora, United States
7-day free trial · no credit card
Seniority
Manager
Department
Information Technology
Location
Aurora
Industry
Investment Banking
Company size
14
Contact information
Reveal Charles's email and phone
Direct contact data is gated. Sign up and reveal. You only pay for verified records.
c•••••••@thinkcapital.in
Phone
5 credits+1 ••• •••• ••••
You only pay for valid records. Bounced emails and disconnected numbers cost nothing.
Background
About Charles Guo
Lead Database Administrator, Sql Developer, Data Engineer and Software Engineer with over 25 years of experience in multiple database systems with enterprise data solution in Trading, Exchange, Finance, and Investment Banking industries. Manage, design and develop complex database systems and database applications using a variety of technologies and database systems including MS SQL SERVER, AWS Aurora, Redshift, AWS RDS, Oracle, MySQL, Azure SQL, Maria DB, Mongo DB, and Postgres etc.Experience with IaaS/PaaS database in cloud environment. Manage complex many major DB systems on both on-Prem and cloud environment. Setup and migrated on-Prem different type of complex databases systems including MS SQL SERVER, Oracle, MySQL, Maria DB, and Postgres etc. into AWS. Expertise in T-SQL and other SQL. Created stored procedures, triggers and functions with complex business logics.Proficiency in Troubleshooting, Optimization, Performance tuning including fine-tuning long run queries, index Analysis, locking and blocking issue etc. for SQL Server, Oracle, MySQL, AWS RDS, Aurora, AWS Redshift databases and related DB applications. Proficiency in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping etc.Configured Reporting Services, Designed, and created complicated SSRS reports.Proficiency in designing ETL for data movement between excel, XML, JSON, flat file, RDBMS like Oracle, DB2 and SQL Server using Bulk Insert, BCP utility, DTS, Python scripts and a variety of SSIS packages including custom transformations based on different requirements. Proficiency in C#.Net.Net CLR assembly, JavaScript and PowerShell development.Good Experiences with Python, sqlalchemy, Pandas dataframe, PowerShell, Linux Bash shell.Certifications: AWS Certified Database - SpecialtyASW Certified Cloud Practitioner Microsoft Certified: Azure Database Administrator AssociateMCSE: Microsoft Certified Solutions Expert Data Management and Analytics MCSA: SQL 2016 Database AdministrationMCSD: Microsoft Certified Solution Developer) For Microsoft.NET
Decision-makers
Other people at Think Capital
Build a list of verified contacts at Think Capital
Free for 7 days · 50 credits · no card · only pay for verified records.
Reach more buyers like Charles
250M+ professionals with verified email and phone. You only pay for records that actually verify.
7-day trial · no credit card · cancel anytime