Job Description
Job Title: Lead Oracle architecture
\n
Location: Jersey City, New Jersey (Hybrid - flexible)
\n
Duration: 12 Months
\n
Experience: 16+ Years
\n
\n
\n
Job Description:
\n
Lead Oracle architecture, design, development, performance tuning, and technical problem-solving across UI-to-database flows. Translate business requirements into database, ETL, reporting, and integration solutions while partnering with technology and QA teams. Serve as a hands-on technical lead who can code, review, identify edge cases, and communicate effectively with non-technical stakeholders.
\n
\n
Hard skills / core responsibilities
\n
- \n
- Demonstrated experience communicating technical designs and capabilities to non-technical team members, product owners, and partners.
- Create Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g and Oracle 12.
- Strong leading capabilities along with coding skills: understand business requirements and translate them while working with other technology team members, including the QA team.
- Perform code reviews, identify edge cases, and provide solutions to address them.
- Load huge data sets from multiple vendors and perform data cleansing, data transformations, and data loading involving data modeling and data analytics.
- Work on performance tuning for existing SQL and PL/SQL objects and build optimized objects.
- Perform logical and physical design of databases, data modeling, and design specifications to analyze dependencies and perform risk analysis.
- Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests that are performed.
- Write complex queries to identify potential issues when interfaces fail and remediate them.
- Automate flat file loading to Oracle using SQL Loader and create control files for that activity.
- Able to understand the flow end to end from UI to DB.
- Technologies / tools
- Oracle 11g and Oracle 12 advanced database capabilities.
- Oracle PL/SQL objects, SQL performance tuning, materialized views, functions, triggers, packages, and views.
- ETL processing with Python, Oracle, and Unix.
- Complex Unix shell scripts to automate batch job processing and create reports on real-time, daily, and weekly basis.
- SQL Loader and control files for automated flat-file ingestion.
- GitHub Copilot or other Dev Assist tools and capabilities.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Frameworks / delivery methods
\n
- \n
- Batch ETL and real-time stream processing.
- Data cleansing, transformation, loading, modeling, analytics, and dependency / risk analysis.
- Change request documentation, data mapping, program logic, and technical specification discipline.
- Structured code review and edge-case identification practices.
- Batch ETL and real-time stream processing.
- Data cleansing, transformation, loading, modeling, analytics, and dependency / risk analysis.
- Change request documentation, data mapping, program logic, and technical specification discipline.
- Structured code review and edge-case identification practices.
- Technical leadership with hands-on coding depth and ability to guide other technology team members.
- Clear communication with non-technical product owners, partners, and project stakeholders.
- Problem-solving mindset focused on remediation, optimized design, performance, and end-to-end ownership.
- Best fit: senior Oracle architect who remains hands-on and can lead design, PL/SQL development, ETL, performance tuning, and production-style issue remediation.
- Prioritize candidates with proven ability to communicate architecture to non-technical stakeholders while also reviewing code, identifying edge cases, and guiding QA/engineering teams.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n