Sql Server DBA
Resume:
Charles R. Denson
Rowlett, TX 75089
Home: 972-***-****
Cell: 214-***-****
Email: **********@***.***
TECHNICAL SKILLS:
Windows NT4, 95, 98, 2000, 2003, 2008, Vista, XP, UNIX, SQL Server 6.0,
6.5, 7.0, 2000, 2005, 2008, 2012, 2014, IIS 5.0, 6.0, 7.0, Microsoft
SharePoint 2003, Visual Studio, .Net Framework, ETL DTS, SSIS, SSAS, SQL,
T-SQL, PL/SQL, Oracle 8i, 9i, 10g, 11i, Sybase Adaptive Server 9 Anywhere
(ASA), DB2 UDB on Windows and UNIX, Access 97, 2000, 2002, 2003, 2007, MS
Exchange 5.5, 2000, Crystal Reports XI, SQL Reporting Services, Microsoft
Project, Excel, Word, Outlook, Lotus Notes, ODBC, Microsoft, Veritas and
Legato Clustering, Log Shipping, Replication, SANs, HP NAS, Symantec Norton
AntiVirus, Erwin, Visio, Remedy, Resolve, LiteSpeed, Data Warehousing,
Disaster Recovery
EDUCATION:
Amber University
Bachelor's Degree, Management Technology (MIS)
Eastfield College
Associate's Degree, Engineering Technology
CERTIFICATIONS/TRAINING:
Systems Administration Training, Web Administration Training, USAF
Information Assurance Training, Transferring and Transforming Data in SQL
Server 2000, Security in a Microsoft SQL Server 2000 Environment, Managing
SQL Server 2000 Databases, Installing, Configuring, and Upgrading SQL
Server 2000, Introducing Oracle 9i Database Administration, Networking
Overview for 9i Administrators, AD 2008, SQL Server 2008
Dallas County - Dallas, Texas
8/2009 - 1/2015
Senior Database Administrator
Responsible for design, implementation and optimization of databases to
support Dallas County inmate population Adult Information System (AIS),
Records Management System (RMS) and Laboratory information Management
System (LIMS). Required to support data manipulation, data generation, and
data cleanup requirements that are reported through the Dallas County
ticketing system (Clickright). This requires heavy interaction with other
departments as well as developing and troubleshooting TSQL code (i.e.
stored procedures) to correct the issue. Required to manage the release
process for all database environments using SQL Server 2000, 2005, 2008,
2012, 2014 and Sybase Adaptive Server Anywhere 10. Required to set policy
on coding standards for TSQL database scripts. Responsible for reviewing,
approving and running all developers scripts in production. Required to
manage the evolution of database environments throughout the software
development life cycle. Design, security, implementation and organization
of databases (i.e. daily job monitoring, verifying daily backups) in both
stage and prod environments to ensure successful completion, and resolving
issues if a job does not complete successfully). Required to document all
procedures and processes using MS Word and MS Excel spreadsheets. Required
to provide Level 1, 2 and 3 production support in 24/7 x 365 environments.
Broadlane - Dallas, Texas
8/2008 - 2/2009
SQL Server Database Manager
Responsible for design, implementation and optimization of databases to
support healthcare management software. Required to support data
manipulation, data generation, and data cleanup requirements that were
reported through BL's ticketing system (Resolve). This required heavy
interaction with other departments as well as developing and
troubleshooting TSQL code (i.e. stored procedures) to correct the issue.
Ability to create, track and manage customer issues utilizing the Resolve
ticketing system. Required to manage the release process for all database
environments using SQL Server 2000, 2005 and 2008. Required to set policy
on coding standards for TSQL database scripts. Responsible for reviewing,
approving and running all developers scripts after Change Board approval.
Required to manage the evolution of database environments throughout the
software development life cycle. Design, security, implementation and
organization of databases (i.e. daily job monitoring, verifying daily
LiteSpeed backups) in both stage and prod environments to ensure successful
completion, and resolving issues if a job did not complete successfully).
Required to document all procedures and processes using MS Word and MS
Excel spreadsheets. Provided Level 1, 2 and 3 production support in a 24/7
x 365 environments.
Pomeroy IT Solutions - Austin, Texas
4/2007 - 4/2008 (IBM contract position)
SQL Server Database Consultant
Responsible for managing six database servers to include maintenance,
administration of database integrity, synchronization, security,
implementing database changes and data loads, performance tuning and
optimization, Remedy tickets, verifying daily backups of SQL Server 2000
and 2005 databases and transaction logs. Ability to create, track, manage
and resolve customer issues utilizing the Remedy ticketing system.
Consulting in a development, test and production environment that includes
Windows 2000 and 2003 O/S, MS SQL Server 2000 and 2005 servers. Excellent
knowledge of Windows 2000, 2003, ODBC, DTS, SSIS, T-SQL and Microsoft
Office Professional. Strong skills troubleshooting server applications in
production, test and development environments. Strong knowledge in
planning, installing, configuring, managing, disaster recovery and
troubleshooting MS Windows 2000 and 2003, SQL Server 2000 and 2005, Visual
Studio, data warehousing, IIS 6.0, .NetFramework, ASP.Net and SQL Server
Reporting Services. Heavy experience working with senior level management;
such as keeping them informed on technical issues, software development,
implementation, deployment and database management. Provided Level 1, 2 and
3 production support in a 24/7 x 365 environment.
Isigma
Tucker, GA
Veracruz, Mexico
9/2006 - 12/2006 (Contract position)
SQL Server Database Consultant
Responsible for managing ten database servers to include design,
maintenance, administration of database integrity, synchronization,
security, implementing database changes, performance tuning and
optimization, verifying daily backups of SQL Server 2000 databases and
transaction logs, snapshot and merge replication. Consulting in a
development, test and production environment that includes an Electronic
Online Billing application for utility companies, Windows 2000 O/S and MS
SQL Server 2000, DTS. Required to document all procedures and processes
using MS Word and MS Excel spreadsheets. Excellent customer interfacing
skills with technical and non-technical clients.
Robert Half Technology- Dallas, Texas
3/2006 - 8/2006 (Contract position)
SQL Server Database Consultant
Responsible for managing eight database servers to include maintenance,
administration of database integrity, synchronization, security,
implementing database changes and data loads, performance tuning and
optimization, verifying daily backups of SQL Server 7.0 and 2000 databases
and transaction logs, snapshot and merge replication. Consulting in a
development and production environment that includes Windows 2003 O/S, MS
SQL Server 7.0 and 2000 servers. Excellent knowledge of Windows 2003,
ODBC, EMC Clarion SAN, HP NAS, DTS, SSIS, T-SQL and Microsoft Office
Professional. Strong skills troubleshooting server applications in
production, test and development environments. Strong knowledge in
planning, installing, configuring, managing, disaster recovery and
troubleshooting MS Windows 2003, SQL Server 2000 and 2005, data
warehousing, IIS 6.0 and SQL Reporting Services. Provided Level 1, 2 and 3
production support in a 24/7 x 365 environments.
DynCorp International - Chantilly, Virginia
10/2005 - 1/2006 (Contract position)
Database Manager/SQL Server Database Consultant
Responsible for managing thirty-nine database servers to include design,
maintenance, administration of database integrity, synchronization,
security, implementing database changes and data loads, performance tuning
and optimization, verifying daily backups of SQL Server 2000 databases and
transaction logs, snapshot and merge replication. Consulting in a
development, test and production environment that includes a GE Secure
Perfect COTS application, Windows 2003 O/S, MS SQL Server 2000 and EMC
Legato Cluster servers. Excellent knowledge of Windows 2003, ODBC, T-SQL
and Microsoft Office Professional. Strong skills troubleshooting server
applications in production, test and development environments. Strong
knowledge in planning, installing, configuring, managing and
troubleshooting MS Windows 2003, SQL Server 2000 and 2005, IIS 6.0, DTS,
SSIS, Crystal Reports XI, SQL Reporting Services, Legato Clustered Servers
and Active Directory. Managed 10 foreign national employees on all SQL
Server technical related issues.
Lockheed Martin - San Antonio, Texas
(Randolph Air Force Base)
12/2000 - 6/2005
Database Consultant/Senior SQL Server DBA
Responsible for managing thirty-eight database servers to include
maintenance, administration of database integrity, synchronization,
security, implementing database changes and data loads, data conversions
(DTS), performance tuning and optimization, capacity planning, verifying
daily backups of SQL Server 7.0/2000 databases and transaction logs.
Consulting in AFPC development and production environment that included
both Windows and HP-UX O/S, MS SQL Server 7.0/2000/2005 (Stand
Alone/Clustered), Analysis Services, OLAP, Oracle and Sybase 11 RDBMS.
Excellent working knowledge of Windows NT 4.0/2000/2003, PVCS, Active
Directory (AD), Toad, IIS 5.0/6.0, Microsoft SharePoint 2003, Apache, ODBC,
MS Access, HTML, MS FrontPage, UML, Visio, TSQL, SQL, PL/SQL, Oracle
8i/9I/10g. Basic knowledge and skills developing applications in the Visual
Studio .NET environment. Strong skills troubleshooting desktop and server
applications in production, test and development environments. Strong
knowledge in planning, installing, configuring, managing, disaster recovery
and troubleshooting MS Windows 2000/2003. Provided Level 1, 2 and 3
production support in a 24/7 x 365 environments. Ability to create, track,
manage and resolve customer issues utilizing the Remedy ticketing system.
AIM Technologies - Austin, Texas
2/2000 - 9/2000
Senior SQL Server DBA
Responsible for managing (fifty-two sites), maintenance and administration
of database integrity, synchronization, security, implementing database
changes and data loads, performance tuning and optimization, verifying
daily backups and NT 4.0 backup administration, continual maintenance of
server hardware, maintaining active transactional replication of databases.
Excellent working knowledge of Windows NT 4.0, IIS 4.0, UNIX (AIX), Lotus
Notes, MS SQL 6.5 and 7.0, DB2 UDB V7.1, SQL, TSQL, DTS, ODBC, ArchserveIT,
and Tivoli. General knowledge of MS SQL stored procedures, triggers and
general systems utilities such as BCP, tablespacing and indexing. Provided
Level 1, 2 and 3 production support in a 24/7 x 365 environments.
Lifecare Technologies - VA Hospital, Dallas, Texas
6/1999 - 12/1999
Systems Administrator/SQL Server DBA
Responsible for managing, maintenance and administration of database
integrity, synchronization, implementing database changes and data loads,
security, verifying daily backups and NT 4.0 backup administration,
continual maintenance of server hardware, maintaining active transactional
replication of databases Data/Application Server to Fail Over Server.
Working knowledge of Windows NT 4.0, MS SQL 6.5 and 7.0, DTS, ODBC,
ArchserveIT, PC Anywhere, Double-Take, Teleform and Crystal Reports 7.
Excellent working knowledge of Dell and Compaq servers and workstations.
Knowledge of HIPPA compliance standards and Healthcare facility
requirements. Provided Level 1, 2 and 3 production support in a 24/7 x 365
environments.
Cooper Institute - Dallas, Texas
4/1998 - 6/1999
Senior Systems Administrator/Database Administrator
Member of MIS team in conversion of Windows 95/NT 3.51 peer-to-peer network
to Windows NT 4.0 client/ server environment. Responsibilities include
hardware and software setup, upgrades, installation, configuration,
connectivity, troubleshooting, and product pricing for institute computer
purchases. Provide Help Desk assistance to PC and Macintosh clients;
maintain functional status of Cabletron Hubs and ISDN Router, Internet
connection, Email Server and HP network printers. Coordinate Backup efforts
and Disaster Recovery Plan with MIS staff. Knowledge of MS Office Suite,
Visual Basic 5.0, Crystal Reports, SQL 6.5, UNIX (AIX), IIS 4.0, HP
OpenView, Back Office, Sybase 5.0 on Windows and Oracle 7/8. Responsible
for managing MS SQL and Oracle RDBMS.
BDM International, Inc - Riyadh, Saudi Arabia
11/1995 - 11/1997
Computer Systems Analyst/AutoCAD Specialist
Computer Systems Analyst/AutoCAD Specialist on the elite F-15, Peace Sun
Program. Consultant/Advisor to Royal Saudi Air Force, Project Section on
the development of an engineering LAN/WAN. Performed a total analysis on
all equipment required, to include cost, of hardware, software and
installation. Reduced original proposal cost by 30% within a month.
Responsible for the installation, security, maintenance, configuration and
troubleshooting of hardware and software on Project Section PCs, printers
and plotters. Experienced with Novell InternetWare 3.x and 4.x, IBM OS/2
LAN Server, UNIX Solaris 2.x, Windows 3.x, Windows 95, Windows NT4.0
(server and workstation), TCP/IP, DNS, DHCP, RAS, SNA/SDLC, SNMP, ISDN and
AutoCAD 12, 13 and 14. Worked with systems engineers on the design,
installation, configuration and management of MS SQL Server 6.0 database
project.
Contact this candidate