Contract Database Administrator Resume Profile

Experience Summary:

An Advanced Systems Engineer and Database Administrator with over thirty years in data processing. Extensive experience in all phases of the application systems life cycle including requirements definition and analysis, system design, database design, data warehouse and data mart design, data modeling, program development, testing, implementation and performance tuning. Assignments have included team leader, technical lead, and database administrator on various customer projects.

Technical Summary:

DBMS: Microsoft SQL Server 2005 / 2008 / 2012 / 2014, IMS, IDMS, DB2, RDB, Sybase, Oracle
Productivity Tools: IIS, SQL Server 2014 Integration Services, SQL Server 2005 Analysis Services, Litespeed, Telon, Excellerator, PACBASE/PACDesign, Advanced Revelation, BMC IMS and DB2 Toolset
Operating Systems: Windows Server 2008 / 2012 R2, OS/390, OS/MVS, VAX/VMS, UNIX, MS-DOS, MS-NT
Languages: PowerShell, C , C , Visual Basic, COBOL, COBOL II, C, PL/I, Pascal

Work Experience:

Confidential Redmond, WA Managed the production and staging environments for Windows Hardware Logo System and Hardware Crash Reporting Data Warehouse. Responsibilities included database administration, IIS administration, Windows Server administration, and managing the Vender team. Designed and implemented High Availability Clustering for SQL 2012 and File Share servers. Set up proactive monitoring to monitor the performance of the SQL databases and WEB servers. Defined SQL Replication tasks to create an ADHOC Reporting environment and created a SQL Mirrored server for disaster recovery.

Contract Database Administrator

Contract assignment with Microsoft WHOS Windows Hardware Online Services team. Responsibilities include developing a monitoring system for SQL Server 2005 servers, assisting with the migration of applications to the staging and live environments, and troubleshooting SQL performance problems. The monitoring system uses the new DM Views and is a rule-based system. Currently there are rules set up to monitor blocking transactions, processes that use more than 5 CPU seconds, or take longer than 30 seconds to run. D

atabase Administration Group

Lead SQL Server DBA responsible for multiple Microsoft SQL Server and DB2 application databases. Responsible for data modeling, database design, creating and maintaining tables, data replication, DTS packages, and data extract and load jobs. Designed Disaster Recovery Plan as well as proactively monitored production, migration of programs and data. Proposed and implemented changes to improve performance of the database, TSQL statements, and Stored Procedures. Designed the databases for moving US Postal mail on Commercial Airlines CAIR . The CAIR system processes over 500,000 transactions a day with a partitioned database design and total size of over 3 Tera Bytes.

Database Administration Group

Supported multiple IMS, Sybase, Microsoft SQL Server, Oracle, and DB2 applications. Tasks performed included creating and maintaining tables, PSBs, ACBs, DBDs, MFSs and DDLs, as well as monitoring production, migration of programs and data, and performance tuning of the database. Designed databases for truck plant scheduling system, time accounting system, web parts system, and data warehouse for monitoring performance of CAD/CAM workstations.

Database Management Supported multiple IMS and DB2 applications. Tasks performed included creating and maintaining tables, PSBs, ACBs, DBDs, MFSs and DDLs, as well as monitoring production, migration of programs and data, and performance tuning to the database.

Database Support Team Team leader of the Database Support Team. Supported multiple projects on a variety of platforms. Tasks performed included supervising database team, creating and maintaining tables, PSBs, ACBs, DBDs, MFSs and DDLs, as well as monitoring production, migration of programs and data, performance tuning of the database, designing logical data model and physical database design, and evaluating the SQL access paths, establishing standards and database design criteria providing maximum performance. Designed databases for dealer telemarketing system, training management system, and utilities customer billing system.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship