PL/SQL Developer
at Mastech Digital
in
Pennington,
New Jersey
Posted in Other 3 days ago.
Type: full-time
Job Description:
- 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