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 functionsShould 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 PathsShould have experience in Query Tuning and Performance OptimizationShould have experience and general understanding of Data modeling, Entity Relationship, Use Case etc.Analyze business requirements /functional specificationPropose scalable and effective technology solutions around Oracle databasePrepare high level and detailed Technical Design DocumentsPrepare and Unit Test Code in Oracle PL/SQL on Oracle 10g/11g Unix environment using tools like TOAD, SQL developerCreates 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. 
Requirements :
 
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