14 Sql Scripts Jobs

Key Responsibilities: Install, configure, and maintain SAP HANA databases in on-premises and cloud environments. Monitor database performance and conduct tuning and optimization to ensure system efficiency. Implement and manage HANA database backup and recovery strategies. Perform HANA database upgrades, patching, and migrations as needed. Ensure high availability (HA) and disaster recovery (DR) strategies are in place. Work closely with SAP Basis, infrastructure, and application teams to support SAP landscapes. Manage user access, security policies, and role-based authentication. Troubleshoot and resolve database issues in production and non-production environments. Automate routine database administration tasks using SQL scripts, Shell scripting, or Python. Ensure compliance with IT security policies, GDPR, and other regulatory requirements. Document all database configurations, procedures, and troubleshooting steps. Notice Period: 0 to 30 Days Mode of Shift: Rotational Rounds of Interview-2 Rounds Location: Pune , Bangalore,Delhi,Chennai,Hyderabad,Bhubhaneshwar,Vizag.

Product Support Specialist Bangalore, India The Opportunity Anthology delivers education and technology solutions so that students can reach their full potential and learning institutions thrive. Our mission is to empower educators and institutions with meaningful innovation that s simple and intelligent, inspiring student success and institutional growth. The Power of Together is built on having a diverse and inclusive workforce. We are committed to making diversity, inclusion, and belonging a foundational part of our hiring practices and who we are as a company. For more information about Anthology and our career opportunities, please visit www.anthology.com. Primary responsibilities will include Understanding of API, SSO & Integrations Providing expertise product support to customer issues. Experience in handling SAAS based product. Investigating, resolving, and providing root cause analysis on reported application issues Using SQL scripts for creating queries and troubleshooting stored procedures (understanding of troubleshooting the stored procedure) Using SQL profiler to identify the root cause Effectively communicating timely updates to customers through appropriate incident tracking tools Quickly establishing rapport, gaining, and maintaining credibility with diverse audiences Coordinating between customers, development team and internal support teams while working on customer issues Efficiently coordinating with the internal and external stakeholders Working with the customers to gather product requirement, analyze and document before it is passed on to the product management team for next steps Escalating issues as and when needed to Level II/Level III analysts or with the development teams for resolutions Following established guidelines and industry best practices to resolve customer issues Mentoring and training junior support analysts in the technical and procedural aspects of our products and operations Good documentation skills to be able to communicate with the customer in a profession a l manner Good verbal and written communication skills The Candidate Required skills/qualifications Should have a minimum 6+ years of experience in application support Willingness to work night shifts Strong written and oral communication skills Good documentation skills and ability to communicate with the customer in a professional manner Fluency in written and spoken English Graduate with BE( CS ) , BCA, MCA

Primary responsibilities will include: Providing Level 1/Level 2 product support to customer issues Investigating, resolving, and providing root cause analysis on reported application issues Using SQL scripts for creating queries and troubleshooting stored procedures Using SQL profiler to identify the root cause Effectively communicating timely updates to customers through appropriate incident tracking tools Quickly establishing rapport, gaining and maintaining credibility with diverse audiences Coordinating between customers, development team and internal support teams while working on customer issues. Efficiently coordinating with the internal and external stakeholders Working with the customers to gather product requirement, analyzing and documenting before it is passed on to the product management team for next steps Escalating issues as and when needed to Level II/Level III analysts or with the development teams for resolutions Following established guidelines and industry best practices to resolve customer issues The Candidate: Required skills/qualifications: Should have a minimum of 0-2 years of experience in application support Willingness to work night shifts Strong written and oral communication skills Good documentation skills and ability to communicate with the customer in a professional manner Fluency in written and spoken English

Peoplesoft Campus Solutions Setup & Implementation Campus Community Student Recruiting and Admissions Student Financial (Cashiering and Tuition Fees) Student Records and Enrollment Curriculum Management Integration Broker with or without API SQL Scripts PS-Query Peoplesoft Application Engine

Primary responsibilities will include: Providing Level 1 product support to customer issues Investigating, resolving, and providing root cause analysis on reported application issues Using SQL scripts for creating queries and troubleshooting stored procedures Using SQL profiler to identify the root cause Effectively communicating timely updates to customers through appropriate incident tracking tools Quickly establishing rapport, gaining and maintaining credibility with diverse audiences Coordinating between customers, development team and internal support teams while working on customer issues. Efficiently coordinating with the internal and external stakeholders Working with the customers to gather product requirement, analyzing and documenting before it is passed on to the product management team for next steps Escalating issues as and when needed to Level II/Level III analysts or with the development teams for resolutions Following established guidelines and industry best practices to resolve customer issues The Candidate: Required skills/qualifications: Should have a minimum of 2 years of experience in application support Willingness to work night shifts Strong written and oral communication skills Good documentation skills and ability to communicate with the customer in a professional manner Fluency in written and spoken English

Job Description: We are seeking a SQL Developer with strong SQL skills and add on experience in either C# or Python. This role demands excellent problem-solving abilities, a focus on optimization, and a commitment to 24/7 system support, ensuring operational excellence. Key Responsibilities: Develop and maintain efficient SQL queries, Joins, procedures, and database structures. Create and optimize stored procedures to enhance database performance and ensure scalability. Implement advanced SQL optimization techniques, including indexing, query tuning, and performance monitoring. Analyze and resolve debugging issues in SQL scripts, stored procedures, and triggers. Write, debug, and maintain C# code, focusing on object-oriented programming (OOPS) principles. Utilize the .NET Framework and .NET Core to build robust and scalable applications. Work with Windows Forms or WPF for developing user interfaces (as required). Knowledge of apply exception handling and error logging mechanisms in C# to ensure robust software development. Write, debug, and maintain Python code for software applications. Knowledge of Python basics, including data types, loops, conditional statements, functions, and file handling. Assist in automating processes using Python scripts. Collaborate with teams to design, implement, and optimize database solutions. Integrate software applications with database systems for seamless performance. Conduct testing and troubleshooting for systems and applications. Document development processes and ensure compliance with coding standards. Provide reliable 24/7 support by monitoring systems and responding promptly to ensure operational continuity. Participate in team discussions and suggest improvements to systems and workflows

Your key responsibilities Production Support Supports the production platform, carrying out monitoring and remediation of issues and specific maintenance tasks as per the run book procedures. Owns the logs that track manual tasks, remediation and system improvement Second line of defence for Incident Management gathering data for investigation and identification of root cause through to resolution Defines and creates Run Book entries and knowledge articles based on incidents experienced in the production environment Application Analysis Carries out deep technical analysis of the production to identify performance, stability and resilience enhancements. Assists in design and creation of NFRs through identification of further requirements. Incident Management Prioritizes and diagnoses incidents according to agreed procedures. Investigates causes of incidents and seeks resolution. Facilitates recovery, following resolution of incidents. Documents and closes resolved incidents according to agreed procedures. Change Management Assesses, analyses, develops, documents and implements changes based on requests for change. These could be technical and/or functional solutions as provided by Development and/or other Production Engineers ensuring segregation of duties Configure the application in response to business and/or technical problems and in accordance with provided requirements and agreed design principles Problem management Investigates problems in systems, processes and services. Ensures PIR reporting and Root Cause Analysis Assists with the implementation of agreed remedies and preventative measures. Attends Program Meetings to prioritize owned stability and performance enhancements as identified in production Release and deployment : Uses the tools and techniques for specific areas of release and deployment activities. Administers the recording of activities, logging of results and documents technical activity undertaken. May carry out early life support activities such as providing support advice to initial users. Production Readiness and Testing Serves as the DevOps Lead, working closely with the Change teams in driving and embedding the Production readiness controls as part of the Software delivery lifecycle. Builds keep list of NFRs and ensures adherence through design forums Reviews requirements and specifications and defines test conditions Analyses and reports on test activities and reports risk and issues associated with own work. Your skills and experience Sound understanding of Production Management processes and controls in large organizations. Strong experience of envisioning and driving full stack automation in medium to large sized groups. Excellent problem solving skills in a distributed, multi-technology ecosystem Strong Experience in Base SAS, Advance SAS, Macros on UNIX Platform. Strong Skill in Advance Data Step programming statement to solve complex problems Strong Skill in writing and debugging SAS SQL/Proc SQL code. Strong Skill in writing and using SAS Macros. Hands on experience with SAS/Access using Oracle Strong Scripting experience in Shell, Perl Good understanding and Hands on experience for SAS Grid Manager Solid understanding of monitoring systems like ITRS Geneos Strong Knowledge of Oracle Management, SQL scripts, performance mgmt. Strong knowledge of configuration management tools like Ansible (preferred), Chef and Puppet Strong understanding of Unix, Linux and Windows Understanding of Agile and Safe methodologies (preferred)

SAP HANA DB Modeler/Developer" is responsible for designing, developing, and maintaining data models within the SAP HANA database, utilizing advanced modeling techniques to optimize data access and analysis for reporting and applications, often collaborating with business analysts to translate requirements into efficient database structures while ensuring data integrity and performance within the HANA platform. Must have skills should include: Hana Views( Analytical, Calculation etc.) , SAP HANA XS JavaScript and XS OData services, Advanced DB Modelling for Hana, SAP HANA Data Services ETL based Replication amongst others. Minimum 2 3 end to end implementations. Key responsibilities may include: Data Modeling: Designing and creating complex data models in SAP HANA Studio using analytical views, attribute views, calculation views, and hierarchies to represent business data effectively. Implementing data transformations, calculations, and data cleansing logic within the HANA model. Optimizing data structures for fast query performance and efficient data access. Development: Writing SQL scripts and stored procedures to manipulate and retrieve data from the HANA database. Developing custom HANA functions (CE functions) for advanced data processing and calculations. Implementing data loading and ETL processes to populate the HANA database. Performance Tuning: Analyzing query performance and identifying bottlenecks to optimize data access and query execution. Implementing indexing strategies and data partitioning for improved query performance. Collaboration: Working closely with business analysts to understand data requirements and translate them into technical data models. Collaborating with application developers to integrate HANA data models into applications. Security and Governance: Implementing data security measures within the HANA database, defining user roles and permissions. Maintaining data quality and consistency by defining data validation rules. Required Skills: Technical Skills: Strong understanding of relational database concepts and data modeling principles. Expertise in SAP HANA modeling tools and features (HANA Studio, Calculation Views, Analytical Views) Proficiency in SQL and SQL optimization techniques Knowledge of data warehousing concepts and best practices Soft Skills: Excellent analytical and problem solving abilities Strong communication skills to collaborate with business users and technical teams Ability to work independently and as part of a team

Utilize Alteryx to develop and automate ETL (Extract, Transform, Load) workflows for data preparation and cleansing. Design, develop, and maintain SQL scripts, queries, and stored procedures for data extraction, manipulation, and analysis. Collaborate with stakeholders to understand business requirements and translate them into technical specifications for Alteryx workflows and SQL queries. Build and maintain data models to support business reporting and analytics needs. Perform data validation, testing, and troubleshooting to ensure data accuracy, consistency, and reliability. Optimize Alteryx workflows and SQL queries for performance and efficiency. Provide support and training to end users on Alteryx and SQL functionalities. Stay updated with the latest features and best practices in Alteryx and SQL technologies. Assist in the evaluation and implementation of new tools and technologies to enhance data analytics capabilities.

Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects. Extensively worked on creating database objects including tables, indexes, views, sequences, packages. Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team. Extensively done performance tuning of oracle databases by rewriting optimized SQL queries. Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance. Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language). Should have good exposure to Linux/Unix, Shell Scripting & XML Good experience in using WinSCP & Putty Flexible working hours (able to work in shifts, if needed) Must have hands on experience in coding. Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer. Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances. Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to migrate data from one database (SQL Server) to Oracle platform.

Key Responsibilities: Install, configure, and maintain SAP HANA databases in on-premises and cloud environments. Monitor database performance and conduct tuning and optimization to ensure system efficiency. Implement and manage HANA database backup and recovery strategies. Perform HANA database upgrades, patching, and migrations as needed. Ensure high availability (HA) and disaster recovery (DR) strategies are in place. Work closely with SAP Basis, infrastructure, and application teams to support SAP landscapes. Manage user access, security policies, and role-based authentication. Troubleshoot and resolve database issues in production and non-production environments. Automate routine database administration tasks using SQL scripts, Shell scripting, or Python. Ensure compliance with IT security policies, GDPR, and other regulatory requirements. Document all database configurations, procedures, and troubleshooting steps. Notice Period: 0 to 30 Days Mode of Shift: Rotational Rounds of Interview-2 Rounds Location: Pune , Bangalore,Delhi,Chennai,Hyderabad,Bhubhaneshwar,Vizag.

Greetings From OLIS Infosystems Pvt Ltd !!! Designation - SAP ABAP Exp - 4+ Years Location - Permanent Remote -SAP HANA ABAP Technical Consultant with 4+ years experience -Strong Experience in ABAP(RICEF) with OO programming Standard Enhancement -Very Strong Experience in OData, NetWeaver Gateway -Experience in ABAP RESTful Application Programming Model (RAP) -Expertise in HANA Native tools -Expertise in writing SQL scripts, AMDP Procedures for complex requirements -Good Knowledge on Fiori/SAP UI5 -Strong analytical and troubleshooting skills -Must have End to End Implementation -Experience Good Knowledge in SAP SD, MM, FI Good problem solving and communication skills. -2-3 implementation must.

Greetings From OLIS Infosystems Pvt Ltd !!! Designation - SAP ABAP Exp - 4+ Years Location - Permanent Remote -SAP HANA ABAP Technical Consultant with 4+ years experience -Strong Experience in ABAP(RICEF) with OO programming Standard Enhancement -Very Strong Experience in OData, NetWeaver Gateway -Experience in ABAP RESTful Application Programming Model (RAP) -Expertise in HANA Native tools -Expertise in writing SQL scripts, AMDP Procedures for complex requirements -Good Knowledge on Fiori/SAP UI5 -Strong analytical and troubleshooting skills -Must have End to End Implementation -Experience Good Knowledge in SAP SD, MM, FI Good problem solving and communication skills. -2-3 implementation must.

Greetings From OLIS Infosystems Pvt Ltd !!! Designation - SAP ABAP Exp - 4+ Years Location - Permanent Remote -SAP HANA ABAP Technical Consultant with 4+ years experience -Strong Experience in ABAP(RICEF) with OO programming Standard Enhancement -Very Strong Experience in OData, NetWeaver Gateway -Experience in ABAP RESTful Application Programming Model (RAP) -Expertise in HANA Native tools -Expertise in writing SQL scripts, AMDP Procedures for complex requirements -Good Knowledge on Fiori/SAP UI5 -Strong analytical and troubleshooting skills -Must have End to End Implementation -Experience Good Knowledge in SAP SD, MM, FI Good problem solving and communication skills. -2-3 implementation must.