Description

Develop and maintain scalable, database-driven technical solutions for complex business requirements.

This role is on-site.

Responsibilities

• Translate stakeholder needs into scalable, database-driven technical solutions.
• Design Oracle optimizations, automation, and workflow improvements by analyzing current business processes.
• Gather and document functional, non-functional, and technical requirements for new requests.
• Analyze data requirements, understanding how applications store and transform data within Oracle/Vertica.
• Identify, document, and troubleshoot application and database issues related to performance or data integrity.

Required Skills

• 10+ years of professional experience in SQL/PL/SQL development, including packages, functions, procedures, triggers, and bulk processing.
• Expert-level proficiency in Oracle SQL and PL/SQL development, including complex data flows.
• Strong experience designing and implementing Oracle-driven data integration pipelines using SQL, PL/SQL, and Unix shell scripting.
• Proven ability to perform proactive and reactive Oracle performance tuning using explain plans and indexing strategies.
• Hands-on experience developing and supporting Unix shell scripts.
• Deep understanding of dimensional modeling, star/snowflake schemas, facts, and dimensions.
• Experience automating Oracle processes using job schedulers, preferably Autosys.
• Skilled in connecting to heterogeneous databases, including Oracle and MS SQL Server.
• Experience with CI/CD pipelines and utilizing AI tools like Github Copilot to accelerate delivery.

Preferred Skills

• Experience with Vertica data warehousing.
• Background in Agile story refinement and effort estimation.

Key Skills

Education

Any Gradute