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
Click
here to apply!
|