SUMMARY

• Highly motivated Full - Stack DBA/ Data Engineer/ SQL Developer with four years of experience in Database Administration, eight years of Data Analysis and SQL Development; as well as twelve years of experience in Information Technology.
• Demonstrate leadership abilities, team-work skills, mentoring, and the ability to accomplish timely tasks under minimal direction and supervision; diligently and efficiently.

TECHNICAL SKILLS

• Operating Systems (Windows Server OS; Windows OS, ESXI 6.5e).
• Database Management (DBMS - SQL Server Management Studio, DbVisualizer).
• SQL Server 2008 R2, 2014, 2016, 2019, Azure SQL, Confidential (working knowledge).
• Languages: Windows PowerShell Scripting, familiarity with dbatools, SQL, and Command Shell Scripting (bat scripts). Working knowledge of C#, and Python.
• ETL Development - Proficient with SSIS, and have working knowledge of Spoon. Also familiar with SQL Server Migration Assistant.
• Reporting - SSRS and SSRS Sharepoint Integrated Mode, Cognos, Crystal Reports, Tableau (working knowledge).
• Systems Administration- (VCenter/VSphere/VMWare).
• Active Directory knowledge.
• IIS Management; SharePoint.
• Project Management (Scrum / Agile and Waterfall Methodologies), JIRA, Wrike, and TFS.
• ERP Implementation and Administration (e-Automate, Sage X3).
• Organization/Time Management.

PROFESSIONAL EXPERIENCE

Sr. Data Engineer

Confidential, Phoenix, AZ

Responsibilities:

• DBA responsible for implementation, security and integrity of Databases, Data Lakes, and Data Warehouses.
• Responsible for upgrades, patching, and moving of data (Loading, ETL, Backup/Copy or Move/Restore/Delete type scripts).
• Responsible for SQL Server Data Migration into Azure SQL.
• Responsible for upkeep of Database Maintenance, Indexing, Performance Tuning, Job Alerts (notifications of failures and successes; as well as any changes/modifications to existing jobs), Backups and performing Restores in multiple environments to ensure success for Disaster Recovery possibilities.
• Responsible for Database design: modifying/altering and creating tables, columns, and data types to ensure application integrity.
• ETL Development - create new packages and modify existing packages responsible for moving data from our Confidential backend to our SQL Server Lakes to our Data Warehouses, and then aggregating into Data Catalogs. Develop data sets based on business process criterion, and allow our data feeds to pull from said data sets into the web-app catalog. Also responsible for troubleshooting SSIS Job performance and efficiency.
• Responsible for Replication - creating publications and push/pull subscriptions (depending on server loads), deleting subscriptions, and reinitializing when needed.
• Also responsible for distributor database housekeeping.
• Responsible for Failover Clusters, Always On High Availability Groups and Replicas/Databases for Disaster Recovery as well as readily accessible data.

Database Administrator

Scottsdale, AZ

Responsibilities:

• DBA for roughly one hundred databases - Responsible for database health - analyze cost efficiency of scripted queries, re-indexing a Database, rebuilding heavily fragmented tables, reorganizing tables, creating stored procedures, creating functions, creating triggers, creating views, SQL development, and database architecture.
• Responsible for Performance Tuning when needed.
• Designing Databases, and setting object data types to correlated needs. Setting Primary and Foreign Keys/Constraints.
• Performing backups and restores (when needed).
• Responsible for replication - creating pull subscriptions, deleting subscriptions, and reinitializing when needed.
• Responsible for log shipping in terms of disaster recovery.
• Managing security - creating / managing logins and responsibilities.
• Application debugging with Visual Studio; stepping into C# code, and determining where the problem lies.
• Project Management duties – I manage our Team Foundation Server work; and allocate responsibilities to coworkers ranging from development to user testing.

Business Intelligence Analyst

Confidential, Lubbock, TX

Responsibilities:

• DBA for 3 Database Servers - Responsible for database health – analyze cost efficiency of scripted queries, re-indexing a database, rebuilding heavily fragmented tables, reorganizing tables, creating stored procedures, creating functions, creating triggers.
• Application Systems Administrator – solving problems on the back end in SQL Server 2008 R2, and SQL Server 2016 to fix deadlocks and errors on the front end of the application (e-Automate and Sage X3); as well as creating and altering Stored Procedures, ETL data using Spoon (Pentaho), and creating and altering reports in Crystal Reports.
• ERP implementation using Scrum and Agile Methodology (from e-Automate to Sage X3).
• Analyzed contract data and service level agreement data for our customers, which led to an increase in profit and revenue in the millions of dollars.
• Process reports for Executive leadership to steer the company in a positive direction.
• Maintained Web Applications via IIS (Internet Information Services). Also configured sites via SharePoint - editing our employee lists, delegating permissions, creating new rows and columns for new territories and employees, and overseeing document management.
• Systems Administrator for e-Automate and Sage X3; as well as a Systems Administrator for Confidential Infrastructure – servicing over 350 employees; and managing over 54 servers/cluster environments.

Support Engineer

Confidential, Lubbock, TX

Responsibilities:

• A leader of the Toshiba Support Group. Provided customer support, and delegated tasks to employees.
• Provided Server, Terminal, Network, and Back Office Support for our customers.
• Analyzed SQL (SQL Server, and SQLite). 4690 OS and ISS45 (application) Reporting is structured data -SQL. Arranged data for reporting to our customers. Altered Data to rebuild sales if needed.
• Project Management – oversaw implementation and installation for several thousand stores.
• Wrote documentation for company use; as well as helped establish a Knowledge Base for a growing company.