Sql Server Database Administrator

Allan Sun

*** ****** ***, ********, ** ***** 630-***-**** ️ **********@*******.***

Professional Summary

Certified Oracle Database Administrator with over 25 years of experience in enterprise-level database management. Proven expertise in data modeling, physical design, performance tuning, high availability, disaster recovery, and migration across Oracle, SQL Server, and PostgreSQL platforms. Adept at collaborating across teams, troubleshooting complex systems, and implementing scalable solutions. Known for strong analytical skills, effective communication, and a proactive approach to learning and innovation.

Certifications

Oracle Certified Professional – Oracle 10g

Oracle Certified Professional – Oracle 9i

Oracle Certified Professional – Oracle 8i

Professional Experience

Northwestern University — Senior Application DBA

2007– 2025

Migrated SQL Server 2016 databases to SQL Server 2022, ensuring a smooth transition with minimal downtime. Proactively monitored database health and scheduled key maintenance tasks—including index rebuilds, statistics updates, integrity checks, and backups—to maintain optimal performance and reliability across environments.

Implemented log shipping for disaster recovery, replicating data from the primary database in the Evanston data center to a secondary in Chicago. Prior to production cut-over, conducted comprehensive failover testing to validate that all data changes were successfully applied to the secondary upon activation.

Designed and deployed a dual log shipping architecture from a single primary SQL Server instance. Configured one secondary in NORECOVERY mode for warm standby disaster recovery, and another in STANDBY mode to support read-only reporting. This solution enabled near-real-time data access for business users while preserving production performance and minimizing infrastructure costs.

Served as project manager leading a cross-functional team with members from three departments to implement Always On High Availability for the monitoring management database system that oversees all major application databases and servers at Northwestern University. Successfully delivered the project on schedule, significantly reducing system downtime caused by patches, incidents, and other disruptions.

Led a strategic initiative to migrate legacy Oracle databases to PostgreSQL on AWS, enhancing scalability, reducing licensing costs, and aligning with cloud-first architecture goals. Oversaw planning, data modeling, schema conversion, and performance tuning, collaborating with infrastructure and application teams to ensure a seamless transition with minimal disruption to business operations.

Upgraded PeopleSoft Campus Solution from Oracle 12c to 19c on Linux RAC with ASM.

Transitioned Oracle 10g standalone to 12c RAC on Solaris with Data Guard.

Collaborated with OS, storage, network, and application teams to ensure Oracle best practices.

Supported over 100 Oracle and SQL Server databases.

Optimized performance for online registration, billing jobs, and reporting queries.

Managed RMAN backups (disk/tape), OEM Grid Control, and proactive monitoring scripts.

Conducted AWR analysis, wait event tuning, and SQL optimization.

Chicago Tribune Company — Oracle DBA

2005 – 2007

Implemented Oracle Advanced Security for PCI compliance in a replication environment.

Led Oracle 10g upgrade project and ensured SOX compliance.

Provided 24/7 support for billing applications.

SAIC — Oracle Consultant

2004 – 2005

Delivered capacity planning and performance analysis using STATSPACK.

Identified bottlenecks and resource constraints across shared database environments.

Developed workload generation mechanisms based on production metrics.

Education

DePaul University, Chicago, IL M.S. in Telecommunication Systems

Shanghai University, Shanghai, China M.S. in Physics B.S. in Physics

Northwestern University, Data Science Boot Camp

Citizenship

United States Citizen

Hobbies

Golf enthusiast, Stroke/Turn official for swimming meets in Illinois

Contact this candidate