Senior Database (Oracle & MongoDB) Developer

Overview

On Site
$100,000 - $125,000
Full Time

Skills

MongoDB
Oracle Db
OracleDB
Oracle
Python
Extract
Transform
Load
File Formats
Confluence
Data Architecture
Bash
Bitbucket
CA Workload Automation AE
Ansible
Backup
Communication
SQL
Writing
XML
NoSQL
JIRA
JSON
Jenkins
Management
Microsoft SSIS
Optimization
Computerized System Validation
Database
Database Design
Documentation
Informatica
Perl
Physical Data Model
Query Optimization
Recovery
Agile
Relational Databases
SQL Tuning
Scripting
Stored Procedures

Job Details

Role: Senior Database (Oracle & MongoDB) Developer
Location: Pennington, NJ/ Plano, TX

Job Description:
Primary Skill: Oracle DB developer, MongoDB Development, MS SQL, ETL, SSIS.

Secondary: Autosys, Informatica.

  • 5+ years of experience as an Oracle Database developer & 3+ years of experience working with MongoDB are required.
  • Autosys, Informatica, scripting such as bash, perl, or python, stored procedures, triggers, table and index creation, and familiarity with database design and development.
  • Experience in SQL tuning optimization will be important.
  • Expected to have good communication and documentation skills.
  • Solid understanding of data architecture, logical and physical data modeling for producing efficient database design.
  • Experience writing complex queries, query tuning, and troubleshooting. In addition, resources will work independently with minimal guidance, in understanding requirements provided by Business Analysts and writing ETL programs to source data from upstream database systems as well as data sourced with various file formats such xml, CSV, etc.
  • Required Skills:
  • 5+ years of experience as an Oracle Database Developer.
  • 3+ years of experience working with MongoDB.
  • Proficient in managing both Oracle relational databases and MongoDB NoSQL databases.
  • Strong understanding of both Oracle database concepts (like tables, views, materialized views, SQL, schema design) and MongoDB administration (document structure, querying with JSON, aggregation pipelines).
  • Monitoring and tuning database performance on both platforms to ensure optimal query response times.
  • Managing backup and recovery procedures for both Oracle and MongoDB databases to ensure data availability.
  • Query optimization using various analysis methods.
  • Writing complex queries and troubleshooting.
  • Must have used automation tools like Autosys.
  • ETL Process expertise and working knowledge of tools like Informatica.
  • Must have worked with database deployment automation tools like Liquibase. Desired Skills.
  • Experience with Agile process and tools like JIRA, Confluence wiki, Bitbucket, Jenkins, Ansible, etc.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.