We provide IT Staff Augmentation Services!

Applications Specialist (senior Database Administrator) Resume

OBJECTIVE:

  • To obtain the position as a ETL Data Analyst within a professional growth oriented organization where I may exchange my years of experience and training for the opportunity to grow and enrich my skills sets.

SUMMARY

  • 24 yrs Experience Database Extraction Transformation and Load (ETL) for Electronic Data Interface (EDI) and Application Programming Interface (API) coding
  • 21 yrs. Experience Database Administrator / Database Engineer / Database Developer
  • 24 yrs.Experience Financial Analyst
  • 24 yrs. Experience Senior Level Data Analyst/ Database Script Developer
  • 24 yrs experience providing custom help desk support for database systems
  • 24 yrs. experience in Relational Database Administration
  • 24 yrs. experience designing Key Performance Indicator (KPI) Dashboard applications & Dashboard reports
  • 24 yrs. experience in Business Leadership Direction team environments
  • 24 yrs. experience creating and modifying advanced SQL report scripts and building complex senior VP level analytical reports
  • 24 yrs. experience performing data analytics, predictive analysis, and developing recommendations for business strategists and VP level decision makers
  • Ability to recommend system upgrades and enhancements for increased report performance and capacity planning to meet business growth analytical needs

TECHNICAL SKILLS

  • Tableau, NetSuite, SQL Azure Cloud Database, MS Excel, Micro Strategy, Hyperion, SSRS, SSIS, SSAS, Visual Studio, Great Plains Management Studio, Business Intelligence Studio, Report Builder, MS Access, ACT, Oracle, Oracle Warehouse Builder, TOAD (Tool for Oracle Database Administration), SQL Server, MS Query, SQL Plus, PL/SQL, Sybase SQL, Transact SQL, Embarcadero's DB Artisan, DB Change Manager, Red - Gate's DB Compare & SQL
  • HP-UX, AS400, Linux Red Hat, Sun Solaris Unix, Linux; Windows Server, Windows Advanced Server; Rational Clear Case, Rational Clear Quest, Visio, MS Office Professional: Outlook, MS Word, Power Point; Front Page, MS Publisher; Word Perfect, SAMS, Reflections and SAN EMC Storage, Share Point, Blade, Remedy, IDERA SQL Diagnostic Manager, SQL Sentry, Solar Winds, RedGate Monitoring, IDERA Database Tools, Cisco AnyConnect, Cisco VPN, Remote Desktop Administration, GoTo Meeting, Zoom, BlueJeans

PROFESSIONAL EXPERIENCE

Applications Specialist (Senior Database Administrator)

Confidential

Responsibilities:

  • Created multiple ETL EDI solutions for billing/accounts payable, operations, plus internal and external customers
  • Act as lead on numerous data related projects including but not limited to Tableau Reporting and SharePoint Administration
  • Support 24/7, high transaction, always on high availability SQL Server 2012, SQL Server 2014, SQL Server 2016 database environments
  • Provide Application Administration and Senior Level SQL Database Administration for Great Plains Dynamics, SharePoint and NetSuite Financials.
  • Support cloud based web applications, enterprise applications, & databases.
  • Utilize database administration, systems administration, and analysis skills.
  • Provide Data Architecture & Schematic Support. Perform Database Scripting, PowerShell Scripting.
  • Performed SQL Scripting to Tune Performance.
  • Applications Administration and Database Administration include: NetSuite, Tableau, Great Plains, SQL Server, Crystal Reports, SharePoint, IDERA Diagnostic Manager, SQL Audit & Salesforce.

Database Administrator

Confidential

Responsibilities:

  • Scripted stored procedures, triggers, views, reports and functions supported 24/7, high transaction, SQL Server 2012 & SQL Server2014 database environments performed senior level production SQL database administration duties responded to alerts on daily data jobs correcting errors and reinitiating jobs set up and maintained replication on SQL Server databases performed research in transaction logs, error messages and error logs provided 3 rd tier helpdesk support in response to all database issues performed DBCC Database Consistency Checks using system utilities designed maintenance plans, disaster recovery plans, optimization plans and back up plans tuned databases, restructured queries for developers to speed data result sets designed maintenance plans, maintenance jobs, recovery plans, and back up plans generated database schemas Entity Relationship Diagrams DBCC designed and created multiple data dictionaries installed Systems Admin Tools, SQL Server 2012, SSRS Reports Server, SSIS supported SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014 database environments supported Virtual Servers and Physical Servers

Database Administrator

Confidential

Responsibilities:

  • supported 24/7, high transaction, always on high availability SQL Server 2012 database environments performed senior level production SQL database administration duties responded to alerts on daily data jobs correcting errors and reinitiating jobs set up and maintained replication on SQL Server databases performed research in transaction logs, error messages and error logs provided 3 rd tier helpdesk support in response to all database issues performed DBCC Database Consistency Checks using system utilities designed maintenance plans, disaster recovery plans, optimization plans and back up plans tuned databases, restructured queries for developers to speed data result sets designed maintenance plans, recovery plans, and back up plans worked with other DBAs to set up and maintained SQL Server High Availability Groups, Databases and replicas designed maintenance plans, recovery plans, and back up plans generated database schemas Entity Relationship Diagrams DBCC designed and created multiple data dictionaries installed Systems Admin Tools, SQL Server 2012, SSRS Reports Server, SSIS supported SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014 database environments supported Virtual Servers and Physical Servers

Database Administrator

Confidential

Responsibilities:

  • performed senior level SQL database consulting on Database Upgrade and Database Migration Project researched thousands of undocumented database foreign key relationships researched table column id fields viable post migration replacement solutions for multiple production databases performed detailed research and analysis of database issues and pre migration issues designed custom migration scripts performed daily production database duties including database and system monitoring performed research in transaction logs, error messages and error logs analyzed database security and encryption options worked on database models: comprehensive and by subject matter areas coordinated and scheduled database jobs for database tuning and optimization best performance worked to ensure SQL Server databases utilized industry best practices standards worked to resolve locking and blocking issues; prevented orphaned records and data loss. worked remotely on secure network tunnels to perform database support performed DBCC Database Consistency Checks using system utilities designed maintenance plans, recovery plans, and back up plans

Database Administrator / Data Analyst / SSRS Reports Designer

Confidential

Responsibilities:

  • performed senior level SQL database consulting on GIS Project Mapping reports project designed, created, tested and implemented dashboard reports using GIS spatial data created test case scenarios and quality testing methods; performed quality assurance testing linked bank mortgage data from SQL Server 2008/2012 Databases to to GIS spatial reports so banks could log into a web application and visually see where they had housing, building or land assets which had been gained via repossession installed Windows Server, Systems Admin Tools, SQL Server, SSRS Reports Server installed all software and designed user web application interfaces and reports for bank clients acted as database engineer; remotely installed database server side software and remotely resolved database, database web based application and web based financial reports portal problems

Database Administrator / Data Analyst / SSRS Reports Designer

Confidential

Responsibilities:

  • performed senior level SQL database consulting on multiple technology projects. performed advanced Transact SQL Scripting to build data analysis Report Applications. performed data analysis daily and created scheduled data analysis reports for various company wide departments. designed automated Microsoft SQL Server 2005 & 2008 based data analysis reports which allowed clients to input information and return desired results. performed upgrade & testing of SQL Server Business Intelligence Reports. resolved Share Point document server support. acted as database engineer; remotely installed database server side software and remotely resolved database, web application and web based software financial reports problems performed database security; added users and maintained user and Vision database application role privileges remotely administered Share Point server and provided remote help desk in support of Share Point documentation server. performed remote help desk and system support. installed and configured SQL Server 2008 R2 tools for web reporting Interfaced application to present data analysis reports for CRM software. performed general database administration, database reporting and other computer technology duties as assigned

SQL Database Training Consultant

Confidential

Responsibilities:

  • performed SQL & other database technology training in individual and group settings provided instructional guidance in person and remotely performed beta testing of new database software performed consultations to identify needs based custom database training curriculum built websites acted as web master using tools including html, html5, java, javascript, python

Contract Data Consultant

Confidential

Responsibilities:

  • performed senior level SQL database consulting to the senior executive service (SES) level Chief Financial Officer and Assistant Chief Financial Officer and support staff of the Office of the Chief Financial Officer of the Confidential . increased accountability in the budgeting and cost management accounting process. performed integration of enterprise wide computer systems with very large SQL data warehouses and SQL database system back ends. performed computer technical software design of SQL Business Intelligence (BI) tools and decision support systems (DSS) for Senior level managers for rapid response decision making. performed full application and database design, creation, testing & implementation worked with ERSI GIS mapping tools and data sets to build location based reports capabilities to display GIS location data within dashboard reports utilized Oracle, PL/SQL, Hyperion, Brio, Ajax, Java, Java Script, HTML, HTML 5

DBA/ Data Analyst

Confidential

Responsibilities:

  • performed data analysis and maintained daily data report cycles performed project management and systems analysis to aid in the acquisition of new SQL database source feeds from over 85 data sources connected over 200 plus remote data sources and over time using SQL scripting and technology across various database platforms narrowed data source selection from 200 to 85 data sources performed review of complex statistical formulas and systems software developers code scripts prior to implementation to mission critical military systems performed management of a multiple state team of 25 technical and functional staff members including 4 - 5 database administrators on various project performed designed and implement new SQL processes, procedures, forms, work measurements tools to effect process improvement, work simplification, improvement of manual processes independently designed 2 full life cycle application BI business intelligence systems including front end application and back end databases. acted as database engineer; installed database server side software, installed patches and upgrade software; resolved database and database web based application portal problems performed database security; created and maintained user / role account privileges

Hire Now