Database Engineer

Company: IT Avalon
Location: Beaverton
Posted on: January 17, 2023

Job Description:

We are seeking a Database Engineer to implement a remote management system that can pass/receive commands and data to/from client devices.
Location: Hybrid on/off site in Beaverton, OR
Responsibilities
Maintaining and enhancing the functionality and performance of existing database programs.
Monitoring and enhancing databases and related systems to optimize performance.
Proactively addressing scalability and performance issues.
Ensuring data quality and integrity while supporting large data sets.
Debugging and resolving database reliability, integrity, and efficiency.
Documenting processes related to the design, configuration, and deployment to new instances.
Collaborate with Product, Engineering and Data Science to ensure data quality and integrity for data reporting, exploration, and analysis.
Follow agile development methodologies to deliver solutions and product features by following DevOps practices.
Knowledge & Skills
Bachelors degree in Computer Science or related field with at least 7+ years of experience.
A minimum of 7 years experience in database engineering.
Expert with relational database design, data modeling, table creation and management.
Expert in SQL queries, knowledge of DWH concepts and ETL development.
Excellent written, verbal, and inter-personal and stakeholder communication skills.
Ability to work with 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
Git/Github for source control
Big data (Hadoop, Map/Reduce, Python) skills
Transactional database design
PostgreSQL - we need deep knowledge i.e., considerable hands-on time, a knowledge of the internals and architecture, familiarity with the system catalogs, a command of best practices (Especially with respect to security), monitoring and control, error handling, PSQL/command line expertise, etc
Docker
Jenkins
RDS
Experience with agile development methodologies by following DevOps, Data Ops and Dev Sec Ops practices.
Desired Experience
Experience with tools like Tableau, Domo and Power BI as visualization tools
Experience using AWS services in a big data platform.
Experience building cloud solutions using AWS or Azure as data lake backend sources.
Linux sysadmin Data warehousing design



#LI-DNP

Keywords: IT Avalon, Beaverton , Database Engineer, IT / Software / Systems , Beaverton, Oregon