Description

KEY RESPONSIBILITIES
Design and maintain logical and physical data models for enterprise Oracle environments.
Analyze business requirements and translate them into scalable database designs.
Develop and optimize complex Oracle SQL & PL/SQL including packages, procedures, functions, triggers, and queries.
Use Erwin Data Modeler to create, maintain, and document enterprise data models.
Perform database design, normalization, schema optimization, indexing, and constraint design.
Analyze existing database structures and recommend improvements for performance, scalability, maintainability, and data integrity.
Develop clean, scalable, and maintainable database code.
Participate in requirements analysis and technical design activities.
Perform unit testing and prepare database/application components for deployment.
Troubleshoot, debug, revise, update, and refactor existing and legacy code.
Support database development, testing, production implementation, and complex technical issues.
Collaborate with application developers, architects, business analysts, and technical teams.
Maintain technical and database documentation.
Work with source-control systems across multiple development branches.
Provide production support and third-tier help desk support when required.

REQUIRED QUALIFICATIONS
10+ years of professional Oracle database development & data modeling experience
Advanced hands-on Oracle SQL & PL/SQL
Strong Erwin Data Modeler or comparable enterprise data modeling experience
Extensive logical & physical data modeling experience
Strong knowledge of:
• Database Normalization
• Entity Relationships
• Indexing
• Constraints
• Schema Design
• Database Performance Optimization

CORE SKILLS
Oracle | PL/SQL | SQL | Erwin Data Modeler | Data Modeling | Toad | SQL Plus | Packages | Procedures | Functions | Triggers | Views | DML | Collections | Async Processes | Query Optimization | Execution Plans | Database Design | Data Normalization | Performance Tuning

Key Skills

Education

Any Graduate