Mastech Digital
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 be familiar with ETL and scheduling tools such as Autosys
ETL Process expertise and working knowledge of tools like Informatica
Must have worked with database deployment automation tools like Liquibase