DATABASES-Architecture & Design-PostgreSQL

Job Role:
As a Senior Database Engineer, you will be responsible for expanding and optimizing our data architecture and data pipelines. The ideal candidate is an experienced data engineer and data wrangler who enjoys optimizing data systems and building them from the ground up. The Database Engineer must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of data process automation and optimizing or even re-designing our company's data architecture to support our next generation of products and data initiatives. Job Title: Senior Database Engineer Job Location: Hyderabad/ Gurgaon / Noida Start Date: As soon as possible

Key Responsibilities:

Build the data pipeline for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and cloud database technologies.
Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data needs. Work with data and analytics experts to strive for greater functionality in our data systems. Assemble large, complex data sets that meet functional/ non-functional business requirements. Ability to quickly analyze existing SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery for greater scalability, etc. Unit Test databases and perform bug fixes. Develop best practices for database design and development activities. Take on technical leadership responsibilities of database projects across various scrum teams. Manage exploratory data analysis to support dashboard development (desirable).

Key Requirements:
Experience: 8-12 years would be preferable. Required Skills:

Strong experience in SQL with expertise in relational database (PostgreSQL preferrable cloud hosted in AWS/Azure/GCP).
Strong experience in cloud based Data Warehouse like Snowflake (preferrable) or any similar ones like Azure Synapse. Competence in data preparation and/or ETL/ELT tools like IBM StreamSets, Snap Logic, DBT, etc. (preferably strong working experience in one or more) to build and maintain complex data pipelines and flows to handle large volume of data. Understanding of data modelling techniques and working knowledge with OLAP systems.

Job Description

• Deep knowledge of databases, data marts, data warehouse enterprise systems and handling of large data sets.
• In-depth knowledge of ingestion techniques, data cleaning, de-dupe, etc.
• Ability to fine tune report generating queries.
• Understanding of index design and performance-tuning techniques
• Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions
• Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting (desirable).
• Adhere to standards for all database e.g., Data Models, Data Architecture and Naming Conventions
• Exposure to Source control like GIT, Azure DevOps
• Understanding of Agile methodologies (Scrum, Kanban)
• Experience with NoSQL database to migrate data into other type of databases with real time replication (desirable).
• Experience with CI/CD automation tools (desirable)
• Programming language experience in Golang, Python, any programming language, Visualization tools (Power BI/Tableau) (desirable).