SUMMARY:

SQL Server professional for 10+ years. He has extensive experience creating data services by using Transact - SQL, creating SSIS Packages, and utilizing SSRS for reporting. He has worked with SQL Server 6.5 through 2019. In addition he has performed database design, developed logical data models, created physical databases, utilized ETL, and Reporting Services. He has 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. Hobart is able to interview immediately and start within 2 weeks of an offer in 75 mile radius.

PROFESSIONAL EXPERIENCE:

Confidential

Database Developer, Database Administrator

Responsibilities:

• 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.
• Mr Burris hasPerson will deliver timely, cost-effective and innovative solutions to County departments to improve business decision making where effectiveness is critical

Confidential

HL7 Developer, Database Administrator, Pacs Administrator

Responsibilities:

• 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
• Supporting Red Hat, MySQL setup and configuration.

Confidential

Database Tester

Responsibilities:

• 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

Confidential

Sr. Database Consultant

Responsibilities:

• 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
• 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.

Confidential

Sr. Database Administrator

Responsibilities:

• 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.
• Confidential 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 Reconfigation.

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

Confidential

Report Analyst/Database Administrator

Responsibilities:

• 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 .

Confidential

Database Administrator / System Analyst / HL7 Developer

Responsibilities:

• 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.

Reporting tools: SSRS, 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 Admin / Dev, CGI PERL, Microsoft Reporting Services, Development tools: Microsoft Visual Studio, ERWIN, .NET, VB.NET debugging.

Confidential

Database Administrator

Responsibilities:

• 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.

Confidential

Database Administrator

Responsibilities:

• 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.

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

Confidential

HL7 Developer / Application Developer / Database Administrator

Responsibilities:

• 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 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 .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.

Confidential

Database Administrator

Responsibilities:

• 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 .
• 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.

Confidential

Database Administrator / Application Developer

Responsibilities:

• 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.