Summary

• Database Administration for the following Database Management Systems:
• SQL Server 2012, 2008 R2, 2005, 2000 and 7.0
• DB2 UDB for AIX and Windows, version 9.1
• DB2 UDB for OS/390, version 7.1
• Typically responsible for:
• SQL analysis and tuning on a various platforms with a variety of tools
• Database utilities on all supported databases
• Performance monitoring on a variety of platforms
• Disaster Recovery planning and drills
• Monitoring of database related batch processing
• Provide support for replication, mirroring and log shipping
• Provide input when choosing between high availability alternatives
• Experiences using the following database tools:
• RedGate SQL Backup, SQL and Data Compare, SQL Log Analyzer
• Idera Diagnostic Manger and SQL Safe
• SQL Sentry Plan Explorer
• Microsoft's Team Foundation Server, Visual SourceSafe, Clear Case
• IBM's TSM TDP for Microsoft SQL Server
• BMC's DASD, Catalog Change Managers, Activity Monitor
• Platinum tools, RC/Query, RC/ Migrator, and Detector for DB2

Areas of proficiency

Index tuning, backup and recovery plans, application development support, database tool selection and implementation, version upgrades, installing new instances of SQL server, disaster recovery planning and drills

Experience

Database Administrator III

Confidential

• Provide production support for seven 2 node clusters that support approximately 1500 databases and 550 transactional replications
• Monitor with Idera's Diagnostic Manager t provide insight int blocking and deadlocks as well as overall server. My goal for the coming year is t fine tune the alerts and make them more meaningful.
• Query tuning with native SQL Server tools as well as SQL Sentry's Plan Explorer.
• Support application development via code promotion, SQL tuning, and general support for development environments.
• Developed disk space forecasting application using SQL Agents jobs and SSRS t make disk space allocations more proactively.
• Currently working on database backup verification process.

Senior Database System Administrator

Confidential

• SQL Server
• The hospital's first SQL Server DBA despite the fact that they have approximately 125 SQL Servers
• Short term goal t verify the recoverability, document version and fix pack level of each new SQL server I discover
• Longer term, plan t identify the servers, categorize the sensitivity of the data stored there, document the configuration and then develop a plan t rein in the sprawl while still providing excellent performance
• Worked with Microsoft t develop standard build for database servers
• Developed automated procedure t monitor database backups and growth
• Provide input for High Availability alternatives including clustering, mirroring and third party alternatives
• Responsible for a installing and documenting all new SQL Instances in this heavily virtualized environment
• EPIC Clarity ETL Administrator
• Provide support for Epic's Clarity database and the associated ETL process
• Play a major role in the application of each new Service Update t each environment
• Provide daily verification that ETL process is running without error
• Perform remediation and document errors when they d occur

Senior Database Engineer

Confidential

• Support clients running IDP software on SQL Server 2005 and 2008 R2
• Provide database support for development and production environments
• Work with clients t troubleshoot database and performance issues
• Developed ETL process using SSIS t populate data mart
• Developed stored procedures, views and functions used in IDP software

Database Administrator

Confidential

• Support clients running InfoMC software on SQL Server 2005, 2008 R2
• Drive performance testing as part of product development
• Provide database support for development environment
• Work with clients t troubleshoot database and performance issues
• Work with DTA and SQL Index Utilization reports t develop index support for existing code base
• Review stored procedure code with an eye toward improving performance and reducing dependency on TempDB
• Developed procedure t de-identify HIPAA data before using it in development environments

Senior Production Database Administrator

Confidential

• SQL Server
• Administer databases that support vendor packages as well as in house developed applications
• Played a key role in the purchase and implementation of the RedGate SQL toolbelt
• Key member in the group responsible for planning the 2000 t 2005 and the 2005 t 2008 migrations
• Lead DBA for AQS/Advantage implementation their new Commercial Lines processing suite
• Supported implementation Duck Creek application this application handled all Personal Lines processing
• Implemented Idera's SQL Diagnostic Manager with an eye towards building warehouse of performance metrics
• Used SQL Performance Reports and DMVs t provide feedback t application developer's on code efficiency
• DB2 on OS/390 and UDB on Windows
• Automated reorg and runstats maintenance
• Used IBM's DB2ADM for maintenance of production objects
• Used Omegamon t diagnose performance issues on the mainframe
• Used SNAPSHOT and Index Advisor t improve UDB on Windows performance
• Support organization wide implementation of DB2 Connect
• Provide support t application development with SQL and performance tuning
• Worked with existing Disaster Recovery guidelines t insure successful disaster recovery drills

Database Professional, Lead UDB DBA

Confidential

• DB2/UDB databases on OS/390, AIX and on Windows
• Perform DB2/UDB DBA functions including database backup, recovery and reorganization
• Used Platinum tools - RC/Query, RC/Migrator, Detector and Log Analyzer
• Provide application development support in the form of DB2 change management, SQL analysis and performance tuning
• Responsibilities include migrating data and structures between subsystems, gathering statistics and utility processing
• The OS/390 environment was DB2 Data Sharing enabled

Technical Analyst DBA

Confidential

• SQL Server
• As Lead SQL Server DBA, I trained and mentored other DBAs
• The SQL Server databases I administered support vendor packages
• Work with vendors t insure that Chubb's standards for performance and recoverability are adhered to
• Work closely with a Microsoft consultants t insure that our database servers are properly sized and configured
• Part of a team responsible for planning the migration from SQL Server 7.0 t SQL Server 2000
• Work with Infrastructure team t consolidate fragmented environment int a High Availability SQL Server environment using Windows Clustering
• DB2/UDB for OS/390
• Perform many typical DB2 DBA functions including database backup, recovery and reorganization
• Responsibilities include migrating data and structures between subsystems, gathering statistics and utility processing
• Possess thorough knowledge of BMC Catalog and Change Managers, as well as IBM's DB2 Utilities
• Planned for and implemented CDB Online Image Copy and Online Reorg products
• Work effectively with BMC DASD Manager and Activity Monitor Provide support for application development groups in the form of DB2 change management, SQL analysis and performance tuning
• Document requirements, make recommendations and draft proposals for tool evaluations
• The OS/390 environment was DB2 Data Sharing enabled
• UDB for AIX and Windows
• Migrated over 100 DB2/2 distributed databases on OS/2 t UDB databases running on MVS, Windows NT and AIX for Y2K
• Supported Chubb's first data mart with UDB version 6.1 databases running on AIX
• Supported a web-based application where the UDB databases reside on AIX
• Application support in the form of SQL and index analysis, change management, developing backup/recovery plans and performance tuning
• Played a key role in the effort t migrate all our UDB databases t version 7
• Documented procedures for using Index Advisor, Visual Explain and Snapshot monitor for application developers