Vandoline KIAWIH

• Perform daily maintenance and monitoring of company databases for optimum performance.
• Design and Implement backup/restore strategy following company's SLA on ongoing basis
• Implement HADR solutions such as Failover Clustering, Log Shipping and AlwaysOn for business continuity
• Enforce database security using Transparent Data Encryption, Always Encrypted and Dynamic Data Masking.
• Create Pro-Active, self-correcting environment with alerts and notifications.
• Participate in on-call rotation to support after hours issues and planned work
• Reviewing and optimizing virtual machine environment
• Reviewing and optimizing storage

Key Accomplishments:

• Performed side-by-side upgrade of SQL Server from 2016 Enterprise to 2019 Enterprise edition
• Successfully migrated company databases from SQL Server 2016 to newer 2019 servers.
• Successfully implemented backup strategy and jobs based on company's RPO and RTO
• Successfully automated index maintenance jobs thus reducing manual efforts by about 10% per week.

• Performed day-to-day database checks, motoring and tuned for optimum performance.
• Developed and implemented Backup maintenance plan for databases based on SLA.
• Oversaw always-on, traditional failover clustering and log shipping.
• Mitigated downtime by configuring appropriate high availability and disaster recovery solutions.

• Generated prompt response to tickets, resolved user request based-off priority.

• Performed replication and log shipping on SQL 2008 and 2012.

• Completed side-by-side and in-place server upgrades.
• Worked with Active directory creating users and managing permissions to databases following principle of least privilege.

• Oversaw team of 5 communications and media relations professionals with focus on achieving PR results.
• Established marketing strategy for Academy's programs and promotion.