XIN LI

617-***-****

adgofe@r.postjobfree.com

OBJECTIVE

Seeking a DBA position where I can maximize my profound professional working experience with database design, administration and development, excellent on performance monitoring and tuning, problem-solving and troubleshooting, strong analytical and reasoning ability, critical thinking, self motivated, a team player and a quick learner. SKILLS

Oracle, SQL Server, MySQL, PostgreSQL, Sybase; SQL, T-SQL, PL/SQL; Oracle Multi-tenant, ASM, RAC, Data Guard, AWR, ADDM, ASH, RMAN, Data Pump; MSSQL Mirroring and Profiler; MySQL Replication; Upgrading and Patching; Backup and Disaster Recovery; Perl, Java, PHP, JSON, XML; Unix Shell, PowerShell, JDBC, ODP.NET; Linux, Windows; etc. EXPERIENCE

Oracle/ATG as Principal Member Of Technical Staff (DBA) Dec. 2000 - Boston, MA

● Review application schema designs and changes (DAS/DCS/DSS/etc.); suggest the better approach according to the schema normalization and performance.

● Proactively monitor and tune database systems as well as individual SQL statements and modules to boost overall system performance by using tools like AWR/ADDM/ASH/Profiler/Query plan, analyzing archived redo logs/transaction logs

● Fix bugs for database related issues in our Java-based applications.

● Solve deadlock and concurrency issues that arose during the life cycle by dev teams and customers. The jobs have been done quickly and properly, especially for customers' cases.

● Develop or improve stored procedures and SQL scripts with high efficiency and excellent performance.

● Port our application schema from Oracle to support SQL Server, MySQL, etc. Solve the RDBMS-specific issues during the porting.

● Develop the schema migration kits for each release to help the upgrade for existing customers.

● Technical support to other teams for databases, especially for developers, QA, sustaining, customer service, and load performance team.

● Database administration for our production databases, including Oracle, Oracle RAC, MS SQL Server and MySQL. Install, configure and upgrade; Monitor and tune the performance; Daily backup and disaster recovery; and other general requests like create account/database, grand permissions, alter tablespaces, etc.

● Setup and maintain MySQL replication and MSSQL mirroring for production.

● Atlassian suite Admin – upgrade, migrate, troubleshooting, etc.

● Customize and enhance Bugzilla; Migrate other bug tracking systems to Bugzilla.

● Develop a migration tool for schema comparison and migration (Java/JDBC) CitiStreet as Software Developer

Jul 1999 – Dec 2000 JAX, FL

● Develop T-SQL and stored procs, Perl scripts for data conversion and reporting

● Monitor and tune the performance, especially for SQL statements and stored procedures

● Review and design schema, develop new modules based on customer’s change orders

● Troubleshooting: fix bugs for perl scripts, stored procs, T-SQL and PowerBuilder program

● Technical support for the production system

EDUCATION

Bachelor and Master’s degree, Tsinghua University, Beijing, China

Contact this candidate