Arnold Levine Email & Phone Number

Chandler, Az

• Major projects and responsibilities• During Tivity Health and Heathway’s separation – As a main Company DBA, - Designed, and built full DB environment, established and completed routine to separate and move company data with zero data loss and downtime no more than two hours. • Upgrade and data replication for company DB servers from SQL 2012/2014 to SQL 2017 utilizing third party software (Rubrik) and native tools (Log Shipping) for OLTP, ETL, Reporting, BI (SSAS, Qlik), and heavy data load servers in virtual environment (Hyper-V to VM Ware)• As a part of a team with IT Security and Auditors – Established, developed and implemented security and practices: for SOX, HIPAA, and PCI audits including User Access Reviews, SQL DB Audit, and Change Management routine. TDE, (Data Encryption)• Full responsibility as company DBA for approval process for database architecture design and implementation, maintenance, and daily support as well as provisioning, and system configuration including DB backups, maintenance, best practice implementation, data movement and replication using various tools such as Log Shipping, Replication and AOAG (synchronized and async)• Support Company development teams and software and DB lifecycle with database configurations, query and index tuning, query and Stored Procedure (SP) troubleshooting, establishing and following database development best practices

Tucson, Arizona Area

• Create Business Intelligence (BI) and Database architecture and underlying technical design and documents to communicate solutions that will be implemented.• Data Warehouse (Business Intelligence solutions): Design and implementation of data warehouses that provide traditional ETL and OLAP reporting capabilities. • Entire Business Intelligence (BI) life-cycle from requirements gathering. Extract Transform Load (ETL) OLAP cube design, implementation, and report development. • Provide expertise on the implementation entire infrastructure of database technologies and disciplines.• Install, upgrade and adjust database management systems - Local and remote locations and/or Cloud technology (Microsoft Azure; Amazon Cloud Services)• Subject Matter Expert in designing, engineering and delivering database solutions leveraging the industry best practices (availability, scalability, performance, back-ups, and disaster recovery) and providing support for database infrastructure.

Tucson, Arizona Area

• Major tasks and responsibilities – Re- Architect, and re-design of database environment to separate Gaming, Hotel business, Business, and Reporting environments according to ASDOG rules, and industry best practices, with additional separation of Application and Reporting from Production environment.• Develop and implement security routine and data and service auditing according to business standards (included Arizona Department of Gaming) • Establish routine to ensure that no data outage will exceed 2 hours (ASDOG) by implementing HI (higher availability) and DR (Data Recovery). Improve DB performance, especially during high demand time • Plan, Architect, and establish full scale environment for reporting, data analyzes and Data Warehousing. • Additional responsibilities - Evaluates the use of data directly to the goals and practices of the EED. Establishes a road map and consensus for moving forward and optimizing the utility of data from multiple sources• Analysis, design, and implementation of data models; database objects; data conversion, integration, and loading processes; query and reporting functions (SSRS); data management and data quality assurance processes Design, test, and implement automated extract, transformation, and load (ETL) routines using tools such as SQL and SQL Server Integration Services (SSIS) and Server Analyses Services (SSAS)

* As a primary database administrator in Pima County production environment – Responsible for County enterprise database servers. (MSSQL Servers 7-2008 and Oracle 10G R2) including but not limited - Setting Database environment, creating and manage a County multilayered systems and solutions: servers, server clusters, server farms, and databases. Ensure uptime of production database systems. * Establishing and managing databases routines such as but not limited to - replications, clustering, and snapshots, backup and restore procedures, DTS, SSIS, views, SP, and database and database servers maintenance.* Responsible for County Enterprise Reporting systems and development of customized reports solutions using variety tools and techniques* Analyze current and proposed information system solutions (including systems and business analyses) and create (build) data integration and data transformation systems* Personally responsible for such projects as: Implementation of Oracle Enterprise Manager Grid and Enterprise Monitoring Solution – First Response systems. * Analyze business systems and procedures, and implement improvements through Business process evaluating and business process mapping

* Responsible for Departmental Database Servers, and databases. These include but are not limited to: Establishing database administration routines such as monitoring and tuning database, creating and managing database replications, backup and restore procedures, DTS, views and stored procedures.* Responsible for Departmental Reporting and development of customized reports solutions using different tools and techniques, such as Web applications, Crystal Reports, SSRS, MS Access, etc* Implement and manage Departmental Document Management System (ProjectDox)* Develop maintain, implement and support departmental automated information systems (Accela line of products such as Permit Plus, Wireless, etc). * Analyze business systems and procedures; defining and document business requirements; implement and integrate improvements and various COTS packages (PermitsPlus, Accela Wireless, ProjectDox, Departmental reporting solution).* Provide end-user training and user support of the systems.

* Designed, build, tested and supported a manufacturing/accounting/reporting software system to convert acquired companies to centralize MIS/accounting/finance system. * Responsible for company and company subsidiaries data analysis and data analysis system based on MS SQL and Oracle databases. * Established and deliver reporting solutions and reporting system based on data analysis using different tools and techniques* Worked with company management to solve any issues with feature design.* Analyze business systems and procedures, and implement improvements through Business process evaluating.* Business and System analyses and developing data integration and data transformation systems

* Responsible for company data analysis and data analysis system. * Established and deliver reporting solutions and reporting system * Coordinated with different department specialists regarding the current data system needs for statistical/data analysis.* Responsible for research, data analysis, and project evaluating. * Manage Database Servers, and databases.