SQL Developer

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 Redshift Familiarity 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

• SQL
• Agile