Analyze and assemble large, complex data sets that meet functional / non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Oracle database.
Work with stakeholders including the Product, Data and Reporting teams to assist with data-related technical issues and support their data infrastructure needs.
Work with people data and analytics experts to design optimal data solution for dashboards.
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.
Required Skills:
Expert knowledge in Database like Oracle, PostgreSQL (preferably cloud hosted), any cloud based Data Warehouse (like Snowflake) with strong programming experience in SQL.
Programming language experience in Golang, Python, shell scripts is desirable.
Deep knowledge of databases, stored procedures, optimization of large data sets.
In-depth knowledge of ingestion techniques, data cleaning, de-dupe, partitioning.
Experience with building the infrastructure required for data ingestion and analytics
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, 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)
Understanding of data modelling techniques and working knowledge with OLTP and OLAP systems