Sql Developer Data Engineer

Robert Bass

*** ********* ***** ******, ** ***** 919-***-**** *******.****.**@*****.***

SUMMARY

Database / infrastructure engineer looking to enhance programming and development skills in the right environment. Fast learner adept at picking up new skills quickly while performing effectively. 9 years of professional experience in eor and tax services. 9 years of experience in query tuning debugging, elt, and ssis in high demand environment. 5 Years of experience with database administration.

RELEVANT EXPERIENCE

DBA / SQL Developer / Data Engineer 7.2018 – present

Front Rush / NCSA / IMG Academy, Raleigh, NC

● Manage DB Servers / clusters make sure they are optimally working

● Construct high performance queries, and ensure data integrity

● Debugging of existing code –find and fix bugs, and optimize

● Generate complex test data and run tests to ensure good quality code

● Optimize in-application SQL statements as well as stored procedures

● Managing and Developing SSIS packages

● Develop and maintain ELT processes

● Handle common database maintenance such as upgrade., patching, backup, recovery, migration, etc.

●Analyze db for performance

●migrating EC2 DB instances

●migrating EC2 to RDS

● migrating Postgres with PGdump

●Disaster recovery

●Experience with setting up and maintaining CDC

●Experience with AWS; Redshift, Airflow, Auora Postgres, DMS, and RDS

●Experience with Terraform

●Experience with git hub

●Experience with optimization of Databases for resizing of server instances

●Setting up MSSQL read-replica

SQL Developer 10.2015 – 7.2018

Headway Workforce Solutions, Raleigh, NC

●Construct queries, and ensure high performance for these queries

●Debugging of existing code –find and fix bugs, and optimize

●Generate complex test data and run tests to ensure good quality code

●Write and optimize in-application SQL statements as well as stored procedures

●Prepare documentation and specification for reporting

●Built complex SSRS business reports for senior business audience, including directly to the CFO and CFO

●Train other employees on writing simple to moderate SQL queries

Education

●Completed 90 hours towards degree 08.2007 – 11.2010

●Bachelors of Industrial Design

●College of Design

●North Carolina State University Raleigh, NC

SKILLS & ABILITIES

●MS SQL (2000,2008,2014,2016,2019,2022)

●Python

●Postgres SQL (13,14,15)

●Terraform

●Stored Procedures

●SSRS (SQL Server Report Services)

●Crystal reports

●AWS

●Migrations

●PG Dumps

●Optimization sql databases

●airflow

●kubernetes

Contact this candidate