Position Type : Description :
Description : Job Description :
Job Description :
The Database Developer will assist in the conversion of Stored Procedures, SQL Views, and Functions from a legacy database model to a new, optimized and highly normalized physical schema.
The goal of this activity is to minimize code changes to applications calling these database objects with the migration from the legacy databases to a new consolidated database schema.
Involved in the duties performed by the Database Developer will be a base understanding of the new schema, table relationships, ability to decompose a programmatic database object and remediate so that the object can retrieve or insert / update the same data elements as previous, using the new schema.
The Database Developer will participate with a remote team in Tampa, FL on this project using the Kanban approach for work management.
This position will report into a Software Engineering Team Lead at the Tampa location.
Essential Job Functions (in addition to the Job Description already in place for the team members)
Remediate outstanding programmatic database objects to utilize the new database schema, returning the same result set, as the original object does using the legacy database, to the calling applications or accept and insert / update the new database schema
Ensure performance, security, and reliability of remediated programmatic objects from legacy object to remediated object
Ability to quickly understand database models and relationships, conceptually, to access and store data reliably during the remediation of programmatic objects
Collaborate with other team members and stakeholders
When needed, ability to profile server usage and optimize programmatic objects to tweak as necessary
Interfacing with our Azure Devops instance, utilizing Git for source control, add all remediated objects to the database project and ensure reliable builds occur.
Experience in the following areas is required :
Strong proficiency with Microsoft SQL Server in general, good knowledge of SQL Server 2017 and ability to understand features in this latest version of the database engine to leverage during the project
Expertise with modern relational databases
Expertise at optimizing large, complicated T-SQL statements
Mastery of the T-SQL language and strong knowledge of tradeoffs when choosing a specific development solution (i.e., scalar functions vs.
table-driven functions, placement of WHERE clauses in a query, etc.)
Knowledge of best practices when writing programmatic objects on a mission-critical relational database
Capable of troubleshooting programmatic object performance issues and table locking scenarios (deadlocks)
Familiar with tools that can aid with profiling server resource usage and recommending ways to optimize
Proficient understanding of code versioning tools (Git) as well as branching and merging operations
Ability to communicate effectively both in written and verbal form
Ability to collaborate effectively with remote teams :
SQL Server SQL Agent and other Automation tools.