Sr. Oracle Database Engineer (Development & Administration)
Job Location:
Howard County, MD - USA
Monthly Salary:
Posted on:
Vacancies:
Job Summary
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.
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
- TS/SCI FSP Clearance
- 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
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 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
Required Experience:
Senior IC
About Company
After a couple of years without an operating business, NewGen Technologies (formerly Bongiovi Entertainment) is once again revving its engines following a reverse merger with alternative fuel developer ReFuel America (which now functions as its operating subsidiary). The company hopes ... View more
