Manage MS SQL database administration assignments for the one of the largest healthcare providers in Pennsylvania. Enhance database performance, conduct regular system backups and restores, implement recovery procedures, handle performance tuning, and provide recommendations to the development and reporting teams.Responsible for the installation and administration of MS SQL Server (2005, 2008, 2008R2, 2012 and 2014) along with related services and components in a server farm (physical and virtual) containing over 1,000 SQL and application servers.Responsible for mentoring DBA team on tuning and optimization techniques.Responsible for maintaining replication model for Data Services team.Responsible for administration and maintenance of SQL Server monitoring solution.Involved in troubleshooting application and database issues for clients and internal users.Work closely with development and reporting teams by providing optimization and tuning recommendations for database related processes.

Provide technical guidance for the one of the largest BPO processors in the U.S. for government sponsored health plans. Assist with perfomance tuning, troubleshooting guidelines and overall SQL Server Database Administration tasks.

Manage MS SQL database administration assignments for the one of the largest BPO processors in the U.S. for government sponsored health plans. Enhance database performance, conduct regular system backups and restores, implement recovery procedures, and handle performance tuning. Ensure technical and functional designs meet business requirements and provide recommendations to the development team during the development process. Responsible for the support and administration of TriZetto Facets application, databases and supported services. This includes troubleshooting Facets application and custom processes, installing application servers and configuring regions, optimizing parallel engine processing for Facets application processes, working with end users on troubleshooting Facets interactive issues and working closely with development teams on custom processes. Responsible for the installation and administration of MS SQL Server (2005, 2008, 2008R2, 2012 and 2014) along with related services and components in a server farm (physical and virtual) containing over 300 SQL Server instances and 500 application servers.Developed reports using MS Reporting Services, to assist DBA team and other departments within the organization regarding database and process performance.Involved with the implementation of SQL Reporting Services as the corporate standard for developing and deploying reports.Work closely with application development team by providing optimization recommendations for databases and processes.Involved in the implementation of new client systems and databases with direct interaction with the client.Implemented database standards control using SQL Policy Management.Implemented transactional replication model on production servers to maintain reporting servers on a near real time and scheduled basis. Also successfully implemented a cross domain replication model with external client.Mentored Jr. and Associate DBA’s.

Manage MS SQL database administration assignments for the one of the automotive industries leading provider of websites and internet marketing solutions.. Enhance database performance, conduct regular system backups and restores, and handle performance tuning. Ensure technical and functional designs meet business requirements and provide recommendations to the development team. Involved with the implementation of SSRS solution as the standard for developing and deploying reports. Responsible for administration tasks related to SQL Server 2008 R2.Responsible for performance tuning and optimizations.

Manage MS SQL database administration assignments for the largest distributor of automotive aftermarket accessories in North America. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements and provide leadership to the development team during the development process. Designed databases for ecommerce applications and electronic catalog, as well as stored procedures and ETL packages. This includes working closely with application developers and business owners throughout the design and implementation processes.Involved with the installation and administration of MS SQL Server 2005 & 2008 R2 along with related services and components.Developed disaster recovery scripts and procedures.Generated recommendations and specifications of database server hardware based on database and application requirements.Developed reports, some using MS Reporting Services, to assist sales and cataloging teams and other departments within the organization.Highly involved in the design and implementation of internal BI solution utilizing MS SQL Server 2005 Analysis and Reporting Services, which lead to the initial development of a Data Warehouse. This task included working closely with the various business units and IT development staff.Administered Microsoft Server farm that is responsible for supporting ecommerce applications.Involved in the redesign of DMZ which included recommendations on what new hardware would be required to improve security and overall network and application performance.Involved with the installation and maintenance of third party applications to support various business units within the organization.

Manage MS SQL database administration assignments for one of the region’s largest health care insurance providers. Implement and manage systems based on business requirements. Developed “Knowledge Base” to have a central point for documentation, notes, scripts and code related to business applications and other tasks for departmental use.Developed “Patch Management” application to assist technicians in maintaining security patch levels on their assigned servers. This application works from a nightly scan from a third party application.Developed SQL Server installation detection utility to search for installations not performed by DBA group. This utility also performs a blank SA password check for verification. Results are emailed to DBA group for follow up and documentation.Designed databases for in house applications using Erwin Data Modeler, as well as developing stored procedures and ETL packages. This included working closely with application developers throughout the design process.Worked closely with Web Development team during the design of high profile public facing web applications.Worked closely with Web Development team during the design of Talent Management System which was used internally by Human Resources.Involved with the installation and administration of MS SQL Server 2000 & 2005. Developed disaster recovery scripts and procedures. Some of which entailed the consolidation of multiple general database servers to one dedicated server in an offsite facility. These processes are automated to run nightly to minimize loss in the event of a disaster.Generated recommendations and specifications of database server hardware based on database and application requirements.Involved with the installation and administration of business applications. These applications are utilized by our Employee Care, Sales & Marketing, Corporate Compliance, Voice Services and IT departments.

Point of contact for database development, administration and support for electronics manufacturing environment. Implement and manage systems based on business requirements. Work closely with various business units during application design process. Developed applications (used globally by over 1,000 users) that interface with Microsoft SQL Server for data collection and reporting purposes using Visual Basic and Borland C++ Builder. These applications track an assembly from the time it is built, through its life cycle in the field, reporting Quality Data to better improve performance and manufacturing techniques. Additional applications have been written to run in conjunction with the ERP System to assist in Cost Tracking and Product Planning which better aids production managers on fiscal responsibility and in turn, saving the company thousands of dollars in time saved researching failure trends and tracking a particular assembly through its production cycle. It also assists in performance monitoring and quality control providing additional savings.Developed intranet to serve as Corporate Data Center. This intranet links all corporate systems together into one location through HTML and ASP pages. Data is pulled from MS SQL Servers, Unidata and Lotus Notes Servers from all locations worldwide. Developed online business reports and charts to assist in day-to-day business practices.Developed extranet to allow customers, with access into our servers, to view the real time data on their projects through the internet using HTML and ASP pages.Setup, deployed and administered MS SQL Servers (Versions 7 & 2000), which are located in manufacturing facilities worldwide, where all data is replicated and merged to form one global database.Trained and mentored help desk technicians in order to better support the business user community.Main technical point of contact at corporate headquarters for telephony, networking, help desk and engineering application issues.

Create detailed process diagrams for fire suppression systems manufacturer. Work closely with engineering to help build electronic symbol library. Work closely with production supervisors to improve and maintain documentation for manufacturing process.Created detailed 3D models, digital images and fabrication instructions for use in manufacturing process and engineering documents.Involved in the analysis of existing processes to make a more reliable, cost efficient system in a “DFT” environment.Involved in the development of ISO-9001 procedures concerning revision control and changes on fabrication instructions and associated documents.Involved in the implementation and maintenance of Novell Networking System in a manufacturing environment. Also responsible for providing PC technical support to manufacturing and engineering departments.

Create detailed process diagrams for electronics manufacturer. Work closely with engineering to generate assembly and specification drawings. Work closely with production supervisors to improve and maintain documentation for manufacturing process. Created detailed fabrication instructions including the development and deployment of online interactive production assembly and troubleshooting procedures using detailed multi-level Windows Help files.Involved in the analysis of existing processes to make a more reliable, cost efficient system.Involved in the creation and maintenance of Schematics, Assembly Drawings, Fabrication Drawings, Parts Lists and Alignment Fixtures.