We provide IT Staff Augmentation Services!

Database Administrator Resume

Folsom, CA

SUMMARY:

  • Repeatedly demonstrated simultaneous handling of multiple assignments with deliverables causing minimal disruption to users.
  • Accomplished career in SQL Server database warehousing, database design/architecture, data conversion from legacy systems, query and performance optimization.
  • Proven ability to navigate complex IT environments.
  • Database Administration
  • Extract, Transform and Load (ETL)
  • Client Needs Analysis
  • Business Intelligence (BI)
  • Data Mining
  • Database Reverse Engineering

EXPERTISE IN:

Microsoft SQL Server Database Architecture Data Analysis ETL T - SQL

TECHNOLOGY SNAPSHOT:

SQL Server 2005/2008/2012/2016 , Azure SQL, SQL Server on Virtual Machine, SSRS, T-SQL, DTS, OLTP, MS Access, VBA, Active Directory, XML, Extensive use and knowledge of data mining in SAP using Oracle database on UNIX and Windows platforms, Optiva, Visual Basic, Omnis Studio, 4th Dimension, DataStage, Infor VISUAL, Motorola MC9200 Handheld Computer

PROFESSIONAL EXPERIENCE

Confidential, Folsom, CA

Database Administrator

Responsibilities:

  • Ad hoc and automated reporting using SSRS.
  • Implementing SSIS packages.
  • Work with off shore resources to deploy code changes.
  • Troubleshoot database issues - SQL Server on VM, Azure SQL

Confidential, Louisville, KY

VB.NET Programmer

Responsibilities:

  • Modified existing Visual Basic code to operate on new replacement Motorola MC9200 handheld computer scanners used for inventory movement.
  • Added features to read new 2D format barcodes in addition to existing 1D barcodes - VB code determines barcode type.

Confidential, Louisville, KY

SQL/VBA Developer

Responsibilities:

  • Developed TSQL and VBA processes to scrub data and automate entry of proprietary, industry specific spreadsheets into Infor VISUAL tables bypassing ERP interface.
  • Reverse engineering of VISUAL processes.
  • In depth forensic analysis of Infor Visual structures as table relationships were not typical parent/child architecture.
  • Using SSRS created reports and dashboards for Finance, Engineering and Manufacturing.

Confidential, Louisville, KY

ETL Analyst

Responsibilities:

  • Corrected failed ETL processes.
  • Create new and modify existing reports in SSRS.
  • Reporting system in development - identify information and create process to extract from legacy retail sales system with Pervasive database.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

  • Forensic ETL between two third party applications.
  • Extract from Taleo with minimal documentation, transform and selectively load into SuccessFactors.

Confidential, Elizabethtown, KY

Database Administrator

Responsibilities:

  • Create new and modify existing reports in SSRS.
  • Produce Excel spreadsheets based on ad hoc queries against SQL Server 2005/2008
  • Responsible for database issues for largest commercial bank client.
  • Review T - SQL code produced by offshore resources.
  • Triage problem tickets.

Confidential, Fort Knox, KY

ETL Analyst

Responsibilities:

  • Created BI data warehouse structures in Oracle
  • Designed processes in IBM DataStage 8.1 to combine information from Oracle, Sybase, SQL Server 2008, Excel and text file sources into tables suitable for long term data analysis.

Confidential, Elizabethtown, KY

Data Warehouse

Responsibilities:

  • Developed purge process to copy inactive/aged information from production database to archive database.
  • Designed de - normalized archive database on linked server to retain relevant information as determined by business.
  • Purge process deleted related table information to prevent orphan records; process in archive database deleted records at end of retention period.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

  • Preparation of electronic transmissions. Assisted web developers with T - SQL (SQL Server 2000) performance issues, creation of complex SQL queries.
  • Manually prepared contract/plan/pharmacy/drug pricing submissions to Centers for Medicare and Medicaid Services (CMS).
  • Developed automated CMS submission to replace manual process.
  • Enhanced existing pharmacy networks application to synchronize pharmacy rate and fee information with pharmacy claims processor.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

  • Performed database administration for multiple servers located on three continents.
  • Provided trouble shooting assistance with database, web and terminal servers.
  • Wrote DTS packages for real time data access from SAP databases.
  • Migrated databases from SQL Server 7 to 2000, 2000 to 2005.
  • Utilized virtualization to create autonomous testing, development and small scale production environments. Configured SAN for optimal performance.
  • Determined appropriate equipment, wrote and implemented conversion plan for software upgrade and new hardware installation which resulted in no service interruption for users.
  • Converted chemical formula information from several legacy systems located on three continents in various languages to standard database table formats - retaining native language instructions.
  • Refined data conversion procedures to include audit and accountability for data migration from legacy systems.
  • Utilized linked servers, DTS packages and T-SQL code to extract, transform and load data warehouse.
  • Configured primary database server as failover cluster for high availability, used replication to remote warm site for disaster recovery.

Confidential, Louisville, KY

Access Application Developer

Responsibilities:

  • Added functionality to existing help desk application to produce metrics and email results to user defined addresses.
  • Converted from Access database to client server architecture using SQL Server 7.0.
  • Interfaced with AS400 DB2 tables using ODBC.
  • Used Access to run DB2 processes.

Confidential, Louisville, KY

Application Developer

Responsibilities:

  • Utilizing Access, Visual Basic and 4th Dimension developed new, or added functionality to existing applications for manufacturing, publishing and printing companies.
  • Working with top level management, developed an Access application to quantify employee work output during a given time period. User customized reports were developed for each department to objectively assign a value to the work performed. System was extremely adaptable in that reporting criteria and format could easily be changed without programming.
  • Increased performance of an in - house developed 4th Dimension application for tracking job reworks. Added functionality and trained in house personnel on advanced features of 4th Dimension.
  • Developed Access app for tracking inventory and projecting sales at remote location for printing company.
  • As part of a team developed a Visual Basic application for magazine layouts. Software used ODBC, RDO and file transfers to move information from/to AS400 DB2 tables and SQL Server 6.5 tables. Primary administrator for SQL Server 6.5.

Confidential, Louisville, KY

Automation Consultant

Responsibilities:

  • Based on forms and workflow developed by Central Admissions Department - automated the patient referral and admission tracking system using Omnis 5.
  • Utilizing a centralized tape backup system - desktop computers were automatically backed up and backups maintained by the Records Retention Department.
  • Converted manual graphic arts department to computerized equipment including scanners, laser typesetter and slide imager.
  • Strategic Planning Committee member.

Hire Now