Oracle DBA (experience with Cassandra)

Overview

On Site
$100,000 - $115,000
Full Time

Skills

Oracle
Oracle GoldenGate
PL/SQL
Apache Cassandra
Data Quality
SQL

Job Details

Note: This is a fulltime and onsite/hybrid opportunity.

Role: Oracle DBA Work location: Charlotte, NC

Job Description
Skill: Oracle DBA
Must-Have Technical/Functional Skills:

  • Primary Skill: Oracle PL/SQL.
  • Secondary: Oracle GoldenGate, Cassandra.
  • Experience: 7+ years.

Roles & Responsibilities:

  • 7+ years of experience in relational databases.
  • Strong SQL background.
  • Able to troubleshoot and tune SQL performance issues.
  • Experience with Cassandra/CQL/DataStax tools.
  • Firm understanding of the core concepts of Cassandra and able to assist with troubleshooting problems.
  • Experience with Oracle GoldenGate replication technology.
  • Experience with IBM's DataStage is a plus.
  • Experience with development models such as Agile and SDLC.
  • Experience in data management best practices.
  • Must be able to handle multiple tasks and adapt to a constantly changing environment.
  • Must be comfortable working on a distributed, multi-time zone team.
  • Database Development and Optimization.
  • Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers, and views for mission-critical applications.
  • Analyze execution plans, and apply indexing strategies and PL/SQL for performance (bulk operations, indexing, pipelined functions).
  • Ensure normalization, integrity constraints, partitioning, and effective indexing.
  • Collaborate with DBAs for capacity planning and system tuning.

Job Position Summary:

  • Database Engineer responsible for the Oracle and Cassandra databases.
  • The candidate will work closely with Database Administration and development teams to define, develop, and maintain those databases, with a keen focus on data quality and optimal database performance.
  • Must have experience working with large, replicated databases.
  • Strong demonstration of effective written and verbal communication skills.
  • Demonstrated analytical, problem-solving, planning, time management, and organization skills.
  • Proven team player with the ability to foster a team environment.
  • Demonstrated knowledge and comprehension of core business functions, processes, and operations.
  • Experience working with the global delivery model.
  • Ability to lead a discussion and drive to a solution.
  • Ability to troubleshoot complex problems. Self-starter, capable of helping to develop a roadmap for handling DB upgrades.

ABOUT Ztek:

Website:

Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek s diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.

Ztek Consulting | Talent Matters

Ztek is a minority and woman-owned business enterprise that provides customized talent management solutions for clients.

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.