Oracle Database Admin

Company: System One
Location: Broken Arrow
Posted on: November 19, 2024

Job Description:

Location: Onsite in Columbus, OH, Broken Arrow, OK, Dallas, TX or remote

Scroll down the page to see all associated job requirements, and any responsibilities successful candidates can expect.
6 month contract
Max bill rate $155

Overview
The teammate will be working in our client's mixed technology environment to deliver data products providing decision support for business and customers. As part of a highly collaborative team, the role will interact with technical and business resources within and outside of IT organization. The ideal candidate is a committed, creative, self-motivated technologist who is interested in practicing current skills and learning new ones.

Primary Duties and Responsibilities Deploy, configure, patch and upgrade database servers and client installs, with a focus of Oracle server production support
Troubleshoot and fix problems and provide root cause analysis in a timely manner
Perform preventive maintenance and system copies
Automate system maintenance tasks
Develop, manage and test backup and recovery plans
Ensure storage and archiving processes are functioning correctly
Write database documentation, including data standards, procedures and data dictionary
Carry out capacity planning
Manage security and disaster recovery aspect of a database
Evaluate SQL Server performance and take appropriate steps for performance improvement
Provide 24x7 on-call support, after hours and weekend work as needed
Relational database design and development
Design OLTP and OLAP environments, and monitor, detect and tune performance
Complete other tasks as required

Experience, Education and Skills 5-6+ years of experience building and administering production level high performance, high transaction volume, and highly available OLTP databases (Oracle and/or SQL Server)
5-6+ years of experience developing, maintaining, and implementing logical and physical data models and PL/SQL or T-SQL solutions in support of complex software development projects
5-6+ years of experience designing and implementing large-scale ETL processes, including data initialization, loading, and conversion
5-6+ years of experience creating and maintaining database documentation and diagrams
3+ years of experience conducting performance monitoring and tuning operations
3+ years of experience administering database security protocols
Knowledge of current DBMS products, primarily Oracle 11g and 12c and SQL Server 2014+, as well as knowledge of related technologies, applications, and processes
Ability to write clear, concise, efficient, and effective DDL, DML, and PL/SQL or T-SQL
Knowledge of relational database internals, objects, and processes, as well as best practice principles regarding availability, performance, and security
Experience working with high availability tools, particularly DataGuard or AlwaysOn
Experience installing OEM and configure to monitor Oracle instances
Experience writing shell scripts to automate database activities
Demonstrated skill using database backup and recovery models, utilities, and best practices
Bachelor's Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, and work experience
Familiar with Agile development methodology
Excellent analytical skills
Excellent interpersonal skills and proficiency to meet face-to-face with internal business customers
Ability to manage multiple, shifting-priority projects

General Requirements Lead and mentor resources on a temporary basis
Exhibit and practice courteous, ethical and professional behavior while interacting with both internal and external customers
Act in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial results
Be accountable and responsible for the accuracy and completeness of assigned work and results
Prioritize and manage work load and communicate issues clearly
Exhibit effective verbal and written communication skills
Comply with all laws, regulations and company policies
Travel when required

Keywords: System One, Stillwater , Oracle Database Admin, IT / Software / Systems , Broken Arrow, Oklahoma