Pay Range: $60 - $65

Job Description:

• Design and implement scalable, efficient data warehouse solutions to support large-scale data environments.

• Develop and maintain high-performance ETL frameworks with strong error-handling and reliability.

• Optimize Oracle database performance using execution plans, AWR reports, and advanced tuning techniques for queries, tables, and indexes.

• Model data across conceptual, logical, and physical layers to meet data warehouse requirements.

• Write, maintain, and optimize complex Oracle PL/SQL code for performance and scalability.

• Manage advanced database features including partitions, indexes, CDC (Change Data Capture), purging strategies, and data virtualization.

Must Haves

• 12+ years of hands-on experience in large-scale data warehousing, with a focus on designing effective data solutions.

• 10+ years of advanced Oracle PL/SQL development and DBA experience, including deep expertise in performance tuning.

• Strong ability to analyze Oracle execution/query plans and AWR reports to identify and resolve performance issues.

• Proven experience in designing and implementing data models (conceptual, logical, and physical).

• Expertise in building scalable, high-performance ETL frameworks with robust error handling.

• In-depth knowledge of database management, including partitions, indexes, CDC, purging, and virtualization.

Plusses

• Experience with data visualization tools such as Tableau (preferred) or Power BI.

• Exposure to Python, Hadoop, and Generative AI/Machine Learning (Gen AI/ML).

• Background in the financial services or banking industry.