Sign upLog in
See more jobs

Cleared Senior Oracle Database Engineer

Azusa Solutions
  • Annapolis Junction, Maryland
    2 days ago

    Job Description

    **Only applicants with an Active TS/SCI and FSP need apply.**

    Azusa Solutions is seeking a Sr. Oracle Database Engineer to join our team of talented consultants. This is an exciting opportunity to join a growing company comprised of highly qualified, highly impactful, and multi-talented individuals.

    We are seeking a Senior Oracle Database Engineer with 10+ years of experience developing, troubleshooting, and supporting enterprise-scale Oracle database applications. This position is primarily focused on hands-on SQL and PL/SQL development, production debugging, script remediation, ad hoc data analysis, and the maintenance of data feeds and integration endpoints.

    The ideal candidate has expertise in Oracle SQL and PL/SQL, along with complementary database administration skills that support effective production troubleshooting, performance tuning, deployment, recovery, and collaboration with DBA and infrastructure teams.


    Required Skills:
    • 10+ years of experience developing and supporting enterprise solutions using Oracle Database, including Oracle 10g through current versions.
    • Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, dynamic SQL, collections, bulk processing, exception handling, and database APIs.
    • Extensive experience debugging and troubleshooting complex SQL and PL/SQL code in development, test, and production environments.
    • Demonstrated ability to:
      • Analyze existing database code and business logic.
      • Identify defects, data issues, and performance bottlenecks.
      • Rewrite, refactor, and optimize existing scripts.
      • Develop and maintain operational and production-support scripts.
      • Create ad hoc queries for data analysis, reporting, reconciliation, validation, and issue resolution.
    • Strong experience maintaining and supporting data feeds and system integrations, including:
      • Apache NiFi data flows and endpoints.
      • AWS services, interfaces, and endpoints.
      • APIs and service-based integrations.
      • File-based data transfers and batch interfaces.
      • Upstream and downstream application dependencies.
      • Data validation, reconciliation, exception handling, and feed monitoring.
    • Experience diagnosing data-feed and integration failures by tracing issues across database objects, PL/SQL processes, NiFi flows, AWS endpoints, files, APIs, and dependent systems.
    • Strong knowledge of SQL and PL/SQL performance tuning, including execution-plan analysis, optimizer statistics, indexing, partitioning, query optimization, locking, concurrency, and wait-event analysis.
    • Experience using Oracle diagnostic and performance tools such as AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
    • Experience supporting high-volume data processing, batch jobs, ETL workflows, data conversion, data migration, and data-reconciliation processes.
    • Working knowledge of database application design, data modeling, schema development, and database object management sufficient to maintain and enhance scalable, reliable database solutions.
    • Experience deploying SQL, PL/SQL, schema, and configuration changes through structured development, testing, validation, and production-release processes.
    • Familiarity with source control, code review, release documentation, rollback planning, and automated or repeatable database deployment practices.
    • Complementary Oracle database administration experience, including working knowledge of:
      • Oracle RAC.
      • RMAN backup and recovery.
      • Oracle Data Guard.
      • Database security, roles, privileges, and auditing.
      • Tablespaces, storage, sessions, locks, and database-object management.
      • Production monitoring, incident troubleshooting, and recovery procedures.


    Education and Certifications:
    • Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.
    • Active CompTIA Security+ certification


    Job Responsibilities:
    • Debug and resolve complex SQL, PL/SQL, data, and production-processing issues.
    • Review, rewrite, refactor, and optimize existing SQL and PL/SQL scripts.
    • Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, data correction, and operational requests.
    • Maintain and enhance PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces.
    • Monitor, troubleshoot, and maintain data feeds involving Oracle, Apache NiFi, AWS endpoints, APIs, files, and connected applications.
    • Investigate failed or incomplete data flows and coordinate resolution across database, integration, application, and infrastructure teams.
    • Perform data validation and root-cause analysis to identify discrepancies between source and target systems.
    • Support application releases, database deployments, production incidents, and post-deployment validation.
    • Tune SQL and PL/SQL workloads to improve performance, scalability, and reliability.
    • Partner with Oracle DBAs on database configuration, RAC, recovery, Data Guard, security, performance, and environment-related issues.
    • Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks.

    About Azusa
    Azusa Solutions (Azusa) helps clients solve their toughest challenges in the area Enterprise Application Development and Maintenance. Azusa is an equal opportunity employer. Find out more about Azusa at www.AzusaSolutions.com.

    Ask about our Monetary Referral Incentive!
     

    Numbers & Facts

    LocationAnnapolis Junction, Maryland
    Websitehttps://www.AzusaSolutions.com

    Skills

    • Amazon Web Services (AWS)unmatched
    • Analysis Skillsunmatched
    • Apacheunmatched
    • Application Integrationunmatched
    • Application Programming Interface (API)unmatched
    • Auditingunmatched
    • Cloud Computingunmatched
    • Code Reviewsunmatched
    • CompTIA Security+unmatched
    • Computer Scienceunmatched
    • Concurrencyunmatched
    • Customer Support/Serviceunmatched
    • Data Analysisunmatched
    • Data Migrationunmatched
    • Data Modelingunmatched
    • Data Processingunmatched
    • Data Qualityunmatched
    • Data Recoveryunmatched
    • Database Administrationunmatched
    • Database Analysisunmatched
    • Database Designunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Programmingunmatched
    • Database Technologyunmatched
    • Database Triggersunmatched
    • Debugging Skillsunmatched
    • Documentation Planunmatched
    • Editingunmatched
    • Enterprise Applicationsunmatched
    • Environmental Issuesunmatched
    • Error Handlingunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Information/Data Security (InfoSec)unmatched
    • Operations Planningunmatched
    • Oracleunmatched
    • Oracle Applicationsunmatched
    • Oracle DBA (Database Administrator)unmatched
    • Oracle Databaseunmatched
    • Oracle Database 10gunmatched
    • Oracle Enterprise Managerunmatched
    • Oracle PL-SQLunmatched
    • Oracle RAC (Real Application Clusters)unmatched
    • Performance Managementunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Process Flowunmatched
    • Production Controlunmatched
    • Production Supportunmatched
    • Production Systemsunmatched
    • Query Analysisunmatched
    • Query Optimizationunmatched
    • RMANunmatched
    • Reconciliationunmatched
    • Refactoringunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Scripting (Scripting Languages)unmatched
    • Software Administrationunmatched
    • Software Designunmatched
    • Software Developmentunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Statisticsunmatched
    • System Integration (SI)unmatched
    • Technical Supportunmatched
    • Technical Writingunmatched
    • Test Plan/Scheduleunmatched
    • Testingunmatched
    • Validation Testingunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder