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.
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.
Similar Jobs
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Leads client-facing SAP data migration and conversion programs across finance, customer, and supply chain processes. Advises on migration strategy, data mapping, cleansing, transformation, testing, cutover, reconciliation, and issue resolution. Directs cross-functional teams, manages risks and dependencies, communicates with senior stakeholders, and coaches team members. Applies SAP technologies including ABAP, SAP HANA, SAP Fiori, SAP Analytics Cloud, and S/4HANA to support ERP transformation and improve repeatable migration processes.
Top Skills:
AbapErpSAPSap Analytics CloudSap FioriSap HanaSap S/4Hana
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Leads specialized tax services focused on energy incentives, tax credits, R&D credits, and tax modeling. Manages client engagements, develops tax strategies, ensures regulatory compliance, oversees project execution, and builds client relationships. Coaches team members, promotes innovation, and advises clients on eligibility, documentation, monetization, transferability, and compliance for energy-related credits.
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Leads Appian BPM solution architecture and client advisory engagements for workflow digitization and process automation. Designs cloud infrastructure, enterprise integrations, secure connectivity, and low-code solutions across Appian, Power Platform, and Pega. Identifies automation opportunities through process modeling and mining, guides implementations using Scrum, and coaches multidisciplinary teams. Advises senior stakeholders, validates outcomes, and supports platform improvements through analytics and service management practices.
Top Skills:
AppianAutomation AnywhereAWSBpmCelonisGoogle Cloud PlatformJIRAJira AlignAzureMicrosoft Power PlatformPegaPower BISap SignavioScrumUipath
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
