Sql Server Oracle
Resume:
CHANG SUN
**** **** ***, ******, ** *****
***********@*****.***
Summary of Skills:
Over 20 years IT experience including Ally Financial, Bank of American & AT&T
Especially over all 10 years of experience as Oracle Database DBA, SQL Server for 5 years
Extensive hands on experience Oracle 10g/11g/12c, SQL server 2008R2/2012/2014/2016 & MongoDB Databases
Experience with Data Quality process, policy, standard and Enterprise Data Governance
Strong critical thinking and data quality analysis technology and skills
Qualifications
• install, migration & upgrade 11gR2 RAC to 12c RAC databases with golden gate & full transportable export/import
• Create/Upgrade/Clone 11gR2/12c RAC instances & AWS
• Performance Tuning & Capacity Monitoring in quarter nodes Exadata
• Supporting OLTP/Compress/reorg and DSS system environments
• Utilities – Data Pump, Full transportable Export/import, Golden Gate 11g/12c
• Tools – Erwin/OEM/TOAD, Grid Control-12c/13c OEM
• SQL performance tuning using AWR/ADDM/ASH/EXPLAIN PLAN/TKPROF
• Install, upgrade & configure SQl Servers in cluster, replications & Azure SQL databases
• Install & configure MongDB replica sets & shards
• Shell scripts in automation for database maintains and notification schedules
Operating Systems: Windows Servers/Redhad Linux/HP Unix
Languages: Sql, Pl/Sql functions & Packages, Shells scripts, Perl/Python/scala, Power shell & NoSQL
Databases: Oracle 11g R2/12c, SQL Server 2008 R2/2012/2014/2016 and MongDB
Tools: Erwin/OEM/TOAD, OBIEE/SQL Developer, Grid Control-12c/13c OEM, AWS
Related Skills: Experienced 10g/11g databases migration/upgrade to 12c & RDS/EC2 in AWS
Knowledge data pump, golden gate replication/refresh tools
Experienced in SQL Server/Exadata/MongDB installations/configurations/administration
Experience
Skillstorm 2015 – Present
Oracle DBA
Upgrade & migrate 11gR2 to 12c by golden gate replication with no downtime.
Migrate & install Oracle 11gR2 & 12c to RDS/EC2 in AWS
Responsible for senior-level production and development of database administration – all platforms.
Built Oracle databases, using BDA tool with (CONT) standby sync with active data guards.
Maintained the Grid Control, Foglight, OS watcher, and other database monitoring tools.
Performed regular database import/export to refresh DEV, QA, and UAT databases.
Setup the Crons jobs to monitor database, perform database backups, clean archive log files, and delete out-of-date backups.
Hands on experience on oracle Exadata setup / upgrade / cell patching
Created dimensional models for fact table mappings using Erwin module tool.
Created material views to fast/complete refresh test, QA, and production databases.
Responsible for performance tuning with applications, using Toad software 12.9 and OEM 12c/13c clouds.
Performed diagnostic evaluation (ADDM, AWR, ASH), and tuning (advisors, SQL tuning, indexing, partitions).
Maintain and test RAC in DR environments for Failover/Switchover features.
Gained proficiency in UNIX/Linux OS in database tuning, design, security, backup, recovery, and HA/DR solutions.
Handled PSU patching installation/upgrade in primary/standby management.
Gained experience with automatic storage environment (ASM).
Designed, installed, and administered/maintained Oracle Real Application Clusters (RAC).
Gained expert-level DBA knowledge of UNIX fundamentals and shell scripting.
Responsible for backup and recovery (RMAN, Cloning, Data Guard, Export/Import), and resource monitoring (CPU, memory, I/O, RAC/ASM).
Performed Oracle patch provisioning and performance tuning of AWR/ASH Reports.
Create MongoDB database, configure replica set & shards, maintain backup & restore activities
Responsible for SQL Server 2016 administration, backups/restore, failover cluster, and Azure SQL database.
Implemented and administered the SQL Server replication, AlwaysOn in Availability Groups,
Managed SQL database cluster, replication, and mirroring.
Developed strong communication skills, both verbal and written.
Tek-System 2014 – 2015
Oracle DBA/Architect
lead as a DBA/Architect for migration of Oracle databases into Exadata machine with setup & configuration
Performed database migration for test case scenarios
Performed and executed HCC in Exadata machine for two nodes RAC.
Create & configure Golden Gate replications for Oracle database & SQL Servers.
Managed user migration, including Citrix Users/oracle users/PC users/No-company users.
Performed batch cycle verifications from source DB to UAT, and stress tests on UAT environments.
Responsible for Prod Parallel set up and dress rehearsal, including Tidal CR/inbound/outbound interfaces implement.
Performed variances/test validations and file comparisons/CFT test run via Tidal.
Responsible for SQL tuning, using AWR/ADDM/ASH/EXPLAIN PLAN/TKPROF.
Implemented and maintained Lawson Financial information system.
Installed and tested upgrade/patches 11gR2/12c container DBs and VMware.
Implemented and maintained Lawson Financial information system.
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.
Created database-related project tasks with duration estimates and resource planning (DDL and DML).
Responsible for Rman backup/recovery, performance tuning, and upgrade planning.
Executed infrastructure projects, ensuring that all DBA and project checkpoints were addressed.
Provided Oracle database expertise on database-only projects, and served as a virtual team member (VTM).
Served as part of the DBA rotation team to provide after-hours support for production environments.
Maintain Sql Server 2012-2014 databases with SSMS & Transact SQL, Support SSIS, SSRS as well.
Geisinger Hospital 2014
Oracle DBA
Installed and tested upgrade/patches 11gR2 DBs and VMware.
Responsible for Oracle database PSU patching in 11gR2 for PSU 2014.
Performed service-level UNIX shell script development for automating.
Create & configure Oracle Databases in RAC and Non-RAC environment.
Performed Rman backup and DEV/QA databases replications.
Performed DB administration, backups, testing, and test case scenarios.
Managed user migration, including Citrix Users/Oracle users/PC users/No-company users.
Install, create and configure MongoDB for replica set & shard environments
Configuring and monitoring MongoDB replica sets, query performance, and identify the proper shard key Selection
Performed SQL tuning, using AWR/ADDM/ASH/EXPLAIN PLAN/TKPROF.
Automated Oracle scripts for passwords change notification and recertification.
Responsible for migration/cloning DB and applications, using data pump in Aix/Linux environments.
Created database-related project tasks with duration estimates and resource planning (DDL & DML).
Operated Oracle Data Guard for standby databases and performance switchover/failover practices.
Used shell script programming on Unix and Linux platforms.
Used Cron Job to run job schedule programming.
Provided Oracle database expertise on database-only projects, and served as a virtual team member (VTM).
Responsible for Oracle security and auditing, and for monitoring high profile/regular users by audit trail.
Administrator for SQL Server 2005/2008R2 by SSMS & Transact SQL, Support SSIS & SSRS.
Dias 2010 – 2013
Oracle DBA Consultant
Installed, configured, and maintained Oracle RAC databases on 11g in UNIX/Exadata environment.
Performed 11G upgrading, cloning, development, and production support.
Supported and maintained Oracle Spatial for installation and configuration, including tuning, and troubleshooting.
Performed Oracle databases character set conversion from US7ASCII to AL32UTF8.
Migrated databases using data pump to import and export schemas compliance.
Responsible for performance SQL tuning, using AWR/ASH/ADDM/SQL profile and Trace10046/TKPRO.
Responsible for performance tuning data warehouse in star schema with BI applications.
Installed and tested databases in Susie Linux VMware with VNC server.
Monitored database security, including adding/removing users, and administering quotas.
Ran Shell scripts on development and production, using TOAD/SQL-developer.
Performed RMAN backup/recovery and clone database in same or remote servers.
Duplicated target database for standby from active database.
Created ASM disk groups and migrated No-ASM File system to ASM system.
Flashback databases from SCN, timestamp and restore points.
SQL Server administrator for 2005/2008R2 databases.
Sutherland Global Service Inc. 2007 – 2009
Oracle DBA Consultant
JFE Inc. 2004 – 2006
Oracle Consultant
Cummins Engine Inc. 2003 – 2004
Oracle DBA Consultant
CBS Inc. 1998 – 2003
IT Developer
Franklin County Government Center 1994 – 1998
Developer / Windows/ UNIX
Education
Master of Business Administration – Information Systems
Wayne State University
Bachelor of Science – Computer Science
Franklin University
Contact this candidate