Database Developer (Oracle & MongoDB)

Ventures Unlimited Inc; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Ventures Unlimited Inc is seeking an experienced Oracle Database Developer in Plano, Texas. The role requires 5+ years of experience in Oracle development and familiarity with MongoDB. Candidates should demonstrate strong skills in database performance tuning, ETL processes, and automation tools. This position involves developing efficient database designs and ensuring data availability.

The ideal applicant has a Bachelor's degree and significant experience in data architecture, alongside communication skills necessary for understanding business requirements.

Qualifications

• 5+ years of experience as an Oracle Database Developer.
• 3+ years of experience working with MongoDB.
• Strong understanding of database design and development in Oracle and MongoDB.

Responsibilities

• Develop and manage Oracle and MongoDB databases, ensuring optimal performance.
• Design ETL processes and write complex queries for data extraction.
• Use automation tools for database deployment and manage backup procedures.

Skills

Oracle DB development

Mongo DB development

MS SQL

ETL

SSIS

Autosys

Informatica

SQL tuning optimization

bash scripting

perl scripting

python scripting

Education

Bachelor's degree

Tools

Autosys

Informatica

Liquibase

JIRA

Confluence

Bitbucket

Jenkins

Ansible

Job description

Ventures Unlimited Inc. is a cutting edge consulting firm dedicated to help customers effectively execute, manage and support their Product Lifecycle Management, Engineering Services and Enterprise Application Programs in a wide spectrum of domains.

Job Description

• Primary Skill: Oracle DB developer, Mongo DB Development, MS SQL, ETL, SSIS.
• Secondary: Autosys, Informatica.
• 5+ years of experience as an Oracle Database developer & 3+ years of experience working with MongoDB is 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, and query tuning and troubleshooting. In addition, resource 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.

Qualifications

Bachelor's

Additional Information

All your information will be kept confidential according to EEO guidelines.