Oracle Database Consultant


Bothell, WA

Industry: IT Consulting/Services


5 - 7 years

Posted 418 days ago

  by    Emily Russo

This job is no longer available.

We are looking for Oracle Database Consultant for our client in Bothell, WA

Job Title: Oracle Database Consultant

Job Location: Bothell, WA

Job Type: Contract – 12 Months / Contract to Hire / Direct Hire

Job Description:

Responsibilities & Qualifications:

  • Responsible for the day to day Database operations including maintenance, monitoring, backup and recovery
  • Work with compliance and legal to determine data retention policies and requirements; execute retirement and define purge parameters under their direction
  • Define and implement security best practices to secure, maintain and access archived data
  • Review application and databasearchitecture to ensure data archiving solution is highly available and scalable
  • Coordinate with cross-functional teams to ensure processes running backups, archiving and retrieval are occurring appropriately
  • Perform installation, configuration, troubleshooting, code optimization and capacity planning for application and databaseinfrastructure to support application and data life cycle management
  • Minimal functional and technical requirements
  • Experienced in IBM-AIX, HP-UX and Sun Solaris environment to deploy and configure Oracle Databases and Optim application
  • Experienced working with Oracle and SQL Server including Oracle RAC and Data Guard to administer and maintain multi-terabyte databases supporting Highly Transactional and Data Warehouse applications
  • Experienced in Enterprise Archiving applications such as IBM Optim Infosphere Data Archiving or similar
  • Experienced in logical and physical data modeling to support application and data retirement/masking of various applications
  • Experienced in Scripting and programming languages: Shell, VB Script, or similar and T-SQL, PL/SQL or similar
  • Experienced in writing, debugging and tuning SQL and PL/SQL codes, SSIS Packages, Stored procedure, functions, triggers etc. to troubleshoot issues related to databases or archiving processes

Minimum Education and Experience Requirements:

  • Four yeardegree in Computer Science , Engineering or Information Tech Discipline and 5 years of experience OR Master’s Degree in Computer Science , Engineering or Information Tech Discipline and 3 years of experience