Oracle PL SQL Developer

Job Description: Hello, I hope this message finds you well.This is Shyam from TechStar Group. We currently have an opening for the below position. If this opportunity interests you, please let me know. “Applicants must be authorized to work in the U.S. without current or future visa sponsorship.” Position: Oracle PL/SQL DeveloperLocation: 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 We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.