Applications Specialist (Senior Database Administrator) Resume

SUMMARY

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

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Applications Specialist (Senior Database Administrator)

Confidential

Responsibilities:

Act as lead on numerous data related projects including but not limited 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

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