Description
In this role, the Oracle DBA Consultant will:
- Manage all aspects of physical database administration including schema management; security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for Oracle 10g and 11g.
- Support application teams and their projects to enhance, troubleshoot and performance tune while exploring SQL programming for query performance improvements
- Support Oracle Databases in Production, Test and Development environments
- Install, upgrade and test complex database software
- Develop and implement Database Recovery plans and procedure
- Analyzes the performance of Databases and recommends tuning and application changes
The appropriate individual will have demonstrated experience in the following:
- 5+ years of hands-on experience as an Oracle DBA, working directly with Oracle 10g & 11g
- 3+ years of hands-on experience in Oracle RAC, ASM environment
- 3+ years of hands-on experience in Oracle Spatial
- 3+ years of Oracle Gateway
- Strong hands-on performance tuning skills
- Strong SQL and UNIX Scripting skills
- Oracle RDBMS concepts and fundamentals
- Oracle Database Space Management & Capacity Planning
- Oracle RMAN Backup and Recovery techniques
- PL/SQL programming writing complex queries and stored procedures, functions, triggers, etc.
- Advanced querying, T-SQL, PL/SQL, ANSI SQL
- Advanced Programming for Data Transformation (Integration Services, DTS, and XML)
- Provide 24x7 support as needed
- Experience with Oracle OEM, and database monitoring tools
- Experience with Oracle DataGuard, Oracle Streams, and Oracle GRID Control.
- Experience with Solaris and Linux
- Experience with data model tools such as ER-Studio, Oracle Designer, etc.
- Proficient in business analysis, data modelling, logical and physical database design, data acquisition analysis and design, data access analysis and design.
- Proficient in planning and management of scope of work and time estimation.
- Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management.
- Strong problem solving skills and strong desire to learn new technologies.
- Oracle certification in 10g or 11g is a plus.
- Experience with Quest Shareplex is a plus.
- Ability to mentor others is a plus.
- PMP certification is a plus.