Sr. Database Engineer
Required Work From Office Hyderabad
Experience: 8 to 12 years would be preferable.
Willing to Join within * 7 days
Required Skills:
- Good knowledge of databases like PostgreSQL (preferably cloudhosted) with strong programming experience in SQL. Cloudhosted (AWS GCP Azure and data warehouse Snowflake Azure Synapse)
- Strong understanding of and practical working experience with Data warehouse (incl. Cloudbased DW like Snowflake and Azure Synapse) ODS and Data marts.
- Competence in data preparation and/or ETL tools like snapLogic MATILLION Azure Data Factory AWS Glue and SSIS (preferably good exposure in one or more) to build and maintain data pipelines and flows.
- Good knowledge of databases stored procedures and optimizations of huge data
- Indepth knowledge of ingestion techniques data cleaning dedupe and partitioning.
- Experience with building the infrastructure required for data ingestion and analytics
- Ability to finetune reportgenerating queries
- Solid understanding of normalization and denormalization of data database exception handling transactions profiling queries performance counters debugging database & query optimization techniques
- Understanding of index design and performancetuning 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
- Adhere to standards for all databases e.g. Data Models Data Architecture and Naming Conventions
- Exposure to Source control like GIT Azure DevOps
- Understanding of Agile methodologies (Scrum Kanban)
- Understanding of data modeling techniques and working knowledge of OLTP and OLAP systems
- Preferably experience with NoSQL database to migrate data into another type of database with realtime replication. (desirable)
- Programming language experience or exposure in Golang Python and shells scripts (bash/zsh grep/sed/awk etc.. (desirable)
- Experience with CI/CD automation tools (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 seek clarity around uncertainty and manage risks
- Ability to communicate complex concepts to nondata audiences
Required Experience:
Senior IC