Responsibilities:
Managing multiple production and development Oracle applications environments
Hands-on experience with Oracle RDBMS and Oracle applications versions R12 and R11.5.10
Good understanding of R12 architecture and the various application tier and database tier components
Full applications R12 lifecycle support
Implementing database and application patches, new releases including major upgrades
Providing system refreshes and application cloning
Working with AD utilities, patching techniques and cloning tools in various Oracle applications environments
Working with Oracle support: opening, managing, and resolving Oracle SR's
Practical knowledge of parallel concurrent processing; debugging concurrent managers and requests
Provide experienced technical consulting in the definition, design and creation of a RDBMS database environment
Define, implement and maintain data management standards and best practices
Partner with Data Governance to ensure the safeguarding of data as a corporate asset
Advise applications development team and users on database solutions to business problems, data architectures, database management system facilities and capabilities and the operation and tuning of databases
Identify opportunities for reuse and sharing of data to enhance data value and information integrity while reducing the cost of data ownership
Develop and maintain expertise in use of automated tools for database design and implementation
Collaborate with business and IT delivery teams in the evaluation, selection and/or development of application software solutions
Support 24/7 applications with backup and recovery practices
Requirements:
4 year Bachelor's degree in Computer Science or equivalent
5-7 years as an Oracle Applications DBA (w/R12, 11.5.10 experience)
Minimum of 3 years experience in data analysis, logical and physical data modeling
Experience with tools such as Oracle Enterprise Manager, Oracle ADI, XML Publisher and Workflow
Oracle RDBMS 10g and 11g product implementation, upgrades, architecture and performance tuning
Experience and in-depth understanding of Oracle backup and recovery methodologies, strong skills in RMAN is desired
Experience in database reorganization, migration, capacity planning capacity, disaster recovery and high-availability experience
Highly skilled in SQL and performance tuning
Experience with software engineering principals and industry practices
Experience working in an onsite/offshore development model
Experience in definition and implementation of data management practices
Experience in multi-tiered applications
Ability to work effectively with project and infrastructure teams
Clear and effective written and verbal communication and strong interpersonal skills