Job Description :
Analyzes, designs, programs, debugs, and modifies Oracle based database applications that form a part of integrated software solutions used in local, networked, or Internet-related application suites. Work with complex data models and object relational database structures. Write database PL/SQL packages, procedures and triggers according to the business requirements. Work with a development team in the design, development, testing, tuning and implementation of database applications. Completes documentation and procedures for installation and maintenance. May interact with users to define system requirements and/or necessary modifications.
Essential Duties and Responsibilities -
60% Development, coding, testing and integration.
20% Support and Troubleshooting of data issues.
10% Documentation, training and support.
10% Requirement capture and analysis.
Prerequisites -
Education:
Bachelor’s degree in computer science or related field.
Required experience:
6 - 8 years of experience in database development and design
Proficiency in Oracle 10g,11g, PL/SQL
Proficient in understanding Data Models and relationships to be able to write complex queries
Strong Analytical skills to triage various production issues and provide fixes/solutions
Experience with SQL Developer, SQL Plus, Toad and/or other Oracle application tools
Experience handling LOB objects
Experience with Data Modeling tools like ER-Win
Experience with scripting languages such as Shell, Perl
Proven experience developing and performance tuning large scale enterprise database applications with high transactional volume
In-depth knowledge of various Oracle objects and PL/SQL features
Experience in developing business scenarios, process flows/models, test cases and scripts
Strong technical documentation ability
Strong verbal communication skills and a demonstrated ability to work effectively in team-based development projects
Preferred Experience
Experience with Team Foundation Server for release management and defect tracking.
Familiarity with multiple Operating Systems (Unix, Linux, Windows)
Certifications/Licenses:
OCP and OCA certifications are a plus.
Specialized Knowledge and Skills –
Language Skills:
Well spoken and written communication in English.
Mathematical Skills:
College level skill is required.
Reasoning Skills:
Very good reasoning, problem solving, and innovation skills required.
Computer/Tech. Skills:
Knowledge and ability to use standard software required, specifically Microsoft Office Applications (Word, Excel, Access, etc.
· Stable work history
· Adaptable and professional within team, leaders and clients
· Must exhibit enthusiasm; highly energetic and self-motivated
· Must exhibit patience and understanding
· Articulate speaker; ability to deliver communication effectively