Sql Server Customer Service

Information Technology Auditor

Passed the Certified Information Systems Auditor (CISA) Exam 2010

Qualifications Profile

Technology-inclined, detail-oriented, and hard working Information

Technology professionals, with sophisticated experience in providing

strategic direction in developing, planning, and implementing initiatives

that drive business optimization and productivity within a highly

competitive organization. Constantly strives for advancement and

professional growth as an IT Auditor to continuously promote acquired

skills and knowledge from education and previous experience. Demonstrated

expertise in problem solving as well as ability to conceptualize and

implement cost-effective procedures that maximized profitability while

minimizing expenses. Flexible and technology savvy who thrives in an

environment of constant challenge, diversity, and high stress. Possess

excellent and unyielding communication skills; able to develop and maintain

rapport with all levels of individuals. Highly regarded as an indispensable

asset for the company with stellar reputation for in-depth technical

expertise and ability to deliver outstanding customer service.

Areas of Expertise:

Database Administrator ? Strategic and Analytical Planning ?

Interdepartmental Coordination

Management and Administration ? Project Lead and Implementation ?

Programming and Testing

Time Management and Prioritization ? Disaster Recovery Plan ? Effective

Problem Solver

Technical Acumen

Databases: SQL Server 2008/2007/2005/7 ? Oracle 10g/9i/8i ? Oracle Fail

Safe ? Oracle 9i DataGuard

Oracle Parallel Server (OPS) ? Multi Threaded Server (MTS) ? MS

Access 6.0/7.0/97/2000

Languages: Oracle SQL ? PL/SQL ? T-SQL ? C ? AWK ? PERL ? NT Shell

Programming

UNIX Shell Programming ? JavaScript ? PowerBuilder ? Visual

Basic 5.0/6.0 ? HTML

Database SQL Navigator ? Spotlight for SQL Server ? QSQL/ISQL ?

Tools: SQL*Loader ? Oracle Enterprise Manager Oracle Discoverer ?

Crystal Reports ? Business Objects ? Designer 6.0/6i ? DBArtisan

? Spotlight for Oracle ? EBU ? Oracle 9i RMAN; LogMiner ? Erwin

? DataStage 5.2 (ETL) ? TOAD ? DTS

EMC Storage

Operation Microsoft Windows NT/2000/2003 ? Windows 95/98/XP ? UNIX

System: (Solaris) ? Linux ? IBM MVS/XA

Career Overview

> Work closely with a team of cross-functional professionals that

specialize in PRISM data architecture; assume responsibility for

streamlining requirements analysis as well as planning, designing,

developing, testing, and implementing data quality management.

> Create innovative strategies for the organization to improve their IT

controls to ensure data privacy, data reliability, system availability,

system performance, and others.

> Collaboratively work with users and colleagues in generating and

executing the infrastructure of the data architecture; identified,

procured, processed, and ensured completeness of the requirements.

> Instrumental for the completion of a disaster recovery plan that

facilitated the immediate repair and restoration of systems in just 30

minutes.

> Directly reported to external and internal auditors; assisted in

generating and executing ISEC to secure Hess business information assets.

> Carefully scrutinized and implemented solutions to various application

performance issues and database bottlenecks along with issues encountered

in Corptax, which resulted to total customer satisfaction.

> Furnished oversight to database management; proactively engaged in the

development and implementation of database capacity planning.

> Performed thorough investigation and system auditing together with the

vendors to distinguish RDBMS error messages. Configured Citrix Farm

replication between the Woodbridge and Houston in conjunction with the

Citrix group.

> Directed and coordinated the upgrading process of various software and

instances to the latest version as well as numerous patch applications.

> Diligently oversaw and audited the DBA connections to secure and prevent

hackers to enter the system; in-charge of developing user and developer

accounts.

> Delegated to enforce the coding stored procedures as well as to configure

and track SQL Server replication and queries; rigorously examined the

locking and blocking of problems within the production environment.

> Upgraded various production SQL servers databases from 6.5 to 7.0; sought

and implemented solutions during the upgrading process.

> Worked hand-in-hand with various developers in devising SQL Server

databases from DEV to QA and to the production, which greatly influenced

the reduction of process time and establishment of a more stable and

reliable migration from code to production.

> Expertly performed several responsibilities to ensure continuous workflow

and attained expected results for various projects, such as providing

assistance to the DBA, generating databases and data modelling, serving

as reinforcement during change management, procuring business

requirements, conducting testing and quality assurance, and preparing

automated scripts.

> Assured delimited quality for product through executing rigorous code

reviews and unit tests, debugging and enforcing enhancements.

> Took part in generating standard operation procedures (SOPs) for the DBA

group and Data Warehouse Architecture Manual. Composed project plan,

testing procedure, user manuals, and internal documentation.

> Carried out basic database-related duties such as backups, exports,

optimization, integrity checks, statistics collection, auditing setup,

truncation of listener, and other large log files. Assured proper

installation of software, instance, and database, such as Oracle and SQL

Server.

> Exemplified technical skills in auditing and managing system to assure

optimize of performance, easy accessibility, and geared to acceptable

standards.

> Analyzed sales and profits from the gathered data from the remote/central

databases.

Employment History

IBM (Amgen) ? Houston, TX

DBA Team Lead Oct 2010-Present

Senior IT Database Specialist / SQL Server Jul 2008-Oct 2010

Administrator

Memorial Hermann Hospital ? Houston, TX

Senior Database Administrator Feb 2008-Jul 2008

Hess Corporation ? Houston, TX

Database Consultant / Application Feb 2005-Feb 2008

Support

Zhang International ? Houston, TX

Consultant 2003-2005

Dell Financial Services ? Austin, TX

SQL Server/Oracle Database Administrator / SQL Server 2000-2003

Database Administration

Oracle Database Administration 2000-2003

Earlier Career

Oracle Database Administrator (DBA) ? Universal Solutions International ?

Clearwater, FL

Oracle Database Administrator (DBA) ? Mo's Computech, Inc. ? Houston, TX

Software Engineer ? CACT Operators Group ? Shenzhen, China

System Engineer ? ChengDu Institute of Computer Application ? Sichuan,

China

Education

Bachelor of Science in Computer Engineering

Xian Jiaotong University ? Shaanxi, China: 1989

Evaluated by World Services, New York

Professional Development

OCP (Oracle Certified Professional)

SQL Server 2008/2005

Oracle 10g/9i New Features and Data Warehouse Database Design

Administrating Windows NT 4.0

Visual Basic / Java / HTML

Contact this candidate