Duties include:

Analyze business requirements, create conceptual, logical and physical database design, create database schema objects like tables, triggers, indexes, packages, procedures, functions, synonyms etc.  Design Data Architecture, Data Analysis, Oracle PL/SQL programming, database administration, tuning, monitoring and recovery of databases. Utilize Oracle 10g/11g/12c database architecture. Design conceptual, logical and physical Data Modeling using tools like ERWin, MS Visio. Code using advanced Oracle PL/SQL programming with use of proper exception handling, use of cursors, bulk collects, collection objects and build new database components (stored routines, triggers) to meet the requirements.  Track the data growth and provide recommendations to management from scalability perspective, report to DBA team for additional hard disk space requirements. Handle disaster management specifically in 11g Active Data Guard implementation, data migration, RAC, ASM, SQL tuning and database cloning and Oracle streams. Configure Java based development framework, Hibernate, JSF and Eclipse. Analyze data layer architecture from security perspective and DB access optimization. Implement database security requirements. Provide day to day Database deployment and live support.

This Position requires a master’s degree in Computer Science or a bachelor’s degree in the same with 5+ years of experience.