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).  
• Personal Attributes:  
• - Very good communication skills.  
• - Ability to easily fit into a distributed development team.  
• - Ability to manage timelines of multiple initiatives.  
• - Ability to articulate insights from the data and help business teams make decisions  
• - Able to work with ambiguous requirements, to seek clarity around uncertainty and to manage risks  
• - Ability to communicate complex concepts to non-data audiences