Job Seekers, Please send resumes to resumes@hireitpeople.com

•  Designs systems and programs to meet complex business needs. Prepares detailed specifications from which programs are developed and coded. Ensures programs meet standards and technical specifications; performs technical analysis and component delivery.
• Gathers information from the existing systems, analyzes program and time requirements, and prepares documentation to change existing programs.
• Researches and analyzes existing systems and program requirements, under periodic supervision.
• Designs programs for projects or enhancements to existing programs.
• Writes specifications for programs of low to moderate complexity.
• Assists in resolving production support problems. Develops and suggests alternative approaches to resolving problems.
• Develops test plans to verify logic of new or modified programs. Identifies issues as appropriate.
• Creates appropriate documentation in work assignments such as program code, and technical documentation.
• Conducts quality assurance activities such as peer reviews.
• Remains abreast of and researches industry technical trends and new development to maintain current skills and remain current with industry standards.
• Must be able to conceptualize, design and write complex SQL queries and PL/SQL stored procedures and functions
• Should be able to understand and implement various advanced features of Oracle such as Table Partitioning, Indexing strategies, DBMS_Scheduler, DBMS_ALERT etc.
• Must be able to understand various Query Execution Paths
• Should have experience in Query Tuning and Performance Optimization
• Should have experience and general understanding of Data modeling, Entity Relationship, Use Case etc.
• Analyze business requirements /functional specification
• Propose scalable and effective technology solutions around Oracle database
• Prepare high level and detailed Technical Design Documents
• Prepare and Unit Test Code in Oracle PL/SQL on Oracle 10g/11g Unix environment using tools like TOAD, SQL developer
• Creates appropriate documentation in work assignments such as program code, and technical documentation. 
• Conducts quality assurance activities such as peer reviews. 
• Remains abreast of and researches industry technical trends and new development to maintain current skills and remain current with industry standards. 
• Design cost-effective, secure, scalable, high- performance database solutions to support various business applications throughout the SDLC.
• Knowledge of design fundamentals and data modeling concepts.
• Strong experience in working with business/IT partners to understand business requirements.
• Ability to implement complex business logic and working in environment with a short development cycle.

• In-depth knowledge of various Oracle database technologies, such as Oracle 10g, Oracle 11g, Enterprise User Security, etc.
• Strong skills in database and SQL performance tuning and troubleshooting.
• Experience with Linux, Solaris and other UNIX operating systems and strong shell scripting.
• Ability to work in a fast-paced and dynamic environment.
• Excellent analytical and problem-solving skills.
• Excellent documentation, communication and interpersonal skills.
• Strong customer facing technical presence with the ability to solve complex problems.
• Expertise in advanced SQL query development in Oracle.
• Ability to interact as a productive team member on a project team, or manage project tasks independently.
• Ability to apply technical knowledge to create business process solutions.
• Ability to work on application development independently.
• Ability to communicate effectively orally and in writing.
• Ability to translate complex information into understandable terms.
• Ability to solve problems creatively.

Experience Required: Bachelor’s Degree or Higher in Computer Science or related or foreign Equivalent