Required Education:
• Bachelor’s degree in computer science, Information Technology, or a related field.
Required Qualifications
• 5–10 years of professional experience as a SQL Developer or in a similar database-focused role.
• Expert proficiency in SQL and Oracle databases, including extensive experience with PL/SQL, stored procedures, functions, and performance tuning.
• Hands-on experience with MongoDB, including a strong understanding of MQL, indexing, and the aggregation framework.
• Proven experience in data modeling for both relational (Oracle) and NoSQL (MongoDB) databases.
• Strong analytical and problem-solving skills with the ability to troubleshoot complex database issues.
• Excellent communication skills and the ability to work effectively in a collaborative team environment.
Preferred Skills
• Experience with cloud-based database services such as Oracle Cloud, AWS RDS, or MongoDB Atlas.
• Knowledge of ETL tools (e.g., Informatica, Talend, SSIS).
• Proficiency in scripting languages like Python, Bash, or PowerShell for automation.
• Familiarity with Agile/Scrum development methodologies.
• Experience with version control systems, such as Git.
• Knowledge of other database technologies is a plus.
Job Summary
We are looking for an experienced and highly skilled Senior SQL Developer with 5–10 years of professional experience to join our data management team. The ideal candidate will have deep expertise in both Oracle and MongoDB environments and will be responsible for designing, developing, and maintaining our critical database systems. This role requires a strong ability to write complex queries, optimize database performance, and work collaboratively with application developers and business stakeholders to deliver robust and scalable data solutions.
Key Responsibilities
Database Development:
• Design, develop, and implement complex SQL and PL/SQL stored procedures, functions, triggers, and packages in an Oracle environment.
• Write and optimize advanced queries, views, and scripts to support application development and data analysis.
• Develop and manage data access layers and backend database logic.
MongoDB Development:
• Design, develop, and manage collections and documents within the MongoDB environment.
• Write efficient and complex queries using MongoDB Query Language (MQL) and aggregation pipelines.
• Implement and manage indexing strategies to ensure optimal performance for MongoDB collections.
Data Modeling and Design:
• Create and maintain logical and physical data models for both Oracle (relational) and MongoDB (NoSQL) databases.
• Ensure database designs are scalable, reliable, and meet business requirements.
• Participate in database design and architecture reviews.
Performance Tuning and Optimization:
• Proactively monitor database performance, identify bottlenecks, and implement optimization strategies for both Oracle and MongoDB.
• Analyze query execution plans and tune SQL and MQL queries for maximum efficiency.
• Work with development teams to refactor and improve existing database code.
Data Management and Integration:
• Develop and maintain ETL processes for data migration and integration between Oracle, MongoDB, and other systems.
• Ensure data integrity, consistency, and security across all database platforms.
• Assist with database administration tasks, including backups, restores, and security management.
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
Rose International has been great to me. I thank everyone there for all of their hard work; it has not gone unnoticed.
Melody, Consultant
Thanks for the opportunity. If in the future I ever need a job, I would like to work for Rose International.
David, Consultant
My on-boarding with Rose was outstanding. The packets of information, the process, and great attention to detail each person gave me allowed me to get started quickly.I appreciated each person's friendly and helpful attitude.
Diana, Consultant
I have been very pleased with my experience with Rose International. Everyone that I encountered was very helpful and courteous.
Stephanie, Consultant
The interactions that I have had with your representatives have always been prompt and very professional. I am very pleased and impressed with your company and services.
Sioe, Consultant
EMPLOYEE COMMENTS