7 Table Partitioning Jobs

Description We are seeking an experienced SAP HANA professional to join our team in India. The ideal candidate will have a strong background in SAP HANA development and implementation, with the ability to work collaboratively with cross-functional teams to deliver high-quality solutions. Responsibilities Design, develop, and implement SAP HANA solutions to meet business requirements. Collaborate with cross-functional teams to gather and analyze requirements for data models and reporting solutions. Optimize performance of existing SAP HANA applications and databases. Ensure data integrity and security within SAP HANA systems. Provide technical support and troubleshooting for SAP HANA environments. Prepare documentation for system design, configuration, and user training. Skills and Qualifications 4-14 years of experience in SAP HANA development and implementation. Strong knowledge of SAP HANA architecture, data modeling, and SQL scripting. Experience with SAP HANA Studio and SAP HANA Database Administration. Familiarity with ETL tools and data integration processes. Ability to perform performance tuning and optimization of SAP HANA applications. Understanding of business processes and ability to translate them into technical requirements.

You will be responsible for performing joins such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins of two or more tables. Additionally, you will be expected to work with Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve working with Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER. You should have a good understanding of creating and maintaining Views and Materialized Views, as well as executing Hierarchical queries for data retrieval from tables with hierarchical data structures. Furthermore, you will be required to handle Complex Queries involving Nested queries, inline views, correlated subqueries, and have basic knowledge of Table Partitioning including table and index partitioning. In addition, you must have proficiency in PL/SQL and be able to create and maintain objects like procedures, functions, packages, types, and triggers. Your expertise should also include recursion, loops (FOR, WHILE DO), nested blocks, conditional logic (IF, CASE statements), and managing exceptions effectively. Moreover, you should be familiar with working with Collection & Records in PL/SQL blocks and executing BULK operations efficiently. Requirements: - Minimum of 2 years of relevant experience in posgress SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred certifications: - PL/SQL Developer Certified Associate Preferred Location: - Mumbai: Thane, Mulund, Bhandup, Vikroli, Ghatkopar, Kurla, and Powai Notice Period: - Immediate Joiner required This is a full-time position with a flexible schedule. You will be expected to work day shifts from Monday to Friday with morning shifts and weekend availability. Performance bonuses will be provided based on your contributions. Ability to commute/relocate to Mumbai, Maharashtra is required. Ideally, you should have a total of 1 year of work experience.,

The SQL Server & SQL DBA position involves being responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of corporate applications. This role requires solid technical skills and excellent interpersonal and communication skills. As the SQL Server & SQL DBA, you will play a key role in developing and sustaining the SQL Server Warehouse, ensuring its operational readiness, executing data loads, and performing data modeling to support multiple development teams. The data warehouse supports an enterprise application suite of program management tools, and you will need to work independently and collaboratively across various products. Key responsibilities include managing SQL Server databases through different lifecycle environments, configuring and maintaining database servers and processes, applying data modeling techniques, and performing maintenance tasks such as index de-fragmentation and data consistency checks. Troubleshooting transaction logs and Tempdb, implementing replication models, managing multiple instances, and database shrinking are also part of the role. You should have a strong understanding of Microsoft SQL Server, Server Integration Services (SSIS), SQL Server Always On Availability, SQL Replication, Azure cloud, and Microsoft Clustering. Experience in query tuning, schema refinement, and providing 24x7 support for critical production systems is necessary. Additionally, knowledge of High Availability (HA), disaster recovery (DR), mirroring, clustering, and AlwaysOn options for MS SQL Server is required. Qualified candidates will be able to troubleshoot and resolve database integrity and performance issues, optimize Azure Cloud with multi-tenancy, and have experience in Very Large Database (VLDB) management. Experience with Analysis Services and Reporting Services is a plus. If you meet the qualifications and are looking to take on a challenging and rewarding role as a Microsoft SQL DBA, we encourage you to apply for this position.,

As a Cloud Data Modeler with 6 to 9 years of experience in GCP environments, you will play a crucial role in designing schema architecture, creating performance-efficient data models, and guiding teams on cloud-based data integration best practices. Your expertise will be focused on GCP data platforms such as BigQuery, CloudSQL, and AlloyDB. Your responsibilities will include architecting and implementing scalable data models for cloud data warehouses and databases, optimizing OLTP/OLAP systems for reporting and analytics, supporting cloud data lake and warehouse architecture, and reviewing and optimizing existing schemas for cost and performance on GCP. You will also be responsible for defining documentation standards, ensuring model version tracking, and collaborating with DevOps and DataOps teams for deployment consistency. Key Requirements: - Deep knowledge of GCP data platforms including BigQuery, CloudSQL, and AlloyDB - Expertise in data modeling, normalization, and dimensional modeling - Understanding of distributed query engines, table partitioning, and clustering - Familiarity with DBSchema or similar tools Preferred Skills: - Prior experience in BFSI or asset management industries - Working experience with Data Catalogs, lineage, and governance tools Soft Skills: - Collaborative and consultative mindset - Strong communication and requirements gathering skills - Organized and methodical approach to data architecture challenges By joining our team, you will have the opportunity to contribute to modern data architecture in a cloud-first enterprise, influence critical decisions around GCP-based data infrastructure, and be part of a future-ready data strategy implementation team.,

You will be responsible for performing JOIN operations such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins on two or more tables. Additionally, you will handle Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve utilizing Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER for data analysis. You should be adept at working with Views and Materialized Views, understanding the basics of creating and maintaining views. Proficiency in executing Hierarchical queries for data retrieval from tables with hierarchical data is essential. Your expertise in handling Complex Queries like Nested queries, inline views, and correlated subqueries will be crucial. Knowledge of Table Partitioning, including table & index partitioning, is required. You will be expected to work with PL/SQL, creating and maintaining objects such as procedures, functions, packages, types, and triggers. Familiarity with recursion, loops (FOR, WHILE DO), nested blocks, and conditional logic (IF, CASE statements) is necessary. You must possess experience in managing Exception handling for run-time Oracle defined/user-defined errors. Understanding the usage of collections and records in PL/SQL blocks is vital. Proficiency in BULK operations for performing operations on bulk data is a must. Requirements: - Minimum 2 years of relevant experience in PostgreSQL SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: Preferred certifications: - PL/SQL Developer Certified Associate Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred Location: (Mumbai) Thane, Mulund, Bhandup, Vikhroli, Ghatkopar, Kurla, and Powai Notice Period: Immediate Joiner required. Job Types: Full-time Benefits: - Flexible schedule Schedule: - Day shift, Monday to Friday, Morning shift - Weekend availability Performance bonus offered. Ability to commute/relocate: - Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Experience: - Total work: 1 year (Preferred),

Key Responsibilities: Install, configure, and maintain Microsoft SQL Server databases. Monitor system performance and ensure database availability and reliability. Perform database tuning and optimization using native monitoring and troubleshooting tools. Manage database backup, restore, and recovery processes. Implement and maintain database security (e.g., create and manage roles and permissions). Create and maintain documentation of database systems and procedures. Write and optimize SQL queries, stored procedures, and triggers. Conduct regular database health checks and audits. Troubleshoot and resolve database-related issues. Support data migration, data transformation, and data integration efforts. Work closely with developers and IT teams to ensure high-performance database systems. Exposure to SSIS , SSRS , or SSAS . Design, install, configure, and maintain SQL Server databases across development, testing, and production environments. Plan and implement high availability (HA) and disaster recovery (DR) solutions. Monitor database performance and proactively address issues to ensure system availability and responsiveness. Automate routine DBA tasks using tools like PowerShell or SQL Server Agent Jobs. Develop and optimize complex T-SQL scripts, stored procedures, views, and triggers. Perform regular database backups, restoration tests, and security audits. Collaborate with application developers to optimize queries and database performance. Manage user access, roles, and security settings to ensure data protection. Lead or assist in data migration. Required Skills and Qualifications: Proven experience as a SQL Server Database Administrator. Strong understanding of database structure, theories, principles, and practices. Hands-on experience with database standards and end-user applications. Proficient in T-SQL, stored procedures, and SQL Server tools. Experience with SSMS, SQL Profiler, and other monitoring tools. Knowledge of High Availability (HA) and Disaster Recovery (DR) options. Familiar with database design and development best practices.

Project Role :Application Developer Project Role Description :Design, build and configure applications to meet business process and application requirements. Must have skills :SAP HANA DB Administration Good to have skills :SAP HANA Technical Architecture Minimum 2 year(s) of experience is required Educational Qualification :1 Minimum 15 years of full time education Project Role :Application Developer Project Role Description :Design, build and configure applications to meet business process and application requirements. Must have Skills :SAP HANA DB AdministrationGood to Have Skills SAP HANA Technical ArchitectureJob Requirements :Key Responsibilities :Requirement for SAP HANA DB Administration role preferably HANA ECS experience candidates with 2-3 years of experience requiredResource has to provide L2 level support in HANA Enterprise Cloud Technical Operations Technical Experience :Must have skills:-Installing, Configuring And Maintaining HANA database-Table Partitioning, Replication, Database Management-HANA DB certification prefered-Upgrades / HA DR / Backup / restore related troublshooting-Multi-node / Multi tenant administration-Collect runtime dumps, kernel profiler traces-Performance parameter tuning / Security compliance And hardening for HANA DB Good to have skills:User management/administration DB on Cloud platforms AWS, Azure etc Professional Attributes :1 Good communication and interpersonal skills2 Good team player3 Candidate must be ready to support 24/7 rotational shifts Educational Qualification:1 Minimum 15 years of full time educationAdditional Info : Qualifications 1 Minimum 15 years of full time education