Eric Emslie Email & Phone Number

San Diego, Ca, Us

San Diego, Ca, Us

• Provide strategic direction for the database team in handling various database related projects and function as the technical/project leader on projects as well. • Manage and administered over 1200+ database in over 150 instances. • Consolidate and/separate out various servers as well as remove old/unused databases. • Installed and configured SQL 2008, 2012, 2014, 2016, 2017, 2019 and 2022 clustered environment with availability groups (availability groups 2012 and up). • Migrating and upgrading SQL Servers and or databases to either newer hardware, newer operating systems or newer SQL versions.• Configured and supported SSRS, SSIS, log shipping, SQL jobs, performance monitoring, performance tuning and data protection (backups) in all environments. • Documented processes for log shipping, SQL setup, migration, database refresh, backups, permissions re-applying and patching. • Set up automated process and created custom scripts within SQL jobs that incorporate CAU (Cluster Aware Updating) to handle automated patching of Windows Server clusters that contain Always-On Availability Groups.• Use Windows PowerShell to create reports, create automated alerts, create GUI's, and communicate with various platforms (VMware, Open Stack, VNX, Compellent, Xtreme-IO, Windows OS level and application level). • Build, manage and support the enterprise backup system as well as the tape libraries, Azure cloud storage and data domains that house our backup data.

Tustin, California, Us

• Assist customers with installation as well as troubleshooting issues within their applications from simple to complex issues.• Utilize tools such as MS SQL 2012, Visual Studio 2012 and V-Edit to build out test environments to test and find solutions for customer software issues.• Provide software and server support for over 14,000 customers using Syspro’s ERP and CRM software.• Assist customers with database backups and restores as well as write custom SQL scripts to repair data issues from within their applications.

• Design and Develop custom Enterprise Level (CRM) Customer Relationship Management software for a BPO call center outsourcing environment using C#, SQL, ASP.NET, JavaScript and HTML.• Systems/Application Support for CRM environment to scale technical specifications to procure systems hardware and software environment.• Built and configured SQL databases as well as set up and configured monitoring system. Helped design custom SQL scripts and stored procedures when required.• Set up computers and networks, installed all their software such as Quick Books. Set up and designed their advertising menu systems.

Irvine, Ca, Us

• Built and implemented several reporting engines used by executive management to monitor command center environments including SQL Server, Crystal Reports, MySQL, SharePoint, Access and Excel.• Create custom scripts to monitor systems/applications health using various languages such as VBScript, PowerShell, Batch, WMI, and Perl environments.• Developed and debugged hundreds of Critical SQL scripts for CRM Software Application called Helix in an enterprise level environment which helped prevent data corruption, and maintained the various client databases.• Manage development and maintenance of the Enterprise Systems Monitoring System Nagios which monitors over 350 Servers, Switches, Routers and Hardware Equipment.• Built, Managed and Engineered multiple databases and applications for purpose of internal auditing for applications such as Nagios, Big Brother, BMC Service Desk, @Task, and ISA Server.• Provide application support for custom built proprietary (CRM) Customer Relationship Management Software and (ERP) Inventory Management software developed for Alorica clients including Samsung, Home Depot, Costco, AT&T, Verizon, Sprint, HP, Gateway/Acer, Vizio, Sony etc..• Implemented Remedy Trouble ticketing system to manage Enterprise Level environment for company help desk to support 20,000 employees in 25 locations across the US.• Command Center support to manage 3 domains of over 350 servers in multiple data centers nationally to support 24/7 environment.• Project Coordination of over 200 systems engineering projects that included installation, migration and support between software engineering and systems operations teams to collaborate and interface together.• Vendor Management of all company software and license agreements including client database backups.• Managed and support our Blackberry Enterprise Server environment for all executive management and direct reports.

Education record

High School Diploma