Mark Phillips Email & Phone Number

Greater Minneapolis-St. Paul Area

Extensive Database Management in MSSQL 2005, MSSQL 2008 and MSSQL 2012 and Sybase 12.5. Minimal Database Management experience with DB2 on Windows.Have used SQLPLUS and Oracle SQL Developer tools to manipulate data in a Oracle environment.. Written and performed Disaster Recovery exercises for USBank Asset Management. Created backup and recovery procedures for USBank Asset Management. Perform security requests and created auditing reports for Database access.Have some experience with monitoring performance and tuning efforts using SQL Profiler, Show Plan, and Embarcadero DBArtisan Database Monitoring tool set. Create SQL scripts for database structure changes for TOS DBA’s to run for major application upgrades. Performed conversion process from Sybase to SQL server. Followed projects through to completion to ensure all business requirements were being met.Experience in Developing Webfocus Reports from business specifications.Provide 24/7 production support for the business related to data management.Work with the MSSQL SQL Server Agent to create jobs to do Index Rebuilds, DBCC, and Update Stats.Created stored procedures to do table purges and reporting.Created Triggers to do audit recording.Have done database refreshes from Production to lower environments.Have used Red Gate SQL compare tool.Have used Microsoft SQL Server migration Assistant for Sybase tool to migrate Sybase tables to MSSQL.Upgraded databases from lower version of MSSQL to newer version.Have used Embarcadero DBArtisan to do database day to day activities. Have used MSSQL Import and export tool to import and export data.Have used MSSQL DTS (Data Transformation Services) packages to import and export data.

Greater Minneapolis-St. Paul Area

Primary DBA supporting 7 production Sybase instances with 94 databases on an HP Unix Platform.Working with BMC SQL Backtrack to do backups and loads.Responsible for day to day database administration activities such as DBCC, update statistics, creating and removing database objects, and monitoring physical growth of the Sybase instances/databases.Responsible for any type of Unix scripting that would deal with database administration activities on a routine basis.Responsible for Sybase software upgrades and Disaster Recovery activities.Monitor Sybase database activity to determine any type of locking and performance degradation.On the on call rotation for the production Sybase database support that covered 23 Sybase instances on Sun Solaris, HP, and Intel platforms with over 300+ databases across 3 locations.

Greater Minneapolis-St. Paul Area

Primary technical security consultant for the Security Automation Management System. This includes cross platform installation of new releases of the product and customization of the product. Primary resource for consulting and problem resolution for the SAM system on 3 RACF mainframe LPARS, over 250 Unix boxes, Top Secret mainframe LPARS, and 5 NT domains. Created process and procedures for the Security Administration team to meet the departments SLA’s.Primary technical support for the VRA product including installation of new releases and problem determination. Perform SAS programming to automate the Security Administrators duties.Ensure user compliance with company’s security policies and procedures.

Greater Minneapolis-St. Paul Area

Responsible for analyzing SQL code and creating indexes to enhance performance within the database and responsible for communication to the application developers on ways to access data to also enhance performance within the database.Primary DBA support for 1 Informix-online database on a Sun Solaris Unix Platform.Responsible for performing database activities such as backups, table loads, and unloads, running update status and granting and revoking user id’s.Primary development DBA for UDB/DBA database.Member of the Employee Satisfaction Team.Member of the Mid-Range Change Management Team which creates procedures for Change Management.On the on call rotation for mid-range database support.On call support for the Support Center rotation which handles IMS, DB2 and Sybase related issues.