Software Engineer

Responsibilities:

• Implement complex queries and stored procedures to support REST APIs and batch rollups of reports data for customer organizations.
• Writing, designing, testing, implementing, and maintaining database applications/procedures using SQL or other database programming languages.
• Resolve performance issues, performance tuning of database systems, queries, indexing.
• Use of Apache Airflow scheduler to setup DB jobs to run automatically.
• Supporting streaming event processing using Spark framework with Scala.
• Manage and create data import and export processes (ETL) into the databases and create and manage data integration scripts using file transfers, API calls, and/or other methods.
• Develop solutions using AWS database technologies like RDS Postgres and Aurora Postgres.
• Provide support for systems architecture for Reporting Platform.
• Setting up Monitor Dashboards and Alerts using DataDog to proactively catch issues.
• Diagnose and troubleshoot database errors.
• Create automation for repeating database tasks.
• DevOps knowledge to automate deployments using Jenkins or Concourse.

Skills & Experience:

• Successful Candidates must demonstrate an appropriate combination of:
• 3+ years of experience as a DB Developer, preferably with Postgres, creating and supporting commercial data warehouses and data marts.
• 2+ years of experience working with Apache Spark and Scala development.
• 2+ years of experience in Java Backend Services programing.
• Plus for experience working with Airflow Schedulers with Python development.
• Strong hands-on working knowledge of managing databases on AWS Databases including: RDS and Aurora.
• Strong command of SQL. SQL server tools, ETL jobs including stored procedures.
• Database technologies such as SQL, Aurora, Redshift, Liquibase or Flyway
• Cloud technologies such as AWS and Azure
• Data Center Operating Technologies such as Apache Mesos, Apache Aurora, and TerraForm and container services such as Docker and Kubernetes
• Advanced knowledge of database security and performance monitoring standards.
• Understanding of relational and dimensional data modeling.
• Shell scripting skills.
• Knowledge of DataDog for setting up monitoring and alerting dashboards.
• Working knowledge of Jenkins or Concourse tool for CI/CD.
• Ability to work independently and in a group to provide sound design and technology leadership.
• Self-starter attitude with initiative & creativity.
• Ability to pay attention to details, dealing with interruptions and changing timelines and priorities.
• Ability to communicate and work effectively with all levels of company.
• Related AWS DBA Certification is a preferred.
• Working knowledge of AirFlow is a plus.
• Knowledge of AWS Database Migration Service and Lambda is a plus.Required Education:
• A BS/MS in Computer Science, Computer Engineering, or a STEM field.