Application Architect

Genesis10 is currently seeking an Oracle Architect - Hybrid position with a Global Financial Institution located in Pennington, NJ. This is a 12+ month contract opportunity.

This role involves designing, developing, and maintaining high-performance PL/SQL packages and complex SQL queries for critical business workflows. The ideal candidate will be an expert in Oracle databases, specializing in advanced performance tuning and troubleshooting production issues while collaborating with architects and engineering teams. This position requires 3 days onsite per week.

Responsibilities:

• Designing, developing, and maintaining PL/SQL packages, procedures, functions, and triggers to support critical business workflows
• Writing and optimizing complex SQL queries, execution plans, and database interactions to ensure high performance, scalability, and reliability
• Performing advanced performance tuning using tools such as AWR reports, SQL Trace, execution plans, and index optimization
• Reviewing code and pull requests to ensure coding standards, performance efficiency, and security best practices are followed
• Troubleshooting production issues by analyzing logs, database metrics, and system behavior under peak load conditions
• Improving automation across builds, deployments, and database-related test suites to enhance development efficiency and system stability
• Actively monitoring database and application health, addressing technical debt, and mitigating potential performance or scalability risks
• Collaborating closely with product owners, architects, and cross-functional engineering teams to clarify requirements, align on solution design, and deliver features efficiently
• Mentoring team members on SQL best practices, performance tuning techniques, and database architecture principles

Requirements:

• Expertise in Oracle Database with Strong PL/SQL and SQL Skills
• Proven experience building and maintaining complex PL/SQL solutions in production environments
• Advanced Performance Tuning Knowledge
• Problem Solving & Critical Thinking - Ability to analyze complex performance and production issues and deliver effective, long-term solutions
• Effective Communication & Stakeholder Management - Clearly communicate technical concepts and recommendations to both technical and non-technical stakeholders
• Strategic Thinking & Decision Making - Balance immediate delivery needs with long-term architectural and performance considerations

Desired skills:

• Oracle GoldenGate experience with familiarity in replication, data synchronization, and real-time data integration

Pay range: $63.68 - $71.68 per hour

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity, please apply!

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:

• Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
• The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
• Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
• Behavioral Health Platform
• Medical, Dental, Vision
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401K
• Sick Pay (for applicable states/municipalities)
• Commuter Benefits (Dallas, NYC, SF, and Illinois)

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.