Oracle Database Admin from System One
Broken Arrow, OK 74012
About the Job
Location:
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
- Onsite in Columbus, OH, Broken Arrow, OK, Dallas, TX or remote
- 6 month contract
- Max bill rate $155
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
- 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
- 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