Deepthi (Dee) Iacconi

Jamison PA ***** 267-***-**** ad325f@r.postjobfree.com linkedin.com/in/deeiacconi

SUMMARY

Dedicated Senior Database Administrator with over 20 years’ experience in the financial, healthcare, government and global cellular communications industries. Extensive experience in all phases of the software development life cycle. Effectively analyzes, designs, and implements global enterprise e-commerce products with a multi-tier client-server architecture. Solid track record in leading teams to implement new and improved procedures to ensure timely execution of processes for client-based systems. Proven success enhancing legacy systems with new features and improvements.

SKILLS

Leadership Disaster Recovery Migrate Design Install Upgrade Analyze Troubleshoot Communicate

TECHNICAL SKILLS

T-SQL SQL*Plus PL/SQL Power Shell MS Access Unix Shell XML XML Schema HTTP HTML WebSeries

MS 365 Windows 2012R2/2016 Standard/Enterprise x64 2008 R2 & NT 2000 X Windows SUN Solaris OS 4.1 Linux+ RedHat 5.6 Unix AIX 5.3 MS SQL Server 2019, 2016, 2012, 2008, 2005 MS SSIS V17 (SSDT), MS Power BI (2020) Reporting, MS Access Oracle RDBMS 10G RAC Cluster 11G & 12c Oracle EBS Applications 10.7 and 11i Oracle Applications (Manufacturing, Financials, Order Management, Workflow, Human Resources, System Administrations, Application Developer, EDI Gateway). McKesson Applications (PCA, PHS, HRMM/HRFM, STAR, HBF, PASSPORT, PHS, HBI, HPM, PCON/PMOD, EC2000, 3M, HRMM, (ILE/FRX)) SMARTworks Standard Register Echo Allegra Quantim Cypress Kronos SunRise SIS (OR system) YARDI Genesis MS Lucid Idera OEM Oracle Grid MS (Visual Studio Word Excel PowerPoint Outlook Novell Groupwise SAN EMC BMC Remedy Track-It Footprint Vastera Kintana Applications (Apps*Integrity, Object*Migrator) Noetix Cognos Vertex RMAN Vi Editor

PROFESSIONAL EXPERIENCE

Premier Dental, Plymouth Meeting, PA Dec 2022 – Jan 2024

Manufacture of Dental Products and instruments, with approximately 300 employees

SQL Server DBA & Microsoft Application Great Plains (GP) Administrator

Designed, installed, upgraded, and deployed approximately 30 - 35 databases from SQL Server 2016 to SQL Server 20229 for multiple Systems, enabling continued support from Microsoft, increased system security, and utilization of new features.

Troubleshoot GP Application issues/errors and provide resolutions for users and support application upgrades.

Development and support Power BI, Power Apps, SSRS Reporting and Application support.

Evaluated existing systems and recommended remediation and tuning solutions for problematic or poor performance environments, improving system performance and degradation.

BUCKS COUNTY, Doylestown, PA Jan 2021 – Nov 2022

Provider of Local Government community services, with approximately 3000 employees

SQL Server DBA & System Administrator

Designed, installed, upgraded, and deployed approximately 40 - 50 databases from SQL Server 2012 to SQL Server 2016/2019 for multiple Systems, enabling continued support from Microsoft, increased system security, and utilization of new features.

Development and support SSIS package programming, Power BI, Power Apps, SSRS Reporting and Application support.

Evaluated existing systems and recommended remediation and tuning solutions for problematic or poor performance environments, improving system performance and degradation.

Support and maintain Applications supporting the SQL Server databases.

BERKADIA COMMERCIAL MORTGAGE LLC, Ambler, PA Mar 2016 – Nov 2020

Provider of technology Solutions for Commercial Mortgages, with approximately 2500 employees.

Senior SQL Server DBA & System Administrator

Collaborated with internal Server, Network/Security experts and Database Administrators (DBAs) on migrating and upgrading SQL Server into AWS and Azure cloud-based environment.

Designed, installed, upgraded, and deployed approximately 12-15 databases from SQL Server 2008 to SQL Server 2016 for Fannie Mae, PeopleSoft Finance and HR Systems, enabling continued support from Microsoft, increased system security, and utilization of new features.

Implemented Disaster Recovery (DR) solutions for Systems / Applications utilizing SQL Server AlwaysOn and Idera Mirroring Software for SQL Server, decreasing downtime and loss of revenue.

Evaluated existing systems and recommended remediation and tuning solutions for problematic or poor performance environments, improving system performance and degradation.

Dee Iacconi 267-***-****) ad325f@r.postjobfree.com Page 2

FUTURA MOBILITY, Fort Washington, PA Apr 2015 – Jan 2016

Provider of technology Solutions and managed services with over 50 employees.

Senior Oracle & SQL Server & System Administrator

Designed, implemented, and supported databases in Oracle 11G / 12c and SQL Server 2008/2012 for 2 new client requirements.

Implemented Disaster Recovery (DR) solutions for 2 clients in vCloud, utilizing Veeam Software for SQL Server & Oracle Databases.

Evaluated and provided troubleshooting for clients' existing systems and recommended remediation solutions including SolarWinds, Veeam, and DBVisit.

Defined and documented policies and procedures for systems per service level agreements and provided 24/7 support and maintenance.

ABINGTON MEMORIAL HOSPITAL, Abington, PA Apr 2009 – Mar 2015

Provides patient health care services – teaching hospital with over 4500 employees.

Senior DBA & Applications System Administrator

●Installed and managed databases and McKesson application systems for Healthcare Financial Systems (HIS) department including on-premises production, testing and development environments and 24/7 support.

●Performed DR of all systems with Sungard for 2 internal hospital locations and took part by ensuring databases were up & running and fully accessible to the DR user team. Took part in internal and external system audits.

●Provided maintenance by applying Service Packs, Security, and Upgrade patches for SQL Servers and Oracle Hot Fixes or Patches (OPatch).

●Documented DBA and security policies and procedures for all McKesson Applications prior to go-live, and supported 3rd party software (Vertex, Regulatory Codes).

MOTOROLA, Horsham, PA Jun 1996 – Feb 2009

Global Cellular Communications Leader in developing technologies, solutions, and services with approximately 6000 employees.

Lead DBA & Applications System Administrator (2007 – 2009)

●Managed and prioritized DBA and Oracle EBS application system administration activities for complex ERP & DW systems including managing printers.

●Led DB maintenance and sustaining project activities for DBA group and coordinated all client-related high profile critical systems utilizing BMC, an IT Service Management Software tool. Provided Change, Incident & Project Management tickets for approximately 10-15 DBAs.

●Established and initiated the Cost-Transformation efforts by decommissioning databases and applications, saving Motorola $5K in performing DR test for an ERP high availability system.

●Utilized OEM (Oracle Enterprise Manager) to set up maintenance and monitoring probes for databases and other Oracle maintenance features such as RMAN, Opatch, tar/untar.

●Participated by executing requested reports/queries in compliance and maintenance of SOX audit controls supported 3rd party software applications.

Senior Applications System Administrator, Contractor through Computer Sciences Corp, (2003 – 2007)

Applications System Administrator, Motorola (2000 – 2003)

Programmer / Analyst, General Instruments, acquired by Motorola (1996 – 1999)

EDUCATION

Graduate Diploma in Information systems (Equivalent to Bachelor of Science in Computer Science),

University of East London, London, UK

Business & Technician Education Council, Higher National Diploma in Computer Studies, Associate Member, Thames Polytechnic, London, UK

Computer Programming and Information Processing, City & Guilds of London Institute,

Willesden College of Technology, London, UK

PROFESSIONAL CERTIFICATIONS / TRAINING

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2 (11gR2-RAC-Grid) Sept. 2013

Updating your Database Skills to Microsoft SQL Server

Microsoft SQL Server Database Maintenance

Linux+ RedHat Certified

Oracle 9i Database Administrator Certified Associate

Oracle Enterprise DBA Part 1A: Architecture & Administration

Managing Your Technology Chain with Kintana (Chain Link)

Oracle Applications Sys. Admin. (Smart Client), Reports & Graphics

Contact this candidate