Impact Analytics - Database Architect - PostgreSQL

Job Description - Analyse database design and architecture requirements for the distributed applications. - Design the databases for the microservices with well-defined bounded context and interaction. - Develop, construct, test, and maintain existing and new data-driven architectures. - Align architecture with business requirements and provide solutions that 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 a 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 of database design and modeling. - 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. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 11/25/2024