Duties: Proactively monitor multiple SQL Server environments to ensure maximum uptime and meet security standards. Responsible for administering a mix of 20+ OnPrem and SQL Azure SQL Server Instances, including 2,000+ databases. Assist in disaster recovery planning. Perform SQL Server patching and upgrades. Implement release of database changes.Accomplishments: Migrated several SQL Server Instances to SQL Server High Availability, 2-node systems. Index analysis and code review for performance improvements, resulting between 10% and 90% performance increases.

Duties: Provide Help Desk technical support and training to all HealthLinx Associates for database services and applications; Database server maintenance and administration; SQL Server Database administration and regular maintenance; Data Reporting for 200+ reports using SSRS and Power BI; Contribute to systems improvements and innovationsAccomplishments: Assisted with migrating “On Premise” to “Cloud” SQL Server-based backup and recovery strategy. Implemented an email-based database monitoring system. Ongoing support for performance and Index tuning against Stored Procedures behind reports. Developed 20+ reports primarily with the Sales and Marketing departments.Technological Environment:Azure Cloud services management; Microsoft SQL Server 2008 R2+ (including SSRS and Power BI); Microsoft Server 2012+; Microsoft Office 365 Applications (including MS Access); Windows 10 in an Active Directory domain environment

Senior member of the IT SQL Server Delivery Team. Responsible for 25,000+ SQL Server databases and 1,200+ SQL Server installations over 6 Windows domains. SQL Server support highlights include: installation, performance tuning, security, patching, AlwaysOn configuration and support for Managed Care programs in all 50 United States, Spain and England. Worked to review and correct failing SQL Server Agent Jobs across all SQL Server environments. Worked on a customized solution that is automated for monitoring SQL Server implementations for all environments. Responsible for multiple performance tuning improvements with several application teams, that utilize both Vendor applications and in-house developed applications. Worked on migrations to SQL Server 2012. Worked on migrations to SQL Server 2019.

Database Administrator responsible for 30+ MS SQL Server and 25+ Oracle database servers on a Windows platform; consisting of 350+ SQL Server databases and 25+ Oracle databases. Work with Business Application Managers (BAMs) and Application Developers in maintaining patching and customizing both Oracle and SQL Server database systems. Member of the Disaster Recovery Team. Worked on migrating all of the Oracle and SQL Server systems as the “carve out” resulting in the sale of the CMDS Business Unit from Mallinckrodt to Guerbet into a new Windows Domain and corporate network. Setup a SQL Server 2014 AlwaysOn 2 Node High Availability Cluster. As the Disaster Recovery Team Lead, coordinated Disaster Recovery Plans for 7 sites across North, South America and Europe.

Senior member of the Enterprise DBA Team. Maintained and supported a combination of 100+ MS SQL Server servers and 85+ Oracle database servers on Windows; consisting of 1,500+ SQL Server databases and 150+ Oracle databases. Migrated a number of SQL Server and Oracle systems to a new Windows domain for the Covidien/Mallinckrodt transition. Worked with staff at multiple U.S. and International sites in supporting SQL Server and Oracle-related issues.

Responsible for administering multiple database environments for the Data Management and Business Intelligence Delivery Team using Microsoft SQL Server and Kalido Data Warehousing application. Supported a team of over a dozen team members. Served as the Subject Matter Expert for database-related issues. Developed and deployed monthly reports that catalog and track database growth for all environments. Primary contact for database-related sizing, tuning, and administration for Agile lifecycle development for adding functionality into the Kalido Dynamic Information Warehouse application suite.

Enterprise-level support of distributed systems using a mix of Microsoft SQL Server and Oracle systems. Deployed SSIS packages for centralized administration of all SQL Server Instances for the M.I.D.A.S. program that monitors Failed Jobs, Disk Space, SQL Log Errors and Backups. Implemented Multimaster centralized SQL Server Jobs server for the M.I.D.A.S. program. Updated Standard Operating Procedures documentation for the Data Operations Group.

Advised DBA Staff on how to catalog, administer and patch 640+ SQL Server Instances at an Enterprise level. Deployed an SSIS package for centralized administration of all SQL Server Instances that monitors Failed Jobs, Disk Space, SQL Log Errors and Backups. Lead for SQL Server consolidation effort resulting in a 60% reduction in SQL Server related hardware, software and licensing costs companywide. Advised upgrade strategies from SQL Server 7.0, 2000, and 2005 to either SQL Server 2008 or SQL Server 2008 R2.

DBA for 500+ vendor and custom SQL Server databases, including clustering. Environments are a mix of Development, Test and Production environment. DBA for 45+ vendor and custom Oracle databases on UNIX, Linux and Windows servers. Responsible for reviewing and promoting database code to Development, Test and Production environments. Logical database, physical database and SQL code review for Application Development team. Implemented a custom SSIS suite for monitoring SQL Server systems. Standardized database backups to Network Attached Storage (NAS), resulting in more than 36,000 backup operations per month. Implemented Database Operations and Database Backup and Recovery Standard Operating Procedures (SOPs). Optimized datatypes for internally developed SQL Server databases by as much as 95%.

Responsible for more than 400 vendor and internally developed databases. Environment was a mix of DB2, Oracle, Microsoft SQL Server (including clustering) and Microsoft Access databases. Crystal Report development. Ad Hoc query development. SQL Server ETL/DTS/SSIS processing from DB2 source.

Database access, query tuning, Crystal Report development. Worked with Project Managers and end users using Timeshare Ware, NEXT and Daybreak applications.

SQL Server 2000, SQL Server 2005 MS Access database development and administration. Queries, stored procedures, DTS/SSIS packages. Database access, query tuning, Crystal Report development. Reverse engineered physical and logical designs.

User-specified Crystal Reports, SQL queries, stored procedures using Oracle 9i and SQL Server databases, for more than 1,000 active users. Not limited to but including Costpoint 5.1. ASP and HTML code for web-based Crystal report distribution.

Database Team Lead. Disaster Recovery Team Lead. Security Team Lead. Responsible for all production and development databases. Support for vendor and custom applications using mix of Oracle (including clusters), MS SQL Server and MS Access. Designed and developed physical design, logical design, triggers, stored procedures, indexes, tables, performance tuning, import, export, SQL*Loader functionality. Delivered monthly Service Level Agreement (SLA) Reports.

Helpdesk support troubleshooting. Installed and configured BellSouth residential and business customer computers for DSL Internet access.

Windows 2000 Admin and SQL Server DBA for Accounting and Finance systems. Managed and maintained more than 50 workstations. Developed Cognos reports. Oversaw SQL Server 6.5 to 2000 upgrade as well as Deltek Costpoint 3.0c to 4.0 SP 3 database upgrade.

Oversaw enterprise wide Oracle and SQL Server database systems. Production patch management, test environment, performance tuning, backup and recovery. ETL and Data Warehouse development using Oracle Data Warehouse. Cognos and Crystal report development. Supported a Deltek Costpoint system. Entity relationship diagrams, scripts, tables, indexes, triggers and stored procedures for multiple Intranet applications using an Oracle data warehouse. Collaborated with developers using JavaScript, VBScript, HTML, ASP, CSS and Include files.

Subject Matter Expert (SME): Oracle Performance Tuning, Subject Matter Expert (SME): Oracle for Windows. Provided real time response and resolution to backup and recovery issues with RMAN, EBU and conventional backup techniques. Provided optimal performance tuning recommendations including SQL optimization, I/O distribution, and memory allocation. Assisted Oracle customers (Database Administrators) with capacity planning, capacity management, database security, load-balancing, Import, Export, SQL*Loader issues as well as database re-organization (logical design) and capacity planning (physical design). Created test databases to simulate customer environments to work through problems. Evaluated Alert Logs, Trace Files, Init.ora Files, Core Dumps and System/Process dumps. Assisted Oracle Development in diagnosing bugs. Provided release patches and hot fixes to Oracle customers.