Job Description :
Oracle DBA

Duration: 6-month contract to hire
Location: Southfield, MI


we would like to convert the contractor after 6-months providing it’s a good fit we are not able to entertain any visa candidates and this unfortunately includes H4 visas as well.
All candidates must be green card holders or US Citizens.

All Interviews must be conducted on-site. We will not consider virtual interviews for out of state candidates for this role.

This role is unique in that the DBA MUST be able to read, troubleshoot AND code in PL/SQL. Usually DBA’s rely on the developers for this, but we are looking for someone who has advanced PL/SQL skills. Must also have excellent communication skills.

Interview process starts with a 30-45 minute technical phone screen with the manager and if that goes well the candidate will be invited on-site for a 2-hour panel. This manager will NOT consider any virtual interviews candidates must come on-site.

Outcomes & Activities:

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
Work with users to define the requirements of new systems development
Develop and maintain standards, procedures and methodologies for effective operation, access, control backup recovery of all client 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 the client location
Coordinate database security requirements including basic education, user guidelines and access authorizations
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
Refresh development and QA databases as necessary
Create storage groups, 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
Implement and upgrade large-scale system and application software packages
Remain compliant with our policies, processes and legal guidelines


Requirements:

Bachelor’s degree or equivalent experience
Minimum of 2 years of experience on Oracle Databases 11g or 12c
Experience in performance tuning, backups and recovery
Proficiency in PLSQL coding, troubleshooting, and performance tuning experience in a High Availability environment
Experience in a RAC environment
Experience with ASM (Automatic Storage Management)
Experience installing, upgrading and patching databases
Proficient in Unix Shell Scripting
Participate in an On Call (24x7) rotation