Urwah Admin

2P Perfect Presentation

<div>
 
 
 Job Summary:
 
 
 
 We are seeking a highly experienced and performance-driven Oracle PL/SQL Backend Developer to join our backend team. The ideal candidate will have strong expertise in Oracle database development, advanced SQL and PL/SQL programming, and database performance tuning. This role requires hands-on experience in designing scalable database solutions, optimizing complex queries, and translating business requirements into efficient database implementations within enterprise environments.
 
 
 
 
 
 
 Key Responsibilities:
 
 
 <ul>
 <li>
 Design, develop, and maintain database components using Oracle SQL and PL/SQL.
 </li>
 <li>
 Develop and maintain packages, procedures, functions, triggers, and views.
 </li>
 <li>
 Write and optimize complex SQL queries for high-performance applications.
 </li>
 <li>
 Perform SQL and PL/SQL performance tuning and execution plan analysis.
 </li>
 <li>
 Translate business requirements into technical database specifications and solutions.
 </li>
 <li>
 Prepare functional and technical documentation.
 </li>
 <li>
 Troubleshoot and resolve database-related production issues.
 </li>
 <li>
 Participate in code reviews and enforce database development best practices.
 </li>
 <li>
 Collaborate with cross-functional teams to ensure system scalability, reliability, and security.
 </li>
 <li>
 </li>
 <li>
 </li>
 </ul>
 
 
 Required Qualifications:
 
 
 <ul>
 <li>
 Bachelor's degree in computer science, Information Technology, Software Engineering, or a related field.
 </li>
 <li>
 5+ years of hands-on experience in Oracle SQL and PL/SQL development.
 </li>
 <li>
 Strong ability to write complex SQL queries including joins, analytical functions, and aggregations.
 </li>
 <li>
 Advanced PL/SQL programming skills including:
 </li>
 <li>
 Packages, Procedures, Functions, Triggers,
 </li>
 <li>
 Bulk Collect and FORALL operations,
 </li>
 <li>
 Dynamic SQL,
 </li>
 <li>
 Exception handling,
 </li>
 <li>
 Cursors and collections.
 </li>
 <li>
 Experience in SQL and PL/SQL performance tuning and execution plan interpretation.
 </li>
 <li>
 Ability to analyze user requirements and translate them into database designs and technical specifications.
 </li>
 </ul>
 
 
 
 
 
 Preferred Qualifications:
 
 
 <ul>
 <li>
 Experience with Oracle 19c or higher.
 </li>
 <li>
 Experience in enterprise systems (ERP, SIS, financial systems, etc.).
 </li>
 <li>
 Knowledge of indexing strategies, statistics management, and optimizer behavior.
 </li>
 <li>
 Familiarity with database security concepts (roles, privileges, auditing).
 </li>
 <li>
 Experience working in Agile environments.
 </li>
 <li>
 Familiarity with Git or other version control systems.
 </li>
 </ul>
 
 
 
 
 
 Soft Skills:
 
 
 <ul>
 <li>
 Strong analytical and problem-solving skills.
 </li>
 <li>
 Excellent teamwork and communication skills.
 </li>
 <li>
 Strong attention to detail and commitment to quality.
 </li>
 <li>
 Ability to work independently and take ownership of assigned tasks.
 </li>
 </ul>
 
 
</div>

Oracle PL/SQL Backend Developer

<div>
 
 
 Role and Responsibilities:
 
 
 
 &bull; Implement, configure, operate and troubleshoot various Network Security solutions including NGFW, Dedicated IPS, SD-WAN, MDM, Secure Mail Gateways, Endpoint Management, Application Delivery Controllers, SWG (Web Proxy Solutions) and Global Traffic Managers
 
 
 &bull;Deploy and manage Web Application Firewall (WAF) solutions to protect web applications from security threats and vulnerabilities.
 
 
 &bull;Implement and support DNS Security solutions to safeguard DNS infrastructure and prevent malicious activity. &bull; Analyze and troubleshoot technical issues for clients, customers, and internal teams. &bull; Demonstrate strong understanding of core networking concepts including TCP/IP, SSL/TLS, VLANs, routing, switching, NAT, DNS, and DHCP.
 
 
 &bull; Demonstrate clear in depth understanding in security technologies including SSL/TLS encryption, IPsec, HTTPS, SSH, PKI, firewall policies, IDS/IPS, WAF, endpoint security, anti-malware, threat detection, and network defense mechanisms. &bull; Understand customer technical requirements, business objectives, and security strategy. &bull; Work proactively and collaboratively with customers to assess needs and recommend secure solutions. &bull; Develop High-Level Design (HLD) and Low-Level Design (LLD) documentation. &bull; Provide L2 support for operational network security issues and coordinate with L3 Network security engineers for advanced and escalated issues.
 
 
 &bull; Ensure daily , weekly and monthly operational tasks are scheduled and executed as per defined processes. &bull; Analyze, diagnose, and resolve incidents and service requests within defined SLA timelines. &bull; Act as a primary point of contact for monitoring, owning, and resolving security-related incidents. &bull; Log, categorize, prioritize, and assign security incidents and service requests appropriately. &bull; Translate customer requirements into practical, secure technical solutions. &bull; Configure and manage IP routing protocols and automatic failover mechanisms between connections. &bull; Provide onsite and remote support as required. &bull; Implement and troubleshoot various VPN technologies (IPSec, SSL VPN, Site-to-Site, Remote Access). &bull; Collaborate with team members and share hands-on expertise across network security platforms. &bull; Demonstrate understanding of MSP processes including SLAs, ticket handling, escalation, and engineering-to-operations handoff. &bull; Perform migration of network security systems while maintaining service continuity. &bull; Maintain accurate and complete documentation including topology diagrams and configuration records. &bull; Analyze logs and security data to provide detailed reports and root cause analysis (RCA). &bull; Manage multiple customers and projects simultaneously in a dynamic environment. &bull; Participate in rotational on-call support as per company policy.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 &bull; 4+ years of experience in Network Security. &bull; Strong analytical and troubleshooting mindset. &bull; Clear communication and strong documentation skills. &bull; Team-oriented, proactive, and detail-focused. &bull; Ability to work under pressure in 24&times;7 environments. &bull; Open to travel abroad when required. &bull; Experience working in an MSP environment is preferred. &bull; Bachelor&rsquo;s degree in IT, Computer Science, or Engineering. &bull; Professional certification in Network Security domain (CCNP Security, PCNSE/PNSE, NSE, JNCIP-Sec, F5 Certified, or equivalent). &bull; Experience working in large enterprise and dynamic environments. &bull; Self-motivated, adaptable, and approachable with excellent written and verbal English communication skills.
 
</div>

Infrastructure System Engineer

Join 2P Perfect Presentation and explore 3   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

2P Perfect Presentation

About Company

Oracle PL/SQL Backend Developer

L2 Network Security Engineer

Infrastructure System Engineer