307 Sql Tuning Jobs - Page 13

Educational Requirements Master Of Engineering,MCA,MSc,MTech,Bachelor of Engineering,BCA,BSc,BTech Service Line Application Development and Maintenance Responsibilities Roles and Responsibilities:Development and Implementation:Design, develop, and implement efficient and scalable PL/SQL stored procedures, functions, packages, triggers, and views.Write and optimize complex SQL queries for data retrieval, manipulation, and reporting.Collaborate with business analysts and solution architects to understand requirements and translate them into technical designs.Participate in the full software development lifecycle (SDLC), including requirements analysis, design, coding, testing, and deployment.Code Quality and Standards:Ensure adherence to established coding standards, best practices, and architectural guidelines.Perform thorough unit testing of developed code and assist with integration testing.Identify and debug issues in existing PL/SQL code, providing timely and effective solutions.Performance Tuning and Optimization:Analyze and optimize the performance of existing PL/SQL code and SQL queries.Utilize Oracle performance monitoring tools (e.g., Explain Plan, SQL Trace) to identify and resolve performance bottlenecks.Contribute to discussions on database design improvements and indexing strategies to enhance application performance.Documentation and Support:Create and maintain clear, concise technical documentation for developed modules and features.Provide support for production issues, analyzing and resolving database-related problems.Collaborate with DBAs on schema changes, data migrations, and other database-related activities.Collaboration and Mentorship (Junior Developers):Work effectively within a team environment, actively participating in team meetings and discussions.Potentially mentor junior developers, offering guidance on PL/SQL coding best practices and problem-solving techniques.Communicate technical concepts clearly to both technical and non-technical stakeholders Additional Responsibilities: Additional Information:EducationBachelor's degree in Computer Science, Information Technology, or a related field.Soft Skills: Excellent analytical and problem-solving skills.Strong attention to detail and commitment to quality.Good communication and interpersonal skills.Ability to work independently and collaboratively in a team environment.Proactive and eager to learn new technologies and concepts.Ability to manage time effectively and handle multiple tasks. Technical and Professional Requirements: Technical Requirements:Must-Have:3-5 years of hands-on experience in Oracle PL/SQL development.Strong proficiency in writing and optimizing complex SQL queries, stored procedures, functions, packages, and triggers.Solid understanding of Oracle database concepts, including data types, indexes, constraints, and views.Experience with SQL tuning and performance optimization techniques.Familiarity with Oracle development tools such as SQL Developer or Toad.Experience with version control systems (e.g., Git, SVN).Good to Have:Basic understanding of data modeling principles.Exposure to Oracle Forms and Reports is a plus.Familiarity with shell scripting (Unix/Linux) for database automation.Knowledge of Agile/Scrum development methodologies.Experience with large-scale transactional systems.Understanding of data warehousing concepts or ETL processes. Preferred Skills: Technology-Oracle Cloud-Oracle Knowledge-Oracle Knowledge

As an Application Developer, you will lead IBM into the future by translating system requirements into the design and development of customized systems in an agile environment. The success of IBM is in your hands as you transform vital business needs into code and drive innovation. Your work will power IBM and its clients globally, collaborating and integrating code into enterprise systems. You will have access to the latest education, tools and technology, and a limitless career path with the world’s technology leader. Come to IBM and make a global impact! The ability to be a team player The ability and skill to train other people in procedural and technical topics Strong communication and collaboration skills Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Strong knowledge and experience in database design, modelling and development using PL SQL. Minimum of 6 years. Proficiency with Oracle databases and tools, such as SQL Developer and Toad In-depth understanding of SQL tuning and optimization techniques Knowledge of database performance monitoring and troubleshooting Familiarity with ETL processes and data integration techniques and Strong analytical and problem-solving skills Preferred technical and professional experience Ability to work in a fast-paced environment and meet deadlines Knowledge of agile software development practices is a plus Bachelor's degree in computer science or a related field is preferred, but not required

Role: Senior Database Administrator Primary Skills: Performance Tuning, Query Handling, SQL. Experience : 8+ Yrs NP: Immediate to 30 days Location: Kolkata/Pune (All Pune candidates will have to work from Kolkata Headoffice for initial 3 months after joining) On-Site Qualification(Preferred) : BS/BTECH degree in Computer Science or a related discipline, or relevant certifications. Key Points: a) Proven experience as a Database Administrator, with a strong track record of managing databases in high-availability environments. b) Hands-on experience with database standards and end-user applications. c) In-depth knowledge of data backup, recovery, security, integrity, and SQL. d) Experience with DBA tools (frontend/backend) and third-party tools. e) Understanding of programming languages and API integration. f) SQL Performance Turning tools such as IDERA (mandatory) g) Knowledge of Enterprise SQL. Responsibilities: Database Management: Build and maintain high-availability database systems tailored to meet each end users specialized needs. Design & Implementation: Design and implement databases in accordance with end-user information needs and views. User Management: Define user roles and enable efficient data distribution to the appropriate users in the correct format and timely manner. Backup & Recovery: Utilize high-speed transaction recovery techniques and ensure regular data backups. Performance Optimization: Minimize database downtime and manage parameters to provide fast query responses. Support & Training: Provide both proactive and reactive data management support and training to users. Policy & Procedure Enforcement: Determine, enforce, and document database policies, procedures, and standards. Security & Integrity: Perform regular tests and evaluations to ensure data security, privacy, and integrity. Monitoring & Updates: Monitor database performance, implement necessary changes, and apply new patches and versions as required.

- Exp in AWS RDS (PostgreSQL, MySQL, DynamoDB) - SQL tuning, indexing strategies, & troubleshooting - Query Optimization & Query Tuning - IaC tools (Terraform) for database provisioning & management - automation/scripting (Python, Bash, PowerShell)

A leading logistics company in Gurugram is hiring a pl/sql developer Age-Upto 25 yrs Pls send CV or call @ 9811691651 F2F Interviews

This role requires working from our local Hyderabad office 2-3x a week. INTRODUCTION: The Lead Database Oracle Administrator will be responsible for operational support for various on-premise databases running on Oracle Exadata Platforms, SQL server, MYSQL, PostgreSQL environments. The position requires Oracle database and SQL tuning expertise, through working knowledge of the Oracle Exadata and EXACC platform, experience working with Platinum support for Exadata/EXACC patching, and capacity planning, installation, integration, configuration, database design, migration, performance monitoring, security, troubleshooting, maintenance, upgrades, refreshes and backup/recovery. WHAT YOULL DO: Manage Oracle EXACC and Exadata environments, both on-premises and in OCI, coordinating with Platinum support and application owners for quarterly patching Administer databases (Oracle, SQL Server, MySQL, PostgreSQL) across on-premises and cloud environments (Azure, OCI), ensuring data integrity, availability, and optimal performance Tune SQL statements and conduct performance management to ensure databases run efficiently Design, install, configure, patch, and upgrade database servers and related software across environments Establish and maintain recovery and backup policies, including periodic disaster recovery testing Implement and manage database security, creating and maintaining users, roles, and privileges Monitor and maintain databases for performance, security, and capacity planning, optimizing resources and database performance Evaluate and recommend improvements to database features, products, and configurations Ensure compliance with database licensing and regulatory requirements, including Sarbanes-Oxley (SOX) Maintain documentation and standards for database management procedures, ensuring compliance and operational consistency. WHAT YOULL NEED: Bachelors degree in computer science, Information Systems, or a related field 7+ years of experience in IT and Database Administration with a proven track record of career growth Extensive experience in tuning SQL statements and managing Oracle EXACC/Exadata environments Strong knowledge of Oracle database products, including Real Application Clusters (RAC), Active Data Guard, and Oracle Enterprise Manager (OEM) Experience managing Exadata X8-M (or higher) using Oracle 12c or higher with RAC Proficiency in database recovery, troubleshooting, and capacity planning Experience with Oracle Golden Gate, managing data warehouses on Exadata, and Oracle environments in VMware clusters running RAC Proven ability to implement IT infrastructure projects on time and within budget In-depth understanding of ITIL/ITSM principles for managing operational service delivery Experience with database security, compliance reporting for SOX, and Database Access Management (DAM) products Strong knowledge of backup and recovery solutions using Veritas NetBackup Automation skills to streamline database tasks and processes Good knowledge of DNS, DHCP, NFS, TCP/IP networking services Strong understanding of disaster recovery solutions and testing procedures Support business needs during US Central Standard Time (CST) working hours as needed and participate in the on-call rotation as required AND ITS GREAT TO HAVE: Excellent communication, problem-solving, and decision-making skills, with the ability to present technical concepts to stakeholders at all levels Strong knowledge management, process management, and documentation skills, including creating architecture diagrams Excellent time management skills, capable of managing multiple priorities and production incidents simultaneously Self-motivated and quick to learn, with a desire to continually improve processes and systems Were committed to diversity and passion, and encourage you to apply, even if you dont demonstrate all the listed skillsets!

Description Senior Platform Engineer Data Store (DWH + CMS + APIs) Experience : 10+ Years Location : Offshore Employment Type : Full-Time About the Role We are hiring a Senior Platform Engineer to lead the design and implementation of a unified Platform Data Store comprising data warehouse systems , content management , and API services . This role demands deep experience in backend engineering, data access patterns, and scalable platform design using tools like Snowflake , Databricks , Strapi , and Spring Boot with Java SDK 21 . Key Responsibilities Design and implement data ingestion and API layers integrating with Snowflake and Databricks for large-scale analytics and warehousing. Build and extend Strapi-based headless CMS for managing dynamic content modules. Develop RESTful backend services using Java SDK 21 and Spring Boot , exposing APIs for data and CMS interaction. Optimize database queries and storage models for performance, scalability, and reliability. Design robust data access layers and secure API endpoints for multi-tenant environments. Ensure proper integration between CMS, data warehouse, and API layers through well-defined contracts and schema definitions. Collaborate with data engineers, DevOps, and product teams to align platform features with business and operational goals. Apply best practices around schema evolution, metadata management, versioning, and access control. Core Skills & Experience 10+ years of software development experience with strong backend architecture and design expertise. Proficient in Spring Boot with Java SDK 21 and RESTful service design. Experience with Snowflake or Databricks for data warehousing, ETL/ELT patterns, and SQL tuning. Solid experience with Strapi or similar headless CMS platforms . Hands-on experience integrating CMS with external APIs and data sources. Strong understanding of data modeling , ORM , and scalable storage patterns. Knowledge of API authentication, RBAC, and secure data access mechanisms. Nice to Have Experience with GraphQL , Apache Airflow , or other data orchestration tools. Exposure to event-driven systems and messaging platforms (e. g. , Kafka). Familiarity with containerized deployments (Docker/Kubernetes). Previous experience working on multi-layered platform infrastructure