SQL Developer
Intertec International
Aurora de Heredia, Costa Rica - Ultrapark Free Zone
hace 17 días

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.
  • Inscribirse
    Añadir a los favoritos
    Eliminar de mis favoritos
    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", acepto que neuvoo recolecte y procese mis datos de conformidad con lo establecido en su Política de privacidad . Tengo derecho a darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación