Oracle Database Developer

Job Description

Location: Vanak, Tehran;
Job Type: Full-Time;

About Bonyan System:

Bonyan System has been a leading provider of telecom and IT solutions for over 10 years, specializing in Business Support Systems (BSS) such as Online Charging Systems (OCS), CRM, Interconnect, Mediation, Billing, and the full BSS stack. We partner with major telecom operators to deliver high-quality, scalable IT solutions and manage critical systems that drive their business operations. Our expertise and commitment to innovation have made us a trusted name in the telecom sector.

Role Overview:

We are searching for a highly skilled and motivated Oracle Developer to join our team and lead the design, implementation, and maintenance of our core telecom network. This is an opportunity to work on challenging projects with a global impact and contribute to the evolution of the telecommunications landscape.

Key Responsibilities:

• Design and Development of PL/SQL Scripts: Designing and developing Oracle PL/SQL scripts involves creating stored procedures, packages, and triggers that help optimize database performance. These scripts can automate repetitive tasks and enhance system efficiency.
• Design Data Models: Design and implement relational data models with application-specific entities. Design application data models for conceptual, logical, and physical layers.
• SQL Query Optimization: Creating and optimizing SQL queries to improve system performance is crucial. Techniques such as using indexes, avoiding complex queries, and optimizing JOINs are key in this area. Decrease query execution time.
• Requirements Analysis: Analyzing requirements and designing technical solutions to meet business needs is also an important part of the software development process. This phase includes identifying challenges and proposing appropriate solutions to address them.
• Collaboration with DBA: Collaborating with the DBA for support, data recovery, and data migration is essential. This collaboration involves monitoring database performance, identifying issues, and implementing optimization strategies.
• Data Security: Maintaining data security and ensuring compliance with company policies and standards is another critical responsibility. This includes implementing security measures to protect sensitive information and prevent unauthorized access.
• Designing PL/SQL Procedures and Functions: Designing and implementing PL/SQL procedures and functions allows developers to simplify complex code and improve system performance. These procedures can serve as building blocks for other applications.
• Troubleshooting and Debugging: Troubleshooting and debugging existing systems requires a deep understanding of the database structure and its performance. This process involves identifying system weaknesses and executing necessary corrections to enhance efficiency.

Requirements:

• Experience: At least 3 years of experience in Oracle PL/SQL or similar relational database. The ability to communicate effectively with team members, stakeholders, and clients is crucial for successful collaboration and project execution.
• Strong Communication and Interpersonal Skills: The ability to communicate effectively with team members, stakeholders, and clients is crucial for successful collaboration and project execution.
• Team Spirit: A collaborative mindset is important for working effectively within a team environment, contributing to group efforts, and supporting colleagues.
• Proficiency in English: A strong command of the English language is necessary for reading technical documentation, writing reports, and participating in discussions with international teams.
• Creative and Analytical Thinking: The ability to think creatively and analytically aids in problem-solving and developing innovative solutions to complex challenges.
• Familiarity with Database Design and Data Management Concepts: Understanding database design principles, data modeling, and data management practices is important for creating efficient and effective database solutions.
• Knowledge of Process and Query Optimization: Adequate knowledge in optimizing processes and SQL queries is essential to enhance performance and efficiency in database operations.
• Ability to Work in Teams and Communicate Effectively: Strong teamwork and effective communication abilities are vital for successful collaboration on projects.

Why Join Bonyan System?

• Join a team with over 10 years of experience delivering complex IT solutions for major telecom operators.
• Lead projects in a dynamic environment, working on cutting-edge BSS technologies.
• Collaborate with a forward-thinking team that values innovation and technical excellence.
• A fast-paced and challenging work environment with opportunities for professional growth.
• The chance to work with a talented and passionate team.