We provide IT Staff Augmentation Services!

Database Administrator Resume

SUMMARY

  • I'm experienced in business reporting, business process automation, OLTP, OLAP, BI, DWH, and ETL.
  • The data layer of systems I've written have been largely within MSSQL 2005/2008/2012, with ETL and application layers in Java, VBA, XML, and/or PHP, depending on business requirements.
  • Taking simple data storage and adding OLAP and BI capabilities enabled many small and medium operations in the past to double their business without expanding labor hours.
  • Reporting experience through the career includes SSRS and web - based PHP reports.
  • Data integration and data mapping from source data experience includes SSIS, Confidential products, and custom software configuration.
  • Experience working with structured and unstructured data in ETL and reporting environments. I've also written SQL triggers for logging, ETL, and data consistency purposes.
  • I've also maintained cubes in SSAS, and provided additional functionality through this role as well.

TECHNICAL SKILLS

  • Solution Design
  • Systems Analysis
  • ETL
  • Business Reporting
  • Data Mining and Integration
  • Microsoft SQL Server (2000-2016)
  • SSRS (2005-2016)
  • SSIS (2005-2016)
  • Oracle SQL (9i-12c)
  • SQL Tuning
  • XML
  • Data Analysis
  • Data Warehousing
  • JavaScript
  • PHP
  • Agile Methodologies
  • Business Intelligence
  • Crystal Reports (11)

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

  • Maintained databases within two domains.
  • Developed links between all networks for remote site reporting.
  • Created powershell infrastructure to deliver flexible system reporting.
  • Aided Loss Prevention with reports.
  • Compensated for Retail software shortcomings through procedures and triggers.
  • Finished ASP.NET website project to replace legacy Excel system.
  • Advanced IIS configuration for use with windows credentials, ASP.NET, and PHP systems.
  • Developed PHP/MSSQL website to support program management using flexible data tracking.
  • Centrally managed store database corrections and sales setups through procedures and ad hoc queries.
  • Deployed automated database maintenance procedures (indexes/stats/backups).

Confidential

BI Developer

Responsibilities:
  • Developed SSIS packages and SQL-based structures and solutions.
  • Analyze and design ETL packages, scripts, and custom functions.
  • Design and Deploy new infrastructure for ETL which remains flexible despite schema changes.
  • Performance tuning in a constantly changing environment.

Confidential

Application Developer II

Responsibilities:

  • Further exposure to medical, claims, provider, patient data.
  • Review and develop C# and Java code for ETL platform.
  • Review, create, and optimizeOracle SQL queries and stored procedures.
  • Performance tuning and review of Java-based ETL processes.

Confidential

SQL Developer

Responsibilities:

  • Create and optimize SQL triggers, and stored procedures for a web based education service.
  • Consult with Agile development teams as member of DevOps on matters relating to database design and maintenance for performance considerations.
  • Support leadership through ad hoc ETL processes.
  • Ensured compliance with state requirements through constant development of trigger-based migration platform, and advised on second version to alleviate the maintenance overhead.
  • SQL Server and SSMS versions in use: 2008R2 and 2012, with one migration project from a legacy SQL 2000 server.
  • Use of TFS for source control and environment promotion of code.
  • Assisted in managing replication issues setup by the DBA on 2008R2.
  • Trained reporting team on performance techniques for queries.
  • Occasionally assisted reporting team using SSRS 2008

Confidential

Project Engineer

Responsibilities:

  • Create and optimize SQL views, and stored procedures for a server-based application.
  • Extended positional tracking software to enable region-based billing in near-real-time.
  • Support for Auxilliary Microsoft Access databases individual clients maintained for reporting or other purposes. Integrated data between their SQL Server and MS Access. (2003-2008)
  • Work with clients to analyze, trouble-shoot, and resolve client reports and requests.
  • SSIS 2008 and 2012 work to correlate multiple data sources into the application's database.
  • SSRS (2008 and 2012), Report Builder (2008 and 2012), and Crystal Reports (11) use to support client and business needs.

Confidential

Senior Consultant

Responsibilities:

  • Worked 100% remote with few exceptions.
  • Lead developer on the XML ingestion project, enabling multi-state tenancy to support business goals of expanding state coverage by 1/3.
  • Data analysis of data sources from disparate schemas for the purpose of constructing ETL processes into our central schema.
  • Served primary-contact role for SQL development questions, advice, and assignment for custom SQL project development on 2005 through 2012
  • Bridged multiple data sources into the destination database, often times from mixed systems such as Microsoft Access, SQL Server, and Oracle.
  • Employed Rapid Development and SDLC methodologies to design, develop, test and deploy ETL solutions for remote clients.
  • Consulted and supervised sub-contractor development.
  • Developed BI reports for clients and business employing SSRS (2005-2008), PHP, JavaScript, and dynamic AJAX systems.
  • Configured SSIS (2005-2008) packages for custom integration projects.
  • Developed office productivity tools using a mix of Java, XSLT, and SQL, for analysis of ETL solutions provided by third parties. These tools were proven to reduce analysis time of the solutions and reduced error rates.

Confidential

Data Integration Engineer

Responsibilities:

  • Lead developer on the XML ingestion project, enabling multi-state tenancy to support business goals of expanding state coverage by 1/3.
  • Data analysis of data sources from disparate schemas for the purpose of constructing ETL processes into our central schema.
  • Served primary-contact role for SQL development questions, advice, and assignment for custom SQL project development on 2005 through 2012
  • Bridged multiple data sources into the destination database, often times from mixed systems such as Microsoft Access, SQL Server, and Oracle.
  • Employed Rapid Development and SDLC methodologies to design, develop, test and deploy ETL solutions for remote clients.
  • Consulted and supervised sub-contractor development.
  • Developed BI reports for clients and business employing SSRS (2005-2008), PHP, JavaScript, and dynamic AJAX systems.
  • Configured SSIS (2005-2008) packages for custom integration projects.
  • Developed office productivity tools using a mix of Java, XSLT, and SQL, for analysis of ETL solutions provided by third parties. These tools were proven to reduce analysis time of the solutions and reduced error rates.

Confidential

Developer

Responsibilities:

  • Developed a database application in MS Access for tracking patient information, patient procedures, doctor's orders and approvals, and nurse scheduling.
  • Involved heavy use of sub-classed historical events records, and VBA procedures to control (and occasionally re-write) report behaviors.
  • Wrote the comprehensive User Guide for this Clinical Services Tracker, and provided on-call support via email for the numerous forms and reports built into the system.

Hire Now