Oracle Database Administrator

Oracle Database Administrator 3

Location:

Portland, OR (Remote)

Duration: 12-month Contract (with possible extensions up to 5 years)

Pay Range: $75.48 – $78.71 per hour

The role of the Database Administrator is to administer, test, and implement management approved computer databases, applying knowledge of database management systems. Coordinates changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases. The Database Administrator (DBA) may also perform enterprise level database administration using the Oracle tool suite to install databases, implement scripting, tuning, backups, monitoring, failover and data protection, recovery, security and integrity.

• Test programs or databases, correct errors and make necessary modifications.
• Modify existing databases & database management systems or direct programmers and analysts to make changes.
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Train users and answer questions.
• Specify users and user access levels for each segment of database.
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
• Review project requests describing database user needs to estimate time and cost required to accomplish project.
• Develop standards and guidelines to guide the use & acquisition of software and protect vulnerable information.
• Conduct performance tuning for servers, databases, and SQL.
• Provide recommendations for process improvements and technical solutions that can be integrated into existing environments.
• Perform login management, install/patch, troubleshoot connectivity issues, monitor performance and tune when necessary, backup and restore databases in a complex three-tier architecture (client web interface, application engine, database engine).
• Write and debug Power Shell, VB and/or PERL scripts to automate DBA processes such as monitoring/alarming on volume growth, performance bottlenecks, batch scheduling, and connectivity failures.
• Utilize Windows-based tools and knowledge of Windows internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Windows.
• Recommend SAN-based storage configuration, such as disk layout, to improve performance.
• Provide developer and end-user support for databases including maintaining existing SQL and PL/SQL code and troubleshooting database interoperability problems.
• Perform routine database management from command line without the use of GUI Tools.
• Install and maintain appropriate database fail-over solutions.

• A bachelor's degree in information technology (or closely related technical discipline) is preferred.
  • 10+ years of experience is required with an applicable bachelor's degree.
  • 15+ years of experience is required without a degree or applicable degree.
• Experience should include directly related IT infrastructure administration.

• 10+ years of knowledge and experience sufficient to administer Oracle 19c/23ai on a Linux platform.
• 5+ years of knowledge and experience sufficient to successfully troubleshoot Linux and Windows operating systems using text-based logs, Windows event logs, and various utilities as it pertains to support of Oracle Database services.
• 5+ years knowledge of and experience building tools for other administrators to use and automating operations with scripting tools such as shell scripting, perl, or Power Shell.
• 5+ years of knowledge of and experience with TCP/IP and related services.
• Direct experience supporting production workloads using Oracle RAC.

• Direct experience managing Oracle Exa Data operations including patch management.
• Direct experience working with an enterprise scheduling system.
• Experience with Perl is highly preferred.
• Experience configuring and managing systems using Puppet Enterprise.
• Expert level knowledge/certification for SQL and/or Real Application Clusters.

Medical, dental, and vision insurance, short-term disability, life and AD&D insurance, a 401(k) retirement plan, and a referral bonus program, paid sick/vacation/holidays, and a health and welfare fringe benefit.

Everest Consultants is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state, or federal civil rights laws.