Client : TCS/Sony Pictures
Job Location: Culver City, CA
Duration: 6+ months
Experience Required : 7 - 8 Years
Job Description - PL/SQL Developer
Experience with Oracle 11g & oracle forms is must
- Expertise in Oracle Database 11g, performance tuning, PL/SQL programming
- Working experience with Oracle Forms
- Strong Pl/SQL programming, writing store procedures, Packages.
- Database Tuning and Optimization, Normalization
- Tables, Constraints, Indexes, Triggers, Cursors, Ref Cursors, anonymous blocks, directories, sequences, synonyms.
- Tuning of complex SQL queries using EXPLAIN PLAN, Hints
- Used Materialized Views, Packages and Dynamic SQL
- Should know best practices to handle Production Environment
- Strong experience with Data warehousing and Data Modelling concepts
- Experience with Scheduling software (e.g. Autosys)
- Experience of development of Unix Shell Scripts
- Provide development and testing support, and follow implementation of standards and best practices in alignment with our architecture patterns
- Identify opportunities to reduce total cost of ownership in the operational application support areas
- Good analytical skills and ability to multitask is a plus
- Attention to detail and ability to manage multiple priorities in a fast-paced environment
- High level of independence but is also a team player
- Bachelor degree in Computer Science or related field
- Overall Experience range : 6 - 8 years
- Demonstrate advanced business and technical acumen for applications
- Demonstrate skills in shaping and leading development of technical specifications
- Strong problem solving and analysis skills
- Demonstrated ability to complete tasks within established timelines
- Strong relationship building skills
- Experience working on Agile Development environment is a plus
- Excellent verbal and communications skill
- Detail oriented
Education/Certifications Desired:
Bachelor's or above