PL/SQL - Oracle DB Engineer
Role: PL/SQL - Oracle DB Engineer
Industry: Financial/banking/investment background
Experience:
12 to 20 years of experience Location: Remote/ First week will be in closest client office onsite
Job Type: 6+ Months Contract
Must Have:
Heavily on hands-on skills like simple PL/SQL scripts and domain-specific data modeling.
Position Summary:
Seeking an experienced Oracle PL/SQL Developer with strong expertise in database development, complex SQL, stored procedures, packages, functions, data modeling, and performance tuning. The role focuses on implementing detailed business logic within Oracle databases and supporting high-volume transactional systems.
Key Responsibilities:
Develop and maintain Oracle PL/SQL solutions.
Create and optimize stored procedures, packages, functions, triggers, and views.
Design logical and physical data models.
Write complex SQL and implement detailed business logic.
Perform query optimization and database performance tuning.
Troubleshoot production issues and support enterprise database applications.
Required Skills:
- Oracle PL/SQLStored Procedures, Packages, Functions, and Triggers
- Advanced SQL DevelopmentQuery Optimization and Performance Tuning
- Execution Plan Analysis
- Data Modeling (Logical and Physical)SQL Developer / TOADGit and Agile methodologies
Required Experience:
- Strong hands-on PL/SQL development experience.
- Expertise in building complex business logic in the database layer.
- Experience with high-volume transactional systems.
- Strong database design and performance tuning skills.
- Top 5 Must-Have SkillsOracle PL/SQLStored Procedures, Packages, and Functions
- Advanced SQL DevelopmentQuery Optimization and Performance TuningData Modeling (Logical and Physical)