Senior Engineer – Data SQL Engineer

Job Title: Senior Engineer – Data SQL Engineer

Corporate Title: AVP

Location: Pune, India

Role Description

• As a SQL Engineer, you would be responsible for design, development and optimization of complex database systems.
• You would be writing efficient SQL queries, stored procedures and possess expertise in data modeling, performance optimization and working with large scale relational databases

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy,

• Best in class leave policy.
• Gender neutral parental leaves
• 100% reimbursement under childcare assistance benefit (gender neutral)
• Sponsorship for Industry relevant certifications and education
• Employee Assistance Program for you and your family members
• Comprehensive Hospitalization Insurance for you and your dependents
• Accident and Term life Insurance
• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• Design, develop and optimize complex SQL queries, stored procedures, views and functions.
• Work with large datasets to perform data extraction, transformation and loading(ETL).
• Develop and maintain scalable database schemas and models
• Troubleshoot and resolve database-related issues including performance bottlenecks and data quality concerns
• Maintain data security and compliance with data governance policy.

Your skills and experience

• 10+ years of hands-on experience with SQL in relational databases – SQL Server, Oracle, MySQL PostgreSQL.
• Strong working experience of PLSQL and T-SQL.
• Strong understanding of data modelling, normalization and relational DB design.

Desirable skills that will help you excel

• Ability to write high performant, heavily resilient queries in Oracle / PostgreSQL / MSSQL
• Working knowledge of Database modelling techniques like Star Schema, Fact-Dimension Models and Data Vault.
• Awareness of database tuning methods like AWR reports, indexing, partitioning of data sets, defining tablespace sizes and user roles etc.
• Hands on experience with ETL tools - Pentaho/Informatica/Stream sets.
• Good experience in performance tuning, query optimization and indexing.
• Hands-on experience on object storage and scheduling tools
• Experience with cloud-based data services like data lakes, data pipelines, and machine learning platforms.
• Experience in GCP, Cloud Database Migration experience, hands-on with Postgres 

How we’ll support you

• Training and development to help you excel in your career.
• Coaching and support from experts in your team.
• A culture of continuous learning to aid progression.
• A range of flexible benefits that you can tailor to suit your needs.

About us and our teams

Please visit our company website for further information:

https://www.db.com/company/company.htm

We at DWS are committed to creating a diverse and inclusive workplace, one that embraces dialogue and diverse views, and treats everyone fairly to drive a high-performance culture. The value we create for our clients and investors is based on our ability to bring together various perspectives from all over the world and from different backgrounds. It is our experience that teams perform better and deliver improved outcomes when they are able to incorporate a wide range of perspectives. We call this #ConnectingTheDots.