Oracle PL/SQL Developer

Job Title- Oracle PL/SQL Developer Location – Irving, TX (ONSITE)- Need Locals Contract – 1+ year • We are seeking a highly experienced and meticulous Principal Database Developer with 7+ years of specialized experience, focusing on exceptional expertise in Oracle SQL. • The ideal candidate will possess a deep understanding of the telecom domain, specifically the order process management lifecycle, and have a proven ability to analyze complex data from diverse sources to create high-performance, robust SQL and reporting solutions. Key Responsibilities • Advanced SQL Development: Design, develop, test, and maintain highly complex and efficient SQL queries, stored procedures, functions, and triggers within a large-scale Oracle database environment. • Data Analysis & Modeling: Proactively analyze intricate business requirements and data structures from multiple source systems to develop effective database solutions, data models, and ETL/ELT logic. • Business Acumen: Develop a deep understanding of the telecom order management process (e.g., order capture, decomposition, provisioning, fulfillment, and status tracking) to translate business needs into precise technical database solutions. • Reporting & Visualization: Design, build, and maintain compelling business dashboards and reports using Tableau, ensuring the underlying data extraction (SQL) is highly optimized. • Performance Tuning: Identify and resolve database performance bottlenecks, tune slow-running queries, and ensure overall database efficiency and scalability. • Collaboration & Documentation: Work closely with cross-functional teams (developers, business analysts) to define data requirements, document database design specifications, and ensure data integrity. • Workload Flexibility: Be flexible and willing to work extended hours as needed to meet critical project deadlines or address production emergencies. Required Skills & Qualifications • Experience: Minimum of 7+ years of professional experience as a Database Developer, with a primary focus on Oracle. • Oracle SQL/PL-SQL Mastery: Exceptional, demonstrable expertise in writing complex, efficient, and well-tuned Oracle SQL and PL/SQL. Must be proficient with advanced concepts like analytical functions and performance optimization techniques (e.g., explain plans, indexing). • Data Visualization: Strong, hands-on experience using Tableau (or similar leading BI tools) for data visualization and dashboard creation. • Telecom Domain Knowledge: Strong, mandatory background working within the telecom industry, with direct experience supporting systems related to customer orders, service activation, or inventory. • Order Process Expertise: Proven understanding of the end-to-end telecom order management lifecycle and the complex data flows associated with it. • Data Analysis: Demonstrated ability to read, interpret, and analyze large datasets from disparate sources and map them into clear, concise database logic. Work Ethic: A strong commitment to project success, including the ability to work extended or non-standard hours when required. Thanks & Regards, Team Lead Mahesh Kumar mahesh@yochana.com Direct No: 949-201-1313 Yochana Solutions INC