We provide IT Staff Augmentation Services!

Database Administrator Resume

Little Rock, AR

SKILLS

  • Microsoft Office - Microsoft Project - SharePoint - Microsoft Visio
  • SQL 2008 - DB2 - Access - C# - VB .net - COBOL - 370 Assembler
  • Micro Med - NextGen - SAP - SSRS - SSIS - SSAS - CA Erwin - PowerShell

EXPERIENCE

Confidential, Little Rock, AR

Database Administrator

Performed Database Administration, BI Architect, Data Warehouse, Data Modeling (Conceptual, Logical and Physical schemas), Data Migration, Data Integration, Database Design, Documentation, VB .net Development, C#, SSIS, SSRS, SSAS, PowerShell, Agresso, ARC Reporting

Individual projects:

  • Custom Program Development C# & VB .net (Automation & Interfaces)
  • Agresso System Automation
  • Bank Rec Statements Import .
  • VB.net and T-SQL Development
  • Check Processing various Countries
  • VB scripting and T-SQL Development
  • Web Interfaces (ASP, API’s)
  • Data Integration with Agresso from multiple packages
  • Windows Development

Confidential, North Little Rock, AR

IT Manager

Performed Database Administration, BI Architect, Data Warehouse, Data Modeling (Conceptual, Logical and Physical schemas), Data Migration, Data Integration, Database Design, Documentation, Project Management, IT Resources, Network Design and POS, SSRS, SSIS, C# .net Development, VB .net Development, Access

Individual projects:

  • Developed and Implemented Database Backup and Disaster Recovery strategies.
  • Developed Documentation regarding Operating Procedures and Technical Manuals.
  • Produced Documentation providing justification of technology implementation to executive staff.
  • Was proactive in Database performance monitoring and fine tuning
  • POS - Setup for new stores:
  • UPS - Generator and Labels by Design
  • C#, VB .net and T SQL Development
  • Analysis and Design of new Database with successful migration of existing data.
  • Redesigned and Installed new Infrastructure

Confidential, North Little Rock, AR

Contractor

  • Development of Data Warehouse and Datamarts
  • Collaborate with Business Owners, Application Developers and Architects in Design and Implementations.
  • Research, Benchmark, Document and Introduce New Technologies
  • Produced Conceptual, Logical and Physical Schemas of Databases
  • Developed Documentation regarding Operating Procedures and Technical Manuals.
  • Optimization and Performance Monitoring of Database
  • Conduct Database Capacity and Availability Audits
  • Developed and Implemented Database Backup and Disaster Recovery strategies
  • Network Installations
  • Network infrastructure design, performed needs analysis and system & security assessments.
  • Risk analysis, capacity planning
  • SharePoint installation and development.
  • Network Evaluations - Maximization of Productivity through Technology
  • Network Installation (Windows 2008, Windows 2003, Eleven Windows XP Workstations, Windows NT Workstation) File Servers, SQL Servers 2005, Exchange Servers, Switches, Cisco Routers, Symantec VPN's, Printers, Power Vaults, Active Directory 2003, Security Protocols, Third Party Software Analysis
  • System Programming
  • File Conversions, Database Conversions
  • Hardware Interfaces, Software Automation
  • Web Site Design and Development, Graphic Automation

Languages: VB, Visual C, C#, SQL, COBOL, DB2/UDB, HTML, Access, Data Stage, .NET, XML

Software: VISIO, MS Office, MS Project, Micro Med, Quick Books, Crystal Reports, Great Plains and some MS Dynamics AX with X++, CA ERwin

SharePoint Administration

  • Configuration, Installation and Management of SharePoint Server
  • Set up and Managed End User Accounts, Permissions and Access Rights
  • Created Reports for Users
  • Trained Users Created Documentation
  • Assisted Users in deploying Web Parts

Platforms: Windows 7, Windows Vista, Windows XP, Windows 2000, Windows 2003 Server, Windows 2008 R2 Server, UNIX System V,MVS/XA, DOS

  • SQL Database Administration
  • SQL Server Installation, Data Modeling, Importation and Extraction of Data, Reporting Capability, Administering Data Security, Architecture and Planning Recommendations, Develop the Logical Data models and Physical Designs, Managed Performance, Performed Backups/ Restores and Archiving of Data, Developed necessary ETL packages needed to populate multiple tables, System Performance and optimization, Document and Standardize Data Structures, Procedures and Processes
  • SMS, SCCM, SCOM, TMG
  • Upgraded SQL Server 2005 to SQL Server 2008
  • Used Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
  • Used the graphical Integration Services tools to create solutions
  • Developed SQL Reports utilizing SSRS
  • Designed and Developed Data Mart Indexing and Extraction System for Data Mining
  • Utilized BI tools in the Design and Development of Collecting, Storing and Delivering Decision Support Data at the Enterprise Level.
  • Systems Analysis & Design with Auditing Capabilities

Individual projects:

  • Took a company that was originally up for sale and redesigned their entire infrastructure, set up production control system with scanning capability to enable tracking production. Through the means of automation increase productivity to the point of the company being taken off the market and clientele being booked a month and a half in advance. The President of the company said that with the investment of equipment and my time the system would more than pay for itself in a year and a half.
  • Developed an entire system for medical clinic that took a patient from the time they entered the doors all the way through back-end billing.
  • Developed interface with EKG machine used during surgery imported readings into SQL database and graphed the readings out within the patients chart.
  • Developed Automation of Reporting through SSRS.

Confidential, Little Rock, AR

Director Information Systems and Communication

  • Recruit, train and motivate dynamic employees for optimum operations
  • Developed and Implemented Database Backup and Disaster Recovery strategies.
  • Developed Documentation regarding Operating Procedures and Technical Manuals.
  • Project Management
  • Research, Benchmark, Document and Introduce New Technologies
  • Establish, Maintain and Evaluate following of Processes and Procedures.
  • Proactive in Implementation of Database Performance Monitoring and Fine Tuning for Optimal Performance.
  • Performance Reviews of associates
  • Managed team of four individuals and acted as liaison to company of 240 associates
  • Coded tracking systems for problem tickets and resolution process
  • Established Information Systems Department from conception
  • Installation of VPN Clients, Cisco Switches, Routers
  • Developed EOB system allowing migration of collections into multiple clinics, improving collections by 35%
  • SMS - Pushed Updates to Workstations from the Server
  • Oversaw legality of licensing issues saving the company millions in possible fines
  • Upgraded Servers allowing much greater access speed increasing work-flow
  • Assisted in automation of payroll process
  • Evaluation and implementation of third party software
  • System Auditing

Confidential, Little Rock, AR

Senior Systems Analyst

  • Membership Eligibility for Data Warehouse
  • Trained team members in DB2 class training sessions
  • Analysis and Design
  • On-call Rotation
  • Maintained and Developed programs in COBOL, Focus, and Assembler (370), DB2
  • Project Lead for Membership Eligibility System
  • Core System modifications in 370 Assembler

Confidential, Little Rock, AR

Senior Systems Development Analyst

  • Analysis and Design
  • Data Conversions from existing client platform to Alltel platform
  • Program Development for IM and ST

Languages: COBOL & Assembler (370)

  • Assisted in Year 2000 Development
  • Data Conversion Process for new banks coming online
  • Development, Maintenance and Installation of features
  • Quality control testing

Confidential, Little Rock, AR

Programming Instructor

  • Oversaw project planning and student development
  • Developed curriculum that received rave reviews
  • Taught following courses:
  • Intro to Computers
  • C
  • Assembler (370)
  • COBOL II
  • Access
  • CICS
  • C-Shell
  • Bourne Shell
  • UNIX System V
  • System Administration
  • Systems Design
  • Performed student evaluation reports for hiring managers
  • Trained visually impaired individuals to program computers for IRS out of Washington D.C.
  • Managed daily processing needs

SUMMARY:

  • Fifteen years of IT industry experience with MS SQL Server 97/2000/2005/2008 , SSIS/SSRS/SSAS as SQL developer.
  • Expertise in scripting T-SQL queries, complex stored procedures, User Defined Functions (UDF), and Database Triggers.
  • Experience with complete SDLC, which includes requirement gathering, analysis, design, development, maintenance and implementation. Experience with Agile and Waterfall methodologies in approach to project development.
  • Extensive experience in Performance Monitoring and Tuning of SQL statements, Sub Queries, Joins, Cursors and Functions. Extensive experience in the development of backup and recovery process plans.
  • Experience in Data Modeling (Logical and Physical Design of Databases) using Visio/Erwin, Normalization and building Referential Integrity Constraints.
  • Experience in Data Modeling, Database Design, Programming and Implementation of Client-Server Applications and Database systems using MS SQL 97/2000/2005/2008 for both OLTP (Batch Processing, Online Processing) and Business Intelligence (SSIS, SSAS, SSRS) applications.
  • Expert in working with BIDS.
  • Experience using SQL Server DTS and SSIS for ETL process and constructing packages for deployment.
  • Expertise in developing reports using SQL Server Reporting Services and MS Excel Spreadsheets.

Hire Now