Overview

The Database Developer builds databases and applications that ensure optimal functionality of the server environment and contributes to accurate, timely delivery of client project data.

Essential Duties and Responsibilities

• Identifies/develops database schema, functions, and procedures
• Automates and optimizes data transfer with multiple sources such as Azure SQL, MySQL, SQL Server, flat files, etc. using queries, PowerShell, and Azure Data Factory
• Builds and maintains deployment pipelines for database projects using Azure DevOps
• Creates and debugs custom queries and stored procedures for disparate data sources
• Processes ad hoc data import and export requests
• Identifies weak/churning code deficiencies and works with team to improve vulnerable sections
• Troubleshoots applications to provide strategic direction and implementation of solutions
• Develops methods of aggregating customer data for analytical purposes
• Identifies and adopts new development methodologies, best practices, and tools
• Contributes to work estimates, designs, policies, and documentation
• Develops demos/proofs of concept at the application and/or data persistence layer
• Designs metric reports, strategy, and procedures for interpreting results/performance/security at an advanced level that spans data persistence layers
• Designs and implements technical documentation for all internal and client-facing projects

Qualifications and Experience

• Bachelor’s degree in computer science, software engineering, computer engineering, and/or related field and 3+ years of experience as a combination of database administration and development in a live production environment in information technology, finance, analytics, and/or statistics, or equivalent combination of education and experience
• Experience efficiently working with large datasets.
• Ability to define problems, collect data, establish facts, and draw valid conclusions that demonstrate good judgment.
• Ability to proactively manage workload and priorities with minimal supervision.
• Strong experience database testing, including structural, schema testing and automated unit testing. Experience with test driven database development desired.
• A strong level of proficiency is required in the following areas:

 

• Microsoft Azure SQL Databases
  • Database modeling and design
• Performance tuning & optimization
  • Indexing
  • Query tuning
• Unit testing principles, database unit testing
• Data Encryption Fundamentals
• Database Documentation, including data flow diagrams and entity relationship diagrams
• Database stored procedures, user-defines types, user-defined functions
• Handling sensitive customer data
• Experience working with Visual Studio 2017-2022 Data Projects, ADO, GIT

 

 

• The following skills are preferred but not required:
  • Azure Synapse Analytics (Pipelines/Analysis Services)
  • C#, Java, or other OO language
  • Advanced Security
  • Data warehousing
  • Cloud (Azure) Data Environments
  • Integrating with third-party systems
  • Google Analytics
  • Azure Data Lakes
  • PowerShell
  • .NET Core
  • UML or similar