Resume

Sign in

Engineer Data

Location:
Dallas, Texas, United States
Salary:
open
Posted:
August 27, 2018

Contact this candidate

Resume:

Chang SUN

ac6ttr@r.postjobfree.com Dallas, TX

214-***-****

Summary

Over 20 years IT experience including Financial Banks & Telecommunications

Over 14 years of database experience including Oracle/SQL & NoSQL databases

Years’ Experience in AWS, Azure & Big Data as well

Strong critical thinking, problem solving & analysis skills

Skills

Operating Systems: Linux, Unix/VMare & Cloud

Languages: Sql, Pl/Sql, shell scripts, Java/Python/Scala

Databases: MySQL/PostgreSQL/Redshift/Hbase/MongoDB & Oracle/SQL server

Tools: Ambari/Zeppelin, CloudWatch/CloudTrail, Erwin/OEM/TOAD, Grid Control-12c/13c

Cloud: AWS, Azure & Oracle cloud

Related Skills:

Migrate IaaS/PaaS/DBaaS from premises to Cloud

Experienced 10g/11g databases migration/upgrade to 12c & RDS/Redshift/EC2/S3 in AWS

Knowledge data pump, golden gate replication/refresh tools

Experienced in SQL Server/MySQL/PostgreSQL & Exadata/MongoDB

Experience

AT & T - Dallas, TX Mar 2015 – Present

Cloud Engineer/Architect

Design, implement & maintain AWS for IaaS, PaaS, SaaS and DBaaS

Develop Mobile applications for field workers using iformbuider with Sisense in backend

Using AWS MySql for Sisense built, and present the GUI in dashboard for BI

Using CloudFront to deliver contents for different AZs, and GuardDuty to detect attaches

AWS Cloud Watch combine with WAF & Shield to protect CloudFront and Web applications

Strategy migration IT Center on promises to AWS cloud including EC2, VPC, RDS, and Redshift

Migration Oracle/Sql Servers on Premises to AWS Aurora, Redshift using SCT, MDS and Glue

Hands-on AWS- S3, EC2, VPC, KMS, AMI, Kinesis, Lambda, EMR, Cloud Front & RDS

Practical experience with Big Data like Hadoop/Apache Spark, Pig/Hive/MongoDB/Sqoop

Experience with techniques such as MapReduce Framework, Hadoop, YARN1

Expert level – AWS such as CloudFormation, EC2, EBS, ELB, SNS, SQS, S3 & Glacier

Strong programming skills like Python, SQL/PL SQL, Java/Scala, PIG Latin, HiveQL & HBase

Migrate RDMS, NoSQL or substructure database to Snowflake database in AWS

Performance tuning with applications using OEM/Toad 12c/13c clouds

Diagnostic evaluation (ADDM, AWR, ASH), tuning (advisors, SQL tuning, indexing, partitions)

Maintain & test RAC in DR environments, Disaster Recovery for Failover/Switchover

Expert DBA level knowledge of UNIX fundamentals and shell scripting

Backup and Recovery (RMAN, Cloning, Data Guard, Export/Import)

Install & configure Oracle Data Vault & encryptions on databases

Oracle patch provisioning, performance tuning of AWR/ASH Reports

Golden Gate Replications 11gR2/12c: Active/Passive & Active/Active

Using Hadoop & Spark ecosystem in Yarn for Pig/Hive/HBase to process data

Maintain SQL Server backups/restores, deployments, creation/ automation of backup plans

Configured SQL server for log shipping/cluster/replications/mirroring & Always ON

SQL Server 2016 administration backups/restore, failover/cluster & Azure SQL

Create & configure MongoDB in Premise and extended to AWS Cloud

Architecting data pipeline flow from premise to Cloud data lakes

Good communication with up management and development teams

Tek-System - Southfield, MI Nov 2014 – Feb 2015

Architect/DBA

Lead data Center migration from premise to Exadata machine & Cloud

Architecting dataflow strategies from end to end migration

Migrate data Centre to Cloud initiatives as AWS & Azure

Hands on Compress HCC in Exadata machine for RAC nodes

Supervise & hands on configure Golden Gate replications migration for Oracle & SQL server

Performed batch cycle verifications from source DB to UAT & stress tests on UAT environments

Handled the migration/clone DB and applications, using data pump in Aix/Linux environments

Responsible for Oracle scripts automation for passwords change notification and recertification

Handled the migration/clone DB and applications using data pump in Aix/Linux environments

Successfully implementing migration tasks on time within budget & achieved ROI objectives

Achieved ROI for business owners & shareholders objectives

Dias - Ann Arbor, Michigan Jan 2010 – Oct 2014

Solution Architect

Supervised five staffers of company for Global initiative

Solution architect for sales team promotes migrating applications and services

Educate customers of all sizes on the value proposition, and participate in deep architectural discussions to ensure solutions are designed for successful deployment

Conduct one-to-few and one-to-many training sessions to transfer knowledge to customers

Capture and share best-practice knowledge amongst the solutions architect community

Author or otherwise contribute to customer-facing publications such as whitepapers

Build deep relationships with senior technical individuals within customers to enable them

Act as a technical liaison between customers, service engineering teams and support

Sutherland Global Service Inc - Windsor, Canada May 2004 – Dec 2009

Oracle Consultant/Data Architect

Architect Solution and technical support for company sales team

Design data flow from QA, Test database into production environment

Replicate by stream to transport source databases data to target databases

Using shell script programing on Unix & Linux platforms

Run job schedule programming using Crontab

Proactively monitors PL/SQL performance and make CBO adjustments as necessary

Serve customers inquiry on database for account receivable and payable

Inquiry & testing development, test database before moving to production environments

Run Oracle 9i/10g database with OEM in Linux/window environments

Cummins Engine Inc - Columbus, Indiana Sept 2003 – Apr 2004

Oracle Dba Consultant

Apply multiple components in Oracle8i, 9i, 10g to consolidate distribution databases

Response for specification, design and programming, documentation, and support of software

Systems for business customers

Analyze business requirements, specify and develop new programs, maintain current program,

Support end users; apply new technologies which could be used to meet current and future needs.

Franklin County Government Center - Columbus, Ohio Sept 1994 – Aug 2003

IT Developer/Dba/Unix Admin

Implemented the county real estate tax infrastructure with IT technology

Performed unit testing with documentation.

Design, Model, Re-Engineer databases and develop prototypes to reflect initial requirements

Fine-tuned performance of Oracle Adapter applications through stored procedures

Education

Master of Business Administration – Information Systems

Wayne State University, Detroit, Michigan 2002 - 2004

Bachelor of Science – Computer Science 1990 - 1994

Franklin University, Columbus, Ohio



Contact this candidate