Oracle PL/SQL Developer

Position: Oracle PL/SQL Developer
Location: Irving, TX (ONSITE)

Job Description

• 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.