Job Description :
Role: Oracle DBA
Location: Southfield, MI
Contract Type: Contract-to-Hire (06 Months Contract)
Interview: Phone then in-person


NOTE: Only Local Candidates Required
NOTE: ONLY GC EAD/GC/Citizens



About this Position: (The purpose of the “Senior Database Administrator” position is to . . . )
Maintain Oracle databases
Plan, implement, support and maintain the CA enterprise database management system environments
Control the migration of database structures from the test environment into the production environment
Manage the production environments
Provide database administration services
Monitor and tune production processes
Understand differences between OLTP and DSS systems
Coach and mentor less senior DBA and development team members
Simultaneously support small and large scope projects
Demonstrate full technical knowledge of all phases of the systems analysis activity

Good to have:
Support EBS release 11i, 12 by:
o supporting applications architecture changes, customizations, stack upgrades
o cloning database and application technology stack
o application system administration
o supporting concurrent managers setup and maintenance
o maintaining EBS technology stack services (web server, forms, reports, discoverer)
o applying EBS security and maintenance patches
o utilizing Oracle Enterprise Manager for application monitoring and performance tuning
o supporting application functional consultants and business analysts


Position Outcomes & Activities:
(You will be measured on your ability to perform the following activities effectively)
Coordinate design and maintenance of complex databases with respect to access methods, access time, device allocation, validation checks, organization, security documentation, guidelines and statistical methods. This includes maintenance of data dictionaries, overall monitoring of standards and procedures and integration of systems through database design.
Support more junior staff in the development of their skills.
Work with multiple application teams to define the requirements of new systems development.
Participate in 24/7 ON CALL rotational schedule
Actively participate in the system architecture meetings
Effectively work with oracle support and other third party vendors
Develop and maintain standards, procedures and methodologies for effective operation, access, control backup recovery of all CAC databases.
Design, implement and modify physical database structures; evaluate, test and implement database management systems, utilities and tools.
Provide all support related issues for databases and application servers in CAC.
Coordinate database security requirements with security team
Develop, maintain, and monitor documentation and procedural standards relating to all database projects.
Conduct and review tests of database systems to verify performance objectives and quality standards.
Ensure the integrity of database backup and restore procedures and maintain related documentation.
Refresh development, test and QA databases as necessary
Create databases, tables and views, review SQL, develop and enforce database standards.
Communicates availability requirements for database accessibility.
Assist in troubleshooting application problems
Prepare time estimates for assigned projects.
Possess general understanding of the system deployment process and correlation with database administration responsibilities.
Assist in disaster recovery planning, testing and execution as needed.
Evaluate project objectives and scope for feasibility.
Execute regular database capacity planning related to database growth and system utilization, trend analysis and predicting future db resource requirements
Implement and upgrade large-scale system and application software packages.
All other duties as assigned
Attendance as required by department


Basic Position Requirements: (What do you need to qualify as a candidate for this position
Required:
Bachelor’s degree or equivalent experience
Minimum of 7 years of experience in Oracle Databases 8i, 9i, 10g and 11g environments
Minimum of 5 years of experience working with Very Large Databases, DSS and Data Warehouse environments
Experience in SQL and database performance tuning, backups and recovery
Remain compliant with our policies, processes and legal guidelines

Preferred:
Strong knowledge of SQL and PL/SQL and stored procedures/packages
Experience using and supporting Oracle Data Integrator
Experience working with OEM/Grid Control 10g, 11g and strong knowledge of tuning and diagnostic pack
Strong knowledge of Unix/Linux environment and shell scripts
Experience with Data Guard, Oracle Streams and Golden Gate
Experience as DBA in a J2EE/Web Logic environments
Oracle DBA certification


Additional Position Requirements:
You need to be organized, with an ability to multi-task and prioritize multiple requests
You need to work with a high sense of urgency to accomplish tasks within deadlines and Service Level Agreements
You need to demonstrate exceptional customer service skills
You need to be able to demonstrate problem-solving skills and make quick decisions
You need to be able to be assertive but always diplomatic
You need to be self-driven, motivated to help, and able to perform with minimal supervision in a team environment
You need to be detail orientated and highly organized


Position Knowledge and Skills: (What Knowledge, Skills and Abilities will you need to succeed in this role
You need to be organized and capable of meeting all deadlines.
You need to remain positive, professional, determined, calm and focused when faced with challenging situations.
You need to be a quick thinker, with an ability to understand and interpret information promptly and effectively.
You need to be self-driven, motivated to help, and able to perform with minimal supervision in a team environment.
You need to be data driven and able to troubleshoot complex issues thoroughly to resolution.