OBJECTIVE:

A SQL Database Administrator position in a company using mid - sized to large scale database systems to utilize in depth knowledge of production support, systems integration and implementation skills.

SUMMARY:

• Over 30 years’ experience working in database environments using Microsoft SQL Server, Oracle, Sybase and MySQL.
• Logical thinker with superior analytical and reasoning abilities.
• Capable of working independently or in teams to define, build and support databases.
• Able to implement, maintain and support all aspects of database monitoring, set-up, installation and performance tuning.
• Mastery completion and Certification in MS SQL Server MCDBA (SQL 2000), MCTS (SQL 2005), Windows/Server 2003, Linux+ and Oracle 10g OCA plus OCP certification.
• Expert experience with Microsoft SQL Server, Oracle, MySQL and Sybase on both UNIX and Windows.
• Wrote SQL stored procedures, triggers using MS SQL Server, Sybase and Oracle.
• Used Replication to provide reporting data and to safeguard data.
• Monitored DBMS system activity including error logs, backup logs and batch scripts.
• Implemented DBMS, 4GL and Report Writing tools into IT departments that had not used them before.
• Tuned and debugged SQL queries to improve performance and correct logic.
• Setup Reindexing/Reorganization maintenance utilities.
• Setup table archiving and purging.
• Developed database backup/restore plans. Built/maintained separate training and testing environments that also served as offsite hotbackup sites.
• Wrote C++ DLL’s to integrate 4GL front end with Crystal Reports and Sybase OpenClient.
• Experienced with Report Writing using SQR against Sybase, Crystal Reports against Sybase, MS SQL Server and FRX against MS SQL Server and InfoMaker against Oracle.
• Used Report Writing tools to create user production reports, ad-hoc reports, debug software, interface data export and audit accounting information.
• Designed and created logical and physical data models.
• Performed normalizations.
• Used Visio for database modeling.

COMPUTER TECHNOLOGY:

Operating Systems: Windows NT/2000/XP/ 2003/2008/2012 , UNIX (Sun Solaris, AIX), Linux

Languages: SQL(T-SQL,PL/SQL), C++

Databases: MS SQL Server 6.5/7.0/2000/2005/2008/2012 , Sybase, Oracle 8/9/10g, MySQL 5.0, MS Access

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Columbus, OH

Responsibilities:

• Using MS SQL Server 2008/2012, converted data from Oracle, Progress, DB2 and flat files using SSIS and stored procedures.
• Ran queries. Performance tuning.

Database Analyst

Confidential, Columbus, OH

Responsibilities:

• Using MS SQL Server 2005 for a state agency providing a financial investment program assisting parents funding their children’s college expenses.
• Produced Year-End statements and 1099-Q for all participants using SQL and SSIS.
• Improved backups, setup maintenance plans and archive/purge of data.
• Ran queries to provide financial info to customers and support staff.
• SQL 2008 upgrade and release/implementation project.
• Performance tuning for production servers running customer web interface.

Database Administrator

Confidential, Hilliard, OH

Responsibilities:

• Database Administration using MS SQL Server 2005/2008 for an automotive financial services company serving North America.
• Participated in project release maintenance/implementation of their environments.
• Maintained their database backups and maintenance plans, archived/purged data.
• SQL 2008 upgrade/migration project.
• Supported/maintained replication for production servers.

Database Administrator

Confidential, Worthington, OH

Responsibilities:

• Database Administration using MS SQL Server 2005 for a health program provider to insurance companies.
• Specialized in new database setup, backups, maintenance plans, archive/purge of data, queries and using SSIS to maintain consistency of their environments.
• SQL 2008 upgrade project.
• Supported/maintained replication for production servers.

Database Administrator

Confidential, Westerville, OH

Responsibilities:

• All aspects of Database Administration using Oracle, MS SQL Server and MySQL for a workers compensation patient support environment.
• Applications in billing, OLTP and BI reporting.
• Performed production support for all three DBMS’s.

Sr. DBA/Support Manager

Confidential, Columbus, Ohio

Responsibilities:

• Established data exports to populate our Data Warehouse.
• Developed data interfaces between application software using tables, stored procedures and Crystal Reports.
• Responsible for planning and implementing data conversions from legacy systems to vendor developed applications.
• Directed and backed-up two Database Administrators using ORACLE, MS SQL Server and SYBASE in a UNIX and WINDOWS environment.
• Implemented backup/recovery for all DBMS systems using ARGENT as central scheduler.
• Managed upgrades for all DBMS systems to new servers and upgraded DBMS versions.
• Established file/print servers to provide data resources, backups and network printing for all departments.
• Provided on-call support for all DBMS’s.

Database Administrator

Confidential, Columbus, Ohio

Responsibilities:

• Administered, maintained and supported SYBASE, MS SQL Server.
• Served on project team to define, plan and implement in house circulation system.
• Established standards and trained Programmers on the best practices for database design and development.
• Installed and configured all Database Management System (DBMS) software.
• Developed C++ interfaces between 4GL, Crystal Reports and Sybase open client.
• Maintained vendor relations, conducted problem resolution and evaluated software.

Database Administrator

Confidential, Columbus, Ohio

Responsibilities:

• Promoted to first DBA on staff to maintain, develop and support all departmental database systems.
• Defined and modified database definitions and established backup/recovery standards for DMSII DBMS.
• Instructed Developers on DBMS coding techniques and debugging with COBOL.