Management Sql Server

Rick McDaniel

Email: ***********@***.***

My primary focus is Database Administration, specializing in Sybase ASE, Replication and MS-SQL Server. My most recent position was for Cambia Health Solutions (Regence Group) supporting multi-terabyte Facets databases. The Sybase and MSSQL databases exceeded 6TB in size and were transaction based, requiring close attention to maintenance and performance tuning. The MSSQL 2012 databases also incorporated transaction and snapshot based replication.

I have spent the bulk of my professional career, working for Chevron Corp. in IT assignments, specializing in programming and DBA responsibilities (production and development DBA experience). I have worked with large and small groups in many cities across the USA in roles from junior DBA to Lead DBA.

Employment Experience

Cambia Health Care 1/2015 - 11/2016

Production DBA

Sybase 15.7 (2K & 8K page servers)

- Production Support for 8TB Facets DB's

- Performance Tuning

- Shell Scripting for ASE Monitoring & Maintenance

- Migration from 2K server to 8K page server

- PowerDesigner for schema migration

Sybase 15.6 Replication Server

- Multiple route environment with extensive performance tuning

- Production Support and latency monitoring

MS-SQL 2012

- Production Support

- Tuning (query plan review & index development)

- Job development related to monitoring (repliction latency, etc)

- Replication Support (Snapshot & Transactional)

DGFastchannel 7/2010 – 10/2014

Lead DBA

MySQL Enterprise HA 5.6 (2 node cluster)

- Generated initial installation

- Tuning Configuration

- Shell Scripting for monitoring

MySQL Replication

Sybase ASE 15.5 Cluster Edition (2 clusters, Primary Production data & DR)

- Primary & DR cluster support

- Tuning & Monitoring

- Query Plan analysis

- Development tuning of SQL & Procedures

- Linux Shell Scripting for maintenance

- Client configuration of ODBC/.Net

Sybase ASE 15.x (2 Prod servers, 2 DR Servers)

Sybase Replication Server 12.5 & 15.6

- Warm standby replication for Clusters

- RepDef replication for Warehouse Reporting

- Shell Scripting for monitoring, recovery & BCP replication

Microsoft SQL Server 2000, 2005, 2008, 2012 (32 Servers, Windows Clusters)

- Maintenance Plans for backups

- Job Creation for Production & Development

- Report Server

- Mirroring used for DR

- Link Servers & ODBC/.Net support

DBArtisan

Sybase Central (ASE & Rep Svr Mgr)

SQL Server Management Studio

dtSearch (document indexing)

SOLR (document indexing)

IBM (Kaiser Permanente) 8/2009 – 7/2010

Sybase ASE DBA (12.5, 15)

Sybase Replication (12.6, 15)

Replication Agent for DB2 (IBM zOS)

SQL Server 2000

OpenClient

OpenServer

DirectConnect for DB2 12.6.1

BMC Patrol

BMC SQLBACKTRACK

Tivoli TSM/TWS

Remedy Support Console

UNIX Shell scripting

PSCI (INGDirect) 1/2009 – 8/2009

Sybase ASE DBA (12.5, 15)

Sybase Replication (12.5, 15)

Sybase IQ 12.7 (Warehouse, Datamart)

Sybase Monitor Server

Sybase Historical Server

DBArtisan

Production support of proprietary banking software

Development support (stored procedures, triggers & SQL)

Shell scripting for cron & batch processing

IBM (Wellpoint Healthcare - FACETS) 7/2007 - 1/2009

Sybase ASE DBA (12.5, 15)

Sybase Replication (12.5, 15)

DBArtisan used to manage & document databases

Installation, Tuning & Support of ASE 12/15 on 50+ servers (AIX, HP)

Support of warm standby Replication 12/15

Production & Development support for major Healthcare systems (FACETS billing, online pharmacy, etc.)

Database conversion from ASE version 12.5x to 15.

Disaster Recovery planning & Testing

Shell scripting to support DBA activities (backups, DBCC health checks, etc.)

ATT Network (Contract Kelly-Mitchell) 2/2007- 7/2007

Sybase ASE DBA 12.5.x

MS SQL2000 Analyst providing SQL reporting

Utilizing DB2 for data warehouse SQL reporting

RapidSQL, MS SQL Server 2000, DTS for data migration & translation

MySQL 4.x for Web based reporting via PERL/CGI for real-time online reporting

Oracle 10G DB development & implementation, stored procedures

ScheduleWizard for automated DB reports and DTS processing (job scheduler)

Supplying SQL queries & ASE tuning, DDL and stored procedures for new projects

Starz Entertainment Group (Contract) 1/2007 – 1/2007

Sybase DBA (12.5, 15) supporting Development & Production

Sybase Replication bidirectional of ASE 12.5 for distributed production

Sybase IQ Datawarehouse used for reports & business analysis

Utilizing DBArtisan, ClearCase & ClearQuest for database documentation

Capital Group (Contract Solugenix) 8/2006 – 12/2006

Application support for back end securities trading application utilizing Sybase ASE, Replication and J2EE (Tomcat & Weblogic)

SQL debugging and tuning related to 30 proprietary applications

Shell scripting for batch processing

John Denning Associates (Part Time Contract Support) 4/2006 – 6/2006

Updated Sybase ASE from 12.0 to 12.5 (review DB’s for reserved words, data types, etc. and recompile all procs, limited tuning)

Corrected bugs and added functionality to JAVA and JSP Logistics Application

Writing & Marketing Software (Independent) 10/2002 – 4/2006

In 2003 I completed a program for capture and analysis of race data with DB integration. I marketed this software independently from 2003 thru 2005 at racetracks across the west. The application was developed in VisualStudio.Net-2003 in C++. The databases for this application were ASE 12.5 and MS SQL Server 2000.

I designed the Sybase DB, constraints and stored procedures, integrating data conversion tools into the data import process. All the initial development was performed using Sybase ASE 12.5x. The ASE DB was designed with Internet access in mind. Stored Procedures are used to prevent invalid data and queries. I have sold the rights to this program and am now available for contract or full time positions.

ViAlta-Inc 3/2000 – 10/2002

Software Team Lead

Supported in house demonstrations of applications and hardware for proposed distribution channels (Costco, Sam’s Club, etc.)

Managed an initial project staff of 2 DBA's, 2 Analysts and 3-4 contract programmer-analysts

Production management of 1 DBA (Oracle & Sybase), 1 Production Analysts (web applications)

Architect for database implementations supporting the web applications and IBM WebSphere

QA manager for all Production applications and hardware

Responsible for hiring, financial reporting, management of systems in Toronto and Fremont

Reporting to VP and board-level senior management

In my previous position as Manager of DBA’s I designed and implemented a bi-directional Sybase

Replication scheme for Oracle 8I servers under Solaris 6-7

We manage proprietary applications written in PHP running under LINUX/Apache

Software in use:

Distributed OpenLDAP/ RADIUS Authentication

Remedy Help Desk

Siebel CRM

Apache Web Server

Oracle 8i

PL/SQL programming of triggers, packages and XML output

Oracle Application Server 9i

Oracle Financial & Logistics (ERP)

Sybase Adaptive Server Enterprise 12.0

Sybase Replication 11.5 (heterogeneous Oracle/Sybase)

Solaris, LINUX (RedHat) scripting

MySQL

Crystal Reports

OptiGold ISP management software

Banc of America Securities LLC, San Francisco, CA. 9/1999 – 3/2000

Production Database Administrator for Sybase 11.0 – 11.92

Production Administration for Sybase Replication 11.0 – 11.x

Supported trading and research data distribution system based on PERL, shell scripts

Supported ADP trade download and DB system specific data alteration

Provided production shell scripting for backups, monitoring, data management

Managed over 30 production databases supporting core business activities

Provided developer support and testing of applications

Member of a four-person team in a 24*7 support environment

Chevron Information Technologies Co., San Ramon, CA. 3/1996-8/1999

Project Manager / Senior DBA

Database programming from C using DB-LIB

Programming in SQL

Database creation and maintenance using Sybase DDL

Database administration for Sybase RDB’s on 30+ OLTP/DSS servers at remote locations.

Database reports programmed in SQR from Scribe Tech.

New application development in Microsoft Visual Studio 6 Enterprise (C++, VB, VJ++) utilizing the MFC library for GUI and OLE implementation

Satellite communications and protocol management via X.25 and TCP/IP.

Software development and maintenance in C, C++, FORTRAN, Command Procedures for Open VMS.

Responsible for configuration, testing and system management of advanced SCADA systems based

on the DEC VAX 3100 with OpenVMS.

Training and remote operations support for business critical systems.

Microsoft Project was used to manage multiple, overlapping development efforts

Chevron Production, Houston, TX. 2/1993-3/1996

Spatial Coordinator - Supervisor

Supervise spatial capture project and 5 full time analysts, 7 contract employees.

Development of SQL based queries for database reporting, verification and maintenance on Oracle RDB’s.

Data management within application specific Oracle DB tables.

Evaluate data sources of land grid, culture and lease information

Testing and approval of new software releases based on a combination of proprietary, third party GIS and AutoCAD developments.

Training of Spatial Analysts in AutoCAD and proprietary applications.

Development and maintenance of AutoLISP applications.

Recommendation of application software and vendor services.

Long term planning for spatial database development and population.

Production of project statistics for management review and strategic planning process.

Chevron Real Estate Management Co., San Francisco, CA. 9/1992-2/1993

Systems Analyst

Development of GIS related billable floor space and taxation applications in C on UNIX workstations and servers, utilizing Sybase version 4.x.

Support of Land assessment project incorporating GIS data capture from Anatech Eagle drum scanner producing 100MB aerial photography images for GIS overlay, stored in BLOB format and indexed in the Sybase SQL Server.

UNIX System management.

Chevron Petroleum Technology Company, Houston, TX 1/1990-9/1992

Programmer Analyst

Development of FORTRAN and C based applications for reporting, maintenance and conversion of CAD databases on UNIX workstations and servers.

Development of MDL applications to enhance Microstation CAD procedures in the mapping and AEC environments.

Application development for conversion of Intergraph Graphic Design file formatted data to Landmark Z-MAP+ format.

Numerous Shell script applications for file transfers, backups, batch processing.

Evaluation and approval of third party applications.

Coordinate application development across operating companies and divisions.

Chairman Corporate Intergraph/Microstation user group.

Evaluate and recommend Intergraph file servers, workstations and peripherals for the local site.

Installation and support of third party plotting solutions.

Chevron USA, New Orleans, LA 1/1979-1/1990

CAD Programmer

Development of FORTRAN applications for VAX 700 series mini-computers in Intergraph configuration.

Support of CAD drafting groups through user training, technical documentation and strategic planning.

Participant in project planning, development and oversight.

Represent company at International CAD user group meetings.

Evaluation of third party applications.

Evaluation of plotting hardware (controllers, electrostatic & pen plotters).

Assist in system management, backup & recovery, hardware maintenance.

Analysis of hardware problems.

Education

Course work in structured computer programming at Tulane University

Course work in statistics at Tulane University

FORTRAN programming for application development at Digital Equipment Corporation

C programming for application development from DEC

UNIX shell programming from DEC

UNIX System management at Intergraph Corporation

MDL programming at University of Houston

Courses in DMRS (Intergraph Database Management & Retrieval System)

Process Improvement, Team Management and related courses

Chevron Project management tools - CPDEP (1 week)

Extended Relational Analysis and Data Modeling (1 week)

Sybase Fast Track to Adaptive Server Enterprise version 11.X

Sybase Advanced Database Administration for ASE version 11.X

Sybase Performance and Tuning for ASE version 11.X

Sybase Fast track to Replication Server Administration 11.5

SUN Solaris 7.0 System Administration I

Sybase System and Database Administration ASE 12.5 (November 2004)

Sybase Interpreting Major ASE tables 12.5 (January 2005)

Sybase Performance and Tuning: ASE Configuration 12.5 (April 2005)

Sybase Troubleshooting ASE Data Structures (February 2005)

Sybase Physical Database Design (February 2005)

Sybase Fast Track to Replication 12.5 (April 2005)

Sybase Replication Server Masters 12.5 (May 2005)

Sybase Fast Track to Java (May 2005)

Sybase Reporting with InfoMaker 9.0 (June 2005)

Sybase EDI Solutions for X.12 Healthcare (ecMap) (July 2005)

Sybase Logical Database Design (August 2005)

Sybase Powering up to ASE 15 (October 2005)

Oracle Database 10G Administration Workshop I (October 2005)

Oracle Database 10G Administration Workshop II (October 2005)

Sybase ASE 15 System & Database Administration (October 2005)

Sybase IQ Data Warehouse (November 2005)

Sybase Performance and Tuning: ASE Query Optimizer 12.5 (November 2005)

Sybase Replication Performance and Tuning 12.6 (November 2005)

Sybase Mastering Transact SQL 12.5 (December 2005)

IBM Websphere App Server Administration 6 (April 2006)

Sun Application Development for J2EE (June 2006)

HIPAA – hipaa003 Privacy & Healthcare Employees (Sept 2009)

HIPAA – hls0102 Healthcare Insurance Portability & Accountability Act (Sept 2009)

Sybase Fast Track to Replication (Sept 2015)

Professional Affiliations:

Member of ISUG (International Sybase User Group)

Member of SANS (System Admin and Net Security)

References are available upon request

Contact this candidate