Oracle Database Developer

Software Development
United States
November 4, 2024
Remote
Login to Apply

Job Description

Hi Professionals,

Hope you are doing well

We do have an opportunity for Oracle Database Developer Kindly check the JD below and Let me know if you are interested in this position

We Need -(Database Development/Data Migration/ Performance Tuning/Production Support/Database Design and Modeling/Scripting and Automation/Collaboration and Communication/Qualifications.)

Full Name:

Current Location:

Candidate Current Location:

Preferences Location:

Current Visa:

SSN Last 4 Digit Number:

Interview Availability:

LinkedIn Id:

Total Years of Relevant Experience:

Total Years of US Experience:

Title : Oracle Database Developer

Location : Remote

Oracle Database Developer -Remote

Experience : 8+ Years Experience

Need Only Strong candidates

LinkedIn Must

Work Authorization: US Citizen, Green Card Holder, H1B Visa+ H4 EAD and TN Visa

Job description:

We are seeking a skilled Database Developer to support our data migration, performance tuning, and application enhancement efforts. The ideal candidate will have extensive experience in PL/SQL development, database design, and production support.

Key Responsibilities:

* Database Development:
• Develop and modify PL/SQL packages, procedures, triggers, functions, and indexes to support data migration, new business requirements, and application enhancements.

• Create and modify database objects such as tables, views, synonyms, materialized views, and stored procedures.

* Data Migration:
• Design and implement data migration processes from legacy applications to new applications, including the creation of XML files for data migration.

• Coordinate with other teams involved in the migration process.

* Performance Tuning:
• Fine-tune database objects and SQL queries for optimal performance, using techniques such as query rewriting, index optimization, query hints, and partitioning.

• Analyze query performance using explain plan tables and optimize SQL queries with sub[1]queries, analytical functions, and inline views.

* Production Support:
• Fix production issues, provide user training and support, and improve application performance by rewriting SQL queries and optimizing PL/SQL code.

• Manage the packaging and release of code changes for applications in different environments.

* Database Design and Modeling:
• Create logical and physical data models using normalization techniques.

• Build and configure database structures, tables, views, constraints, and indexes to collect and normalize business data.

• Generate SQL and PL/SQL scripts for database object creation and manipulation.

* Scripting and Automation:
• Create and modify Unix shell scripts to support project requirements and client needs.

• Utilize Oracle utilities like SQL*Plus and PL/SQL Developer for database development tasks.

• Manage Autosys jobs for process automation.

* Collaboration and Communication:
• Coordinate with business application owners, front-end teams, architects, and other teams involved in upstream/downstream interfaces.

• Interact with various stakeholders to ensure seamless integration and functionality.

* Qualifications:
• Proven experience in PL/SQL development and database management.

• Strong understanding of database design and modelling principles.

• Experience with performance tuning and production support.

• Proficiency in Unix shell scripting and Oracle utilities.

* • Excellent communication and coll

Related Jobs