Senior Data Modeler / Oracle DBA - Onsite

NTT DATA

Plano (TX)

On-site

USD 100,000 - 142,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Benefits

Job summary

NTT DATA in Plano, TX is seeking a Data & Analytics Principal Consultant to own the Oracle 19c data model, design logical and physical schemas, and deploy databases across environments.

You will mentor ETL and Java developers on data modeling, SQL and database standards, ensure availability and security, contribute to repeatable deployments with tested rollback plans, and collaborate with stakeholders onsite five days a week to deliver reliable data platforms.

Qualifications

  • 10+ years in data modeling and Oracle development or administration.
  • 5+ years data modeling incl. logical/physical models, data dictionaries, ERwin.
  • 5+ years Oracle SQL and PL/SQL, including design, indexing, partitioning, performance tuning.
  • 5+ years Oracle database administration: backup/recovery, monitoring, security, maintenance.

Responsibilities

  • Design, build, and support Oracle 19c database for retirement, health savings and stock plan data platform.
  • Mentor ETL and Java developers on data modeling, SQL and database standards.

Skills

Data modeling
Oracle development
Oracle administration
Oracle SQL
PL/SQL
Data dictionaries
ERwin
Backup & Recovery
Monitoring
Security

Education

Bachelor's degree in Computer Science, Engineering or Mathematics

Tools

Oracle 19c
AWR
Jenkins
Informatica
Azure

Job description

Data & Analytics Principal Consultant – Plano, Texas, United States (US-TX)

ONSITE 5 days/week
NO STEM OPT
MUST WORK DIRECTLY ON NTTD W2
6 MONTHS with extensions possible

Position Summary / Day-to-Day Responsibilities

We are seeking a Senior Data Modeler / Oracle DBA to design, build and support the Oracle 19c database for a platform that aggregates retirement, health savings and stock plan data. This role will own the logical and physical data models, table creation scripts and database deployments across environments. Day-to-day responsibilities will include designing and tuning database structures, maintaining database availability and security, and supporting repeatable deployments with reviewed scripts and rollback plans. The senior engineer will also partner with and mentor ETL and Java developers on data modeling, SQL and database standards.

Required Qualifications
  • 10+ years of experience in data modeling and Oracle development or administration.
  • 5+ years of data modeling experience, including logical and physical models, data dictionaries, and ERwin or an equivalent modeling tool.
  • 5+ years of Oracle SQL and PL/SQL experience, including database design, indexing, partitioning and performance tuning.
  • 5+ years of Oracle database administration experience, including backup and recovery, monitoring, security and database maintenance.
Preferred Qualifications
  • Bachelor's degree in Computer Science, Engineering or Mathematics.
  • Experience with Oracle 19c, AWR and execution-plan tuning.
  • Experience with scripted database deployments, Jenkins, environment promotion and rollback planning.
  • Experience with data masking, encryption and least-privilege access.
  • Experience with Informatica or other ETL tools, mainframe or DB2 migration to Oracle, or Azure.
  • Experience with financial services, retirement or benefits data.
  • Strong problem-solving and communication skills, with the ability to mentor developers and collaborate across teams.
About NTT DATA

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

Benefits
  • This position is eligible for company benefits including participation in medical, dental, and vision insurance, flexible spending or health savings account, and AD&D insurance, employee assistance, participation in a 401k program, and additional voluntary or legally-required benefits
Salary

NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this role is $88.hour. Actual compensation will depend on a number of factors, including the candidate's relevant experience, technical skills, and other qualifications.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data & Analytics Principal Consultant
Data & Analytics Principal Consultant

NTT DATA, Inc. • Plano (TX)

On-site
USD 120,000 - 150,000
Senior Oracle Data Engineer - Onsite
Senior Oracle Data Engineer - Onsite

NTT DATA, Inc. • Plano (TX)

On-site
USD 103,000 - 171,000
Medical insurance
Dental insurance
Vision insurance
+2
Senior Data Engineer (w/ Oracle & OLTP) - Remote Role
Senior Data Engineer (w/ Oracle & OLTP) - Remote Role

NTT DATA, Inc. • Tennessee

On-site
USD 90,000 - 103,000
Medical insurance
Dental insurance
Vision insurance
+6
Senior Data Engineer (w/ Oracle & OLTP) - Remote Role
Senior Data Engineer (w/ Oracle & OLTP) - Remote Role

NTT DATA • Plano (TX)

Remote
USD 90,000 - 103,000
Medical insurance
Dental & Vision
401(k) with company match
+4
Senior Data Engineer (w/ Oracle & OLTP) - On-Site
Senior Data Engineer (w/ Oracle & OLTP) - On-Site

NTT DATA, Inc. • Plano (TX)

On-site
USD 94,000 - 163,000
Medical Insurance
Dental Insurance
Vision Insurance
+2
Senior Oracle Data Engineer - Onsite
Senior Oracle Data Engineer - Onsite

NTT DATA, Inc. • Plano (TX)

On-site
USD 92,000 - 214,000
Medical, dental, and vision insurance
Employer contribution to benefits
401k with company match
Senior Data Engineer (w/ Oracle & OLTP)
Senior Data Engineer (w/ Oracle & OLTP)

NTT DATA, Inc. • Nashville (TN)

On-site
USD 94,000 - 163,000
Medical insurance
Dental insurance
Vision insurance
+2
Senior Data Architect & Oracle DBA Lead
Senior Data Architect & Oracle DBA Lead

NTT DATA, Inc. • Plano (TX)

On-site
USD 120,000 - 150,000
Senior Oracle Data Engineer - ETL & PowerCenter
Senior Oracle Data Engineer - ETL & PowerCenter

NTT DATA, Inc. • Plano (TX)

Hybrid
USD 103,000 - 171,000
Health insurance
401k with company match
Paid time off
+4
Senior Data Engineer
Senior Data Engineer

NTT DATA • Plano (TX)

Remote
USD 130,000 - 157,000
Fully remote work