Oracle Database Developer

Valiant Technologies LLC; Madison (WI); On-site; USD 110,000 - 150,000; Full time

Job summary

Valiant Technologies LLC seeks an experienced Oracle Developer to design, develop, and optimize Oracle database solutions for enterprise applications. You will write advanced SQL, PL/SQL, and manage objects like tables, views, and materialized views.

Key duties include data integration, performance tuning, and ensuring data security. Collaboration with developers, analysts, and QA teams is essential to deliver robust database-driven features.

Qualifications

• Proficient in Oracle Database development and PL/SQL
• Ability to write complex SQL, procedures, functions, packages and triggers
• Experience with data modeling, performance tuning and query optimization
• Knowledge of data migration and ETL processes for enterprise apps
• Familiarity with REST APIs and web services integration

Responsibilities

• Design, develop, and maintain Oracle database applications based on business requirements.
• Write complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Develop and manage database objects including tables, views, indexes, and materialized views.
• Analyze requirements and translate them into technical solutions.
• Perform SQL performance tuning and query optimization.
• Develop and maintain data integration and migration processes.
• Support Oracle database environments for enterprise applications.
• Implement database security and data integrity measures.
• Troubleshoot issues and perform root cause analysis.
• Monitor performance and optimize application efficiency.
• Collaborate with developers, analysts, and QA.
• Participate in code reviews, testing, and deployment activities.
• Support upgrades and production releases.
• Prepare technical documentation and standards.

Skills

Oracle Database

Oracle SQL and PL/SQL

Stored Procedures and Functions

Packages and Triggers

Database Design and Data Modeling

Query Optimization and Performance Tuu

Views, Indexes, and Materialized Views

Oracle SQL Developer

Oracle Data Pump

ETL and Data Migration

REST APIs and Web Services

Tools

Oracle SQL Developer

Oracle Data Pump

Job description

Valiant Technologies LLC seeks an experienced Oracle Developer to design, develop, and optimize Oracle database solutions for enterprise applications. You will write advanced SQL, PL/SQL, and manage objects like tables, views, and materialized views.

Key duties include data integration, performance tuning, and ensuring data security. Collaboration with developers, analysts, and QA teams is essential to deliver robust database-driven features.