{bc}
paylocity

DevOps Engineer - Database and ETL Platforms

AdvancedPCB
Aurora, USA
Full-time
Mid · 3+ years experience
Onsite
USD 100000-135000 yearly / year
Discovered 1 months ago
PythonMicrosoft SQLProgressOracleMySQLDocker

Full Job Posting

Essential Job Function

Evaluates, automates, and optimizes processes, building infrastructure through code and streamlining pipelines, monitoring, and incident response processes, following industry standards and best practices

Develop ETL pipelines, and automation to extract source data, transform to map to the target model and/or cleanse the data, and load into a data warehouse or analytical model

Configure the operational and analytical database(s) to host data, and develop data marts to meet the business requirements

Optimize the ETL data pipelines code and configure data interface tools and APIs as needed

Create visualizations via PowerBI and other tools

Follows the SDLC process and adheres to company coding standards to produce high quality software

Able to learn quickly and automate, integrate, deploy, or release solutions using tools, scripting, or coding as needed.

Continuously striving for improvement, evaluating new approaches, industry standards, new tooling, etc. and producing recommendations for improvements

Maintains established SLAs, SLIs, SLOs, and monitors systems, assessing lead time for changes, change failure rate, deployment frequency, mean time to recover, and availability, striving for continuous operational improvement and improved user satisfaction

Proficient at problem management including definition, brainstorming, and determining a resolution through collaboration

Establishes and maintains thorough and accurate documentation of all work; communicates technical issues within scope of assignment; Produces and reviews technical specification documentation

Maintain revision control of developed software according to company guidelines

Essential Qualifications, Education and Experience

  • · Bachelor’s Degree in a field of science or engineering plus three years of experience in software development, data analysis and ET, or equivalent experience.
  • · Demonstrated understanding of Computer Science fundamentals and proficiency in one or more programming languages (Primary language is Python)
  • · Python Development using Python 3.x
  • · Microsoft SQL (2+ years), Progress, Oracle, MySQL
  • · Containers; Docker, Kubernetes (preferably on Azure), etc.
  • Experience with UNIX/Linux (RedHat/CentOS/Oracle preferred)
  • Version control using Git/GitHub
  • PowerBI
  • SSIS

Physical Requirements

  • · Sit for long periods of time.
  • · Repeat the same movements.
  • · Ability to lift 25 pounds from time to time

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at AdvancedPCB