8 Indexing Strategies Jobs

As a Technical Account Manager (TAM) at our company, your primary focus will be on ensuring the success of our customers by delivering high-value services. You will be responsible for overseeing governance and technical service delivery to help customers maximize the business value of their Oracle investments and achieve their desired outcomes while minimizing risks. Building trust as a key advisor, ensuring consistency and quality, helping customers align their IT strategies, overcoming challenges, and leveraging leading practices for successful Oracle technology and Cloud deployments will be essential aspects of your role. The services portfolio you will manage includes a range of offerings like Managed Services, On-Premise, Hybrid Cloud, Applications, Platforms, Databases (SaaS/PaaS/IaaS), and Security services. Your expertise should include strong troubleshooting skills on Database and related technology products, proficiency in analyzing and resolving performance issues, guidance on Oracle Database Best practices, knowledge of Database Security Products such as Transparent Data Encryption, Redaction, Data Vault, and Masking. You should also possess troubleshooting skills on Real Application Cluster, ability to mentor a team of engineers, and articulate the benefits of Advanced Compression and In-memory functionalities to customers. Additional knowledge on Oracle Enterprise Manager will be valuable. In terms of personal skills, you should have a solid background in service delivery or project management, familiarity with Oracle products and services, experience with Oracle HW platforms and OS, and a track record of working with Enterprise Customers. Excellent communication and relationship-building skills, a customer-focused mindset, ability to excel under pressure, strong organizational skills, decision-making abilities, and proficiency in managing multiple concurrent activities are crucial for success in this role. As a Database Administrator, you will be responsible for tasks such as monitoring, analyzing, and optimizing database performance in a RAC Environment, implementing DR solutions using Oracle Standby Database, managing data backup processes, conducting database tuning, analyzing diagnostic tools, managing Oracle database instances, identifying performance bottlenecks, and collaborating with development teams to optimize SQL code and schema design. To qualify for this position, you should hold a Bachelor's degree in computer science, IT, or a related field, possess Oracle Database certifications (e.g., OCA, OCP), and have 8-12 years of hands-on experience in Oracle Database administration and support. The role requires working in a 24*7 shift from the client site in Kerala with no remote or WFH options available. Your technical skills should include in-depth knowledge of Oracle Database architecture, proficiency in SQL, PL/SQL, and database performance tuning, experience with Oracle Real Application Clusters, Data Guard, ASM, and RMAN, basic familiarity with Cloud platforms such as OCI, AWS, or AZURE, expertise with Oracle Enterprise Manager and monitoring tools, and understanding of database security principles like encryption and user management.,

As a DBA Expert, you will be required to have strong knowledge of CouchDB architecture, including replication and clustering. Your expertise should include experience with JSON, MapReduce functions, and query optimization for efficient data retrieval. You should be skilled in CouchDB performance tuning and effective indexing strategies to ensure optimal database functionality. Additionally, familiarity with monitoring tools like Prometheus, Grafana, etc., for real-time performance tracking is essential. Your responsibilities will also include understanding backup strategies, including full backups, incremental backups, replication-based backups, automated scheduling, storage policies, and restoration processes. You should be capable of troubleshooting database locks, conflicts, and indexing delays to prevent performance bottlenecks and ensure smooth operations. The ideal candidate for this role should possess strong experience with Apache CouchDB and a solid understanding of NoSQL database concepts, document stores, and JSON-based structures. Experience with CouchDB replication, clustering, and eventual consistency models is a must. Knowledge of data backup/recovery and security best practices is also crucial for this position. In addition to technical expertise, you should have excellent problem-solving and communication skills to effectively collaborate with team members and stakeholders. Your ability to analyze complex database issues and propose effective solutions will be key to success in this role.,

As a Data Modeling Engineer specializing in Near Real-time Reporting, you will be responsible for creating robust and optimized schemas to facilitate near real-time data flows for operational and analytical purposes within Google Cloud environments. Your primary focus will be on designing models that ensure agility, speed, and scalability to support high-throughput, low-latency data access needs. Your key responsibilities will include designing data models that align with streaming pipelines, developing logical and physical models tailored for near real-time reporting, implementing strategies such as caching, indexing, and materialized views to enhance performance, and ensuring data integrity, consistency, and schema quality during rapid changes. To excel in this role, you must possess experience in building data models for real-time or near real-time reporting systems, hands-on expertise with GCP platforms such as BigQuery, CloudSQL, and AlloyDB, and a solid understanding of pub/sub, streaming ingestion frameworks, and event-driven design. Additionally, proficiency in indexing strategies and adapting schemas in high-velocity environments is crucial. Preferred skills for this position include exposure to monitoring, alerting, and observability tools, as well as functional familiarity with financial reporting workflows. Moreover, soft skills like proactive adaptability in fast-paced data environments, effective verbal and written communication, and a collaborative, solution-focused mindset will be highly valued. By joining our team, you will have the opportunity to design the foundational schema for mission-critical real-time systems, contribute to the performance and reliability of enterprise data workflows, and be part of a dynamic GCP-focused engineering team. Skills required for this role include streaming ingestion frameworks, BigQuery, reporting, modeling, AlloyDB, pub/sub, CloudSQL, Google Cloud Platform (GCP), data management, real-time reporting, indexing strategies, and event-driven design.,

You will be working as a Data Schema Designer focusing on designing clean, extensible, and high-performance schemas for GCP data platforms in Chennai. The role is crucial in standardizing data design, enabling scalability, and ensuring cross-system consistency. Your responsibilities will include creating and maintaining unified data schema standards across BigQuery, CloudSQL, and AlloyDB, collaborating with engineering and analytics teams to identify modeling best practices, ensuring schema alignment with ingestion pipelines, transformations, and business rules, developing entity relationship diagrams and schema documentation templates, and assisting in the automation of schema deployments and version control. To excel in this role, you must possess expert knowledge in schema design principles for GCP platforms, proficiency with schema documentation tools such as DBSchema and dbt docs, a deep understanding of data normalization, denormalization, and indexing strategies, as well as hands-on experience with OLTP and OLAP schemas. Preferred skills for this role include exposure to CI/CD workflows and Git-based schema management, experience in metadata governance and data cataloging. Soft skills like precision and clarity in technical documentation, collaboration mindset with attention to performance and quality are also valued. By joining this role, you will be the backbone of reliable and scalable data systems, influence architectural decisions through thoughtful schema design, and work with modern cloud data stacks and enterprise data teams. Skills required for this position include GCP, denormalization, metadata governance, data, OLAP schemas, Git-based schema management, CI/CD workflows, data cataloging, schema documentation tools (e.g., DBSchema, dbt docs), indexing strategies, OLTP schemas, collaboration, analytics, technical documentation, schema design principles for GCP platforms, and data normalization.,

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world. Your role includes monitoring and maintaining SQL Server databases (2012 and above), performing routine database backups, restores, and recovery procedures. You will troubleshoot and resolve database performance issues using tools like SQL Profiler, Extended Events, and DMVs. Additionally, you will be responsible for implementing and maintaining database security (roles, permissions, encryption), assisting in database deployments, patching, and upgrades, as well as designing and implementing high availability (HA) and disaster recovery (DR) solutions (AlwaysOn, Log Shipping, Replication, Clustering). To be successful in this role, you should have 4 - 12 years of experience as a SQL Database Administrator with a strong knowledge of Microsoft SQL Server (2012-2019/2022). Proficiency in T-SQL, indexing strategies, and query optimization is required. Understanding of database backup strategies and recovery models, as well as familiarity with monitoring tools like Redgate, SolarWinds, SentryOne, is essential. Working at Capgemini, you'll have the opportunity to work with modern SQL Server versions (2012-2022) and advanced tools such as SQL Profiler, Extended Events, DMVs, Redgate, SolarWinds, and SentryOne. As a DBA, you'll contribute to projects spanning strategy, design, engineering, and AI-driven solutions. You can expect career growth, global exposure, a focus on innovation, cloud, security, and automation, as well as an inclusive culture and a strong support system. Capgemini is a global business and technology transformation partner, helping organizations accelerate their dual transition to a digital and sustainable world. With a diverse team of 340,000 members in over 50 countries, Capgemini has a strong over 55-year heritage and is trusted by clients to unlock the value of technology across their business needs. The company delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, fueled by market-leading capabilities in AI, generative AI, cloud, and data, combined with deep industry expertise and a strong partner ecosystem.,

Description We are looking for an experienced SQL Engineer to join our team in India. The ideal candidate will have a strong background in database management and will be responsible for designing, developing, and maintaining our SQL databases. You will work closely with various teams to ensure data integrity and availability. Responsibilities Design, develop, and maintain SQL databases and data models. Write complex SQL queries to extract and manipulate data. Optimize database performance and troubleshoot issues. Collaborate with data analysts and other teams to understand data requirements. Implement data security and integrity measures. Skills and Qualifications 6-9 years of experience in SQL database management and development. Strong proficiency in SQL and database design principles. Experience with database management systems such as MySQL, PostgreSQL, or SQL Server. Knowledge of data warehousing concepts and ETL processes. Familiarity with performance tuning and optimization techniques. Ability to work with large datasets and perform data analysis. Strong problem-solving skills and attention to detail.

Description We are seeking an experienced SQL Developer to join our team in India. The ideal candidate will have a strong background in SQL development and database management, with a proven ability to optimize and maintain complex database systems. Responsibilities Design, develop, and maintain SQL databases and applications. Optimize database performance by analyzing and tuning SQL queries. Create and manage stored procedures, triggers, and views. Collaborate with application developers to integrate SQL solutions with applications. Ensure data integrity and security within the SQL environment. Troubleshoot and resolve database-related issues in a timely manner. Skills and Qualifications 5-15 years of experience in SQL database development and management. Proficiency in SQL programming and query optimization. Experience with database design and architecture. Knowledge of database management systems (DBMS) such as MySQL, SQL Server, or PostgreSQL. Familiarity with data modeling and ETL processes. Strong analytical and problem-solving skills. Ability to work collaboratively in a team environment. Good communication skills and attention to detail.

Whats the Role? We are seeking an experienced Senior Database Developer with deep hands-on expertise in MSSQL, MySQL, PostgreSQL , and other relational databases. This role requires strong SQL and T-SQL programming skills, stored procedure development, and query performance tuning. Experience across multiple RDBMS environments is critical as our applications span diverse database technologies. Responsibilities/ Duties Design, develop, and maintain SQL databases (MSSQL, MySQL, PostgreSQL) and objects such as views, stored procedures, triggers, and functions. Write and optimize complex T-SQL and SQL queries for performance and scalability. Implement efficient indexing strategies and database normalization for high-performing systems. Analyse execution plans, fine-tune queries, and apply performance tuning best practices. Conduct data migration and transformation between different RDBMS platforms. Collaborate with cross-functional teams to ensure seamless integration between applications and databases. Build and maintain ETL pipelines using tools like SSIS or other open-source platforms. Develop reporting solutions using SSRS or equivalent tools. Participate in schema design, data modelling, and version control practices. Document database designs, processes, and optimizations clearly for team reference. Stay current with advancements in database technologies and recommend tools/solutions. Criteria for the Role! 5–7 years of experience in database development . Strong hands-on expertise in MSSQL, MySQL, PostgreSQL , and SQL query development. Deep understanding of T-SQL , stored procedures, triggers, indexes, views, and schema design. Solid grasp of query execution plans and optimization techniques. Experience with SSRS (or similar reporting tools) and SSIS (or other ETL frameworks). Familiarity with working in cross-database environments and handling heterogeneous data integrations. Good analytical, troubleshooting, and debugging skills. Clear communicator with collaborative working style. Experience with Git or other version control for SQL scripts is a plus. Nice to Have Exposure to replication concepts (Transactional, Merge, Snapshot) is a plus, but not mandatory. Experience with NoSQL or cloud-native databases (e.g., DynamoDB, Firebase, or MongoDB). Experience in logistics, freight, or enterprise ERP systems. Knowledge of Power BI or data visualization tools. Competency Agile Methodologies Experience in Agile/Scrum environments Involvement in sprint planning, stand-ups, retrospectives Communication & Collaboration Ability to understand business requirements and translate them to SQL logic Collaborate with product, engineering, and QA teams Problem Solving Proactive in identifying and fixing performance issues Familiarity with SQL Profiler, indexing strategies, and real-time diagnostics Growth Mindset Willingness to learn new databases, technologies, and paradigms Passion for continuous improvement