Oracle Data Steward & DB Developer — TS/SCI Clearance

NewGen Technologies

Annapolis (MD)

On-site

USD 110,000 - 150,000

Full time

5 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

The Oracle Data Steward / Oracle Database Developer at NewGen Technologies ensures the quality, integrity, governance, and security of enterprise data while developing and supporting Oracle database solutions.

You will blend data stewardship with PL/SQL programming, data migration, performance tuning, and data integration, collaborating with stakeholders, data owners, developers, and DBAs to keep data accurate and compliant.

Qualifications

5+ years of Oracle Database development experience.
Strong proficiency in Oracle SQL and PL/SQL development.
Experience developing stored procedures, functions, packages, triggers, views, and materialized views.
Experience with Oracle Database 19.
Experience planning and executing data migration and conversion projects.
Strong understanding of ETL processes, data mapping, and data validation techniques.
Experience with SQL performance tuning and query optimization.
Working knowledge of data governance, data quality management, and data stewardship principles.
Experience with Jira, Confluence, and Git.
Strong analytical, troubleshooting, problem-solving, and communication skills.

Responsibilities

Data Stewardship: maintain quality, integrity, security of enterprise data; define data ownership.
Data Stewardship: implement governance policies and best practices; monitor data quality.
Data Stewardship: analyze data quality issues via profiling, validation, cleansing, reconciliation.
Data Stewardship: collaborate with business units to define data definitions and lineage.
Data Stewardship: ensure regulatory compliance for data management.
Data Stewardship: identify opportunities to improve data usability across systems.
Data Stewardship: establish ownership and stewardship responsibilities with users.
Database Development: develop, test, and maintain Oracle database apps and solutions.
Database Development: build PL/SQL packages, procedures, functions, triggers, views, and MVs.
Database Development: create and optimize SQL queries for reporting and support.
Database Development: manage database objects for applications and integrations.
Database Development: participate in code reviews and changes with version control processes.
Database Development: troubleshoot DB issues to ensure reliability and performance.
Data Migration: plan and execute data migration strategies for Oracle implementations, upgrades, consolidations, and cloud moves.
Data Migration: perform ETL/ELT between source and target systems.
Data Migration: develop PL/SQL scripts to automate migrations.
Data Migration: validate migrated data for completeness and accuracy.
Data Migration: conduct reconciliation and post-migration verification.
Data Migration: collaborate on data mappings and migration schedules.
Data Migration: troubleshoot migration issues with minimal business disruption.
Data Migration: support decommissioning and archival tasks.
Database Performance and Security Support: analyze and optimize SQL/PLSQL performance.
Database Performance and Security Support: tune objects and queries for efficiency.
Database Performance and Security Support: monitor performance and recommend improvements.
Database Performance and Security Support: maintain security with roles, privileges, auditing.
Collaboration: work with analysts, developers, DBAs, data owners, and project managers.
Collaboration: provide guidance on data governance and migration activities.
Collaboration: document data dictionaries, migration plans, and procedures.