SUMMARY

• Passionate healthcare Information Systems professional with extensive experience and proven track record in managing high - availability database technologies.
• Recently achieved cloud certification as AWS Certified Solutions Architect and pursuing a master’s degree in Cybersecurity and Information Assurance.
• Provides a depth of technical experience utilizing the right balance of management, database, and systems administration skills to work effectively in a team and across Information Technology groups.
• Background in project management, strategic planning, and business administration as well as proven strength in managing 24/7 database systems in mission-critical environments.
• Highly proficient in various Microsoft Windows and Unix-based Operating Systems, Microsoft SQL Server 2005 through 2017, High-Availability Disaster Recovery with SQL Always-On Technology, SQL Replication, SQL Reporting Services, SQL Integration Services, SQL Analysis Services, IBM Unix (AIX), PowerShell and Unix/Linux shell scripting, VMWare virtual server platform
• Capacity planning of large databases and systems on Storage Area Networks (SAN) using EMC products including Data Domain for backup and archive storage
• Experience coding PowerShell, Visual Basic.NET, C#, ASP.NET, ADO.NET, Visual Studio.NET, C#, C/C++, Java, Perl, HTML, HL7 and other languages
• Experience with wide array of Microsoft Office products

TECHNICAL SKILLS

• Microsoft SQL, Oracle, MySQL Database Administration
• High Availability, Backup/Recovery, Data Security
• Integrated Systems Delivery
• Data and Systems Security and Integrity
• Performance Tuning
• PowerShell / Unix Shell Scripting
• Project and Resource Management
• Business Intelligence / Analytics (SSIS, SSRS, SSAS)
• Problem Resolution Strategies
• Capacity Planning

PROFESSIONAL EXPERIENCE

Confidential, Exton, PA

Senior SQL Database Administrator

Responsibilities:

• Collaborate with company managers and directors in developing future architecture of Business Intelligence systems as well as other SQL-based financial systems
• Assist developers with coding standards, database architecture, quality assurance, and best practices resulting in reduction of overnight query job processing of more than 55%
• Perform migrations to new servers including SQL Server installation and configuration, databases and maintenance plans, user roles and permissions
• Ensure backups meet business recovery time objectives and recovery point objectives as defined for each system and perform disaster recovery testing
• Install, configure, administer, and manage SQL Server 2005 through 2017
• Create, maintain, migrate, and troubleshoot SSIS packages and SQL Jobs used to transfer data between systems
• Consults with management team to ensure conformity with system best practices, and presents weekly updates on project development

Confidential, Philadelphia, PA

Senior SQL Database Administrator

Responsibilities:

• Senior SQL Database and Systems Administrator for high-criticality hospital systems including multi-terabyte OLTP/OLAP Clinical, Physician Practice, and Financial Systems
• Managed, monitored and guaranteed efficient day-to-day operations of systems across multiple platforms for both Microsoft Windows and Unix-based database systems
• Investigated and resolved database and application performance issues for several hundred instances containing over 3,500 databases during on-call rotation
• Served as project/technical lead in the completion of medium to large scale implementations, managing projects from business requirements analysis to solutions delivery and support
• Maintained and installed updates to OLAP database and analytics application servers which ran nightly Extract Transform and Load (ETL) processes
• Experience with SQL Server Business Intelligence Development Studio (BIDS) and SQL Server Reporting Services (SSRS)
• Created, maintained, migrated, and troubleshot SSIS packages and SQL Jobs used to transfer data between systems
• Database performance tuning including SQL execution plan review as well as index creation/maintenance
• Installed, configured, administered, and managed SQL 2005 through 2017
• Applied application and security updates for SQL Server and Windows Operating System
• Planned, executed, and documented systems and procedures as part of disaster recovery planning
• Reviewed upgrade projects as well as changes for proposed system upgrades, vendor statement of work and cost proposals for hardware and software implementations
• Consulted with management teams to ensure conformity with system best practices, and presented weekly updates on project development
• Extensive experience with SQL Server High-Availability: Always On, Replication, Mirroring, Failover Clustering
• Performed both in-place and side-by-side system and application software upgrades
• Automated notification of critical system events resulting in significantly increased uptime and reduction in event criticality
• Created and modified queries and stored procedures
• Experienced with a wide array of scripting languages as well as some programming languages
• Maintained SQL Server user security via authentication modes, roles, and logins

Confidential, Yardley, PA

Manager, Unix Technical Support

Responsibilities:

• Managed a 15-member IBM RISC hardware and UNIX database technical support team
• Developed, tested, and debugged software applications, utilizing Progress 4GL programming
• Provided diagnostic, configuration, performance, network, and installation support
• Utilized shell programming to facilitate system functionality and administration
• Configured peripheral devices for integration into system hardware and software for MS Windows / Unix
• Performed system upgrades, and backup and recovery operations