SQL/ MongoDB Developer

Mitchell Martin
Irving, United States of America
17 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Irving, United States of America

Tech stack

Data analysis
Backup Devices
Bash
Cloud Database
Databases
ETL
Data Migration
Data Security
Query Languages
Python
MongoDB
NoSQL
Oracle
Oracle Applications
Performance Tuning
Powershell
Software Engineering
SQL Stored Procedures
PL-SQL
SQL Databases
SQL Server Integration Services
Talend
Scripting (Bash/Python/Go/Ruby)
Informatica Powercenter
Database Optimization
Indexer
Amazon Web Services (AWS)
Information Technology
Data Management
Oracle Cloud Infrastructure

Job description

  • Hands on with Design, develop, and implement complex SQL and PL/SQL stored procedures, functions, triggers, and packages in an Oracle environment.
  • Write and optimize advanced queries, views, and scripts to support application development and data analysis.
  • Develop and manage data access layers and backend database logic.

MongoDB Development:

  • Design, develop, and manage collections and documents within our MongoDB environment.
  • Write efficient and complex queries using the MongoDB Query Language (MQL) and aggregation pipelines.
  • Implement and manage indexing strategies to ensure optimal performance for MongoDB collections.

Requirements

  • Senior SQL Developer with 5-10 years of professional experience
  • The ideal candidate will have deep expertise in both Oracle and MongoDB environments, * Bachelor''s degree in Computer Science, Information Technology, or a related field.
  • 5-10 years of professional experience as a SQL Developer or in a similar database-focused role.
  • Expert proficiency in SQL and Oracle databases, including extensive experience with PL/SQL, stored procedures, functions, and performance tuning.
  • Hands-on experience with MongoDB, including a strong understanding of MQL, indexing, and the aggregation framework.
  • Proven experience in data modeling for both relational (Oracle) and NoSQL (MongoDB) databases.

Skills:

  • Data Modeling and Design: Create and maintain logical and physical data models for both Oracle (relational) and MongoDB (NoSQL) databases.
  • Performance Tuning and Optimization: implement optimization strategies for both Oracle and MongoDB.
  • Data Management and Integration: Develop and maintain ETL processes for data migration and integration between Oracle, MongoDB, and other systems.

Preferred Skills:

  • Experience with cloud-based database services such as Oracle Cloud, AWS RDS, or MongoDB Atlas.
  • Knowledge of ETL tools (e.g., Informatica, Talend, SSIS).
  • Proficiency in scripting languages like Python, Bash, or PowerShell for automation.

Apply for this position