Data Engineer
Data EngineerDescriptionPhoenix Technologies is one of the world's most experienced platform firmware security companies.
We were the first company to develop a BIOS that was compatible with the IBM PC clone in the 1970s.
And the rest is history.
Today, we serve global customers from offices in the United States, Taiwan, and Japan.
The total number of known medium-, critical, and high-risk firmware vulnerabilities tracked by Phoenix has more than quadrupled in less than five years.
We are a private company in growth mode while developing new products to address these challenges.
Location:
On-Site 4 days per week in Beaverton, Oregon.
Remote and relocation is not an option.
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 other groups within Engineering.
Document processes related to core responsibilities.
Knowledge & Skills Bachelor's 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.
Nice-To-Have Experience working in the firmware business domain or a related field such as hardware engineering.
Experience working in a high security business domain.
Experience in highly related infrastructural areas, e.
g.
, AWS IAM security and data encryption both in transit and at rest.
Experience in cross-process workflow orchestration.
Data warehouse, data mart, and ETL/ELT data pipeline design and implementation.
Experience in non-relational data storage and retrieval.
Familiarity with DevOps and SecOps practices.
The use of advanced PostgreSQL features such as row-level security, replication, partitioning, and high availability features.
Experience in additional non-PostgreSQL data platforms, including non-relational stores and technologies.
Multi-platform change control, in particular deploying to SQLite in addition to PostgreSQL-based systems.
Cross-platform data migrations.
Recommended Skills Amazon Redshift Architecture Backend Business Requirements Cloudwatch Cryptography Apply to this job.
Think you're the perfect candidate? Apply on company site Estimated Salary: $20 to $28 per hour based on qualifications.
We were the first company to develop a BIOS that was compatible with the IBM PC clone in the 1970s.
And the rest is history.
Today, we serve global customers from offices in the United States, Taiwan, and Japan.
The total number of known medium-, critical, and high-risk firmware vulnerabilities tracked by Phoenix has more than quadrupled in less than five years.
We are a private company in growth mode while developing new products to address these challenges.
Location:
On-Site 4 days per week in Beaverton, Oregon.
Remote and relocation is not an option.
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 other groups within Engineering.
Document processes related to core responsibilities.
Knowledge & Skills Bachelor's 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.
Nice-To-Have Experience working in the firmware business domain or a related field such as hardware engineering.
Experience working in a high security business domain.
Experience in highly related infrastructural areas, e.
g.
, AWS IAM security and data encryption both in transit and at rest.
Experience in cross-process workflow orchestration.
Data warehouse, data mart, and ETL/ELT data pipeline design and implementation.
Experience in non-relational data storage and retrieval.
Familiarity with DevOps and SecOps practices.
The use of advanced PostgreSQL features such as row-level security, replication, partitioning, and high availability features.
Experience in additional non-PostgreSQL data platforms, including non-relational stores and technologies.
Multi-platform change control, in particular deploying to SQLite in addition to PostgreSQL-based systems.
Cross-platform data migrations.
Recommended Skills Amazon Redshift Architecture Backend Business Requirements Cloudwatch Cryptography Apply to this job.
Think you're the perfect candidate? Apply on company site Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
