Oracle DB Database Developer Job at Eagle Eye Technologies, North Carolina

WDhzZXp2TjlDQmZUMlR2dkV3ZWxleWtXQUE9PQ==
  • Eagle Eye Technologies
  • North Carolina

Job Description

Job Description

Job Description

Title : Oracle DB Database Developer

Client : Fleet Code

Location : Remote

Experience : 8+yrs

Visa : ONLY US CITIZENS

Need Only Strong candidates

LinkedIn Must

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:

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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 collaboration skills

Please send your resumes to:

Email: manoj@eagleiitech.com

Job Tags

Remote job,

Similar Jobs

Soliant

Clinical Staff Pharmacist - State College, Pennsylvania Job at Soliant

 ...considered. A clinical pharmacist position is available in State College, PA, offering a unique hybrid role blending clinical...  ...position as the clinical services program continues to grow. The hospital values expanding its clinical pharmacy services and seeks a motivated... 

The Anderson School

Piano Teacher Job at The Anderson School

 ...sure you're amazing and look forward to meeting you when you move to our neck of the woods. The Anderson School is looking for a piano teacher for Sundays. Availability to sub on other days is a plus. Our ideal candidate has a degree in music with an emphasis... 

Yexgo

Data Entry Clerk ( 100% Remote) - Entry Level Job at Yexgo

 ...inquiriesManaging online customer orders and associated data via EDI portalsGenerating internal reports to sales...  ...:High degree of proficiency and proven past experience in the areas of data entry using software, online portals, spreadsheets, etc.Previous... 

Prevea Health

Clinical Psychologist- Behavioral Care- East Depere Job at Prevea Health

 ...Job Description This position will work 30 hrs per week Clinical Psychologist Come work where we specialize in you! We have...  ...principles and practices of clinical, counseling, rehabilitation or research psychology. Knowledge of current social and health problems... 

Aleut Federal LLC

SQL Database Administrator with Security Clearance Job at Aleut Federal LLC

Aleut Federal is hiring a SQL Database Administrator for the Air Force's BlueSCI enterprise. The SQL Database Administrator must be highly motivated, organized, and highly skilled in administering SQL services for a 40K+ user enterprise. The position is in San Antonio,...