Database Developer (SQL Server / PostgreSQL, Dagit / Airflow)

Job Title: Database Developer (SQL Server / PostgreSQL, Dagit / Airflow)Location: RemoteJob Type: Contract

Job Description:We are seeking an experienced Database Developer to join our team working directly with key client bringing innovative solutions to the higher education market.Candidates must have a very strong background and significant experience as a database developer using both MS SQL Server and PostgreSQL. This must include very high competency in: coding, testing and optimizing SQL queries; designing logical and physical models; resolving performance issues; identifying and fixing data issues; and developing and testing T-SQL and PL/pgSQL functions, triggers and procedures. Although experience with core DBA duties is helpful, this is not a DBA position.Candidates must be experienced with developing transactional and analytic data solutions, and have experience with modern ETL concepts and tooling. Candidates must have demonstrated experience developing data solutions on leading cloud platforms such as AWS, Azure or GCP.Ideal candidates will also have understanding and practical experience with Dagster and/or Dagit and with related tooling such as Apache Airflow or similar to orchestrate workflows.Candidates must have demonstrated experience scripting and automating process steps using tools, such as Jenkins, for example to refresh data in QA databases.Candidates must quickly learn the customer’s business processes and how they are implemented within the logical and physical data structures. Candidates must have ability to understand the data, what it means, such that incorrect data can be recognized, root causes identified and remediation plans defined.This role requires exceptional problem-solving and communication skills, strong attention to detail, and the ability to work collaboratively in a dynamic, customer-facing environment, with a very strong focus on system performance and data quality.Key Responsibilities:Design and document effective logical data models. Design and implement efficient physical data DB schemas and objects, including tables, views, data types, indices and procedural language objects.Develop, enhance, optimize and test SQL queries for transactional and analytic solutions, as well as ad hoc queries for support requests; support application developers to design and optimize queries within application code.Develop, enhance, optimize, test and deploy T-SQL and PL/pgSQL procedures, triggers and functions.Design and model DAGs using Dagit, author, test and manage workflows using Apache Airflow.Develop, test and implement scripting solutions to automate common DB-facing tasks, such as refreshing data tables within QA databases.Identify, troubleshoot and resolve data issues; respond to DB-facing trouble tickets to identify root causes and remediation steps.Analyze and optimize database performance, addressing issues related to query performance, indexing, and data retrieval.Design and construct test data and test cases to support unit, integration and performance tests.Identify and implement process improvements to align DB-facing activities to current industry best practices.Work closely with cross-functional teams, including software developers, business analysts, and system administrators.Create documentation for the data models, procedural language objects and supporting processes.Required Qualifications:Education:Bachelor’s degree in computer science, Information Technology, or a related fieldExperience:Minimum of 10 years of experience as a Database DeveloperProven experience as a database developer using MS SQL Server and PostgreSQLTechnical Skills:Expertise in SQL Server and PostgreSQL database design, development, and optimizationExpertise in T-SQL and PL/pgSQL functions, triggers and proceduresExpertise in SQL queries, and in query performance tuning and optimizationExperience in scripting languages (e.g., Python, Shell Scripts) and tooling (Jenkins or similar) for automationExperience in Dagster and/or Dagit and in orchestrating workflows using Apache AirFlowExperience in database design, data modeling, and schema normalizationExperience in data warehousing concepts and ETL processesExperience with database security best practicesExperience with agile development methodologiesExperience with cloud-based database services such as Amazon RDS and Amazon AuroraKnowledge of both SQL Server and PostgreSQL database architecturesKnowledge of other databases such as DynamoDB, MongoDB and RedshiftFamiliarity with database administration tasks such as backup and recovery, replication, and high availability configurationsFamiliarity with AWS Cloud Platform with good domain knowledge on core services such as EC2, S3, IAM, Lambda, EBS, SQS, etc.Soft Skills:Excellent problem-solving abilitiesStrong analytical skills and attention to detailAbility to learn new business and technical concepts quicklyExcellent communication and documentation skillsAbility to work independently and as part of a customer teamAbility to work efficiently on both small- and large-scale projectsAbility to manage multiple priorities

Key Skills

• PostgreSQL