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 cloud-hosted), with strong programming experience in SQL. Cloud-hosted (AWS, GCP, Azure, and data warehouse ( Snowflake, Azure, Synapse)
• Strong understanding of and practical working experience with Data warehouse (incl. Cloud-based 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
• In-depth knowledge of ingestion techniques, data cleaning, de-dupe, and partitioning.
• Experience with building the infrastructure required for data ingestion and analytics
• Ability to fine-tune report-generating 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 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
• 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 real-time 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 non-data audiences