*

CHUO DAIZY YUNG

SQL Database/AZURE Administrator MTA

Certified/AZ-104 Certified

Shandong, China +861********** adt5rb@r.postjobfree.com

OBJECTIVE

SQL Database Administrator with over 5 years of hands-on experience. Worked in a 24/7 Production and Development environment; providing Support in Database Design, Configuration, Monitoring, Tuning, Migration, Backup & Recovery, Security Administration, High Availability and Disaster Recovery Solutions and Fail over Clustering. Used Service Now for incident management, ticketing, issue tracking and resolution. Great Communication, Analytical and Organizational skills. An accomplished and highly qualified IT professional with diverse and extensive database administration experience. An energetic achiever capable of successfully managing multiple priorities as well as perform and deliver under pressure

AVAILABILITY/

LOCATION

TECHNICAL

SKILLS

Phone Interview: 24 – 48-hour notice

In Person Interview: 24 – 48-hour notice

To Start: As soon as needed

Location: Ready to relocate if necessary

Installation, Configuration and Setting up of MS SQL Server 2008 to 2019 following best practices

Performance Tuning & Monitoring

SQL Standalone and cluster environments setup and installation

Backup & Recovery

Database virtualization - installation, configuration and management of VMs

Experience in Client Facing to meet and plan on application installations and implementations

Meet and discuss with Clients on software compatibility with available hardware

Test and install Client applications on environment successfully and help business decision making and cost forecasting.

Worked closely with development and engineering teams during product releases and responsible for end to end database change management process, automated database deployments

Upgrades, Patching & Migration

Implementing and maintaining new databases, backup/recovery and configuration management.

Experience with DB encryption, and SQL/PowerShell scripting

Expertise in Always-On Availability Groups (AAG), Log Shipping and Replication

Failed job analysis and prevention

Use of Service Now for incident management, ticketing and issue tracking and resolution

Experience with SQL in Virtual and Cloud environments.

Good working knowledge on Incident management and Change management CDY

2

process

Documentation of all my processes in a step by step manner to keep up with a good knowledge sharing policy within the team and the entire company and future issue tracking remedies

Performance tuning and Capacity planning

Proficient in Database Security using TDE, Always Encrypted, Dynamic Data masking

Management of Users and Logins in Active Directory

Migration of SQL server databases from on premise to Azure (Cloud)

Manage AZURE SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems

Develop data solutions that utilize cloud-based technologies and platforms

(PaaS etc.

Understanding of performance tuning concepts on the cloud

Hands on experience on SSRS, SSIS, SSAS

Fluency in at least one scripting language, shell scripting, and experience with object-oriented programming languages.

WORK

HISTORY SQL DATABASE ADMINISTRATOR 01/2021 - Present Dezhou Import and Export

Performed SQL server installation following best practices.

Migrating and Upgrading SQL Server 2012 to SQL Server 2019.

Configured High Availability and disaster recovery Solution- Always on Cluster environment, and Traditional Failover Clustering.

Working with development and systems teams to perform application and database upgrades and tuning.

Worked with Sentry one, and Solar Winds Monitoring Tools

Provided Support on Performance Issues during Project Development, resulting in improved response times and reduced contention.

Provided On-call support in a 24/7 environment.

Upgrading SQL Server by reviewing, planning, testing and installing database security patches and service packs.

Deployed Database Security Policy and Installation, using Passwords, Privileges and User Profiles. Used Transparent Data Encryption to Encrypt Columns, Tables and Tables paces.

Specified user access levels for each Database segment to protect Database integrity and company information.

Performance Tuning for optimized results using tools like Sentry one and SolarWinds Monitoring Tools.

Documented processes for installations, clustering, availability group setup, and patching

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Rebuilt indexes at regular intervals per Microsoft recommendations for better performance

Used Activity Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

2

Mentored newly hired employees, offering insight into job duties and company policies for easier transition job position.

SQL DATABASE ADMINISTRATOR 04/2017 - 04/2021

SHANDONG WINSON MACHINARY

Performance Monitoring and Performance Tuning.

Maintained database response times in 24/7 Production environments

On-call support

Planning and implementation of Database backup/restore and disaster recovery

Managed Database Security by creating, assigning appropriate roles and privileges to Users based on User activity, auditing and performing important security tasks as Transparent Data Encryption and creation of contained Database

Automation of DBA Tasks and monitoring

Experience with DB encryption and SQL/PowerShell script

Documented all my processes in a step-by-step manner to keep up with a good knowledge sharing policy within the team and the entire company

SSIS

SQL DATABASE ADMINISTRATOR 02/2015 - 03/2017

EXPRESS UNION

Installed and configured SQL Server 2014 & 2016

Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space

Managed the migration of SQL Server 2012 databases to SQL Server 2016

Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Used Activity monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Used Always On HA technology synchronization of database

Reviewed and optimized Vms

Updated statistics, database integrity check and backup operations

Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space

Responsible for Stored Procedures optimization, Performance tuning & index maintenance

Responsible to monitor and troubleshooting Log shipping

Managed Database Security by creating, assigning appropriate roles and privileges to Users based on User activity, auditing and performing important security tasks as Transparent Data Encryption and creation of contained Database

Performed Migrations, patching and upgrades

2

Education

PURSUEING

300+ Advanced Database Administration Training at KiawitechIT Academy - Texas BSc in Accounting in National Polytechnic Cameroon Associate Degree in Computer Science - University of the People 2021

.

Contact this candidate