302 Oltp Jobs - Page 4

#Notice Period: Immediate #Employment Type: Contract #Work Mode: WFO/Hybrid #Job Description : Key Responsibilities: Design, develop, and maintain Qlik View applications and dashboards. Collaborate with business stakeholders to gather requirements and translate them into technical specifications. Perform data analysis and create data models to support business intelligence initiatives. Optimize Qlik View applications for performance and scalability. Provide technical support and troubleshooting for Qlik View applications. Ensure data accuracy and integrity in all Qlik View applications. Integrate Snowflake with Qlik View to enhance data processing and analytics capabilities. Stay updated wit...

Routine Administrative Activities Resolve incidents escalated by L1 as per the agreed SLAs and timelines. L2 escalates the problem to L3. Installation / Upgradation / Migration of SQL Servers. Apply any patches or service packs for SQL Server. Configure High Availability/Disaster recovery solutions. Configure automated alerts to send a mail to team if any issues. Work on incidents, change tickets and problem tickets. Setup Maintenance plans for Backups, Database integrity check, rebuild index and Update statistics and make sure to run all the jobs without any issues. Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them. Join bridge calls to troubleshoot and ...

Job Description: We are seeking a Senior Data Modeler / Data Architect with 10+ years of experience in data modeling and database architecture. The ideal candidate will have expertise in SQL, dimensional modeling, OLTP & OLAP modeling, and enterprise-scale data warehouse design . Proficiency in Snowflake Data Cloud and experience with data modeling tools like ERwin, SQL DBM, or ER/Studio is required. Key Responsibilities: Develop and maintain conceptual, logical, and physical data models based on business and technical requirements. Design data marts and enterprise-scale data warehouses , ensuring scalability, performance, and integrity. Collaborate with database administrators (DBAs) and da...

Experience in any one of data modeling tool (currently NOV using SQL DBM) Very good knowledge/experience in SQL Knowledge on Dimensional Modeling Additional skills - Experience in Snowflake Data Cloud Min 10+ years of Total experience with minimum 5-6 years being Data Modeler or Data Architect. Knowledge in both OLTP and OLAP Modelling. Experience designing Data Marts and Data Warehouses on Enterprise Scale. Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements. Experience in ERWIN, SQL Database Modeler or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred. Coll...

We are seeking a highly skilled Senior Data Architect to lead the design, development, and optimization of scalable data architectures. This role requires expertise in data modeling, database performance tuning, big data solutions, and ETL pipelines , ensuring efficient data processing and seamless integration across various platforms. Key Responsibilities: Data Architecture Design Develop and maintain comprehensive relational, NoSQL, and cloud-based database architectures, ensuring scalability and high performance. Advanced Data Modeling Implement best practices in dimensional modeling (star, snowflake, galaxy schemas) , entity-relationship diagrams (ERD), and data normalization/de-normaliz...

About Us: Access is a global leader in information management solutions, offering comprehensive services across the entire document and records management lifecycle. From secure offsite storage for paper and digital records to advanced software for privacy, retention, and document management, Access enables organizations to protect, govern, and maximize the value of their information. Our end-to-end services include backfile imaging and digital delivery, scanning and digitization, business process automation, and secure destruction, purges, shredding and data archiving. Function: IT About the Role: Job Title/Role: Senior SQL DBA Mode of hire: Full-Time Base Location:Chennai Mode of work: Hyb...

We are looking for a skilled Data Modeler with 8 to 10 years of experience to join our team in Chennai. The ideal candidate will have expertise in data modeling techniques and methodologies for traditional OLAP/OLTP databases and modern data warehouses. Roles and Responsibility Design efficient data models for Oracle, BigQuery, and other databases. Analyze data requirements and develop effective data modeling solutions. Develop and maintain data warehousing systems using various technologies. Collaborate with cross-functional teams to identify business needs and develop data-driven solutions. Ensure data quality and integrity by implementing robust data validation and testing procedures. Sta...

Mandatory skills: • Min 7+ years of hands-on experience in creating T-SQL functions, stored procedures, views, triggers, complex querying techniques, Query optimization/Performance tuning techniques, indexes, user-defined types, constructing dynamic queries ( all are mandatory) • Min 3+ years of experience in ETL concepts and any one ETL tool • Flexibility to work in any RDBMS database tech like MSFT or Oracle. • Should be well versed in RDBMS constructs and CAP Theory. • Should be able to explain the redo and rollback functionalities in RDBMS • Should be able to explain performance by design constructs for different types of data stores like OLTP and OLAP • Should be aware of Bill Inmon Vs ...

Job Summary: We are seeking an experienced Oracle Performance Tuning Specialist to analyze, optimize, and troubleshoot database performance issues in complex Oracle environments. The ideal candidate will have deep expertise in SQL tuning, Oracle internals, AWR/ASH analysis , and end-to-end performance diagnostics to ensure mission-critical systems perform optimally. Key Responsibilities: Identify and resolve performance bottlenecks at the SQL, PL/SQL, and instance levels. Conduct in-depth analysis using AWR, ASH, SQL Trace, tkprof , and other diagnostic tools. Work with developers and DBAs to tune SQL queries, indexes, and PL/SQL code . Optimize Oracle database configurations , including mem...

Project Role : Engineering Services Practitioner Project Role Description : Assist with end-to-end engineering services to develop technical engineering solutions to solve problems and achieve business objectives. Solve engineering problems and achieve business objectives using scientific, socio-economic, technical knowledge and practical experience. Work across structural and stress design, qualification, configuration and technical management. Must have skills : 3D Modeling Good to have skills : NA Minimum 2 year(s) of experience is required Educational Qualification : BE or BTech Summary: As an Engineering Services Practitioner, you will be responsible for providing end-to-end engineering...

Looking for Immediate joiners only or max 10days Experience 8+ years Location - Pune, Look from only Pune location Budget - 25LPA Job Description Troubleshoot complex database issues in accurate and timely manner. Proficient in both Azure and AWS, certifications preferred but not required. Maintain database disaster recovery procedures to ensure continuous availability and speedy recovery. Ensure databases are deployed according to GBS standards and business requirements. Identify and resolve database issues related to performance and capacity. Ensure database management and maintenance tasks are performed effectively. Ensure ticket SLA expectations are met. Stay updated with new database te...

Job Descriprtion:- Manage SQL Server database, Configure and maintain database servers and processes Monitor system's health and performance and troubleshooting problems Ensure high levels of performance, sustainability and DB security Capacity planning and monitoring database growth. Experience in setting up MS SQL Server High Availability and Disaster Recovery (DR) solutions including failover clustering, replication, log shipping and database mirroring Demonstrated expertise in SQL server, database tuning and server administration Having exposure to SSIS, SSRS and SSAS performance tuning and Job executions are advantageous Experience in handling multi-terabyte OLTP, DR, Data Warehouse pro...

Data management, OLAP, OLTP, ETL, Data pipelines, Azure Data services - ADF, Data lake, Azure SQL, Databricks, Azure Synapse. Data Science - Python, Data Models, ML/AI

Mandatory skills: • Min 7+ years of hands-on experience in creating T-SQL functions, stored procedures, views, triggers, complex querying techniques, Query optimization/Performance tuning techniques, indexes, user-defined types, constructing dynamic queries ( all are mandatory) • Min 3+ years of experience in ETL concepts and any one ETL tool • Flexibility to work in any RDBMS database tech like MSFT or Oracle. • Should be well versed in RDBMS constructs and CAP Theory. • Should be able to explain the redo and rollback functionalities in RDBMS • Should be able to explain performance by design constructs for different types of data stores like OLTP and OLAP • Should be aware of Bill Inmon Vs ...

Highly motivated ODI (Oracle Data Integrator) senior developer, with broad experience in designing, developing, documenting requirements and validation. The position requires strong technical and communication skills, and a track record of successfully implementing Oracle BI products. Skills and Responsibilities: Strong design and development experience in Oracle SQL and PL/SQL and Oracle Data Integrator using 11g & 12c Must have experience in Oracle Database Design and Data Modeling Understanding the OLAP process Monitor, analyze and address reliability and performance tuning Develop strategies for resolving issues and preventing future occurrences Data warehouse lifecycle management experi...

Required Skills and Experience 4-6 years of strong experience in Programming with Python, Perl Strong experience in query based databases: SQL, SQLplus, Oracle SQL, MySQL Experience in Power BI Comfortable working in a Linux environment as well as Windows 4-6 years of experience in e-Discovery, including relevant working knowledge of at least one e-Discovery review platform (Relativity preferred) Strong background in key technologies, including client/server environments, network technologies, databases and web-based technologies Excellent English oral and written communication skills; ability to interact with management and co-workers, and possibly client managers. Understanding and impleme...

The people here at Apple don t just build products they craft the kind of wonder that has revolutionized entire industries. It s the diversity of those people and their ideas that encourages the innovation that runs through everything we do, from amazing technology to industry-leading environmental efforts. Imagine what you could do here. Join Apple, and help us leave the world better than we found it! A job at Apple is unlike any other you ve had. You will be challenged. You will be inspired. And you ll be proud! At Apple, phenomenal ideas have a way of becoming phenomenal products, services, and customer experiences very quickly. Bring passion and dedication to your job, and theres no tell...

We are Motive - the worlds leading provider of device management for mobile, fixed and IoT as well as managing the omni-channel customer experience which through its business logic drives actions, runs proactive care campaigns and improves customer satisfaction. Deployed by leading service providers worldwide, Motives device management and service management platform drive revenue, reduce customer care costs and automate each customer interaction. A relaunched brand with a long history and pedigree, at Motive we differentiate ourselves by creating innovative technical solutions, packaging them in ways that simplify operational complexity and time to market, and we never forget that we only s...

Role Overview: As a skilled Data Modeler specialized in using DBSchema within GCP environments, you will play a crucial role in creating and optimizing data models for both OLTP and OLAP systems. Your focus will be on designing models that are performance-oriented and easy to maintain. You will be responsible for developing conceptual, logical, and physical models using DBSchema, ensuring alignment with application requirements, and optimizing models in BigQuery, CloudSQL, and AlloyDB. Apart from these tasks, you will also contribute to supporting schema documentation, reverse engineering, and visualization activities. Key Responsibilities: - Develop conceptual, logical, and physical data mo...

Are you a self-motivated engineer and ready for changes in building large-scale and mission-critical distributed systems and cloud servicesOCI s OLTP organization offers exciting opportunities for you! Our fast-growing engineering team is looking for a Software Engineer to help us to build the next-generation cloud Data platforms. Join us today! An engineer at any level can have a significant technical and business impact. In our area, we specialize on everything related to distributed database systems and cloud services. We are looking for people who have experience or are deeply interested in databases, distributed systems and cloud services. There is always something new to do at our team...

Principal Technical Specialist Leads feature design by analyzing requirements, guiding teams, and aligning with product strategy. Understands domain and network operations, mitigates software hot-spots, and applies AI techniques to enhance operator application usage. You have: Bachelors degree or equivalent with 58 years in designing scalable, reliable systems. Strong Programming Skills in Java and Python/Shell, with exposure to Golang and frameworks like Spring, Guice, Micronaut; familiar with key data science libraries. Data Engineering Expertise including real-time platforms (Kafka, Spark) and deep knowledge of both SQL (Postgres, Oracle) and NoSQL databases (Elastic, MongoDB, Redis). Dom...

You are a talented SAP HANA Developer sought after by RiskInsight Consulting Pvt Ltd, a company specializing in providing innovative risk management solutions to clients across finance and insurance sectors. Your role in this growing team involves designing and implementing sophisticated SAP HANA applications to enhance business value and efficiency. - Developing and maintaining data models in SAP HANA - Designing, coding, and testing applications - Optimizing SQL queries for high performance - Collaborating with business analysts to translate requirements into technical specifications - Implementing data integration processes - Troubleshooting, debugging, and staying updated on advancements...

As a Senior ETL Developer at Elevondata Labs, Gurgaon, DLF Phase IV, your role involves designing and developing enterprise data warehouse (EDW), data analysis, and reporting solutions in alignment with business objectives. You will be responsible for developing database interfaces for on-premise and online multi-tier web and client-server applications. Additionally, your responsibilities include maintaining databases, understanding business requirements, and translating them into effective solutions. Key Responsibilities: - Manage data warehouse and business intelligence systems - Design and develop enterprise data warehouse solutions - Monitor all components for integrity, stability, and h...

As a Data Architect specializing in OLTP & OLAP Systems, you will play a crucial role in designing, optimizing, and governing data models for both OLTP and OLAP environments. Your responsibilities will include architecting end-to-end data models across different layers, defining conceptual, logical, and physical data models, and collaborating closely with stakeholders to capture functional and performance requirements. Key Responsibilities: - Design, optimize, and govern data models for OLTP and OLAP systems - Architect end-to-end data models across various layers - Define conceptual, logical, and physical data models - Collaborate with stakeholders to capture functional and performance requ...

As a Solutions Architect with over 7 years of experience, you will leverage your expertise in cloud data solutions to architect scalable and modern solutions on AWS. You will be a key member of high-impact engineering teams at Quantiphi, collaborating closely with clients to solve complex data challenges and design cutting-edge data analytics solutions. **Key Responsibilities:** - Act as a trusted advisor to clients and lead discovery/design workshops with global customers. - Collaborate with AWS subject matter experts to develop compelling proposals and Statements of Work (SOWs). - Represent Quantiphi in various forums such as tech talks, webinars, and client presentations. - Provide strate...