Req ID: 397493
We are currently seeking a Data & Analytics Principal Consultant to join our team in Plano, Texas (US-TX), United States (US).
Senior Data Modeler / Oracle DBA
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.