Oracle Financials DBA

• Implement database software installations, upgrades, and patches
• Conduct regular database performance testing and tuning
• Conduct regular SQL tracing and tuning.
• Capacity planning for database storage and memory
• Recommend and implement dimensional models, including aggregation and indexing strategies
• Implement and maintain operational and disaster recovery procedures
• Manage database security, user accounts and access privileges
• Write and maintain UNIX shell scripts for database monitoring and job automation
• Perform complex bug verification, release testing for assigned products
• Work with fellow DBAs and other internal teams to establish, implement and document database standards
• Confer with internal department managers regarding problems with and the capabilities of various internally used databases
• Flexibility to adapt to and willingness to learn new technologies.
• Advise on database concepts and functional capabilities
• Share responsibility with fellow DBAs for 24/7 on-call support
• Recommend systems changes to programming management
• Demonstrate effective oral and written communication skills with the ability to communicate technical information to non-technical personnel.
• Work positively and have fun within a team environment
• Maintain hot and cold backups using RMAN and maintain backup and recovery documentation
• Ability to work within change control processes
• Maintain detailed project plans for and occasionally lead DBA projects
• Work on multiple Oracle database projects in a fast paced and dynamic environment.

Qualifications

Required :

• 4 to 9 years of experience in managing Oracle relational database systems in a Unix environment.
• 3-4 years of experience supporting Oracle Financials and other database technologies like: Netezza, DB2 and PostgreSQL.
• Strong conceptual and analytic skills.
• Skilled in SQL programming, with knowledge of operating systems and UNIX scripting languages.
• Knowledge of database security management and data integrity concepts, knowledge of ETL and query tools, and experience in code migration, database change management and data management through the various stages of the development life cycle.