Job Location : all cities,AK, USA
Location: Onsite in Columbus, OH, Broken Arrow, OK, or Dallas, TX or remote 6 month contract Max bill rate $155 Overview The teammate will be working in our 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