Senior Database Engineer - Hyderabad, India - KloudPortal ™ - SaaS | Product Marketing

Description

Job Description for Senior Database Engineer:

KloudPortal Technology Solutions Private limited offers a range of software solutions to clients worldwide. We take pride in creating solutions that are scalable, optimal and effective. Our team of 60+ engineers is diverse and welcoming.

About the position:

This job posting is for a software engineer for a senior level position at client end. The position is for Work from Office. We would prefer candidates who are in Hyderabad.

Overview:

As a Senior Database Engineer, you will be responsible for expanding and optimizing our data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Database Engineer will support our software developers, database architects, application reporting team and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They 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.

Experience: 8-12 years.

Key Responsibilities:

• Create and maintain optimal data pipe line architecture.

• Assemble large, complex data sets that meet functional/non-functional business requirements.

• Identify, design, and implement internal process improvements: automating manual process, optimizing data delivery, re-designing infrastructure for greater scalability, Python/open source technologies.

• Build the infrastructure required 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 infrastructure needs.

• Keep our data seperated and secure across national boundaries through multiple data centers and regions.

• Work with data and analytics experts to strive for greater functionality in our data systems.

• Test databases and perform bug fixes.

• Develop best practices for database design and development activities.

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

• Take on technical leadership responsibilities of database projects across various scrum teams.

• Manage exploratory data analysis to support database and dashboard development.

Key Requirements:

Required Skills:

• Strong experience in SQL with expertise in Database like PostgreSQL (preferably cloud hosted in anyone or more cloud offerings like AWS, Azure, GCP) or any cloud based Data warehouse (like Snowflake, Azure Synapse).

• Strong Programming experience in Python.

• Competence in data preparation and/ or ETL tools like SnapLogic, Azure Data Factory, AWS Glue, SSIS, MATILLION (preferably strong working experience in one or more) to build and maintain data pipelines and flows.

• Understanding of data modelling techniques like dimensional modelling and working knowledge with OLTP and OLAP systems.

• Deep knowledge of databases, stored procedures, optimizations of huge data.

• In-depth knowledge of ingestion techniques, data cleaning, de-dupe, 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 database e.g., Data Models, Data Architecture and Naming Conventions.

• Exposure to Source control like GIT, Azure DevOps.

• Understanding of Agile methodologies (Scrum, Kanban).

• Preferably experience with NoSQL database to migrate data into other type of databases with real time replication. (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, to seek clarity around uncertainty and to manage risks.

• Ability to communicate complex concepts to non-data audiences.

If you feel you are the right person for this position, please CLICK APPLY