Job Description :
PL/SQL Developer (Retail Experience is Preferred)
Commerce, California
Key Responsibilities
1. Develop and maintain solutions for new requests for existing Accounting applications
2. Follow standard coding practices for all new and existing code
3. Resolve any issues dealing with performance for all code released to production
4. Assist with impact analysis of any changes made to the database objects
5. Analyze and resolve any daily transmission issues in a timely manner
6. Developing and updating design documentation
7. Testing the changes developed to ensure bug-free code in higher environments
Required skills:
1. Advanced PL/sql skills, 5+ years, in developing database applications in an Oracle, Unix/Linux/Solaris environment within a multi-tier environment
2. Knowledge of PL/sql, 5+ years, with stored procedures, triggers, packages, functions and complex queries are required at an advanced level
3. Experience with Oracle performance tuning techniques and unit testing methods for PL/sql using Sql Developer for at least 3 years
4. Solid understanding of messaging in middle ware environment, as well as Unix scripting with 3 years working experience
5. Background should include experience with Oracle 10g/11g (3 years or more)
6. Experience Crystal Reports/Oracle Reports&Forms (2 - 3 years)
7. Worked in a multi-tier application environment (3 or more years)
8. Expert knowledge of Hierarchical query structures (2 - 3 years)
9. Excellent interpersonal and communication skills
10. Working knowledge of ADP payroll systems (2 - 3 years)
11. Solid understanding of GITHUB and underlying structures (1 - 2 years)
12. Worked with Oracle RAC clusters and Exadata systems. (2 or more years)
13. Must be experienced with banking interfaces for updating payments and charges (2 or more years)
Additional skills:
1. Knowledge of SDLC and Agile methodologies for 2+ years
2. Good knowledge of XML/XSL/XSLT technologies 1+ years
3. Good knowledge of Web Services 1+years
4. Java/J2EE experience 2+years
5. Experience with JIRA and tasks management 2+ years
6. Experience in UNIX/Solaris based scripting language 2+ years