| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address B Ward StreetJacksonville FL Street Address
E-Mail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEOBJECTIVETo secure a Database Administration position where I can incorporate my 10+years of experience.SOFTWAREERWIN, System Architect, VMware, SQL Server 6.5 - 2014, DTS, SSIS, Oracle6, 7, 8, 9i, 10g, 11g, , Oracle Forms, Oracle Reports, TOAD, SQLNavigator, SQL*Loader, DB2, ASP.NET, ASP, VB.NET, Visual Basic 4.5 -6,VBScript, VBA, , WMI, ADO.NET, DAO, MAPI, CDO, ActiveX, , HTML,Infragistics Ultra Web Suite, Crystal Reports 4.5 - 10, Active Reports,Microsoft Access 2.0 - 2013, PowerPoint, Visio, SourceSafe, LiteSpeed,Ignite Monitoring ToolEDUCATION . Indiana University of Pennsylvania, Indiana, Pennsylvania . B.A. Economics . Harrisburg Area Community College, Harrisburg, PA . Database, Systems Analysis . Wake Technical Community College, Raleigh, NC . Networking . FCCJ, Jacksonville, FL . Oracle SQL, PL/SQL & Database AdministrationCERTIFICATIONS . MCDBA, MCSE, MCITP: DBA and Developer 2005 and 2008, MCSA, MCSD, Microsoft Small Business Specialist, OCP DBA 10gPROFESSIONAL EXPERIENCEDatabase Professional Consultants, Inc.NOV 2013 - PresentDatabase Consultant\Owner . Migrated and upgraded multiple databases . Installed 32 and 64 bit drivers and created Linked Server to AS400 Database . Create Backup and Maintenance Plans and perform general DBA functions.Cypress Property and Casualty InsuranceOCT 2011 - January 2015DBA . Installed SQL Server 2008 R2 and upgraded SQL Server 2005 Databases to SQL Server 2008 R2 and SQL Server 2012 and 2014 in a test environment . Create Tables, Views, Function, etc. for new 2.2 TB Data Warehouse . Created ETL Packages that loaded Data from AS400, Oracle into SQL Server Data Warehouse . Configured Reporting Server, BI Application Server, Great Plains and various other Database Servers . Develop SSIS and Reporting Services Solutions and managed the deployment, subscriptions, etc. . Implemented Backup and Recovery Procedures, Maintenance Plans, performed other common DBA duties . Monitored SQL Server Jobs. . Mentored and assisted Developers and BA's on an ongoing basis.First Coast Service OptionsOCT 2009 - NOV 2009DBA . Converted DTS Packages to SSIS. . Created scripts for deployments to Production.Safariland - BAE Systems Subsidiary (Contract)JUL 2009 - AUG 2009Database Developer . Consolidated data from several Oracle Databases and SQL Server Databases into an Oracle 10g Operational Data Store Database for Reporting purposesPSS World MedicalSEP 2006 -MAY 2009Database Administrator . Created and maintained ERD Diagrams and implemented physical design . Created SQL Server Traces, queried System Tables, stepped through C# and VB.NET code to identify deficiencies in the SQL Server Procedures, User defined Functions. . Installed 3rd party SQL Server 2005 Databases, decommissioned Database Servers and moved Database to different Servers to consolidate and optimize performance . Monitored Database growth and identified space requirements for Database files and Backups . Performed Database Backups and restored Databases to a Point in Time . Created ETL Packages (DTS and SSIS) to transfer to between SQL and Oracle Databases and import and export data to and from various file formats . Provided ongoing support to various departments with developing ad-hoc queries, performance and connection issues to include SQL Server, Oracle and Microsoft AccessFidelity Information ServicesAUG 2005 - SEP 2006Web & Client Services C# Team Database Analyst/DBA . Performed Data Modeling and implemented physical Database . Create Tables, Indexes, Constraints, Stored Procedures, UDF's Triggers, DTS Packages . Created scripts to Promote to create and modify objects from Development to QA & Production . Tuned Stored Procedures and Monitored Production SQL ServersAllstate (Contract)JAN 2005 - JUN 2005SQL Server Developer/DBA . Converted Postgre SQL Database to SQL Server , wrote DTS Packages to load Database . Modified existing DTS Packages and created deployment scripts . Created SQL Scripts on a daily basis to perform updates of dataMerrill Lynch (Contract)APR 2004 - DEC 2004SQL Server Development DBA . Performed data modeling, database design and implementation . Converted Access Tables, Access Queries, VBA Code into SQL Server Objects . Created DTS Package to load SQL and refresh Several Tables from Sybase . Integrated Data from various external data sources into single databases . Created Staging Tables, DTS Packages and Stored Procedures to populate Operational Data StoreMedical Services CompanySEP 2001 - JAN 2004Web Development and Database Administration Team Leader . Lead Development effort to transfer Legacy Application Data to SQL Server Database. . Created the logical and physical design and implemented and promoted from the Development, QA and Production Environments. . Created queries from the legacy system to generate text files, created DTS Packages to load Tables from text files and created Stored Procedures and UDF's for an ASP.NET/VB.NET SQL Server Application that interacted with Insurance Adjusters, TPA's & Pharmacy Benefit Management System (PBMS) and customer service . Translated conversations and quickly created functional Relational Databases . Created Database Objects, Constraints, UDF's, Stored Procedures, Views and Triggers . Gathered requirements and created a Prototype using VB.NET for an application that provided the functionality to search and drill down on Insurance Companies and TPA Regions Adjusters, Patients, Claims and generate Pharmacy utilization Reports . Gathered requirements and led the development effort for a ASP.NET /SQL Server component that processed Pharmacy Orders, rejects and overrides, generated e-mails to the adjusters for authorizations of medication outside the formulary, displayed and printed unpaid, overpaid or partially paid invoices and interfaced with a PBMS . Created tables to store & report medical billing (HCFA 1500) data to include HCPCS, CPT & ICD 9 Codes. . Created queries from Accounting Legacy Systems and imported into Great Plains. . Provided Technical Support for ADP and migration to Ceridian.BellSouth (Contract)MAR 2001 - SEP 2001SQL Server DBA/Developer . Worked in a SQL Server Environment with data feeds into SQL Server from Oracle, Teradata, DB2, and Informix Data Sources . Developer for Bellsouth and Singular Small Business Marketing Rebates Applications . Created Stored Procedures and wrote VB Modules to extract service orders to determine the number of activations and disconnects and generate excel objects that are e-mailed to the customer and posted to the STARS Web Site . Developed project specifications Developed scripts to initiate FTP Sessions . Developed Stored Procedures and Visual Basic Programs that dynamically created Excel WorksheetsTeleHealth Inc.FEB 1999 - MAR 2001Systems Engineer . Responsible for the development of logical data models and the creation of physical database designs . Created tables, Indexes, Constraints, Stored Procedure, Views and Triggers . I created a program that captures Health Level 7 (HL7), Admission, Discharge and Transfer (ADT) messages and store into SQL Server to enable patients to rent their telephone/television and provide billing information feeds to the vendor . Developed an automated Simulcast (Phone and TV) Hospital Customer Satisfaction Survey Component for Baptist Health Jacksonville . Developed Application that captures payroll and sales information extracts data from a locked down Excel Workbook and creates a text file, e-mails text file attachment using MAPI to a Server to import into SQL Server, validate and process the data and load into J.D. Edwards. . Developed Crystal Reports for Digital Video on Demand System and Customer Satisfaction Reporting. . Created VB/SQL Server Credit Scoring Program for Dunn & Bradstreet Application. . Provided Technical Support for ADP Payroll and Human Resource System.EDS (Contract)AUG 1998 - MAR 1999Systems Engineer . Developed a VB 4.5/SQL 6.5 Server application by creating COM Objects and writing ADO . Wrote code to Push Data to General Motors FTP SitePennsylvania Department of Commerce and Community & Economic DevelopmentJUL 1987 - AUG 1998Computer Systems Management Trainee/Systems Analyst I - IV (DesignParenthetical)/DBA/Developer . Lead DBA/Developer/Architect responsible for the analysis, design and development of all database applications . Responsible for all phases of the System Development Life Cycle . Designed and developed conceptual, logical and physical data models and implemented physical design . Integrated disparate databases into single databases and from various file formats . Imported and Exported Data to and from Oracle . Created Tables, Views, Procedures, and Triggers . Created Several Databases for Economic Development and Community Affairs . Developed reports for various revolving loan programs using Crystal ReportsUS Army Reserve (Activation)NOV 1990 - NOV 19911LT Finance & Accounting Officer . Responsible for all sections of Military and Civilian Pay, Control, Finance Services, Reconciliation, In-Out Processing, Travel, Commercial Accounts and the Finance Crisis Coordination Center . Operations Team Leader for Mobilization and Demobilization of Soldiers for Finance Processing . Performed the duties of a vacant GS-12 Information Technology Civilian Position . Wrote various Finance and payroll programs to calculate Variable Housing Allowance and Separation payments during demobilization when the IBM Mainframe crashed during demobilization operations |
