Job Description

Company Overview Job Overview Job Summary: We are seeking a Performance Engineer with expertise in SQL/PLSQL query optimization, performance tuning, and the development of efficient PL/SQL stored procedures and functions to support data processing and calculations using best practices within the BI environment. This role focuses on enhancing report performance, optimizing SQL queries, and improving ETL processes for efficient data processing and reporting. The ideal candidate should have at least 8 years of experience in PL/SQL-based ETL development, database performance tuning and 2-4 years of BI Publisher, OAS RPD optimization. Familiarity with SQL Server is a plus. Key Responsibilities: Performance Optimization & BI Reporting: Identify and resolve slow-performing reports, dashboards, and queries in OAS/OBIEE. Optimize BI Publisher reports, ensuring efficient layouts, pagination, and caching strategies for fast rendering. Enhance query efficiency by tuning OAS/OBIEE RPD metadata layers (Physical, Logical, and Presentation). Proficiency in SQL/PLSQL query optimization techniques, performance tuning, Develop and maintain efficient PL/SQL stored procedures and functions that support data processing and calculations using best practices within the BI environment. Monitor system performance metrics, including query response times, cache hit rates, and resource utilization. PL/SQL-Based ETL Development & Optimization: Develop and maintain efficient PL/SQL stored procedures for ETL processes. Optimize ETL workflows, ensuring high-performance data transformations and aggregations. Troubleshoot data loading and transformation issues, ensuring seamless data integration. Database & RPD Management: Manage the Oracle BI Repository (RPD), optimizing data models for reporting efficiency. Utilize query hints, materialized views, partitioning, and indexing to improve database performance. Deep understanding of query execution plans, indexing, joins, partitioning, and caching. Optimize performance by using query hints, materialized views, and caching strategies. Implement best practices in data modeling, Star Schema design, and caching strategies. Collaborate with DBAs, BI developers, and report analysts to improve overall performance. Qualifications & Experience: Strong expertise in PL/SQL-based ETL development and query optimization. Experience with OAS/OBIEE RPD metadata management and performance tuning. Ability to create BI Publisher reports with optimized layouts and data structures to ensure fast rendering times and analyze complex data sets and identify performance bottlenecks (Nice to have) Familiarity with SQL Server query optimization. (Nice to have) Deep understanding of query execution plans, indexing, joins, and partitioning. Experience with cloud-based BI environments. (Nice to have) Compensation Estimated Pay Range: Exact compensation and offers of employment are dependent on circumstances of each case and will be determined based on job-related knowledge, skills, experience, licenses or certifications, and location. Our Commitment to Diversity & Inclusion At Milestone we strive to create a workplace that reflects the communities we serve and work with, where we all feel empowered to bring our full, authentic selves to work. We know creating a diverse and inclusive culture that champions equity and belonging is not only the right thing to do for our employees but is also critical to our continued success. Milestone Technologies provides equal employment opportunity for all applicants and employees. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, gender identity, marital status, age, disability, veteran status, sexual orientation, national origin, or any other category protected by applicable federal and state law, or local ordinance. Milestone also makes reasonable accommodations for disabled applicants and employees. We welcome the unique background, culture, experiences, knowledge, innovation, self-expression and perspectives you can bring to our global community. Our recruitment team is looking forward to meeting you. Back Share Apply Now