Sql Server Oracle

RESUME

Sophia Li ******@*****.***

Certification

Oracle Certified Professional (OCP DBA)

MySQL Certified Database Administrator

IBM Certified Advanced Database Administrator(DB2 UDB)

*RDBMS

Oracle 11gR2/10g RAC, MySQL, Microsoft SQL Server, Teradata,

DB2UDB, Informix, Turbo Image

*Language/Development Tool

SQL, PL/SQL, UNIX/Linux shell, Perl, C / C++, html, Oracle

Grid Control/DB control, Oracle Developer/2000, Pro*C, SQL

plus, SQL*Loader, RMAN, OEM, AWR/StatsPack, Designer/2000, SQL

Server Management Studio, sqlcmd, osql, isql, db2move, db2look,

dbcc, Microsoft DTS, ErWin, Informatica PowerMart/PowerCenter,

Informix dbaccess, 4gl, ESQL/C, HPL, Teradata bteq, multiload,

FastExport etc.

*OS

Linux RHEL, Sun OS, HP-UX, Unix, NetApp Data ONTAP, MPE/ix,

VAX VMS, Xenix.

PROFESSIONAL EXPERIENCE

(2007-present : Sr. Database Administrator, Yahoo Inc.

Sunnyvale)

Support Yahoo Answers, Groups, Mail, Video, Grid/Hadoop etc.

Databases

Database platforms : Oracle 11gR2/10g, RAC, Dataguard,

Streams, MySQL, MSSQL

1. Manage high traffic production terabyte databases and numerous dev/QA

databases

2. Capacity planning and provide backup/recovery strategy for

databases on different platforms

3. DB installation, configuration, upgrade, logical design & physical

implementation

4. Performance tuning and SQL optimization.

5. Benchmark database performance for new applications

6. Assist with DB schema design and implementation of

productions DB applications.

7. Make recommendations for the implementation of new

technologies.

(2006: Database Architect, Solectron corp. Milpitas)

Database platforms : Oracle 10g/9i RAC, MS SQL server cluster

1.Work closely with Application Support teams on database needs for

corporate data warehouse initiatives. Mentor a team of offshore DBA to

support The Global Data Warehouse.

2.Help defining the complex datamodel, implement database schema for

mission critical applications. Large table partitioning.

3. Provide OLTP Database Administration for WebMethods, Business Objects,

Informatica and other packaged software applications.

4. Establish user access controls and providing database security.

5. Space management, database backup and recovery (Rman)

6. Configure database for failover and high availability (RAC, ASM and Data

Guard)

7. Database Installation, Upgrade and Patches.

8. Performance tuning and SQL optimization (statspack, 10g grid control)

(2001-2005: Sr. Database Administrator, Siebel Systems Inc. San

Mateo)

Database platforms: Oracle 8i/9i RAC, MS SQL server, Teradata,

DB2UDB, MySQL

1.Install, configure and maintain database software, patches,

upgrades and utilities.

2.create, refresh, support databases for dev/QA/prod

environments.

3.Performance tuning and measurement, query optimization.

4.Capacity planning, back-up/recovery, physical design, volume

database re-organization and rebuild.

5.Maintain and support production and development/QA databases

in a 24X7 environment.

6.Database migration across different database

platforms(ORACLE, MSSQL server, Teradata, DB2UDB).

7.Work with Analytics team to implement Data Warehouses and

Data Marts

8.Work with other groups within the company to resolve internal

infrastructure related tasks and issues pertaining to database

configurations, installation, tuning, regular system upgrades

and user training.

9. Document procedures and standards for effective database

software use.

10. Work with off-shore DBA team.

(1999-2000 : Sr. DBA of Data Warehouse team, Providian

Financial, San Francisco )

Database platforms : Oracle, Informix, Teradata

1.Database server and application installation, upgrade,

configuration, tables creation, space management, backup and

restore. Space reclaiming, Data integrity checking, etc.

2.Table partitioning, OLAP Queries monitoring, optimization.

3.Tables access control, permission grant/revoke for database

and tables.

4.Database server activity monitoring, performance tuning.

5.Large volume data batch loading, rebuilt index and tables,

data migration across diff platforms.

6.Plan, recommend, coordinate, and carry out Database schema

design changes with user departments.

7.Transfer data using Informatica PowerCenter ETL across

different databases.

8.Provide support to application teams in creating SQL

statements to access databases, Support the production

implementation of applications including development and

implementation of backup and recovery strategies.

(1996-1998: DBA & Sr. Software Engineer, Hewlett-Packard in

Singapore)

Database platforms : Oracle, Informix

1.Database products installation and config: Set env.

variables, Prepare db configuration file, Allocate disk space,

Prepare connectivity configuration file, Evaluate UNIX kernel

parameters, initialize disk space, etc.

2.Online activities Monitoring, Performance tuning : SQL, share

pool, buffer cache, rollback segment and redo log, Optimal

disk location, indexing, etc.

3. Database Migration from Informix 7.3x to Oracle8

4. Database application support. These systems are multi-tier

applications incorporating client/server technology, span

across multiply platforms(OS: HP-UX, MPE/ix, Window NT/95, DB:

Informix, Turbo Image, Oracle

5.Participate in several BOM, inventory database management

applications development and design. Responsibilities include

ERD design, Database logical design, data storage planning,

Data migration, development work using designer 2000/developer

2000, SQL, PL/SQL, Solid, Pro C etc.

EDUCATION Earned a master's Degree in EE dept., ZJU

Contact this candidate