Database Developer Sql
Resume:
Shaun Sparks
Lincoln, NE *****
*****.******@*****.***
Professional Summary
Skilled Database Developer with 15 years of experience in designing, developing and optimizing database systems. Proficient in SQL, PL/SQL and associated technologies (Microsoft SQL Server, Oracle, MySQL and MariaDB). Long track record of working closely with cross-functional teams, completing large development and ETL projects, improving database performance and ensuring data integrity. Key Skills
-Proficiency in SQL, PL/SQL
-Database Design and Implementation/Data Modeling
-ETL Processes and Data Warehousing
-Performance Optimization
-Scripting and Automation
Professional Experience
Database Engineer - Penlink
JULY 2022 - present, Lincoln NE
Oracle database developer utilizing PL/SQL Developer, Oracle SQL Developer and SQL Plus. Designed solutions within specific requirements, providing estimates to project managers during sprint planning, creating stored procedures, packages, architectural additions/modifications, functions, triggers, creating Pull Requests (PRs), writing documentation and assisting QA engineers. Performed code reviews of PRs from other developers and Database Engineers. Collaborated with cross-functional development and project management teams to deliver within deadlines. Member of a principal team of Database Engineers that share knowledge between its members, tackle escalated issues in live customer databases, meet with Oracle representatives, and have feasibility discussions on new features and solutions.
Identified and resolved performance problems using execution plan analysis for query tuning, indexing strategies and data partitioning. Recommended necessary items for development to lead developers and project managers.
Setup and configured synchronized standby databases for replication and disaster recovery using Oracle Data Guard and Recovery Manager.
Database Administrator/Developer - Senior Market Sales SEPTEMBER 2020 - JULY 2022, Omaha NE
Created and oversaw database backup and restore tasks. Identified, tracked and resolved database related issues, incidents and requests, filling requests and resolving incidents.
Performed query tuning and performance optimization. Monitored, analyzed, recommended and implemented solutions.
Worked closely with software and project management cross-functional teams. Created SQL statements, stored procedures, functions and related T-SQL activities. Mentored and collaborated with developers on database development techniques. Developed automation scripts, Extract-Transform-Load (ETL) and reporting solutions. Provided communication to IT to make decisions and assist in resolution. Researched and monitored new database features and methodologies. Presented applicable concepts to the IT teams, assisting in bringing database methodologies up to current industry best practices. Developed SSIS packages, including managing SQL Agent jobs. Performed regular maintenance (e.g. backups, index maintenance, etc.) on corporate databases to ensure optimal performance.
Continued training in cutting edge SQL Server development, such as plan cache strategies and query optimization and index tuning.
Database Administrator/Database Developer - Macpractice MARCH 2018 - SEPTEMBER 2020, Lincoln NE
Reviewed and authorized all schema and code changes to the database proposed by the engineering team.
Conceptualized, designed and strategized upcoming products and features. Designed data models and created DDL scripts for
Built database schemas, tables, views, stored procedures, triggers, cursors, SQL and dynamic SQL queries and indexing strategies for new products and features. Authored entity relationship diagrams and other documentation for new products and features. Analyzed expensive queries and recommended index strategies and code adjustments. Moved performance cost from the application to the database through DB and SQL solutions to improve slow reporting issues for end users.
Designed ETL process to extract data from EDI files converted to JSON objects into staging tables, transforming data through automated SQL scripts to load into a warehouse environment. ETL Developer/Data Analyst - Blackbaud
OCTOBER 2016 - FEBRUARY 2018, Lincoln NE
Worked in a cross-functional team that designed and built a new unified data model (UDM) based on dimensional modeling for source agnostic ETLs and scripts for legacy ETLs. Created conformance layers of views and synonyms for an incoming source system for UDM and performed data reconnaissance against new DBs.
Created tables, views, indexies, SQL queries, stored procedures as required. Responded to off-hours notices of failed jobs or other errors and performed necessary tasks to solve issues and restart jobs.
Performed investigation and troubleshooting of problematic SQL queries. Managed and performed onboarding of first client databases to UDM and worked with the project team to assess and address related issues.
Created custom exports using T-SQL and XML jobs.
Created data translation maps for onboarding source systems. SQL Developer/Data Analyst - Aviture
SEPTEMBER 2014 - JULY 2016, Omaha, NE
Analyzed and identified anomalies in customer systems and corrected erroneous data on production sites.
Assisted implementation team with customer onboarding by developing scripts to populate customer databases.
Performed various database administration roles including permissions and user management, scheduled backup management, and DB restore
Project Manager/Software Support Specialist - Decision Logic FEBRUARY 2011 - SEPTEMBER 2014, Lincoln, NE
Managed and directed customer onboarding process and established regular communication with customers during.
Organized requirements for the development team to streamline onboarding while continually developing custom SQL scripts to fulfill special requests. Managed project plans for integration process for customer 3rd party systems while managing other customer unique processes via in-house applications. Provided Tiers 1 and 2 support for customer issues. Education
Northeast Community College / Associate of Arts and Sciences May 2000, Norfolk, NE
Associates degree in Audio Recording Technology
Doane University / Bachelor of Science (MIS)
May 2011, Lincoln, NE
Bachelors Degree in Management Information Systems Microsoft Academy / MTA Database Fundamentals
March 2016, Online
Brent Ozar Unlimited / SQL Server Training
April 2022, Online
Contact this candidate