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.
- Solid 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.

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