Oracle Database Administrator Job at ClearpointCo, Houston, TX

dFg1YzZTbHNEVHRmS29iYm83OC84Vmk5
  • ClearpointCo
  • Houston, TX

Job Description

Title: Oracle Database Administrator

Location: Houston, Texas

Type: Direct-Hire, Hybrid- Onsite and Remote

Salary: Dependent On Experience

Summary:

Our client within the energy industry is seeking an Oracle DBA to be responsible the availability, security, support and integrity of the company’s database platforms. This includes, but is not limited to, implementation and maintenance of both SQL and Oracle databases, support to operating units and use of various management tools. The ideal candidate would have a background in database server design and architecture, implementation, database tuning, reporting services and security.

Duties:

  • Perform daily DBA tasks, including but not limited to verify daily backups and resolve backup related issues, verify health check by reviewing database alert log errors, and space usage.
  • Confirm off-site sync and database scheduled jobs completed successfully
  • Resolve blocking, deadlocking, log shipping, connectivity or security issues
  • Monitor database health and performance using Enterprise Manager (13c) or queries and provide recommendations based on monitoring results
  • Install, configure, monitor and troubleshoot MS SQL Server systems in non-clustered and clustered configurations.
  • Keep up with tickets assigned and provide updates frequently
  • Practice good communication skills inside and outside the team
  • Participate in on-call rotation
  • Maintain database documentation and standards
  • Work on projects as defined by Manager Database Systems

Requirements:

  • Experience administering complex 24x7 database environments
  • Hands On experience with Oracle Version 19c
  • Hands On experience with MSSQL Versions (2016, 2017, 2019, 2022)
  • Experience with instance caging and resource management including resource management plan, maintenance window, runaway queries, and CPU limit
  • Good knowledge about partitioning, and compression including Exadata specific compression feature
  • Proven experiences with Access Advisor, Segment Advisor, Memory Advisor and other Oracle Advisor tools
  • Familiar with user, role and profile management including create/delete/change user privileges, create/delete/redesign roles and profiles. Provide recommendation for user access database design by implementing role-based access.
  • Comprehensive knowledge of RMAN backup and recovery including creating, modifying, and implementing RMAN backup scripts, restoring RMAN backups, managing RMAN retention policy, and other RMAN configurations in Data Guard and non-Data Guard environments
  • Experience with flash back and restore points in Data Guard and non-Data Guard environments
  • Experience with Data Guard failover/switchover process
  • Experience with Always On failover process
  • Extensive practice with Enterprise Manager including target management, metric alert management, job management and other database related tools integrated in Enterprise Manager
  • Understand patching procedures including patch search, patch apply procedure, patch rollback procedure and aware of known patch issues
  • Considers Oracle best practices as guidelines in all assigned tasks and make good judgements in what can be applied to current environments

Preferred:

  • Knowledge about Azure/OCI is a plus.
  • Oracle certified Associate - Preferred
  • MCSA for Microsoft SQL Server – Preferred
  • ITIL Foundation – Preferred

Education:

  • Bachelor’s Degree preferred from an esteemed university and relevant studies.

Job Tags

Remote job,

Similar Jobs

VitalCore Health Strategies

Behavioral Health Professional (LCSW, LMHC, LMFT, Psychologist) Job at VitalCore Health Strategies

 ...the Institution. Performs specific psychiatric social service work on the Behavioral Health Unit of a Correctional Facility. Assists in planning and implementing the goals and objectives of programs and projects. May direct special projects as requested. Participates... 

Accenture

Global Executive Compensation Strategist (San Francisco) Job at Accenture

A global consulting firm in California is seeking a Total Rewards professional. The role requires expertise in compensation analysis, project management, and collaboration within a dynamic team. The ideal candidate should have a strong background in data analysis and effective...

LCMC Health

RN Peri/Post Op Outpatient Surgery Center Job at LCMC Health

RN Peri/Post Op Outpatient Surgery Center Join to apply for the RN Peri/Post Op Outpatient Surgery Center role at LCMC HealthRN Peri/Post Op Outpatient Surgery Center 1 week ago Be among the first 25 applicantsJoin to apply for the RN Peri/Post Op Outpatient Surgery Center... 

Two Sigma

Corporate HR Business Partner Job at Two Sigma

Get AI-powered advice on this job and more exclusive features.OverviewTwo Sigma is a financial sciences company that combines data analysis, invention, and rigorous inquiry to help solve the toughest challenges in investment management, securities, private equity, and... 

Genentech

Senior Machine Learning Scientist, AI for Drug Discovery (Frontier Research) Job at Genentech

 ...need today and for generations to come. Creating a world where we all have more time with the people we love. Thats what makes us Roche.Advances in AI, data, and computational sciences are transforming drug discovery and development. Roches Research and Early Development...