• Database Administrator

    ACS Professional StaffingPortland, OR 97240

    Job #1694847582

  • Database Administrator

    Date Posted: 7/20/2021

    Job Function: Technology

    City: Portland

    State/Province: Oregon

    Job Number: JO-2107-9836

    Overview:

    ACS Professional Staffing is looking for an employee to work on-site with our client. The Database Administrator 2 position responsible for providing enterprise Oracle Database support in a dynamic team environment. This position will be supporting both 11g and 12c environments across multiple networks and in multiple configurations to include RAC and Exadata.This full-time position is located in Portland, OR.

    Because we are a federal government contractor, we have special restrictions placed on us for hiring foreign nationals into certain key positions within the company. This particular position requires U.S. citizenship.

    ACS Professional Staffing will provide equal employment opportunities to all applicants without regard to applicant's race, color, religion, sex, gender, genetic information, national origin, age, veteran status, disability status, or any other status protected by federal or state law. The company will provide reasonable accommodations to allow an applicant to participate in the hiring process if so requested.

    Responsibilities:

    • Perform Database Administration (DBA), logical and physical design, capacity planning, backup and recovery, data integrity, data/system security

    • Support a mature, complex, and highly automated Oracle 11g and/or 12c environment that includes Linux on stand-alone systems, Real Application Clusters (RAC) and Exadata engineered systems.

    • Monitor, assess and promote system security and information compliancy and baselines for Relational Data Base Management Systems (RDBMS). Vulnerability and Information System Security management typically considers FISMA, NIST, NERC-CIP, WECC, Non-Coincidental Peak (NCP), Common Vulnerabilities and Exposures (CVE), Information Assurance Vulnerability Management (IAVM), Security Technical Implementation Guide (STIG) and other cyber security standards, measurements, or guidance

    • Perform install, troubleshoot connectivity issues, monitor performance and tune, backup and restore databases in complex three-tier architecture

    • Install, integrate, configure, and use Oracle Enterprise Manager (OEM) 11g and/or 12c Grid Control.

    • Conduct performance tuning and diagnostics for Oracle servers, databases, and SQL.

    • Write and debug Perl and shell scripts to automate DBA processes such as monitoring, performance bottlenecks, batch scheduling, and connectivity failures.

    • Utilize Perl modules Database Interface Module (DBI), & Database Driver (DBD) and customize Perl module development

    • Utilize Linux based tools and knowledge of Linux internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Linux.

    • Recommend ASM storage configuration for maximum performance and manageability.

    • Perform routine database management from command line without the use of GUI Tools.

    • Design, implement and maintain appropriate database continuity of operations plans and solutions.

    • Debug, migrate and extend functionality of current batch processes

    • Provide recommendations for process improvements and technical solutions that can be integrated into existing environments.

    Requirements:

    • Bachelor of Science in Information/Computer Technology or a closely related technical discipline is preferred.

    • 5 Years of work experience in Computer/Information Technology or related field is required.

    • 5+ years of DBA experience including at least 3 years with Oracle 10g R2 or higher.

    • Knowledge of and skill in applying:

    • At least 2 of the following: Oracle 10gR2, 11gR2, 12c

    • Oracle SQL and PL/SQL

    • TOAD, DBArtisan or similar tool(s)

    • Oracle Enterprise Manager 11g and/or 12c Grid Control

    • Scripting languages including Perl and Linux Shells

    • Recovery Manager (RMAN) and DataPump Export

    • Oracle Database Resource Manager

    • Performance tuning of Oracle servers, databases, and SQL with an emphasis in the use of ADDM and AWR.

    • Exadata and RAC architecture and operations

    • Exadata patching process

    • Automatic Storage Management (ASM)

    • Exadata features such as Hybrid Columnar Compressions, Storage Indexes and Smart Scans including tuning to maximize performance benefits.

    • Perl modules and database connectivity

    • Experience supporting on-call operations in a 24x7 environment.

    • Experience working in a large production environment.

    • Valid U.S. Driver's License is required.

    • Required to support on-call operations in a 24x7 environment on a rotational schedule.

    • Work sponsorship not available at this time. No third-party candidates considered for this position.