| Database Engineer (Postgress)|| REmote but local to CA,WA, OR Only at Remote, Remote, USA |
| Email: [email protected] |
| Role : Database Engineer Location : Beaveton, OR - They would like someone local but open to 100% remote folks MOI : Phone/Skype **Key to this is PostgreSQL and ETL. Database Engineer Our client is seeking a Database Engineer to implement a remote management system that can pass/receive commands and data to/from client devices. Responsibilities Interpret data-related business requirements into technical ones. Relational database design and feature development with a primary focus on high-volume, high-velocity transactional systems. Maintain and enhance the functionality and performance of existing PostgreSQL-based database systems, including PostgreSQL running in WSL Docker and AWS RDS. Monitor and control database instances including use of the pg_stat extension, DBeaver, the AWS Management Console, 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 with closely with Product personnel and in particular the backend Engineering group, as well other Engineering groups. Follow Agile development methodologies to deliver solutions and product features. 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 and Aurora), and 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). Working within an Agile team. Excellent prioritization and problem-solving skills. Required Experience Extensive experience in transactional database design and SQL coding. Rapidly and fluidly scaling high volume/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. Desired Experience 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. Familiarity with DevOps and Dev Sec Ops practices. The use of advanced PostgreSQL features such as row-level security, replication, and high availability features. The use of Alembic in a continuous integration/continuous test environment. AWS Aurora (a migration path under active consideration for the current AWS RDS system). 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 in particular from AWS RDS to AWS Aurora. -- Keywords: information technology microsoft |
| [email protected] View all |
| Fri Dec 22 21:30:00 UTC 2023 |