The Role
Design, develop, and optimize Oracle and MongoDB databases; write complex queries, stored procedures, triggers, and ETL (SSIS/Informatica); perform performance tuning, backup/recovery, and deployment automation; work independently with business analysts to source and transform data from databases and files (XML/CSV); use Autosys and scripting for automation; document solutions and participate in Agile processes.
Summary Generated by Built In
Company 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.
- Experience: Minimum 10 Years.
- 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.
Bachelor's
Additional InformationAll your information will be kept confidential according to EEO guidelines.
Skills Required
- Minimum 10 years total experience
- 5+ years as an Oracle Database Developer
- 3+ years working with MongoDB
- Proficient managing both Oracle relational databases and MongoDB NoSQL databases
- Strong understanding of Oracle database concepts (tables, views, materialized views, SQL, schema design)
- MongoDB administration knowledge (document structure, JSON querying, aggregation pipelines)
- Experience with SQL tuning and query optimization
- Experience writing complex queries, stored procedures, triggers, and troubleshooting query issues
- Monitoring and tuning database performance on both platforms
- Managing backup and recovery procedures for Oracle and MongoDB
- ETL process expertise and working knowledge of tools like SSIS and Informatica
- Experience using automation/job tools such as Autosys
- Experience with database deployment automation tools (e.g., Liquibase)
- Scripting experience (bash, perl, or python)
- Solid understanding of data architecture, logical and physical data modeling
- Good communication and documentation skills
- Bachelor's degree
- Experience with Agile tools and CI/CD/DevOps tooling such as JIRA, Confluence, Bitbucket, Jenkins, Ansible
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Ventures Unlimited Inc. is a service-centric organization established in 2004 that specializes in enterprise-wide innovation, integration, and strategy. The company provides a comprehensive suite of IT services, including software development and implementation, cybersecurity, and professional services, aimed at delivering innovative business solutions across various sectors, including healthcare.
