Data Steward/Database Developer

Oracle Data Steward / Oracle Database DeveloperThe 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.ResponsibilitiesData Stewardship Serve as a Data Steward by maintaining the quality, integrity, consistency, and security of enterprise dataImplement and support data governance policies, standards, and best practicesMonitor, analyze, and resolve data quality issues through data profiling, validation, cleansing, and reconciliationCollaborate with business units to define and maintain business data definitions, metadata, and data lineageEnsure compliance with organizational policies and regulatory requirements related to data managementIdentify opportunities to improve data quality, consistency, and usability across enterprise systemsWork with business users and technical teams to establish data ownership and stewardship responsibilitiesDatabase Development Develop, test, and maintain Oracle database applications and solutionsDevelop complex PL/SQL packages, procedures, functions, triggers, views, and materialized viewsCreate, optimize, and maintain SQL queries for reporting, analytics, and application supportDevelop and maintain database objects to support business applications and system integrationsParticipate in database code reviews and implement database changes using version control and established change management processesTroubleshoot and resolve database-related issues to ensure application reliability and performanceData Migration Plan, develop, and execute data migration strategies for Oracle database implementations, upgrades, consolidations, and cloud migration initiativesPerform data extraction, transformation, validation, and loading (ETL/ELT) activities between source and target systemsDevelop PL/SQL scripts and SQL utilities to automate data conversion and migration processesValidate migrated data to ensure completeness, accuracy, referential integrity, and compliance with business requirementsConduct reconciliation and post-migration verification activitiesCollaborate with business users to define data mapping, transformation rules, and migration schedulesTroubleshoot and resolve data migration issues while minimizing business disruptionSupport legacy system decommissioning, data archival, and migration documentationDatabase Performance and Security Support Analyze and optimize SQL and PL/SQL performanceTune database objects and application queries for optimal performanceMonitor database performance and recommend optimization strategiesMaintain database security through user roles, privileges, auditing, and compliance controlsCollaboration Work closely with business analysts, application developers, database administrators, data owners, and project managerProvide technical guidance on data governance, database best practices, and data migration activitiesPrepare and maintain technical documentation, data dictionaries, migration plans, operational procedures, and data quality reportsRequirementsTS/SCI FSP ClearanceBachelor's degree in Computer Science, Information Systems, Data Management, or a related field (or equivalent experience)5+ years of Oracle Database development experienceStrong proficiency in Oracle SQL and PL/SQL developmentExperience developing stored procedures, functions, packages, triggers, views, and materialized viewsExperience with Oracle Database 19Experience planning and executing data migration and conversion projectsStrong understanding of ETL processes, data mapping, and data validation techniquesExperience with SQL performance tuning and query optimizationWorking knowledge of data governance, data quality management, and data stewardship principlesExperience with Jira, Confluence, and GitStrong analytical, troubleshooting, problem-solving, and communication skillsAbout 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