217 Query Tuning Jobs - Page 9

6+ yrs of exp in database administration, management, performance engineering with expertise in MS-SQL databases. Strong hands-on experience with MS SQL, PostgreSQL & Azure Cosmos DB. Required Candidate profile Design, implement & manage database architecture for both relational (SQL) & non-relational (NoSQL) databases, with a focus on security. Optimize database performance through query tuning, indexing

Responsibilities The main role of a Principal/Senior Consultant (Database) is to troubleshoot highly complex technical problems (Oracle Database & Exadata) requiring a high level of technical expertise. Works directly with customers. Open to work in rotational shifts based on business requirements. Drives improvements in product quality. Serves as Situation Manager on highly sensitive Customer issues. Consult with Management in directing the resolution of critical Customer situations. Consult with Customers on the complex use of Oracle products. Achieves knowledge transfer through the development and delivery of training, knowledge sessions, mentoring, etc. Creates /reviews Knowledge Articles. Analyzes workload determines best practices and implements changes to improve productivity. Proactively contributes to increasing the team efficiency by sharing knowledge, and providing feedback about best practices, and writing tools/utilities. Whom are we looking for? Required Qualification: 8 to 10 years of work experience in Oracle DB 12c/18/19c Installation, Upgrade, Configuration, Migration & Performance tunning. Technical degree i.e. BE / B.Tech / M.Tech / MCA / M.Sc. in Computer Science / Management Information Systems / Engineering. Open to working in 24*7 shifts. Oracle OCP DBA certification - Preferred. Oracle OCM DBA Certification is a plus. Technical skills: Database architecture knowledge and administration. Good knowledge of Exadata, Exadata Cloud, and OCI architectures. Experience with cloud technologies from different vendors. Thorough understanding of the Oracle database features. Extensive hands-on interaction with large Database management systems. Real Application Cluster (RAC) & ASM/Storage areas. ZDLRA, Backup and Recovery, RMAN, Dataguard, knowledge of various restore and recovery scenarios. Performance Tuning, Parallel query, Query tuning. Networking. Partitioning. Database Security. Golden Gate & Replication. Enterprise Manager. General UNIX/Linux Concepts & Administration Managing Kernel Parameters, Partitioning, and File Systems. Operating systems expertise will be an added advantage. Personal Attributes: Self-driven and result-oriented. Open to working from the client's location (Locally) Strong customer support and client relation skills. Ability to work effectively in high-volume & high-pressure situations. Ability & Flexibility to work late shifts. Certifications preferred: OCI/OCP certification. Career Level - IC2 Responsibilities Qualifications Career Level - IC2

Responsibilities The main role of a Principal/Senior Consultant (Database) is to troubleshoot highly complex technical problems (Oracle Database & Exadata) requiring a high level of technical expertise. Works directly with customers. Open to work in rotational shifts based on business requirements. Drives improvements in product quality. Serves as Situation Manager on highly sensitive Customer issues. Consult with Management in directing the resolution of critical Customer situations. Consult with Customers on the complex use of Oracle products. Achieves knowledge transfer through the development and delivery of training, knowledge sessions, mentoring, etc. Creates /reviews Knowledge Articles. Analyzes workload determines best practices and implements changes to improve productivity. Proactively contributes to increasing the team efficiency by sharing knowledge, and providing feedback about best practices, and writing tools/utilities. Whom are we looking for? Required Qualification: 8 to 10 years of work experience in Oracle DB 12c/18/19c Installation, Upgrade, Configuration, Migration & Performance tunning. Technical degree i.e. BE / B.Tech / M.Tech / MCA / M.Sc. in Computer Science / Management Information Systems / Engineering. Open to working in 24*7 shifts. Oracle OCP DBA certification - Preferred. Oracle OCM DBA Certification is a plus. Technical skills: Database architecture knowledge and administration. Good knowledge of Exadata, Exadata Cloud, and OCI architectures. Experience with cloud technologies from different vendors. Thorough understanding of the Oracle database features. Extensive hands-on interaction with large Database management systems. Real Application Cluster (RAC) & ASM/Storage areas. ZDLRA, Backup and Recovery, RMAN, Dataguard, knowledge of various restore and recovery scenarios. Performance Tuning, Parallel query, Query tuning. Networking. Partitioning. Database Security. Golden Gate & Replication. Enterprise Manager. General UNIX/Linux Concepts & Administration Managing Kernel Parameters, Partitioning, and File Systems. Operating systems expertise will be an added advantage. Personal Attributes: Self-driven and result-oriented. Open to working from the client's location (Locally) Strong customer support and client relation skills. Ability to work effectively in high-volume & high-pressure situations. Ability & Flexibility to work late shifts. Certifications preferred: OCI/OCP certification.

4 to 6 years experience in Dot Net technologies Basics Angular 2+- exp : min 6 months. Good Practical knowledge on Web API. Good Practical knowledge onCore. Good Practical knowledge on JavaScript and HTML5. Hands on exp in Syntactically Awesome Style Sheet(SCSS). Good Practical Knowledge on SQL Server and Query Tuning Experience with GIT & JIRA Knowledge on Bootstrap, Angular Material Good to have : Rabbit MQ. Good to have : Azure DevOps

6+ yrs of exp in database administration, management, performance engineering with expertise in MS-SQL databases. Strong hands-on experience with MS SQL, PostgreSQL & Azure Cosmos DB. Required Candidate profile Design, implement & manage database architecture for both relational (SQL) & non-relational (NoSQL) databases, with a focus on security. Optimize database performance through query tuning, indexing

6+ yrs of exp in database administration, management, performance engineering with expertise in MS-SQL databases. Strong hands-on experience with MS SQL, PostgreSQL & Azure Cosmos DB. Required Candidate profile Design, implement & manage database architecture for both relational (SQL) & non-relational (NoSQL) databases, with a focus on security. Optimize database performance through query tuning, indexing

Job Title: Senior Database Architect / PostgreSQL DBA Consultant Job Type: Part-time / Consulting (Flexible engagement model) Location: Remote (Preferred overlap with IST working hours) Duration: 3-6 months (extendable based on performance and scope) About the Role: The client is undergoing rapid growth and data scale-up and seeks an experienced Database Architect/DBA Consultant to help manage, optimize, and future-proof their high-volume data infrastructure. The role involves proactive database operations, schema evaluation, query optimization, and cost-efficiency planning in a PostgreSQL-heavy environment, with auxiliary tools like Redis, Snowflake, and object storage. Key Responsibilities: Assess and monitor the health of a large-scale PostgreSQL (Aurora RDS) database (>50 TB). Identify and resolve performance bottlenecks, including I/O, memory, and CPU-related issues. Optimize long-running SQL queries, indexes, and schema design. Reinstate and tune auto-vacuum settings to improve DB hygiene. Implement guardrails for observability, monitoring, query control, and DB health. Design data retention and purging policies to reduce storage bloat. Consult with application teams on schema redesign and query optimization. Guide transition and offloading of analytical workloads to Snowflake. Recommend cost-effective strategies to reduce AWS resource consumption. Collaborate with business analysts and developers to align DB performance with app functionality. Required Skills: 12+ years of experience in PostgreSQL database administration and architecture. Hands-on experience with Amazon RDS (Aurora) and AWS cost/performance optimization. Expertise in query tuning, indexing strategies, and storage management. Strong understanding of geospatial queries, time-series data, and large-scale data processing. Familiarity with Redis, Snowflake, and object storage (e.g., S3). Experience managing data-intensive platforms with complex reporting and analytics needs. Knowledge of observability tools, query logging, and alerting systems. Nice to Have: Experience with Apache Iceberg, PostGIS, or other geospatial extensions. Prior involvement in application re-architecture or migration projects. Exposure to DevOps or cost modeling for cloud-based DB infrastructure. Comfort working with both platform-level data teams and application developers. Soft Skills: Strong analytical and problem-solving skills. Ability to work independently in a fast-paced environment. Effective communicator and team collaborator. Ability to mentor teams on best practices.

35 years of hands-on experience with SQL Server Strong experience in SQL Server database administration Proficient in managing SQL Server on Azure and AWS Skilled in query tuning and performance optimization Experienced in analysing and resolving complex database issues Hands-on experience with backup and recovery for standalone and Availability Groups Location: Chennai

Design performance test plans, test cases and automation performance test cases for a given release. Develop and implement automated performance test frameworks and scripts using NodeJS, Shell scripts, Perl Scripts, and Python. Collaborate with stakeholders and development teams to understand product performance goals and ensure comprehensive performance test coverage. Execute, analyse and generate performance reports for product functionalities. Identify and analyse performance bottlenecks, and issues and provide recommendations to resolve them. Participate in capacity planning activities to ensure optimal utilization of resources with high throughput. Continuously validation of product performance to identify any degradation due to changes. Participate in design reviews, product performance certification, and release activities to support the software development lifecycle. Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise o Bachelor's degree in Computer Science, Computer Engineering, or related field. Minimum 8 years of experience, including at least 4 years of experience in performance engineering. o Hands-on experience working with LDAP and Directory concepts includingDirectory Schema, Directory Structure, LDIF etc. o Hands-on experience with VMWare, KVM, containers and various deployment techniques o Experience with cloud platforms (AWS, Azure, ROSA etc.) and containerization technologies (Docker, Kubernetes) o Hands-on experience with APM tools (Instana, NewRelic). o Conceptual understanding of different software performance metrics. o Experience with analysing core dumps, SQLs, explain plans and resource utilization. o Experience with PostgreSQL and DB2 databases. o Strong understanding of software development methodologies and performance testing best practices. o Experience with version control systems (e.g. Git), ticketing systems (e.g. Jira) and CI/CD tools. o Excellent analytical and problem-solving skills with meticulous attention to detail. o The right candidate should possess strong communication skills, be a collaborative team player, is adept at independent decision-making, and is capable of providing recommendations to stakeholders. Preferred technical and professional experience o Knowledge of SCIM, Federated & Virtual Directory Concepts o Familiarity with database query tuning and knowledge of database administration.

The Apex Group was established in Bermuda in 2003 and is now one of the worlds largest fund administration and middle office solutions providers. Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion. Thats why, at Apex Group, we will do more than simply empower you. We will work to supercharge your unique skills and experience. Take the lead and well give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities. For our business, for clients, and for you Responsibilities Installation, administration and maintenance of multiple SQL Server instances. Setup environments for use within the end to end software delivery lifecycle. Define, design & implement control procedures. Backup monitoring and continuous review of the backup strategy. Troubleshoot and resolve issues quickly. Performance monitoring and tuning. Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I/O etc.) Planning and execution of Service Pack upgrades. Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patching. Adhere to change management procedures. Working closely with other team members. Complete structured and systematic testing. Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement roadmap. Pro-actively identify productivity opportunities. Ensure correct procedures are adhered to as tasks are being progressed. Experience in a Windows based 24/7 environment including 1st/2nd line support. Involved in the design and build of new systems, including high-availability and disaster recovery solutions. Skills Required Min. 8+ years of Exp in Microsoft SQL Server 2016, 2019, Azure SQL. A bachelors degree in computer science or a related discipline Extensive knowledge of SQL and SQL server tools Experience in Database Performance, Development and Maintenance In-depth understanding of database security, backup and recovery, and performance monitoring requirements Familiarity with relational and dimensional data modelling Extensive knowledge in database design, implementation, and conversion Knowledge of PowerShell and Unix shell scripting Experience with SSAS, SSIS, and SSRS A solid mathematics and statistical skills Outstanding writing and verbal communication abilities Meticulous attention to detail MCSE/MCSA certificates preferred Working knowledge of Linux and Windows Server infrastructures Extensive knowledge of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB) Prior experience with cloud services (AWS, Microsoft Azure) Excellent time management and decision making skills. Excellent communication skills in both English written and verbal. Background in the financial Industry preferable DisclaimerUnsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.

Responsibilities: Installation, administration and maintenance of multiple SQL Server instances. Setup environments for use within the end to end software delivery lifecycle. Define, design & implement control procedures. Backup monitoring and continuous review of the backup strategy. Troubleshoot and resolve issues quickly. Performance monitoring and tuning. Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I/O etc.) Planning and execution of Service Pack upgrades. Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patching. Adhere to change management procedures. Working closely with other team members. Complete structured and systematic testing. Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement roadmap. Pro-actively identify productivity opportunities. Ensure correct procedures are adhered to as tasks are being progressed. Experience in a Windows based 24/7 environment including 1st/2nd line support. Involved in the design and build of new systems, including high-availability and disaster recovery solutions. Skills Required: Min. 8+ years of Exp in Microsoft SQL Server 2016, 2019, Azure SQL. A bachelor's degree in computer science or a related discipline Extensive knowledge of SQL and SQL server tools Experience in Database Performance, Development and Maintenance In-depth understanding of database security, backup and recovery, and performance monitoring requirements Familiarity with relational and dimensional data modelling Extensive knowledge in database design, implementation, and conversion Knowledge of PowerShell and Unix shell scripting Experience with SSAS, SSIS, and SSRS A solid mathematics and statistical skills Outstanding writing and verbal communication abilities Meticulous attention to detail MCSE/MCSA certificates preferred Working knowledge of Linux and Windows Server infrastructures Extensive knowledge of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB) Prior experience with cloud services (AWS, Microsoft Azure) Excellent time management and decision making skills. Excellent communication skills in both English written and verbal. Background in the financial Industry preferable

What this role includes :- The role involves designing and developing solutions to support the business needs. Optimizing and tuning existing programs and developing new routines will be an integral part of the profile. Key Responsibility Areas: Work closely with programming teams to deliver high quality software Analyze application problems and provide solutions. Participate in the creation of development, staging, and production database instances and the migration from one environment to another. Review requirements with the users and provide time estimates for task completion. Responsible for the monitoring and uptime of all production databases. Responsible for regular backups and recovery of databases including PITR. Responsible for High Availability Failover Replication. Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving). Responsible for Query tuning, Process Optimization and preventative maintenance. Provide support in different phases of software development. Develop and Schedule cron jobs as per requirement. Educational Qualifications: B.Tech/B.E Skills Required: shell scripting , UNIX , LINUX , PostgreSQL , Database Administration , Database Development , Architecting , RDBMS , AWS , Cloud Candidate Attributes: Experience: 5-7 years of experience in Postgres Database Administration 9/10/11. Working knowledge of AWS/GCP environments will be an added advantage. Skillsets :- Strong knowledge of Postgre Architecture 9/10/11 including Master-Slave Replication. Hands on experience in Postgre installation, configuration and upgradation. Good understanding of data and schema standards and user/application security concepts. Must have experience in monitoring, troubleshooting and fixing Postgres issues. Experience with regular maintenance tasks automation (e.g., Vacuum, Reindexing, Archiving) and proactive intervention, reducing any downtime Good working experience of SQL Query Optimization Experience in Postgres Backups, restore and recovery (including PITR). Strong knowledge of UNIX/LINUX platforms and shell scripting. Knowledge of High Availability Failover Replication , pg-pool. Ability to quickly learn new business and technical concepts in a fast paced service focused environment. Demonstrated analytical and problem-solving skills. Good customer service and communication skills. Must be comfortable interacting with Internal clients and internal staff. Highly motivated with the ability to work well independently and within a team environment. Ability to work under pressure and to handle several tasks efficiently

Role:- Oracle PL / SQL Developer Client:- Reliance Industries Exp:- 4 to 7 Years Mandatory Skills:- Oracle PL / SQL Development with Data Modelling, Performance Tuning, Query Tuning, experience on Oracle19C version, My SQL Database Development experience is also required. Need Strong PL / SQL Programming and Database Development experience. Work Location:- RCP, Ghansoli, Navi Mumbai (Look for Local Mumbai Resource) Max Joining Time:- Immediate to 15 Days (Need someone who can join in June month) Work From office:- All 5 Days mandatory Work from Office Shift Timing:- General Shift (9 to 6 PM IST)

Sr. Engineer/Engineer- DBA The role involves design, develop, enhance and monitor all production databases that exist within the technical architecture related to Postgres. Optimizing and tuning existing programs and developing new routines will be an integral part of the profile. Experience Range: 3 - 6 years Educational Qualifications: B.Tech/B.E Job Responsibilities: Work closely with programming teams to deliver high quality software Analyze application problems and provide solutions. Participate in the creation of development, staging, and production database instances and the migration from one environment to another. Review requirements with the users and provide time estimates for task completion. Responsible for the monitoring and uptime of all production databases. Responsible for regular backups and recovery of databases including PITR. Responsible for High Availability Failover Replication. Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving). Responsible for Query tuning, Process Optimization and preventative maintenance. Provide support in different phases of software development. Develop and Schedule cron jobs as per requirement. Skills Required: Database Administration , RDBMS , NoSQL , Cloud , PostgreSQL , Cassandra , Graph db,Tuning,Recovery,Back Up Candidate Attributes: Strong knowledge of Postgre Architecture 9/10/11 including Master-Slave Replication. Hands on experience in Postgre installation, configuration and upgradation. Good understanding of data and schema standards and user/application security concepts. Must have experience in monitoring, troubleshooting and fixing Postgres issues. Experience with regular maintenance tasks automation (e.g., Vacuum, Reindexing, Archiving) and proactive intervention, reducing any downtime Good working experience of SQL Query Optimization Experience in Postgres Backups, restore and recovery (including PITR). Strong knowledge of UNIX/LINUX platforms and shell scripting. Knowledge of High Availability Failover Replication , pg-pool. Ability to quickly learn new business and technical concepts in a fast paced service focused environment. Demonstrated analytical and problem-solving skills. Good customer service and communication skills. Must be comfortable interacting with Internal clients and internal staff. Highly motivated with the ability to work well independently and within a team environment. Ability to work under pressure and to handle several tasks efficiently.

- 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)

The Role: Software Engineer The Team: The OSTTRA Technology teamis composed of Capital Markets Technology professionals, who build,supportand protect the applications that operate our network. The technology landscape includes high-performance, high-volume applications as well as compute intensive applications , leveragingcontemporary microservices, cloud-based architectures. Whats in it for you: We are seeking a Java Developer having 5 to 7 years of experience with deep expertise in Core Java, strong system design and development skills, solid hands-on experience with databases, and a proactive mindset toward code quality and mentoring. This role demands a self-motivated individual who can not only write efficient and scalable code but also guide junior developers through peer reviews, architecture discussions, and best practices. Responsibilities: Design, develop, and enhance complex Java applications and services, , requiring high throughput. Lead technical solutions end-to-end from design through implementation and deployment. Perform detailed code reviews, ensure code quality and adherence to best practices. Collaborate with architects and senior stakeholders to shape system design and architecture. Analyze and troubleshoot performance bottlenecks across code and database. Mentor and support junior team members in coding, debugging, and technical issues. Work closely with QA, DevOps, and product teams to deliver high-quality software. What Were Looking For: Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent practical experience). Core Technical Skills: Expert-level Core Java (OOP, Collections, Concurrency, Java 8+ features). Strong experience with Spring Boot, Spring MVC, and RESTful APIs. Exposure to UI Development React Angular Good knowledge of database design, query optimization, indexing, and stored procedures. Experience with ORM frameworks like Hibernate or JPA. Solid experience with Git, build tools (Maven/Gradle), and logging frameworks (Log4j/SLF4J). Familiar with unit testing frameworks (JUnit/TestNG) and mocking tools (Mockito). Nice-to-Have: Exposure to microservices architecture and distributed systems. Familiarity with NoSQL databases (e.g., MongoDB, Redis) is a plus. Experience with cloud platforms like AWS, Azure, or GCP. Understanding of CI/CD pipelines, Docker, and Kubernetes. In-depth knowledge of SQL and RDBMS (PostgreSQL, MySQL, Oracle) with strong database design and query tuning skills. Soft Skills: Strong analytical and problem-solving abilities. Excellent communication and leadership qualities. Ability to handle peer collaboration, feedback, and conflict resolution constructively. Attention to detail and a commitment to software craftsmanship.

The Team: The OSTTRA Technology team is composed of Capital Markets Technology professionals, who build, support and protect the applications that operate our network. The technology landscape includes high-performance, high-volume applications as well as compute intensive applications, leveraging contemporary microservices, cloud-based architectures. The Impact: Together, we build, support, protect and manage high-performance, resilient platforms that process more than 100 million messages a day. Our services are vital to automated trade processing around the globe, managing peak volumes and working with our customers and regulators to ensure the efficient settlement of trades and effective operation of global capital markets. Whats in it for you: We are looking for a hands-on Technical Lead Java with 12 to 15 years of experience who can lead a team of developers while actively contributing to system design and complex coding tasks. The ideal candidate should have deep proficiency in Core Java, strong database skills, excellent code review practices, and the ability to effectively engage with stakeholders, prioritize work, and drive task distribution across the team. This role is a blend of technical leadership, team mentoring, and project ownership. Responsibilities: Understanding of, contribution towards and alignment with the tech strategy of OSTTRA Lead end-to-end design, development and maintenance of scalable/distributed critical services, requiring high throughput. Hands-on development and fair experience of designing technical architecture while guiding the team on technical execution. Liase with enterprise architecture on more complex or new initiatives that are cross cutting Collaborate with product owners, business stakeholders, and cross-functional teams to gather requirements, define scope, and influence priorities. Perform peer code reviews, enforce coding standards, and ensure high-quality deliverables. Distribute work across the team, manage delivery timelines, and ensure workload balance. Drive sprint planning, estimation, and progress tracking. Identify technical risks and provide proactive solutions or mitigations. Provide mentorship and technical guidance to developers and ensure team growth.Troubleshoot complex application and database issues in production and development environments. What Were Looking For: Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent practical experience). Core Technical Skills: Expert-level proficiency in Core Java, including OOP, Collections, Multithreading, and Java 8+ features. Strong experience in Spring Boot, REST APIs, and microservices architecture. Exposure to React Angular UI Familiarity with ORM frameworks like Hibernate/JPA. Solid understanding of system design, design patterns, and architectural best practices. Strong experience in version control (Git), build tools (Maven/Gradle), and logging (SLF4J/Logback). Exposure to testing frameworks like JUnit, Mockito. Nice-to-Have: Experience with cloud platforms (AWS, Azure, or GCP). Familiarity with DevOps, CI/CD pipelines, Docker/Kubernetes. Exposure to Agile/Scrum methodologies and tools like Jira or Azure DevOps. Past experience of Investment management ( or BFSI in general) In-depth knowledge and proven experience of SQL and RDBMS (PostgreSQL, MySQL, Oracle) with strong database design and query tuning skills. Soft Skills: Strong stakeholder communication and expectation management. Excellent work prioritization and task delegation capabilities. Proven team leadership, mentorship, and conflict resolution skills. Ability to manage multiple priorities and deliver under tight timelines