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.
- Robust 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 K

📌 Software Engineer (Pune)
🏢 Houghton Mifflin Harcourt
📍 Pune