Java Microservices Developer AVP C12 - PUNE

Qualification:

This is a data architect position for an individual with a strong background in data architecture, data modeling, performance tuning and trouble shooting skills in Oracle, Big Data and Cloud based databases.

• At a minimum, a bachelor’s degree in Computer Science, Information Technology or a related field is required

• 10+ years' experience in a database technologies

• Strong communication and customer engagement skills

Professional skills:

• Deep experience and "Hands- On" experience in architecting, designing, and building enterprise-class relational and dimensional data models for large scale OLTP and data warehouse

• Hands on experience with Oracle and at least one Cloud based DB

• Extensive experience in analyzing and fixing query performance issues. Very good understanding in reading and analyzing explain plan and fixing performance issues.

• Extensive experience in advanced database skills such as oracle in-memory, data partitioning, stat gather, data purging, materialized views, star and snowflake design, index and stored procedures.

• Advanced knowledge of SQL and related programming languages such as PL/SQL, Python and Unix Shell scripting

• Familiar with technologies including Snowflake, ETL/ELT tools, Spark SQL, AWS

• Understanding data management and governance concepts such as data quality, data purging, metadata management, data lineage, data lakes etc

• Experienced with integration tool like Talend, dimensional models, slowly changing dimensions, and database tuning

• Self-starter attitude and ability to work independently

• Excellent communication skills and problem solving skills

Responsibilities:

• Involve in architect, design and development of data warehouse and ODS databases

• Work with system architects, software architects, and design analysts to understand business requirements

• Develop standards: Create and enforce standards for database development

• Manage and Monitor : Oversee the day-to-day activities of the database, including monitoring quality, service, and utilization standards

• Optimize for throughput, concurrency, load and performance with best practices for SQL queries, caching, indexing strategies and other performance best practices

• Work closely with production support and developers to identify trouble queries, analyze query plan and tune queries for performance issues

• Develop and enhance existing framework using python that can performs data load/unload, export/import, purging, stat gather and other db monitoring.

• Pro-actively monitor db locks, blocks, long running queries and act on its

• Ensure proper process and policies are being followed by enforcing data management and governance. 

• Create, build and maintain lower environments (i.e UAT/QA/Dev) and regularly perform data refresh on these environment

• Builds data models including conceptual, logical, and physical design

• Work with SA and DBA to ensure latest VTM patches and bug fixes are applied.

• Monitor DB and tablespace size and keep db size under control by purging 

• Defining strategic roadmaps for migration of data from legacy app to new app.

• Added benefits: Cloud and Snowflake certifications.