Data Steward/Database Developer

NewGen Technologies; Annapolis (MD); On-site; USD 110,000 - 150,000; Full time

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.

Skills

Oracle SQL

PL/SQL

Data Governance

Data Migration

Data Quality

Performance Tuning

Security Controls

Jira

Confluence

Git

Education

Bachelor's degree in Computer Science, Information Systems, Data Management, or related field

Tools

Jira

Confluence

Git

Job description

The Oracle Data Steward / Oracle Database Developer is responsible for ensuring the quality, integrity, governance, and security of enterprise data while developing, maintaining, and supporting Oracle database solutions. This role combines data stewardship responsibilities with Oracle database development expertise, including PL/SQL programming, data migration, performance tuning, and data integration. The successful candidate will collaborate with business stakeholders, data owners, developers, and database administrators to ensure enterprise data is accurate, reliable, and compliant with organizational standards.

Responsibilities

• Data Stewardship
  • Serve as a Data Steward by maintaining the quality, integrity, consistency, and security of enterprise data
  • Implement and support data governance policies, standards, and best practices
  • Monitor, analyze, and resolve data quality issues through data profiling, validation, cleansing, and reconciliation
  • Collaborate with business units to define and maintain business data definitions, metadata, and data lineage
  • Ensure compliance with organizational policies and regulatory requirements related to data management
  • Identify opportunities to improve data quality, consistency, and usability across enterprise systems
  • Work with business users and technical teams to establish data ownership and stewardship responsibilities
• Database Development
  • Develop, test, and maintain Oracle database applications and solutions
  • Develop complex PL/SQL packages, procedures, functions, triggers, views, and materialized views
  • Create, optimize, and maintain SQL queries for reporting, analytics, and application support
  • Develop and maintain database objects to support business applications and system integrations
  • Participate in database code reviews and implement database changes using version control and established change management processes
  • Troubleshoot and resolve database-related issues to ensure application reliability and performance
• Data Migration
  • Plan, develop, and execute data migration strategies for Oracle database implementations, upgrades, consolidations, and cloud migration initiatives
  • Perform data extraction, transformation, validation, and loading (ETL/ELT) activities between source and target systems
  • Develop PL/SQL scripts and SQL utilities to automate data conversion and migration processes
  • Validate migrated data to ensure completeness, accuracy, referential integrity, and compliance with business requirements
  • Conduct reconciliation and post-migration verification activities
  • Collaborate with business users to define data mapping, transformation rules, and migration schedules
  • Troubleshoot and resolve data migration issues while minimizing business disruption
  • Support legacy system decommissioning, data archival, and migration documentation
• Database Performance and Security Support
  • Analyze and optimize SQL and PL/SQL performance
  • Tune database objects and application queries for optimal performance
  • Monitor database performance and recommend optimization strategies
  • Maintain database security through user roles, privileges, auditing, and compliance controls
• Collaboration
  • Work closely with business analysts, application developers, database administrators, data owners, and project manager
  • Provide technical guidance on data governance, database best practices, and data migration activities
  • Prepare and maintain technical documentation, data dictionaries, migration plans, operational procedures, and data quality reports

Requirements

• TS/SCI FSP Clearance
• Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field (or equivalent experience)
• 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

About Us

For more than 20 years, NewGen Technologies has solved our clients' toughest IT challenges with integrity, security, and outstanding service by delivering both technology and talent. We have helped secure borders, have used artificial intelligence (AI) to fight terror, aided the identification of criminals, and have helped to prevent crime through the introduction of biometrics. Our team of Highly Cleared Specialists have hard-to-find skills and expertise in a wide spectrum of technologies to provide solutions that transform business processes and solve problems of national significance. #CJ