Hobart Burris

480-***-****

ad3jz6@r.postjobfree.com

Professional Experiences

SQL Server professional for 19+ years. I have extensive experience creating data services by using Transact-SQL, creating SSIS Packages, and utilizing SSRS for reporting. I have worked with SQL Server 6.5 through 2019. In addition I have performed database design, developed logical data models, created physical databases, utilized ETL, and Reporting Services. I have also administered and maintained the security and integrity of database environments as well as implemented corporate back-up, high availability and DR strategies and corporate data security policy. I am able to interview immediately and start within 2 weeks of an offer in 75 mile radius of Phoenix or Prescott, AZ..

Signature Consultants: Maricopa County OET

Database Developer, Database Administrator December 2018 – June 2019

Advanced SQL developer in MS SQL Server 2012 or newer in areas of database structures to improve/maintain performance/security and creating technical documentation (topology diagrams, SOPs (Standard Operating Procedure), knowledge base articles, etc.).

Hobart has a vast hands-on experience in 3 tier environments in using SSIS (best practices, logging, notifications, and supporting documentation).

This role targeted at identifying, categorizing, capturing, cleansing, aggregating and analyzing enterprise-wide data, metadata, and master data from a complex, distributed, and technologically diverse environment to support enterprise data analytics such as performance management, trend analysis, and advanced information modeling.

I was able to deliver timely, cost-effective and innovative solutions to County departments to improve business decision making where effectiveness is critical

Binovia

HL7 Developer, Database Administrator, Pacs Administrator March 2003 – November 2018

Zen Development (Intersystem’s Cache) for healthcare interfaces and trouble resolution

Create Data stores that interfaces with RPMS (Cache’) MS SQL Server 6.5 - 2016,

HL7 interface creation and configuring using Mirth and Intersystem's Ensemble MS SQL Server 6.5 - 2016

Reporting tools. Crystal report XI, DeepSee (Intersystem’s Cache) BI Reporting, RPMS and Actuate E. Reporting MS (SSRS, SSAS)

Microsoft Visual SourceSafe, TFS: Team Foundation Server, Midas, Microsoft Access, Cache'(Intersystem’s Cache), Microsoft SQL 6.5 to 2019 Admin/Dev, CGI PERL, SSRS, BI 360 Development tools, Microsoft Visual Studio, ERWIN,C# .NET, VB.NET

Responsible for providing 24x7 DBA and Pacs support

Management, administration, and availability of the Radiology database environment

Perform database design, developed logical data models, created physical databases, ETL, Reporting Services

Create and implement SSIS, SSAS and SSRS solutions

Provided a Microsoft Dynamics GP snap shot.

Provided a Microsoft Dynamics GP support for reporting and data storage.

Plan and automate routine database administration tasks; These tasks were well thought out, documented, and continually refined in order to anticipate, prevent, detect, and resolve problems

Administer and maintain the security and integrity of the Radiology database environment

Implementation of database changes throughout the Radiology database environment

Manage backup and recovery strategies for the Radiology database environment

Resolve MS SQL Server 6.5 - 2016 database performance, capacity, replication, and other distributed data issues

Shina Cloud Web Server on MS SQL Server 2008 – 2016

Supporting Red Hat, MySQL setup and configuration.

Cognizant Technology Solutions

Database Tester May 2016 – November 2016

Planned, designed, executed testing for Data Warehouse projects to certify that they meet business and technical requirements with minimum supervision

Analyzed testability of requirements;

Provided testing estimate

Designed and prepared Test Strategies and Approach, testing metrics and other testing artifacts

Created test cases based on requirements and conducts reviews with development team/business users

Prioritized and executed functional tests and regression tests

Reported defects, raised issues or concerns

Participated in design meetings, risk analysis meetings

Provided leadership and mentoring to junior staff, interns, and business testers

Created and maintained quality assurance standards and processes

Monitored common business specific quality measurement frameworks and track improvement against predefined metrics

Planned and deployed software/DWH testing and project management processes based on the current methodologies of the company

Created and monitored quality assurance-related activities at both the program and project level to ensure appropriately planned and executed

EAR Foundation of Arizona August 2015 – November 2016

Sr. Database Consultant

Database design, developed logical data models, created physical databases, ETL, Reporting Services.

Creation, Testing and Deployment of SSIS (ETL), SSRS(RDL).

Microsoft Access Development : VBA, Reports, Forms, Linked Tables, Upsizing to SQL Server 2012 /2014

Web Site Development.

Validating all SQL Databases creating and identifying a System errors and create a plan to correct errors. Implemented data synchronization between development, test, and production platforms.

Provided instruction to Development and Production teams to determine the best strategy to create the foundation for new, performance-driven, scalable and flexible enterprise databases.

Created and built new database and application environments for custom/ off-the-shelf applications.

Performed daily monitoring, support and routine maintenance of all SQL Servers 2000, 2005, 2008r2, 2012, 2014) and application / Web Servers.

Create and Implemented corporate back-up, high availability and DR strategies and corporate data security policy.

Create and Implemented data synchronization between development, test, and production platforms.

Create and Implemented corporate change control policies, code deployments, corporate data purging and archiving strategies.

SkyTouch Technology October 2014 - June 2015

Sr. Database Administrator

Responsible for providing 24x7x365 DBA Support for Production, Development, QA (Quality Assurance), UAT

(User Acceptance Testing). Reviewing and Validating all environment Back-ups.

Creation of new environments for AFT (Automated Functional Testing), Development, QA (Quality Assurance), UAT (User Acceptance Testing) and Production. (SQL 2005, 2008r2, 2012, 2014) (Informix).

Creation, Testing and Deployment of SSIS (ETL), SSRS(RDL).

Code reviews, Agile Project Management (Scrum), Documentation, Improving the deployment process.

IBM My Services: Creation of Change request, Service request, and Incident.

Implemented data synchronization between development, test, and production platforms.

Provided instruction to Development and Production teams to determine the best strategy to create the foundation for new, performance-driven, scalable and flexible enterprise databases.

Created and built new database and application environments for custom/ off-the-shelf applications.

Performed daily monitoring, support and routine maintenance of all SQL Servers 2000, 2005, 2008r2, 2012, 2014) and application / Web Servers.

Provided Level-1 database support and problem screening, troubleshooting, and performance tuning.

Create and Implemented corporate back-up, high availability and DR strategies and corporate data security policy.

Create and Implemented data synchronization between development, test, and production platforms.

Create and Implemented corporate change control policies, code deployments, corporate data purging and archiving strategies.

Informix Server Creation, Deployments and Reconfiguration.

Tools: MSSMS, SSRS, SSAS, Visual Studio 2014, Report builder 3.0, RedGate Tool belt, Rally,

Catholic Community Charities December 2013 - August 2014

Report Analyst/Database Administrator

Database administration and network support for the management, administration, and availability of the client’s database environment.

Reviewed and rated Remote DBA (off site services).

Validating all SQL Databases creating and identifying a System errors and create a plan to correct errors.

Reviewing and validating Corporate Back-up.

Provided corporate change control policies, code deployments, corporate data purging and archiving strategies.

Created Reports from SAP Business Objects: Social Solutions BI Platform.

Created Base Metrics for SSIS, SSRS.

Upgraded Microsoft Dynamics GP 10.0 to 2013.

Provide a Microsoft Dynamics GP snap shot for accounting review.

Department of Economic Security December 2012 - December 2013

FAA Systems

Responsible for providing ADHOC Reporting and Reoccurring Reports.

Daily, Weekly, Monthly, Quarterly, Biannual, Annual Reports.

PCR (Program Change Requests), SOW (Scope of Work).

Validating data prior to releasing new reports.

ETL (Extract Transform Load): XML, TXT from AS400.

ACA (Affordable Care Act).

Testing and Back End RAD Reporting.

HEA Plus Reporting and data analysis in excel.

HEA TIPS data validation.

Simon Medical Imaging December 2011 - April 2012

Database Administrator / System Analyst / HL7 Developer

Responsible for providing 24x7 DBA and PACS (Picture Archive and Communication System) support. Management, administration, and availability of the Radiology database environment.

Performed database design, developed logical data models, created physical databases, ETL, Reporting Services.

Created and built new database and application environments for custom/ off-the-shelf applications.

Performed daily monitoring, support and routine maintenance of all SQL Servers 2000/ 2008 (R2) and application / Web Servers.

Provided Level-1 database support and problem screening, troubleshooting, and performance tuning.

Implemented corporate back-up, high availability and DR strategies and corporate data security policy.

Implemented data synchronization between development, test, and production platforms.

Implemented corporate change control policies, code deployments, corporate data purging and archiving strategies

Planned and automated routine database administration tasks as permitted.

HL7 interface creation and configuring using Microsoft Biztalk 2009 and WCF Services.

Department of Revenue January 2011 – December 2011

Database Administrator

Created and built new database and application environments for custom/ off-the-shelf applications.

Performed daily monitoring, support and routine maintenance of all SQL Servers 2000/ 2008 (R2) and application / Web Servers.

Provided Level-1 database support and problem screening, troubleshooting, and performance tuning.

Implemented corporate back-up, high availability and DR strategies and corporate data security policy.

Implemented data synchronization between development, test, and production platforms.

Implemented corporate change control policies, code deployments, corporate data purging and archiving strategies.

Coventry Health Care September 2010 – January 2011

Database Administrator

Created and built new database and application environments for custom/ off-the-shelf applications.

Performed daily monitoring, support and routine maintenance of all SQL Servers 2000/ 2008 (R2) and application / Web Servers.

Provided database support and problem screening, troubleshooting, and performance tuning.

Implemented corporate back-up, high availability and DR strategies and corporate data security policy.

Implemented data synchronization between development, test, and production platforms.

Implemented corporate change control policies, code deployments, corporate data purging and archiving strategies.

Gila River Health Care April 2008 – February 2010

HL7 Developer / Application Developer / Database Administrator

Performed Zen Development (Intersystem’s Cache) for healthcare interfaces.

HL7 interface creation and configuring.

Created a data store that interfaces with RPMS (Cache’).

Worked with other Departments with Data Storage and reporting needs.

Reporting tools. Crystal report XI, DeepSee (Intersystem’s Cache) BI Reporting, RPMS and Actuate E. Reporting.

Microsoft Visual SourceSafe, Midas, Microsoft Access, Cache' (Intersystem’s Cache), Microsoft SQL 2000 to 2008 Admin / Dev, CGI PERL, Microsoft Reporting Services, Development tools: Microsoft Visual Studio, ERWIN, .NET, VB.NET.

Responsible for providing 24x7 DBA support.

Managed and maintained databases, configured and managed security, monitored and optimized databases, and installed and configured SQL Server 2000 to 2008.Index tuning.

Performed statistic maintenance, Backup and Recovery Plans, Daily Monitoring of all jobs.

Upsized a Web apps to SQL2008 on .Net from MS Access on Perl.

Natural Data INC. (Gila River Health Care client) September 2007 – April 2008

Database Administrator

Database design, developed logical data models, created physical databases, ETL, Reporting Services.

Managed and maintained databases, configured and managed security, monitored and optimized databases, and installed and configured SQL Server 2000 to 2008.

Performed index tuning, statistics maintenance, backup and recovery plans, daily monitoring of HR jobs.

Upsized a Web apps to SQL2008 on .Net from MS Access on Perl, Creating a Data store that interfaces with RPMS(Cache’), Worked with other departments with data storage needs, report writing Crystal report, DeepSee BI reporting.

IBM June 2007 – August 2007

Database Administrator / Application Developer

Supported American Express BIA Database, Currently an MS Access MDB Correct current MDB Errors (Queries, Reports, Tables, Linked tables and VBA.

Derived physical database designs from Access, developed logical data models, created physical databases on SQL 2005, created data services by using Transact-SQL, created SSIS Packages, configured and managed security, Created/revised MS Access as a front end.

Provided specs to convert to web interface.

CirTech October 2006 - April 2007

DBA / IT Manager

Implemented and administered Microsoft SQL Server 2005™ databases. Derive physical database designs, developed logical data models, created physical databases, created data services by using Transact-SQL, managed and maintained databases, configured and managed security, monitored and optimized databases, and installed and configured SQL Server 2005.

Analyzed the business requirements and design and implemented the infrastructure for business solutions based on the Microsoft Windows® 2003 platform and Microsoft .NET Enterprise Servers. Implementation responsibilities include installing, configuring, and troubleshooting network systems.

GCTECH April 2006 - June 2006

Database Administrator / Systems Engineer

Database Administration and Network support responsible for the management, administration, and availability of the Client’s database environment. This is achieved through the planning and automation of routine database administration tasks.

Offered clients general support for Windows, Windows XP, Windows NT, OS/2, Novel and Mac systems. Internal/external hardware and system trouble shooting a long with ACD operations. Installation and configuration of the following: Exchange, SQL Server 2000-03, Server 2000-03, Desktop support.

EarthLink Networks Inc. January 1996 - May 2003

Database Administrator

Approval and optimization all Installs, tests, migrates, upgrades/fixes and stored procedures on production and Development Database, Manage (SQL 7.0 Current Upgrading to 2000 in 1st quarter 2003) Completed on February 10, 2003.

Oracle 8i Architecture and Administration, Oracle 8i Backup and Recovery, SQL and PL/SQL scripts.

Development and Management of the Employee Tracking Database a Client/Serve App. Client is MS Access and the Server is SQL server 8.0. Processing payroll for all users of the Web based Time and Attendance tool. Report creation and distribution of head counts, attendance, overtime, vacation, PeopleSoft 8 Stats, H.R.’s exports to PC Payroll, Personal Plus, also a team member of the HRIS Horizons implementation team. Customer Satisfaction reports, survey and along with many other projects.

Responsible for maintaining the performance and availability of existing production NT40/2000 environments,

Major tasks include typical system day to day administration, attending department and project meetings on a regular basis, perform system level and applications level monitoring and backups

Implemented hardware and software changes throughout the environment in compliance with the problem and changed management procedures, assisted in determining root causes with both technical and production related problems.

Constructed and maintained thorough documentation of managed environment.

Worked with distributed database technologies in SQL 7/2000 environments including; Backup/Recovery strategies, Data Migration, SQL Object Management, Security, SQL error handling, Performance Monitoring, Alert Management and Transact SQL.

Performed best practice housekeeping, such as DBCC checks. DBA experience supporting highly available, highly transactional SQL servers in a mission critical 24x7 environments.

Education

Attended College of the Canyon 1981 to 1983

Certifications

Microsoft Certified Database Administrator from Microsoft University of Burbank, CA.

The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000

The Microsoft Certified Systems Engineer (MCSE) from Microsoft University of Burbank, CA.

Oracle University: Enterprise DBA Part 1B Backup and Recovery

Oracle University: Enterprise DBA Part 1A: Architecture and Administration

Oracle University: Introduction to Oracle: SQL and PL/SQL

Contact this candidate