Jack M.

Database Administrator

915 dollar
Freelancer
20 ans
Lancaster, ROYAUME-UNI

Mon expérience

Taos Mountain, LLCFebruary 2015 - Présent

Distributed Systems Services, Inc. (DSS) SQL Server DBAOctober 2014 - February 2015

Voir plus

Meta Pharmaceutical Services, LLCMarch 2014 - October 2014

Database Administrator/Project Lead:
Provide IT leadership for ERM/CRM applications. As the Local database administrator, I have ownership of all application & data storage servers. As a leader in the IT organization, I play a critical role in business decisions across all departments when technical and/or process changes/alignments are required
Voir plus

Endo PharmaceuticalsMay 2011 - March 2014

Database Administrator/Project Lead:
Provide IT leadership for ERM/CRM applications. As the Local database administrator, I have ownership of all application & data storage servers. As a leader in the IT organization, I play a critical role in business decisions across all departments when technical and/or process changes/alignments are required.
Voir plus

Advanced Micro Computer SpecialistsMay 2011 - March 2014

Database Administrator/Project Lead:    
Provide IT leadership for ERM/CRM applications. As the Local database administrator, I have ownership of all application & data storage servers. As a leader in the IT organization, I play a critical role in business decisions across all departments when technical and/or process changes/alignments are required.
Voir plus

Johnson & JohnsonNovember 2005 - May 2011

Provide IT leadership for ERM/CRM applications. Manage developers in application and reporting platforms. As the Local database administrator, I have ownership of all application & data storage servers. As a leader in the IT organization, I play a critical role in business decisions across all departments when technical and/or process changes/alignments are required.

Key Results:
    Led efforts as Project and Lead Technical Manager to implement interfaces between in-house CRM applications and JDE (JD Edwards).
    Managed developers and implementations of 25+ successful releases and counting. Each release encompassing new features including bug fixes.
    Developed/Re-engineered normalized data architecture of the previous production backend database(s) with supporting documentation (Data Models/Dictionaries/Diagrams).
    Successful migrated reports to Microsoft Reporting Services from previous reporting tools. CRM applications were generating reports from the production data servers, causing performance issues on the transactional side. Using MS Replication Technologies, all reports had been pushed to MS Reporting Services freeing up available bandwidth on the production servers.
    Developed and Implemented CGI Applications to perform Address Validation via United States Postal Systems Databases. Address Validation was a critical to minimize returns occurring from invalid addresses, thus improving the likelihood of payment.
    DBA Admin for Production/DEV/Beta data servers. My roles comprised of architecture, security, performance optimizations, stored procedures scripting, upgrades, etc
Voir plus

PCI Insurance, Inc.June 2002 - November 2005

Tasked to take a small company from Excel/Access worksheets/desktop-dbs to an enterpirse level enviroment and retire the oursourcing of their billing and collections
Designed, implemented and supported Data and Application Servers including ERM/CRM ApplicationsThe net result, the company was able to billing onsite and save 1.0+Million/Year by retiring the outsourcing of their billing/collections.
Key Results:
    Reviewed and documented the company’s business environment and model(s) to begin development of a backend/frontend solution.
    Developed backend data servers/architecture to facilitate the storage of their current/future data needs.
    Developed the frontend applications to support data entry and call center processes.
    Developed the frontend applications to support billing and collections. The application had been designed to generate invoices (PDF via API) and save to network shares and eventually print for mailing once/month.
    By the 2nd year, began to manage and train new employees to support reporting, application and SQL Support.
    The milestone result had been 1.0MM+ per year by retiring the 3rd party vender that they had once outsourced to each month. This had been reached within 10 months; 2 months earlier than expected.

Mes compétences

Databases

MySQL, Database Administration, Oracle

Languages

XML, SQL

Frameworks

.NET

Other

self-employed, Database, JDEdwards Suite, Microsoft Access, Microsoft Windows, industry~it, Database Administrator, development of a backend/frontend solution, MSSQL DBA, Administrator/Project Lead: Provide IT, Senior DBA, the Local database administrator, Project Lead: Provide IT, IT/DBA Manager, Project and Lead Technical Manager, IT Lead, Data Architecture, SUPPORT BILLING, Data Storage, Application Servers, SQL Server DBA, Front End, Back End, Manage Developers, Data Modelling

IT Infrastructure

Security

Computer Tools

Microsoft Excel

Technologies

SharePoint, CRM

Business Intelligence

Data Warehouse, Business Intelligence, ETL, SSRS

Others

SDLC

Software testing

Debugging

Mes études et formations

Bachelor's degree, Information Technology - Missouri Institute of Technology

Credits, Field Of Study Computer Software Engineering - Camden County College

Amazon Web Services - AWS DEV ASSOCIATE2017 -