Oracle DB Database Developer

Eagle Eye Technologies

Full-time - Mid Level

Remote

11-50 employees

Professional, Scientific, and Technical Services

About the position

The Oracle DB Database Developer will play a crucial role in supporting data migration, performance tuning, and application enhancement efforts. This position requires extensive experience in PL/SQL development, database design, and production support, focusing on optimizing database performance and ensuring seamless integration with various applications.

Responsibilities

• Develop and modify PL/SQL packages, procedures, triggers, functions, and indexes to support data migration and application enhancements.
• Create and modify database objects such as tables, views, synonyms, materialized views, and stored procedures.
• 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.
• Fine-tune database objects and SQL queries for optimal performance using techniques such as query rewriting and index optimization.
• Analyze query performance using explain plan tables and optimize SQL queries with subqueries and analytical functions.
• 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.
• 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.
• 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.
• Coordinate with business application owners, front-end teams, architects, and other teams involved in upstream/downstream interfaces.

Requirements

• 8+ years of experience in PL/SQL development and database management.
• Strong understanding of database design and modeling principles.
• Experience with performance tuning and production support.
• Proficiency in Unix shell scripting and Oracle utilities.
• Excellent communication and collaboration skills.