Senior Database (Oracle & MongoDB) Developer
Senior Database (Oracle & MongoDB) Developer
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.
If you’re exploring new job opportunities and wish to know more about this role, then reply to my email or call me on null and I can help you with more details.
I regularly hire for similar roles, and even if you aren’t looking out now, I’d be happy to understand what you are looking for so that if any suitable role is available in the future I can reach out to you,
Looking forward to hearing from you soon.
Equal Opportunity Employer We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.