Senior Oracle Database Engineer (Development & Administration)

Responsibilities: of the Senior Oracle Database Engineer (Development & Administration): • Debug and resolve complex SQL, PL/SQL, data integrity, and production-processing issues across multiple environments. • Review, rewrite, refactor, and optimize existing SQL and PL/SQL code to improve maintainability and performance. • Develop ad hoc queries and scripts for reporting, reconciliation, data analysis, investigations, and operational support requests. • Maintain and enhance Oracle packages, procedures, functions, triggers, batch jobs, and database interfaces. • Monitor and support enterprise data feeds involving Oracle databases, Apache NiFi, AWS services, APIs, file transfers, and connected applications. • Troubleshoot failed integrations and data-processing workflows while coordinating with application, infrastructure, and database teams. • Perform root-cause analysis and data validation activities to identify and resolve discrepancies between source and target systems. • Support database deployments, production releases, incident response activities, and post-deployment validation efforts. • Analyze and tune SQL and PL/SQL workloads using Oracle performance tools and best practices. • Partner with DBA teams to support Oracle RAC, Data Guard, backup and recovery operations, security, monitoring, and performance optimization. • Create and maintain technical documentation, deployment procedures, operational runbooks, and troubleshooting guides. Qualifications: of the Senior Oracle Database Engineer (Development & Administration): • 10+ years of experience developing and supporting enterprise solutions utilizing Oracle Database. • Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, materialized views, dynamic SQL, collections, bulk processing, and exception handling. • Extensive experience troubleshooting and debugging complex database applications in development, testing, and production environments. • Strong knowledge of SQL and PL/SQL performance tuning, execution-plan analysis, indexing strategies, partitioning, optimizer statistics, concurrency management, and wait-event analysis. • Hands-on experience with Oracle diagnostic and performance tools including AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control. • Experience supporting Apache NiFi data flows, AWS integrations, APIs, file-based interfaces, and enterprise data-feed monitoring. • Working knowledge of Oracle RAC, RMAN backup and recovery, Oracle Data Guard, database security, auditing, and database-object management. • Experience with source control, release management processes, code reviews, deployment planning, and rollback procedures. • Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience. • Active CompTIA Security+ certification required. • Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable. • Active TS/SCI with Full Scope Polygraph (FSP) clearance required.