Customer Service Sql Server

Cynthia Jones

Summary

Industries Aerospace, Financial, Insurance, Brokerage, Retail,

Healthcare

Functional Areas Database Administration, Analysis, Production

Support, Operations, Quality Customer Service

SKILLS Sybase ASE 12.x and 15.x, Sybase Replication 12.x,

Sun Solaris, Unix, T-SQL, Progress, SQL Server 2000,

2005 and 2008, fine-tuning and performance,

production support DBA roles and responsibilities

for 10+ years.

Professional Experience

ROYAL BAnk of ScotlanD

03/11 - Present

Financial Services

SYBASE/SQL Server DBA

Provided all aspects of database administration duties to ensure the

health of the database instances on SQL Server 2000/2005 and Sybase ASE

15.0.2.

Responsible to assist with global production support to London, Tokyo

and Singapore. Remedy tickets are submitted that need immediate

attention and closed with remediation.

Responsible to do Sybase and SQL Server installations and configuration.

Production support, problem ticket management, daily production support

duties, and general DBA duties were the daily functions.

Provided excellent customer service.

Environmen Sybase ASE 15.x 64 bit, Unix shell scripts, putty, T-SQL,

t: SQL, Windows XP, Sybase replication software 12, MS SQL

Server 2005, 2008 and 2008 R2, Embarcadero DB Artisan,

Remedy, HP Polyserve, Sun Solaris, Exceed, Remedy.

Cognizant

08/10 - 12/10

DBA Contractor

Operations Manager

Provided DBA administration oversight to a client located in Scottsdale,

AZ.

Provided all aspects of database administration duties to ensure the

health of the database instances on SQL Server 2000/2005 and Sybase ASE

12.x and 15.0.3.

Responsible to assist the healthcare client with audit reporting for

HIPPA and internal auditors; review the current environment

configuration; participate in a major upgrade effort to upgrade ASE

12.5.4 to ASE 15.x.

Responsible to implement Golden Gate replication from Oracle to Sybase.

Planned, organized and executed a production upgrade for Sybase ASE

12.5.4 to ASE 15.0.3

Provided excellent customer service.

Environmen Sybase ASE 12.5 64 bit, Unix shell scripts, putty, T-SQL,

t: SQL, Windows XP, Oracle Golden Gate replication software, MS

SQL Server 2000 and 2005, Embarcadero DB Artisan.

XTivia

01/10 - 08/10

Virtual DBA/Consulting

Database Systems Engineer Consultant

Provided DBA administration oversight to clients located throughout the

USA.

Provided all aspects of database administration duties to ensure the

health of the database instances on SQL Server 2000/2005 and 2008.

Responsible to assist clients with database administration functions to

help in their environment.

Provided excellent customer service.

Environmen MS SQL Server 2000, 2005 and 2008. Sybase ASE 11.0.3 on

t: Windows. VMWare. VPN and Remote Desktop; any other software

that the clients used

Full-time student at University of North Texas Health Sciences Center

08/09 - 12/09

Federal Home Loan Bank of Dallas

08/07 - 06/09

Federal Banking

Senior Database Administrator

Provided all aspects of database administration duties to ensure the

health of the corporate environments which includes installation,

configuration, fine-tuning and performance, security, backup and

recovery, disaster recovery, database standards and procedure

documentation, monitoring and space management. Many other varied tasks

were accomplished as well such as writing and implementing monitoring

scripts in Korn shell on Unix.

Completed a major migration project from Access databases and Excel

spreadsheets to a SQL Server 2005 data repository using SSIS packages

from Microsoft. This was an extreme complex project that was completed

within 3 months and the final repository was 50GB holding 7 years of

historical data.

Environmen Sybase ASE 12.5.x, Progress 10.1B03, MS SQL Server 2005,

t: Embarcadero DB Artisan, Unix Sun Solaris, T-SQL, Sybase

replication 12.5.3 and BMC Control-M Job Scheduler.

IM FLASH TECHNOLOGIES

06/06 - 07/07

Semiconductor Manufacturing

Database Administrator

Participated as a key DBA in the migration project to transfer data from

Sybase ASE to MS SQL Server 2005 using Sybase Direct Connect and

replication. Accomplishments included determining the nuances between

the two platforms, managing large data loads and trouble-shooting

replication issues. This was a large migration project that is ongoing

to move over 500 Sybase databases to MS SQL Server on Windows.

Provided maintenance support for the production, QA and development

environments for all midrange database platforms - Sybase ASE, Oracle,

and MS SQL Server 2000/2005 versions in a global environment.

Responsibilities cover all aspects of day-today fine-tuning and

performance, backup and recovery, trouble-shooting performance issues,

solving customer requests and monitoring the health of the production

databases. Tasks cover space management on Unix and Windows hosts,

monitoring network connections and disk i/o usage.

Environmen Sybase ASE 12.5 64 bit, Unix shell scripts, putty, T-SQL,

t: SQL, Replication Server 12.5, Windows 2003, Oracle 10G and

9i, MS SQL Server 2000 and 2005, Embarcadero DB Artisan and

Change Manager.

LoWE's Companies, INCORPORATED

10/04 - 06/06

Home Improvement Retail

Database Administrator

Participated as a key member of the computer room migration project that

physically relocated the hardware to a new leased facility.

Responsibility included working with IBM consultants to prepare and

execute detailed migration tasks to ensure the safe move of the

corporate data. I participated in weekend and night rotations to perform

a task that brought down and back up the corporate databases and ensured

their health once the hardware was relocated. The tasks covered fine

details of instructions how to bring down the databases and restart them

and then check the validity of the data that everything was intact

again.

Provided all aspects of database administration duties to ensure the

health of the corporate environments.

Environmen Sybase ASE 12.5 64 bit, Sybase Central, Unix shell scripts,

t: IBM AIX, Exceed, T-SQL, SQL, Replication Server 12.5, Windows

2000, Oracle 9I, MS SQL Server 2000, and Remedy Change

Control. Learning to migrate Sybase over to UDB midrange

platforms.

E*Trade Canada

05/03 - 08/04

Online Brokerage

Lead Sybase Database Administrator

Provided all aspects of database administration duties for the

production, QA and development environments

Environmen Sybase ASE 12.5 64 bit, Sybase Central, Unix shell scripts,

t: Solaris, Exceed, T-SQL, SQL, Replication Server 12.0 and

12.5, Windows 2000, Sun SMC monitoring software, Sybase Power

Designer. Remedy Change Control.

Keane, INC. Advanced Development Center (ADC) 01/03 - 05/03

Software Outsourcing Consulting Firm

Senior Consultant

Environmen Sybase ASE 11.9.2, BMC SQL Backtrack 4.4.10, BMC Patrol,

t: Sybase Central, SQL Advantage, Rapid SQL, SQL Expert, Unix

shell scripts, Solaris, Groupwise, Lotus Notes, Citrix,

Exceed, T-SQL, SQL, Windows NT 4.0, Capability Maturity Model

(CMM) Level 3 certified. Keane is currently reaching for

Level 5 CMM certification.

Past Positions Continued

Integrity Life Insurance Company 08/00 -

06/02

Insurance Specializing in Annuities and Retirement Planning

Sybase Database Administrator

Raytheon/EROS Data Center 08/98 - 11/99

NASA placement for Sybase DBA

Sybase Database Administrator

University of Athabasca 09/96 -

02/98

Distance Education University

Systems Analyst/Programmer

Education

Bachelor Masters of Science in

Science in Computer Space Studies

Information Systems University of North

DeVry Institute of Dakota

Technology Grand Forks, ND, USA

Calgary, AB, Canada

Contact this candidate