Impact Analytics - Database Engineer - Design & Maintenance (4-6 yrs)

About the job :

What this role entails :

- Analyze database design and architecture requirements for the distributed applications

- Develop, construct, test and maintain existing and new data-driven architectures

- Align architecture with business requirements and provide solutions which fits best to solve the business problems

- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources on the Cloud (AWS / GCP).

- Using well defined ETL tools like PySpark, Data Flow

- Data acquisition and clean up from multiple sources across the organization

- Design custom tools to collate the data

- Identify ways to improve data reliability, efficiency, and quality

- Develop automated tasks for data operations

-Deliver updates to stakeholders based on analytics

- Set up practices on data reporting and continuous monitoring using Prometheus, ELK or similar tool.

What lands you in this role :

- Seven or more years as a hands-on technologist with a good mix of application development and database development.

- Expert Level Sql, Postgresql, including stored procedures, functions, triggers, and views.

- Strong understanding in database design and modelling.

- Ability to efficiently write database code without compromising data quality, privacy or security.

- Knowledge of database design principles, query optimization, index management, integrity checks, statistics, partitioning and isolation levels

- Good understanding of Postgresql replication, high availability and clustering across availability zones and regions

- Good understanding of Database backup and restore to align with data laws

- Participate in an agile software development life cycle including providing testing guidelines for database related changes.

- Good understanding of Programming language, preferably Python for custom scripts

- Understanding No Sql and In memory databases is a value add