Data Engineer - Crockett, United States - Beyondsoft Group
Description
Role: Data Engineer
Is your CV ready If so, and you are confident this is the role for you, make sure to apply asap.Primary Skills: PostgreSQL
Role Description: As a Data Engineer you must have at least 7+ years of experience.
Responsibilities:
Interpret data-related business requirements into technical ones.
Relational database design and feature development with a primary focus on high-velocity, write-intensive transactional systems.
Secondary focus on relational database design and feature development for read intensive applications.
Experience in non-relational data storage and retrieval preferred.
Maintain and enhance the functionality and performance of existing PostgreSQL-based database systems, including PostgreSQL running in WSL Docker and AWS RDS/PG.
Monitor and control database instances including use of the pg stat extension, DBeaver, the AWS Management Console, AWS CloudWatch, and AWS Performance Insights.
Implement multi-environment database change processes using scripts, Jenkins, and Terraform.
Proactively address scalability, performance, and availability requirements and concerns.
Ensure data quality and integrity.
Collaborate closely with Product personnel and in particular the backend Engineering group, as well as other groups within Engineering.
Document processes related to core responsibilities.
Knowledge & Skills
Bachelors degree in Computer Science or related field with at least 7+ years of experience in data engineering
Extensive knowledge of PostgreSQL, related AWS services (RDS/PG, Aurora, and Redshift), and associated tools.
Expert in relational database design, data modeling, and management.
Excellent written, verbal, and inter-personal communication skills.
Ability to work with small, cross-functional teams from multiple regions/time zones by effectively leveraging multi-form communication (Email, MS Teams for voice and chat, meetings).
Excellent prioritization and problem-solving skills.
Required Experience
Extensive experience in transactional database design and SQL coding.
Rapidly and fluidly scaling high velocity data sets.
Considerable hands-on time with PostgreSQL, possessing a deep knowledge of the internals and architecture, familiarity with the system catalogs, extensions, best practices, security, monitoring and control, related tools, error handling, etc.
Experience with team tools including Jira, Git/GitHub, Jenkins, Docker, and Teams.
Experience with Agile/Scrum development methodologies.