Your role
As a Senior Data Engineer, you will be instrumental in setting the direction and strategy for Db2 on the decentral Datawarehouse platform across the globe and in designing and building solutions in line with client's needs and to increase efficiency and decrease costs of these systems. Teamwork is pivotal to our success; it plays a very important role. We offer flexibility in the workplace and equal opportunities to all our team members.
Are you passionate about Data, Db2 and Technical Architecture Are you motivated to work in a complex, diverse and global environment We are looking for a database centric Senior Data Engineer to join our team and help us to build and maintain reliable and scalable Database infrastructures supporting huge workload patterns. This includes predictive automation, machine learning and data models that can help identify problem areas even before they occur, increase overall throughput and lower cost to run the environments.
Responsibilities
As a Senior Data Engineer you are responsible for planning, installation and maintenance of DBMS software and related software components. Responsible for problem management and problem determination of assigned software in AIX Db2 environment with DPF (database partitioning feature).
In detail:
- Change and release management of our large and complex data warehouses.
- Provide support and assistance to other work groups to meet their business objectives (plan, design and implement).
- Provide technical assistance to the Application Developers, Business Reporters and Data Scientists in problem diagnosis and resolution.
- Tune complex SQL statements and optimize execution plans.
- Collaborate in various infrastructure and/or client-related projects.
- Develop maintenance and infrastructure scripts.
Additional responsibilities include the development of further automation opportunities, the analysis and implementation of various optimizations and to ensure performant and secure data access from different applications into Db2 on AIX Data Warehouse.
Job Type
Full Time
Job Reference #
318153BR
City
Hyderabad
Your team
In our agile operating model, crews are aligned to larger products and services fulfilling client needs and encompassing multiple autonomous pods. You'll be working in the crew Midrange and Datawarehouse Services in Zurich focusing on
- Designing and building solutions to automate the deployment, configuration and upgrade of the AIX Data Warehouse running on Db2 LUW with data partitioning feature (DPF).
- Actively supporting WMPC business application in the database design, performance and monitoring area to guarantee correct and in time processing and to strengthen our position as leading wealth manager and the strongest universal bank in Switzerland.
- In deep root cause analyses, providing and executing solutions to fix issues on the AIX DWH. This often requires close cooperation with the specialists from IBM's lab.
- Design, plan and execute migration scenarios to transfer databases or parts of them to other environments with a minimal downtime.
- Creating guidelines to make good and state of the art use of existing resources and to avoid cost intensive infrastructure lifecycles.
Your expertise
At least 7-8 years of experience in the Db2 LUW software area. Knowledge of the database partitioning feature. Hands on person with an overwhelming aim to serve and support the customer, when problems appear.
Specific Database related skills required are:
- Database design experience (physical and logical) and deep knowledge in partitioned Databases
- Knowledge in Data Modeling, Data Integration and Database Design structured methods for design (e.g Star schema, Snowflake etc.)
- Knowledge in Data Architecture conceptual modelling methods
- Database optimization techniques such as Partitioned Tables, SQL programming, Execution Plans, Data File management to support different usage, Indexes, LOB handling and XML optimization
- Very good skills in performance tuning of complex SQL statements on AIX DWH
- Dataflow analysis for performance improvements to reduce physical IO in a complex environment
Good skills in AIX operating systems architecture, design & implementation. Advanced programming skills in AIX shell (or Unix / Linux) and/or Perl.
You are a committed and visionary team player with analytical and logical mind-set, well organized with an innate sense of how to prioritize across a complex environment, a hands-on person with natural instincts to support our customers. In addition, you're curious, collaborative and constantly interested in learning new things, fluent in English and eager to work in an English-speaking global team.
Bachelor's degree in data engineering, big data analytics, computer engineering, or related field.
Master's degree in a relevant field is advantageous.
At least 7-8 years of experience in the Db2 LUW software area. Knowledge of the database partitioning feature. Hands on person with an overwhelming aim to serve and support the customer, when problems appear.
Specific Database related skills required are:
- Database design experience (physical and logical) and deep knowledge in partitioned Databases
- Knowledge in Data Modeling, Data Integration and Database Design structured methods for design (e.g Star schema, Snowflake etc.)
- Knowledge in Data Architecture conceptual modelling methods
- Database optimization techniques such as Partitioned Tables, SQL programming, Execution Plans, Data File management to support different usage, Indexes, LOB handling and XML optimization
- Very good skills in performance tuning of complex SQL statements on AIX DWH
- Dataflow analysis for performance improvements to reduce physical IO in a complex environment
Good skills in AIX operating systems architecture, design & implementation. Advanced programming skills in AIX shell (or Unix / Linux) and/or Perl.
You are a committed and visionary team player with analytical and logical mind-set, well organized with an innate sense of how to prioritize across a complex environment, a hands-on person with natural instincts to support our customers. In addition, you're curious, collaborative and constantly interested in learning new things, fluent in English and eager to work in an English-speaking global team.
Bachelor's degree in data engineering, big data analytics, computer engineering, or related field.
Master's degree in a relevant field is advantageous.
About Us
UBS is a leading and truly global wealth manager and the leading universal bank in Switzerland. We also provide diversified asset management solutions and focused investment banking capabilities. Headquartered in Zurich, Switzerland, UBS is present in more than 50 markets around the globe.
We know that great work is never done alone. That's why we place collaboration at the heart of everything we do. Because together, we're more than ourselves. Want to find out more Visit ubs.com/careers.
Join us
At UBS, we know that it's our people, with their diverse skills, experiences and backgrounds, who drive our ongoing success. We're dedicated to our craft and passionate about putting our people first, with new challenges, a supportive team, opportunities to grow and flexible working options when possible. Our inclusive culture brings out the best in our employees, wherever they are on their career journey. And we use artificial intelligence (AI) to work smarter and more efficiently. We also recognize that great work is never done alone. That's why collaboration is at the heart of everything we do. Because together, we're more than ourselves.
We're committed to disability inclusion and if you need reasonable accommodation/adjustments throughout our recruitment process, you can always contact us.
Disclaimer / Policy statements
UBS is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills and experiences within our workforce.
