SQL Query Tuning Expert

2 days ago

Hyderabad Telangana, India Oracle Full time

**About Oracle Customer Success Services(CSS)**:
As a key member of Oracle Customer Success Services, you will join an international network of experts dedicated to driving customer success through innovation and expertise. Our One Oracle approach ensures you will be part of a team delivering comprehensive, end-to-end services and solutions that accelerate the entire customer journey. Work alongside certified and experienced professionals, gaining exposure to cutting-edge technologies and methodologies, and enhancing your skills and credentials. Engage with a diverse range of customers, managing the full lifecycle of delivery and services, and ensuring each project has a tangible impact. Benefit from robust team support in a collaborative environment that prioritizes teamwork and mutual success. Join us in Oracle Customer Success Services and elevate your career with a company that values innovation, expertise, and customer-centric solutions

Career Level - IC4

Mandatory Skills:

- Should have 8+ years of experience in Oracle SQL query tuning expertise.
- Strong expertise in writing and understanding of Oracle SQL/PLSQL
- Functional knowledge of Oracle Fusion Middleware products, Weblogic & Database products.
- Interpreting explain plans and able to read AWRs and ASH for identifying SQL query bottle necks.
- Ability to interpret explain plans for access path, predicate filtering and high knowledge of joins and orders in table access.
- Advanced knowledge of SQLHC, parallel query knowledge. Should have rich experience in factored / scalar sub-queries and ability to utilise them in sql queries.
- Strong decision making, convincing skills to bring down the complex discussions to closure supported by right arguments and facts.
- Understanding of database initialization parameters, logs and traces.
- Experience working on complex software development/integration projects
- Experience in scripting tool like Unix shell, Python, Perl
- Optional hands on troubleshooting Oracle OTBI & BIP report issues and performance related techniques on components like Data models/sets, LOV, parameters, bursting, FF, scheduling.

Good to Have Skills:

- Understanding of AI and Machine learning will be an added advantage.
- Oracle SQL performance diagnostic tools like SQLHC
- Experience in using monitoring tools like OEM.
- Building synthetic test cases.

**Responsibilities**:

- **Early Adopter of Innovation**:Explore and adopt new technologies like Oracle 23ai, Autonomous DB, Auto indexing, AI related tools.
- **Analysis and Optimize Oracle BIP Reports**:Should be able to help customer to identify performance issues with Oracle BIP reports functionality and sql queries involved with them.
- Optional knowledge of various components of BIP reports like Data models, Parameters, LOVs, Flex Fields, Bursting. Should be able to advise customers to use right sql queries as per Oracle best practices and which aids in completing the report optimally.
- **OTBI and BIP reports**:Knowledge of troubleshooting OTBI reports for advising customers to use performance enhancing configuration parameters.

  • SQL Queries

    4 weeks ago

    Hyderabad, Kolkata, Mumbai, India Robotics Technologies Full time

    Job DescriptionDescriptionWe are seeking a skilled SQL Queries expert to join our team in India. The ideal candidate will have extensive experience in developing, optimizing, and maintaining SQL queries to support various business needs. This role requires a strong understanding of database management systems and the ability to work collaboratively with...

  • SQL expert

    7 days ago

    Hyderabad, Telangana, India Winjit Technologies Full time US$ 90,000 - US$ 1,20,000 per year

    Location : Hyderabad, NarsingiWork Mode - Work from Office (5 days a week)Joining : Within a weekRole & responsibilitiesDesign, develop, and maintain optimized SQL queries for large-scale data systems.Analyze slow-running queries and implement performance tuning strategies.Rewrite and refactor complex SQL queries for improved execution efficiency.Collaborate...

  • SQL Database Expert

    3 days ago

    Hyderabad, Telangana, India beBeeDatabase Full time US$ 1,20,000 - US$ 1,80,000

    Job TitleWe are seeking a seasoned SQL expert to fill a critical role in our organization.The ideal candidate will possess exceptional leadership skills and have a proven track record of delivering high-quality results. A strong background in database design, data modeling, and query optimization is essential for this position.Key Responsibilities:Develop...

  • SQL Developer

    7 days ago

    Hyderabad, Telangana, India TechDoQuest Full time US$ 1,04,000 - US$ 1,30,878 per year

    Position Overview:We are seeking a highly skilled SQL Developer with deep expertise in SQL query performance tuning and database optimization. This role demands a strong command of SQL and focuses on improving the efficiency and speed of queries, stored procedures, and overall database performance. The ideal candidate will be responsible for ensuring fast,...

  • Python Architect with SQL Queries

    2 weeks ago

    Hyderabad, Telangana, India Cognizant Full time

    Skill: Python Architect+ SQL query+ Oops Experience: 10 to 19 years Location : Hyderabad (Hybrid) **Job Description**: - Strong proficiency in Python and in OOPs principles. - Strong proficiency in working with SQL databases. - Hands-on experience with RESTful API development, JSON and in PANDAS libraries - Familiarity with version control tools like...

  • PL/SQL Database Specialist

    2 weeks ago

    Hyderabad / Secunderabad, Telangana, India beBeeDatabase Full time

    Job Title: PL/SQL ExpertWe are seeking a skilled PL/SQL developer to join our team. As a key member of our database development team, you will design, develop, and maintain high-quality PL/SQL code to meet business requirements.Key Responsibilities:Design and implement complex PL/SQL procedures, functions, triggers, and packages.Write and optimize SQL...

  • SQL Server Database Specialist

    1 week ago

    Hyderabad / Secunderabad, Telangana, India beBeeDatabase Full time ₹ 1,04,000 - ₹ 1,30,878

    Seeking a seasoned database professional to oversee Microsoft SQL Server databases within an Application Management Services (AMS) framework.Key ResponsibilitiesAdminister and maintain Microsoft SQL Server databases across various versions, ensuring optimal performance and availability.Develop and implement robust backup, recovery, and disaster recovery...

  • Senior SQL Developer

    7 days ago

    Hyderabad, Telangana, India Coffee Beans Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Skills required for SQL expert:Years of Experience : 5-7 yearsWork Location : HyderabadWork Mode : Onsite - 5 days work from officeMandatory skills :5+ years of experience in SQL query tuning and optimization on big data systems and big data projects (Apache spark, apache Kafka, Apache Hadoop, MongoDB, Hive)Knowledge of Machine Learning and Data Science...

  • SQL Database Administrator

    4 days ago

    Hyderabad, Telangana, India Softify Technologies Full time

    **Job Title**: DBA - MS SQL Server with Snowflake Exposure **Experience**: 6+ years **Location**: Onsite **Type**: Full-time **Role Overview**: Looking for an experienced **Database Administrator** with strong expertise in **MS SQL Server** and working exposure to **Snowflake**. You will manage, optimize, and secure databases while supporting data...

  • SQL Server Database Professional

    2 weeks ago

    Hyderabad / Secunderabad, Telangana, India beBeeDatabaseAdministrator Full time

    We are seeking an experienced database administrator to manage and maintain our SQL Server databases. The ideal candidate will be responsible for ensuring the availability, security, and performance of our databases.Key Responsibilities:Install and configure Microsoft SQL Server databases.Monitor database performance, identify bottlenecks, and implement...