Job Description

:

At The Est\xc3\xa9e Lauder Companies (ELC), we believe that technology will power the future of beauty. Across more than 25 globally recognized brands sold in over 150 countries and territories, we use technology to reinvent and redefine how consumers worldwide explore and express their individual beauty. Infused throughout our organization is a passion for creativity and innovation and a desire to push the boundaries and invent the unexpected.

Our Digital Technology Centers are made up of talented individuals who exemplify ELC\xe2\x80\x99s heritage of high-performance, innovation, and family values. We\xe2\x80\x99re looking for creators, leaders, and visionaries with the passion and imagination to shape the next generation of beauty products and experiences. We\xe2\x80\x99re hiring technologists at all levels.

The Application DBA / Engineer is a hands-on expert in analyzing and remediating performance issues across the Azure database landscape. This position is responsible for continual performance improvement and associated maintenance processes ensuring optimal performance of the EDL Consumption layer. The Application DBA / Engineer will lead the effort to establish performance standards and automate performance management. Through collaboration and demonstrations with data and project teams, this role will develop data integration (ETL) standards and guidelines and influence data integration design ensuring best practices are followed across projects delivering consistency and maximizing performance across solutions.

Key Activities:

Develop and lead the evangelization of an application and data protection strategy to support strategic initiatives in Performance and tuning of Azure databases

Establish, automate, and maintain database performance and maintenance processes

Establish, automate, and maintain database audit capabilities

Work with data modeling lead and project teams developing and implementing standards and best practices for both physical data model design and SQL coding

Work with data integration and EDL engineering teams developing and implementing ETL standards and best practices on Databricks platform and Azure databases

Implement, manage & optimize row level security solutions in EDL consumption layer

Perform functional analysis of new database systems guiding evolution of EDL Consumption layer

Participate in the evaluation and implementation of data management technologies and solutions
Qualifications

Technical Competencies:

Expertise with Azure SQL databases

Deep understanding of Azure Cosmos and Synapse (Databricks Lakehouse is a plus)

Database performance management expert

Expert in database performance & tuning practices and concepts; proven hands-on performance and tuning expertise in Azure cloud environment; ability to tune physical data models across Azure cloud database offerings

Expert experience automating database maintenance processes

Excellent SQL coding skills

Excellent Python coding skills

Strong, proven experience developing ETL standards

Strong, proven physical data modeling skills & experience defining and optimizing data access patterns

Experience developing in Databricks environment

Strong understanding of concepts in Data Management

Functional Capabilities:

Expert understanding of Cloud based database systems

Expert understanding of relational databases and associated performance management techniques & solutions

Expert understanding of SQL coding techniques, relational databases, and best practices, especially in regard to performance management

Deep understanding of data integration (ETL) design and development

Manages performance of EDL consumption platform

Develops and maintains performance management standards and guidelines

Develops and maintains data integration (ETL) standards and guidelines

Supporting a federated community of data engineers loading data into the EDL consumption layer

Solid understanding of row level security implementations, database functionality implementing row level security, and associated performance and & tuning considerations.

Understands ELC EDL technical landscape and integration processes

Drives automation and efficiencies of performance management and ETL solutions

Experience installing and maintaining database and data management platforms (ETL, Master Data, Data Quality, etc.)

Strong communications skills to collaborate with the virtual global team and drive consensus with project and technical teams

Pragmatic approach to deliver incremental value to the organization

Comfortable within a global, complex, highly matrixed organization

Ability to establish credibility and be decisive \xe2\x80\x93 but able to recognize and support the organization\xe2\x80\x99s preferences and priorities

High Performing Leadership Competencies

Understands how contributions fit into overall strategy

Demonstrates mindset receptive to change

Seeks opportunities to grow breadth and depth of experience

Actively seeks feedback from others to continuously improve

Builds and leverages emotional intelligence

Exhibits ability to influence without authority

Adapts behavior in response to new information

Recognizes unexpected learnings and shares results and insights

Learns from experiences and understands that different situations may call for different skills and approaches
Job: Information Technology
Primary Location: Asia Pacific-MY-14-Wilayah Persekutuan
Job Type: Standard
Schedule: Full-time
Shift: 1st (Day) Shift
Job Number: 2219399

Est\xc3\xa9e Lauder