Description

Responsibilities

This individual will work closely with users, technical leads, project managers, and other cross-functional development teams to design and deliver database solutions. This includes writing SQL queries, developing backend procedures, functions and integration with applications within the core pathway. Also support quality assurance team(s)
Optimize/tune queries for best performance efficiency, Assess security of SQL written for potential risks
Tackle simple/moderate DBA tasks independently
This individual must develop database/backend solutions using disciplined database development and testing processes, adhering to team/company standards and database best practice guidelines, and corporate policies
Desired Skills:

Demonstrable experience in database design and development role on medium to large, enterprise-scale databases. The engineer must be familiar or have experience with Enterprise Integration Patterns, EAI, SOA, EDA architectures and their main principles

Candidate must be able to demonstrate experience in the following:

Working with RDBMS and NoSQL databases.
PostgreSQL / Oracle / MySQL
Design and development (governance/setting standards, versioning, etc.)
Cloud – AWS preferred (RDS, DynamoDB, EC2, IAM, S3)
Write/tune moderate to highly complex queries
ETL – moderate to complex data structure, high volume of data
Familiarity with various SQL clients
Practice with Git and Continuous Integration infrastructure
Transformation of Oracle SQL scripts into Postgres scripts
Data migration from Oracle db to Postgres db
Experience with AWS DMS, SCT tools

Education

Bachelor's degree