Hello Professionals,
Greetings,
Need a Senior 10+ years of experienced ORACLE DEVELOPER Only.
Candidate must be Local to Ohio with Ohio DL Copy or State ID of Ohio.
Only H1B and Eads are workable.
Position: Oracle Developer
Location: Columbus, OH (Hybrid)
Client: Confidential
Interview Type: webcam
Introduction
We are seeking a highly experienced Oracle database consultant to address critical limitations in an Oracle 11-based application and database. This application is integral to a recently acquired business and is experiencing frequent crashes, limiting its scalability and reliability. Our internal application team has limited Development DBA expertise, and we require a consultant to assess, optimize, and implement necessary changes to support substantial business growth. All infrastructure is in Azure.
Company Background
Our organization recently acquired a business with a legacy application built on Oracle 11. While the application serves critical business functions, it is currently unstable and not equipped to handle anticipated growth. Ensuring stability and scalability is essential to fully integrate this application into our broader operations and meet future demands.
Project Objectives
The primary goals for this engagement are:
-
Assessment:
-
Analyze the current Oracle 11 database and application environment.
-
Collaborate with the application team and system DBAs to stabilize the database.
-
Optimization:
-
Implement changes to improve database performance and reliability.
-
Optimize application interactions with the database to handle increased loads.
-
Scalability:
-
Enhance the database and application design to support substantial growth.
-
Ensure the system meets future performance and capacity requirements.
-
Migration off Oracle 11 – data platform scalable for workload.
-
Knowledge Transfer:
-
Provide documentation and training to our in-house application team.
-
Recommend best practices for ongoing maintenance and scalability.
Scope of Work
The consultant will:
-
Conduct a comprehensive assessment of the Oracle 11 database and application.
-
Provide a detailed report outlining current issues, risks, and recommended solutions.
-
Implement approved changes, including:
-
Database performance tuning.
-
Schema optimization.
-
Index and query improvements.
-
Application-to-database interaction refinements.
-
Collaborate with the application team to ensure seamless integration of changes.
-
Establish monitoring and alerting mechanisms for ongoing stability.
-
Deliver documentation and conduct training sessions for the in-house team.
Expertise Required
Candidates must demonstrate:
-
Extensive experience with Oracle 11 database administration and development.
-
Proven track record of resolving performance and scalability issues in legacy systems.
-
Proficiency in database performance tuning, schema design, and query optimization.
-
Ability to work with teams with limited DBA expertise.
-
Strong communication and documentation skills.
-
Familiarity with monitoring tools and best practices for ongoing maintenance.
Regards,
Himanshu Shukla
Recruitment Associate
Flairsoft Limited
CMMi and ISO 9001 Certified
Office : 614-888-0700 (Ext-245)
Fax: 614-573-7255
www.flairsoft.net
We Deliver. You Succeed.
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer