▷ 15h Left: Databases-architecture

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