SQL DBA

Steve Bale

**** ******** **

Colorado Springs CO 80918

Cell: 719-***-****

SUMMARY OF QUALIFICATIONS:

• RDBMS full life cycle Consultant / Developer / Administrator with Ten + years I.T. experience.

• Previous TSSBI Clearance

• Ten years experience designing and developing databases using MS SQL Server, Oracle, DB2, Sybase and MS Access.

• Excellent communication and instructional skills.

• Full life cycle developer / administrator

STRONG TECHNICAL SKILLS INCLUDE:

• Data analytics, data, database design, DW concepts

• Data security and encryption

• Database replication, mirroring and clustering

• Enterprise data architecture implementation experience

• Replication, Mirroring and ETL tools

• Understanding Service SOA / OO principals

• Ability to model complex ideas

• Agile development experience

Software:

Business Objects

Ceridian 6.14 – 7.0

Some Cold Fusion

Crystal Reports 4- 11.5

DB2 (UDB V 7- 8+)

DB Artisan, Erwin, Rapid SQL

Heat 3.6 – 6.0

MS SQL 6.5

MS SQL 7.0

MS SQL 2000

MS SQL 2005

MS SQL 2008

Oracle 7.3 – 10g

Some Sybase

Some Informix

Touch Works (HER)

Touch Works (PM)

ASP.Net – VB.Net

XML / WAP / WML

SUMMARY OF PROFESSIONAL EXPERIENCE:

Xtivia Inc. (Colorado Springs) (FTE) Aug 07 to Present

Sr. Database Administrator / Developer

• Remotely Administered 30 + Clients totaling in 90+ instances while maintaining 24/7 on demand support with domestic and international clients (stand alone/clustered and all SQL Server versions).

• Developed and administered many hundreds of client SQL scripts, maintenance scripts, maintenance plans, stored procedures, triggers, administrative reports, automation processes, databases and virtual administrative processes using SQL, SSIS, DTS, VBS, .bat, bcp, isql, osql, sqlcmd and various other methods.

• Fine tuned each instance and database to best compliment each client’s unique environment, traffic volume, application and workload.

• In-depth administrative and development knowledge transferred to every level of expertise

• Administered many hundreds of databases some as large as 1.2 terabytes.

• Administered every recovery model in compliment of various recovery strategies and special requirements to include log shipping

• Recovered and developed preventive measures for numerous client databases and in some cases instances whom where victims of SQL injection attacks.

• Developed and automated virtual DBA processing and data collection practices, scripts and processes.

• Detailed development and administration of client backup and restore strategies, automation and testing.

• Implemented and maintained numerous client ‘high availability’ RDBMS to include replication, mirroring and clustering

• Redesigned hundreds of client company database and application infrastructures

• Optimized and administered many hundreds of existing client scripts, procedures, triggers and maintenance plans

• Hundreds of hours dedicated modeling/planning/developing and administering client back end applications (SQL 7.0 - 2008)

Florida Health Care Plans (Daytona Beach) (Contract) Feb 07 to Aug 07

Application / Database Developer

• Application front end design/development (ASP.Net, VB.net)

• Web based application design/development (Classic ASP)

• SQL / TSQL programming (SQL 2005)

• Managing -25 TouchWorks (PM & HER) servers + 2 single node clusters

• ETL Development / Management

• Some Data Mining

• Some Data Warehousing

• Web Services / Applications

• Design and rebuilds of existing and new RDBMSs

• Detailed development of Backup and restore strategies and automation

• Developed ‘high availability’ RDBMS to include replication, mirroring and clustering

• Developed a company wide Document Management System (ASP.Net, SQL 2005)

• Designed a company wise member letter management system (ASP.Net, SQL 2005)

• Rebuilt company database and application infrastructure

• Developed and rewrote internal disaster recovery documentation and processes

All SQL Server database administration and development (SQL / TSQL) are on versions 2000 - 2005. All Oracle database and development is Oracle 9i or 10g

Wells Fargo Home Equity (Colorado Springs) (Contract/FTE) Sept 01 to Feb 07

Application / Database Developer

• Application front end design/development (Visual basic)

• Application front end design/development (ASP)

• Development and design of Business Objects reports

• Web site/Reporting structure Development and Redesign(ASP)

• Application backend design/database development (SQL / TSQL)

• SQL / TSQL, PL/SQL programming (applications / reports)

• Insured referential integrity with trigger development

• Insured data integrity / data accuracy with the use of Dynamic SQL,SQL,TSQL

• Built Multiple relational database management systems (RDBMS)

• Built multiple relational production based databases

• Access database conversions to SQL with TSQL (partial and full rebuilds)

• Crystal reports and Business Objects conversions to SQL (partial and full rebuilds)

• Data manipulation for reporting and some minor data migrations

(Normally less than 50 Million records ea. – SQL Server, DB2)

• SQL restructure/redesign of new and old reports (SQL,TSQL rewrites)

• Full database administration/development and maintenance

• Trigger design/development/trouble shooting

• Multi source reporting (Multiple databases and Servers)

• Ad hoc / 'on the fly' Stored Procedure/trigger build/rebuilds (SQL,TSQL,DB2, PL/SQL)

• Application backend design/database development (SQL,TSQL,DB2, PL/SQL)

• SQL programming SQL, PL/SQL, DB2 (applications / reports)

• Ad hoc Stored Procedure (DB2) build/rebuilds

• Data manipulation for reporting and data migrations (DB2)

(Data Manipulation / data migrations 5 – 200 million records)

All SQL server database administration and development (SQL/TSQL) are on versions 6.5 through 2005.

Rhythms Netconnections Inc. (Denver) (Contract) April 01 to Sept 01

Systems Administrator/DBA and Report Writer

• SQL ,TSQL, ACCESS 2000, VB 6, Interdev 6, COM, IDE, DTC,CSS, DHTML, HTML,ADO, DDL, RDS, Java Script, VB Script

• Designed, implemented numerous databases developing with SQL, TSQL for SQL based test environments (Oracle, SQL Server).

• Created, redesigned 40+ reports in SQL 7.0, Ceridian 6.14, Crystal 6.0, and Crystal 8.0

• Project lead on data migration of data from Ceridian to Oracle 8I

• Planned and designed ‘Proof of Concept’ of migration project using tools from Ceridian 6.14, Oracle 8I, Crystal Reports and SQL 7.0

• Planned and designed Visual Basic report applications using ADO

• Planned and designed web based projects using Visual Interdev 6.0 including HTML, DHTML, ADO JScript, VB Script, with CSS and some COM.

• Designed and developed numerous data migration and reporting tools using SQL,TSQL, Access 2000, Visual Basic 6.0, and Visual Interdev 6.0

• System administration for Ceridian 6.14 included Crystal Report writing, SQL, TSQL, administration, and preparation for a 6.14 to 7.0 Migration.

Vanion Inc. (Colorado Springs) Nov 00 to March 01

Billing Systems Administrator / DBA

• Designed, Implemented, and maintained infrastructure for supporting, maintaining, and reporting for data from current Rodopi billing systems to a centralized database server

• Created, implemented new backup and disaster recovery processes, and procedures for the new infrastructure

• Planned, researched and designed new SQL process. Reports and back up procedures with Vanion IT Department using SQL 7.0 and Crystal Reports 8.0

• Produced, implemented and maintained new relational database structures, supporting three main locations with a customer base spanning the state of Colorado

• Implemented new processes for daily, weekly, monthly and annual customer activity and financial reporting using SQL 7.0 and Crystal Reports 8.0

Goldmine Software Corporation (Colorado Springs) Aug 98 to Nov 2000

Sr. Onsite Consultant:

• Planned, researched and designed new processes, procedures, internal applications within Goldmine’s Professional Services Organization (PSO) department.

• Assisted in the training of 10 Associate Consultants in way of creating and coordinating implementation proposals for myself, and the team for upcoming onsite installations.

• Conducted interviews and assisted in making hiring decisions for the PSO team.

Onsite Consultant (100% travel required):

• Implemented Goldmine HEAT Software at various client sites throughout the US successfully demonstrating a unique mix of custom Database Development and Administration, Project Management, Business Analysis, LAN/PC Support, Systems Administration and Software Training skills for our clients.

• Full-scale integration projects oftentimes required extreme database customizations or conversions in MS SQL Server 6.5 and 7.0, MS Access 97, MS Access 2000, Oracle 7.3, Oracle 8.0, Sybase 6.2, or Sybase 11.

• Successfully completed most implementations in 3-5 days, which required intense effort to gain intimate understanding of client’s goals and the existing processes/technologies on installs for 2 to 2,000 users.

• Successfully designed, built and deployed custom integrated database applications and then trained the existing staff of DBA’s, Systems Admin’s, software developers and end users on how to use our product in their daily tasks.

• Instructed Admin’s and DBA(s) on data manipulation of customer, ticket or asset data.

• Very strong database conversion skills used in converting data from Magic, Eudora, Mcafee, Remedy, and other databases.

• Engineered and designed: recruiting, human resources, accounting, maintenance, and asset tracking databases.

• Customized Heat peripheral applications with Exchange 5.0, 5.5, Lotus Notes 4.6, 5.0, GroupWise 5.5, email, and MS IIS 3.0, 4.0

• Designed custom reports using Crystal 4.0, 5.0, 6.0, or 7.0.

• Heavy interface with VP, and management level clientele requiring high degree of professionalism and consultative post-sales support.

• Completed design and integration of procedures, processes, ensured functionality, and connectivity of workstations, web servers, and external tables.

Systems Engineer:

Assisted in the sales support of Goldmine’s sales department. Assisted customers in installing and evaluating Goldmine’s demo software ‘HEAT’.

Various Contracts (San Fransisco and Colorado Springs) Aug 93 – Feb 98

Knowledge Alliance: Systems administrator

Chevron: Integration Specialist

Adecco Corporate: Project Contractor (Lead)

Kaiser Permanente: Sr. PC LAN Administrator

Pacific Bell: Systems Administrator/Desktop support

Current, Inc: Systems Administrator/Desktop support

Clearance:

Served with 1/75 Ranger Battalion HAAF Georgia

Previous TS/SBI clearance, debriefed in 2005

Contact this candidate