Oracle DBA

Overview

BASED ON EXPERIENCE
Full Time
Contract - W2
Contract - Independent

Skills

Database administration
Database performance tuning
Oracle RMAN
Backup administration
Linux administration
Shell
Unix
Migration
Microservices
Oracle RAC
RPO
Recovery
Encryption
Quality assurance
Management
RAC
Production support
Red Hat Linux
File systems
Oracle ASM
Application service management
GRID
Ansible
Automation
Scripting
Linux
High availability
Oracle Data Guard
Database architecture
Design
Replication
Cloud computing
Amazon Web Services
Microsoft Azure
Database
Root cause analysis
Oracle
Policies
Entrepreneurship
IT strategy
Partnership
Leadership
Data
Application development
Cyber security
Recruiting

Job Details

Tasks:
  • Install, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, and software and related tools/products for the database systems at OTI.
  • Implement Grid Infrastructure release 19c on a OS Unix/Linux platform support databases;
  • Implement Oracle Automatic Storage Management (ASM) cluster Filesystem and maintain it; Add new disks to an ASM disk group.
  • Patching grid infrastructure and Oracle rdbms.
  • Setup Oracle database security environment.
  • Carry out DB Performance Tuning, and RMAN backups.
  • Working with Oracle, implement best of class solutions.
  • Utilize Linux Administration skills as needed; develop UNIX shell scripts; Automation using ansible; work with the Database team and teams of Unix engineers and administrators to design, build, upgrade and support the necessary Oracle infrastructure.
  • Work hands on more extensive projects such as migration, implementing of new features, architectures and validation.
  • Configure Golden gate replication; both integrated and microservices based configuration.
  • Configure Oracle RAC and ASM technologies on Redhat Linux.
  • Configure Oracle Data Guard with Active and Standby database modes.
  • Assist developers and end users in implementing best practices and addressing performance issues in implementation.
  • Ensure all databases are backed up and meets the business's Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
  • Lead team efforts in adopting in modernized architecture such as hybrid cloud and database ready for hybrid cloud.
  • Perform RCA; manage different database encryption technologies; and implement DR by design and validate.
  • Perform special projects, and initiatives as assigned by OTI.
  • Experience with latest Oracle versions and their features but not limited to Multi-tenant Architecture, Oracle Partitioning, Real Application Testing (RAT), Oracle Database Vault.
Mandatory Skills/Experience:
  • Minimum 12 years of hands- on experience in database engineering.
  • Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support.
  • Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment.
  • Experience implementing ASM cluster Filesystem with knowledge of how to maintain it for successful operational delivery.
  • Knowledge of Best Practices for adding a new disk to an ASM disk group.
  • Experience patching grid infrastructure software.
  • Familiarity with Oracle database resource manager.
  • Familiar with Ansible/automation/scripting.
  • Familiarity with huge pages on Linux.
  • Experience supporting a high-availability production database.
  • Experience in configuring/supporting Oracle Active Data Guard required.
  • Experience in database architecture and design; Oracle Advanced Security Option; and Golden Gate for Oracle Replication
  • Knowledge of working on cloud environments preferable AWS & AZURE. Participate in application/DB outage incidents during trouble shooting and provides solution and RCA.
Desirable Experience:
  • Experience with Oracle Advanced Security Option is highly desirable.

    Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.

    Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing

    Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

    About Spruce Technology Inc.