Rina Wei

• Led the migration of 200+ SQL Server and Oracle databases to AWS PostgreSQL and Aurora PostgreSQL using AWS Database Migration Service and ora2pg, enhancing cloud integration.
• Led 2000+ AWS PostgreSQL/Aurora PostgreSQL upgrades using Terraform and AWS CLI across 150+ AWS accounts, ensuring consistent and reliable database performance.
• Administer enterprise database platforms across on-premises and AWS environments, with primary responsibility for on-prem PostgreSQL and AWS PostgreSQL/Aurora PostgreSQL.
• Provision and manage AWS PostgreSQL and Aurora PostgreSQL databases using Terraform and CDK.
• Deploy highly available AWS database environments using multi-AZ and multi-region architectures.
• Install, configure, upgrade (in-place upgrade vs migrate), and support EDB Postgres and community PostgreSQL databases on RHEL Linux.
• Configure AWS RDS Proxy to support database connectivity and application workloads.
• Performed AWS PostgreSQL/Aurora PostgreSQL database restores across AWS accounts for recovery and migration requirements.
• Configure TLS connections for AWS PostgreSQL/ Aurora PostgreSQL and on-premises PostgreSQL environments.
• Use AWS Schema Conversion Tool (SCT) and AWS DMS for heterogeneous database migrations.
• Install and configure Barman backup infrastructure for on-premises EDB Postgres databases.
• Configure PostgreSQL Foreign Data Wrappers (FDW) for cross-database access and integration.
• Install and configure EDB Postgres Enterprise Manager (PEM) servers and agents for database monitoring and notification configuration.
• Perform PostgreSQL performance monitoring and tuning, complex SQL query tuning, connection and memory tuning, and troubleshooting blocking sessions/deadlocks.
• Troubleshoot database issues, provide guidance and screen share training sessions to the DBA team.
• Automate database provisioning and management processes using infrastructure-as-code technologies.
• Use Terraform and AWS CLI to support repeatable database deployment and upgrade processes.

• PostgreSQL and SQL Server database administration
• Administered PostgreSQL, Microsoft SQL Server, and CDC DataMirror environment supporting mission-critical enterprise applications.
• Planned, installed, configured, and implemented SQL Server 2014 failover clusters to ensure high availability.
• Configured and managed SQL Server 2016 databases hosted on Microsoft Azure.
• Led database and data center migration initiatives to enhance operational continuity.
• Designed and supported high-availability database environments.
• Executed backup and recovery processes for EDB PostgreSQL using BART tools.
• Performed complex SQL query tuning and database performance tuning.
• Installed, configured, migrated and upgraded PostgreSQL databases.
• Conducted database and data warehouse modeling.
• Planned and executed database and data warehouse disaster recovery testing.
• Developed and maintained disaster recovery procedures and technical documentation to mitigate data loss risks.

• Established database security protocols, conducted backups and recovery processes, and optimized performance tuning.
• Maintained SQL Server databases, ensuring high availability and reliability for critical applications.
• Oversaw all Choate database servers, IIS and applications servers.
• Planned, refreshed and upgraded Microsoft SQL database and application servers.
• Created technical documentation and facilitated user group training to enhance user understanding and system utilization.

• SQL Server database administration
• Administered and maintained enterprise Microsoft SQL Server environments and refreshed database servers to meet business requirements.
• Supported SQL Server high availability.
• Performed Windows Server and SQL Server performance monitoring and tuning.
• Configured maintenance jobs and alerts to ensure proactive database health monitoring.
• Implemented SQL Server database encryption, backup/recovery, and replication.
• Ensured optimal functioning of data warehouse operations.
• Collaborated with ETL developers on database design and operational requirements to streamline data integration processes.
• Performed database space design, ETL/load design, and capacity planning.
• Monitored temporary tablespace usage for data warehouse workloads.
• Configured restricted database modes for controlled data-loading operations.
• Developed technical documentation and conducted user training to enhance user understanding and database utilization.
• Oracle database administration
• Administered Oracle database instances and monitored database capacity and space utilization.
• Supported Oracle database design, modeling, and implementation.
• Installed, upgraded, configured, and patched Oracle 10g and 11g environments.
• Managed Oracle users and implemented database auditing and password policies in accordance with corporate IT requirements.
• Developed UNIX shell scripts and scheduled automated jobs using crontab.
• Supported Solumina ERP failover cluster environments.
• Participated in monthly maintenance windows and weekly production change-control processes.
• Developed Oracle administration documentation.
• Delivered continuous on-call production support.

School of Information Studies