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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.