Bin Weng Email & Phone Number

Create and maintain enterprise conceptual data model. Identify and analyze business domains. Create domain logical and physical data models. Provide strategic direction for building data solutions. Gather and document data requirements, draw data flow diagrams. Ensure alignment of enterprise data architecture with business and technology strategy and roadmap. Define enterprise data model naming convention and database design standard. Create dimensional model for data mart with conformed dimensions. Implement erwin workgroup with er360 web portal to design data model, develop data dictionary, and manage metadata. Evaluate data virtualization product Denodo as virtual data integration for enterprise, participate in architecting and implementing Denodo.

Atlanta, Georgia, United States

Create and maintain logical and physical data model using ERWin. Apply normalization technique to remove dependencies and reduce redundancies. Analyze data elements and group into fact or dimension tables in star schema. Design slowly change dimension type and auditing columns to keep tracking of data changes. Perform Oracle database architectural design, installation, creation, administration, optimization, migration and upgrade. Create physical standby databases and configured active data guard. Perform disaster recovery testing using data guard broker. Ensure new designs integrate with existing database structure effectively. Design and implement materialized views in AWS RDS to replicate data into a cloud analytics database. Create views to aggregate multiple dimensions.

Suwanee, Georgia, United States

Architect database migration strategy and migrate EBS databases to new data center. Redesign database schema to improve application performance. Design data archiving strategy and architecture. Perform data analysis, data cleansing and develop data conversion processes.

Responsible for Oracle database architecture, capacity planning, performance tuning, backup/recovery. Identify top CPU consumers or long running processes. Retrieve associated SQL statements for tuning.

Maintain high availability of databases using Oracle RAC and Data Guard/Standby databases. Install Oracle database 9i/10g software and apply the required patches.

Provide technical direction and leadership to a team of Oracle DBAs and Unix Administrators. Oversee and define technical strategy in the area of system architecture, capacity planning, and database upgrade.