561 Query Optimization Jobs - Page 3

Database design, SQL query optimization, data modeling, and troubleshooting database issues. Responsibilities Database Development and Design: Create, maintain, and optimize SQL databases, including tables, views, stored procedures, and functions. SQL Query Optimization: Write efficient and performant SQL queries, and analyze existing queries for performance improvements. Data Modeling: Design and implement data models to effectively represent and manage data within the database. Troubleshooting and Debugging: Identify and resolve issues with database queries and applications. Collaboration: Work with other developers, business analysts, and stakeholders to understand requirements and integrate database solutions. Database Administration: Perform tasks related to database backup, recovery, and security. Data Analysis and Reporting: Generate and analyze reports from SQL databases to support decision-making. Staying Up-to-Date: Keep abreast of emerging database technologies and best practices. Skills SQL Programming: Proficient in SQL syntax and database management systems (DBMS) like MySQL, Oracle, or Microsoft SQL Server. Data Modeling: Understanding of database design principles and data modeling techniques. SQL Query Optimization: Ability to write and optimize SQL queries for performance. Problem-Solving: Strong analytical and problem-solving skills to troubleshoot database issues. Communication: Ability to communicate effectively with other developers and stakeholders. Experience Proven Experience: In SQL development or related roles. Bachelor's Degree: In Computer Science, Information Technology, or a related field is often preferred. Relevant Work Experience: Experience in SQL development, database design, or database administration.

MongoDB Database Administrator (DBA) MongoDB - 70% | Postgresql - 30% Exp: 5 - 8 yrs Loc: Bangalore We are seeking an experienced MongoDB Database Administrator (DBA) to manage, maintain, and optimize our database infrastructure. The ideal candidate will have a strong background in MongoDB (70%) and PostgreSQL (30%) and will be responsible for ensuring high availability, performance, and security of databases in a production environment. Terraform : good to have Ansible, Jenkins, Groovy(infrastructure automation with DevOps knowledge) : required Coding basics(loop handling, exception handling etc.) : required Cloud basic knowledge : required Key Responsibilities: Manage and administer MongoDB and PostgreSQL databases with a focus on MongoDB. Handle production database environments , ensuring uptime and optimal performance. Perform backup, restore, replication, and disaster recovery operations. Conduct routine database maintenance, upgrades, and performance tuning. Monitor database performance and troubleshoot issues proactively. Implement and manage automation tools such as Jenkins, Ansible, and Terraform to streamline DBA tasks. Write and maintain shell scripts for automation and operational efficiency. Collaborate with development, DevOps, and infrastructure teams on database architecture and best practices. Required Skills & Qualifications: Proven experience as a MongoDB DBA in a production environment. Strong working knowledge of PostgreSQL database administration. Hands-on expertise in backup and recovery , replication , and disaster recovery planning . Proficient in database monitoring , troubleshooting , and performance tuning . Experience with automation tools such as Jenkins , Ansible , and Terraform (preferred). Solid experience in shell scripting (e.g., Bash, KornShell). Strong problem-solving skills and the ability to work independently and in a team environment.

PostgreSQL Database Administrator (DBA) PostgreSQL DBA - 70% | MongoDB DBA - 30% Exp: 5 - 8 yrs Location: Bangalore We are looking for a skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. The ideal candidate will have strong expertise in PostgreSQL (70%) along with working knowledge of MongoDB (30%) . This role involves managing mission-critical production databases, ensuring high availability, performance, and security, while also contributing to automation and scripting initiatives. Terraform : good to have Ansible, Jenkins, Groovy(infrastructure automation with DevOps knowledge) : required Coding basics(loop handling, exception handling etc.) : required Cloud basic knowledge : required Key Responsibilities: Administer, monitor, and maintain PostgreSQL and MongoDB databases, with a primary focus on PostgreSQL. Manage production environments , ensuring system reliability and uptime. Perform and manage database backup, restore, replication, and disaster recovery procedures. Handle database upgrades, patching, performance tuning, and capacity planning. Troubleshoot database-related issues, optimize queries, and monitor database health. Collaborate with engineering and DevOps teams for database provisioning and release management. Automate DBA tasks using tools like Jenkins, Ansible, and Terraform . Develop and maintain shell scripts for routine administrative tasks and automation. Required Skills & Qualifications: Proven hands-on experience as a PostgreSQL DBA in production environments. Good working knowledge of MongoDB administration. Proficient in backup/restore , replication strategies , and disaster recovery planning . Strong understanding of database performance tuning and troubleshooting . Experience with automation tools : Jenkins, Ansible, Terraform (preferred). Skilled in shell scripting (e.g., Bash, KornShell). Good understanding of Linux-based systems and database security best practices.

We are looking for an experienced Senior Data Engineer to lead the development of scalable AWS-native data lake pipelines with a strong focus on time series forecasting and upsert-ready architectures. This role requires end-to-end ownership of the data lifecycle, from ingestion to partitioning, versioning, and BI delivery. The ideal candidate must be highly proficient in AWS data services, PySpark, versioned storage formats like Apache Hudi/Iceberg, and must understand the nuances of data quality and observability in large-scale analytics systems. Role & responsibilities Design and implement data lake zoning (Raw Clean Modeled) using Amazon S3, AWS Glue, and Athena. Ingest structured and unstructured datasets including POS, USDA, Circana, and internal sales data. Build versioned and upsert-friendly ETL pipelines using Apache Hudi or Iceberg. Create forecast-ready datasets with lagged, rolling, and trend features for revenue and occupancy modelling. Optimize Athena datasets with partitioning, CTAS queries, and metadata tagging. Implement S3 lifecycle policies, intelligent file partitioning, and audit logging. Build reusable transformation logic using dbt-core or PySpark to support KPIs and time series outputs. Integrate robust data quality checks using custom logs, AWS CloudWatch, or other DQ tooling. Design and manage a forecast feature registry with metrics versioning and traceability. Collaborate with BI and business teams to finalize schema design and deliverables for dashboard consumption. Preferred candidate profile 9-12 years of experience in data engineering. Deep hands-on experience with AWS Glue, Athena, S3, Step Functions, and Glue Data Catalog. Strong command over PySpark, dbt-core, CTAS query optimization, and partition strategies. Working knowledge of Apache Hudi, Iceberg, or Delta Lake for versioned ingestion. Experience in S3 metadata tagging and scalable data lake design patterns. Expertise in feature engineering and forecasting dataset preparation (lags, trends, windows). Proficiency in Git-based workflows (Bitbucket), CI/CD, and deployment automation. Strong understanding of time series KPIs, such as revenue forecasts, occupancy trends, or demand volatility. Data observability best practices including field-level logging, anomaly alerts, and classification tagging. Experience with statistical forecasting frameworks such as Prophet, GluonTS, or related libraries. Familiarity with Superset or Streamlit for QA visualization and UAT reporting. Understanding of macroeconomic datasets (USDA, Circana) and third-party data ingestion. Independent, critical thinker with the ability to design for scale and evolving business logic. Strong communication and collaboration with BI, QA, and business stakeholders. High attention to detail in ensuring data accuracy, quality, and documentation. Comfortable interpreting business-level KPIs and transforming them into technical pipelines.

Do you want to design and build attractive digital products and services Do you aspire to play a key role in transforming our firm into an agile organization At UBS, the reimagination of our work processes, connections with colleagues, clients, and partners, and value delivery is ongoing. Embracing agility will enhance our responsiveness, adaptability, and innovation. As an individual in this role, your responsibilities will include: - Designing, developing, and enhancing digital products and technology services for clients and employees - Applying a wide range of software engineering practices, from user needs analysis to feature development, automated testing, and deployment - Ensuring quality, security, reliability, and compliance of solutions by implementing digital principles and meeting functional and non-functional requirements - Incorporating observability into solutions, monitoring production health, assisting in incident resolution, and addressing root cause of risks and issues - Understanding, representing, and advocating for client needs - Sharing knowledge and expertise with colleagues, participating in hiring processes, and contributing to engineering culture and internal communities regularly In the agile operating model at UBS, teams are aligned with larger products and services to meet client needs and consist of multiple autonomous pods. You will be a part of the Save, protect, and grow team in Pune, focusing on the Advisory Portfolio Management business area, which includes portfolio management, model management, trading, and reconciliation. This team, spread globally, manages a significant percentage of Assets Under Management (AUM) for UBS. Your expertise should include: - Strong understanding of rdbms concepts, pl/sql, data modeling, and data design - Hands-on experience in query optimization - Working knowledge of postgressql - Experience in ETL and ELT processing using tools like Azure Data Factory (ADF) - Good knowledge of Azure environment, containerization concepts, cloud-native development practices, Azure wizard, etc. - Solid grasp of DevOps and CI/CD concepts (GitLab, TeamCity, automated testing, pipelines, Ansible, Rex, Maven, IntelliJ, Sonar) - Resilient team player with strong interpersonal skills, driving initiatives independently - Experience in gitlab-facilitated software delivery UBS, the world's largest and only truly global wealth manager, operates through four business divisions: Global Wealth Management, Personal & Corporate Banking, Asset Management, and the Investment Bank. With a presence in major financial centers across more than 50 countries, our global reach and expertise differentiate us from competitors. As part of our hiring process, you may be requested to complete assessments. At UBS, flexible working arrangements such as part-time, job-sharing, and hybrid (office and home) options are available when feasible. Our purpose-led culture and global infrastructure enable us to collaborate and work agilely to meet business needs. Great work is achieved through collaborative efforts. Join #teamUBS and contribute to making an impact with us. UBS is an Equal Opportunity Employer that values and empowers individuals from diverse backgrounds, cultures, perspectives, skills, and experiences within our workforce.,

Join us as a Senior Full stack developer at Barclays, responsible for supporting the successful delivery of Location Strategy projects to plan, budget, agreed quality and governance standards. You'll spearhead the evolution of our digital landscape, driving innovation and excellence. You will harness cutting-edge technology to revolutionize our digital offerings, ensuring unparalleled customer experiences. To be successful as a Senior Full stack developer, you should have experience with Requirement Analysis, designing and developing highly scalable applications in Java and React, expertise in Spring Boot and REST API, containerization like Kubernetes and Docker, database design and development, and query optimization. Some other highly valued skills may include being a self-starter who is able to thoroughly technically investigate and manage/track/report issues on a timely basis, design and deliver high-quality .Net applications, experience in handling production releases, hands-on experience in React, experience in containerization platforms, and meeting sprint goals agreed upon in an Agile delivery model. You may be assessed on key critical skills relevant for success in the role, such as risk and controls, change and transformation, business acumen, strategic thinking, digital and technology, as well as job-specific technical skills. This role is based in Pune. Purpose of the role: To design, develop, and improve software utilizing various engineering methodologies that provide business, platform, and technology capabilities for our customers and colleagues. Accountabilities: - Development and delivery of high-quality software solutions using industry-aligned programming languages, frameworks, and tools. Ensuring that code is scalable, maintainable, and optimized for performance. - Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives. - Collaboration with peers, participation in code reviews, and promoting a culture of code quality and knowledge sharing. - Staying informed of industry technology trends and innovations and actively contributing to the organization's technology communities to foster a culture of technical excellence and growth. - Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions. - Implementation of effective unit testing practices to ensure proper code design, readability, and reliability. Assistant Vice President Expectations: To advise and influence decision-making, contribute to policy development, and take responsibility for operational effectiveness. Collaborate closely with other functions/business divisions. Lead a team performing complex tasks, using well-developed professional knowledge and skills to deliver work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraise performance relative to objectives, and determine reward outcomes. If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviors to create an environment for colleagues to thrive and deliver to a consistently excellent standard. All colleagues are expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence, and Stewardship our moral compass, helping us do what we believe is right. They are also expected to demonstrate the Barclays Mindset to Empower, Challenge, and Drive the operating manual for how we behave.,

Job Description: As a Database Administrator at our Tech-Support department, you will play a crucial role in setting up, configuring, administering, and maintaining various production and development environments. These environments may consist of both Relational databases such as SQL Server, PostgreSQL, MySQL, as well as NoSQL databases like MongoDB or others. You will be based at our Noida office and should have 1-2 years of relevant experience in this field. Your primary responsibility will be to collaborate closely with the tech team to design, build, and operate the database infrastructure. You will provide support to the tech team in identifying optimal solutions for data-related issues such as data modeling, reporting, and data retrieval. Additionally, you will work alongside deployment staff to address any challenges related to the database infrastructure effectively. Requirements: - Ideally, you should hold a BE/B.Tech degree from a reputed institute. - Proficiency in SQL Server/PostgreSQL database administration, maintenance, and tuning is essential. - Experience with database clustering, high availability, replication, backup, auto-recovery, and pooling, such as pgpool2, is required. - Strong familiarity with Logging and Monitoring tools like Nagios, Prometheus, PG-badger, POWA, Data-Dog, etc., is preferred. - Expertise in analyzing complex execution plans and optimizing queries is a must. - Good understanding of various database concepts including indices, views, partitioning, aggregation, window functions, and caching. - Up-to-date knowledge of the latest features in PostgreSQL versions 11/12 and above. - Experience working with AWS and its database-related services like RDS is a necessity. - Previous exposure to other databases like Oracle, MySQL will be advantageous. - Familiarity with NoSQL technologies is a plus. If you meet these requirements and are interested in this role, please share your updated profile with us at hr@techybex.com.,

As a Database Administrator, you will play a crucial role in building and maintaining database systems while ensuring data security. Join our team to contribute to the automation of material handling systems and be a part of a diverse and multidisciplinary culture at Addverb, the largest Robotics company in India. Benefit from working alongside intellectual minds in a collaborative and dynamic environment that offers international exposure and a flexible work setting focused on freedom and responsibility, paving the way for endless opportunities for growth and learning. In this role, you will collaborate with developers, system administrators, and end-users to manage and maintain databases independently. Proficiency in SQL Server and MySQL databases is essential for conducting project-related analyses. If you have a strong analytical mindset, a passion for data and technology, and thrive in a fast-paced environment, we invite you to apply for the position of Software Engineer - Database Administration in Noida. Responsibilities: - Design, install, configure, and maintain SQL Server and MySQL databases on Windows and Linux systems, including monitoring, tuning, and troubleshooting issues. - Ensure the seamless operation of the database systems. - Uphold data security and integrity by implementing access controls, backups, and recovery plans. - Execute disaster recovery plans and procedures to maintain database availability during system outages or dysfunction. - Review database performance, optimize queries, and write stored procedures in collaboration with engineering. - Support users and developers by resolving data-related technical issues and guiding them with best practices for query troubleshooting. - Perform regular database maintenance tasks such as defragmentation, backups, and replication. Key Skills, Qualifications, and Required Experience: - 3-4 years of relevant experience in MSSQL and MySQL database administration and optimization. - B.Tech in IT/Software or a related field.,

You will be responsible for installing, configuring, and maintaining MySQL databases to ensure smooth operations. Monitoring database performance, optimizing queries, and structures are essential tasks to enhance efficiency. Implementing backup and recovery strategies is crucial for data integrity. Managing user access and security permissions will be part of your routine duties. Regular database maintenance, updates, and patches are necessary for optimal functioning. Collaborating with developers to design and implement database solutions is key to successful database management. Documenting database configurations, processes, and procedures is imperative for maintaining accurate records. Staying updated on MySQL best practices and emerging technologies will be essential for continuous improvement. To qualify for this role, you should have a Bachelor's degree in Computer Science, Information Technology, or a related field, along with at least 5 years of experience as a MySQL DBA. Strong knowledge of MySQL performance tuning and optimization is required. Experience with database backup and recovery techniques is also essential. Familiarity with database security, user management, proficiency in SQL, and database design are crucial skills. Excellent analytical and problem-solving skills are necessary for troubleshooting database issues. Strong communication and teamwork abilities are important for effective collaboration with the team.,

• Administer and manage SQL Server databases in high-availability, clustered environments. • Implement and maintain robust backup, restore, and disaster recovery strategies.

Responsibilities: * 3+ Yrs of Exp in SQL Development * Design, develop & optimize complex SQL queries * Manage large databases with efficiency * Collaborate on performance tuning strategies * Ensure data accuracy through rigorous testing Health insurance Provident fund Accessible workspace Flexi working Cafeteria Work from home

We are looking for Lead Database Developer-Oracle to join our technology team at Clarivate. The Lead Database Developer will be responsible for overseeing the design, development, and maintenance of high-performance databases using Oracle and PostgreSQL. About You experience, education, skills and accomplishments Bachelors degree in computer science, Information Technology, or a related field, or equivalent experience At least 8 years of experience in Oracle database environments and PostgreSQL. At least 8 years of experience in database performance tuning, query optimization and capacity planning. At least 4 years of experience in cloud-based database services, such as AWS RDS Solid understanding of data security, backup, and recovery procedures. Strong understanding of relational database concepts including primary/foreign keys, many-to-many relationships, and complex joins operations. Experience in system analysis and design, problem-solving, support and troubleshooting. Experience with cloud database platforms (e.g., AWS RDS, Azure Cloud) is a plus. It would be great if you also had In-depth understanding of database architecture and data modelling principles Good knowledge of No-SQL database solutions, AWS and Azure Db solutions and services What will you be doing in this role? Database Design and Development: Collaborate with the development team to design and implement efficient database structures that meet the organization's requirements. Develop and maintain database schemas, tables, views, stored procedures, and functions. Database Performance Tuning: Monitor and analyze database performance, identifying and resolving bottlenecks or other performance issues. Optimize queries, indexes, data schemas, and database configurations to enhance system performance. Build a proactive service engagement, understanding the data base workloads and data model, to evaluate ASH and AWR and other diagnostic tools to ensure a continued stable and performant database. Data Security and Integrity: Working with DevOps, implement and maintain database security measures to protect sensitive data from unauthorized access or breaches. Data Integration and ETL: Develop and maintain data integration processes, including Extract, Transform, and Load (ETL) workflows. Collaborate with developers to ensure accurate and timely data extraction, transformation, and loading across various systems. Database Documentation and Reporting: Create and maintain comprehensive documentation for database environments, including data dictionaries, schemas, configurations, and standard operating procedures. Generate regular reports on database performance, capacity, and usage. Database Backup, Recovery, and Disaster Planning: Working in collaboration with DBA's and DevOps, develop and maintain database backup and recovery strategies to ensure data integrity and availability. Ensure regular backups, test data recovery processes, and create disaster recovery plans. Collaboration and Support: Work closely with cross-functional teams, including developers, system administrators, and business stakeholders, to understand their database requirements and provide technical support.

As an experienced individual with 6 years of relevant experience, you will be based in Jaipur. Your educational background should include a BE/B.Tech or MCA degree in IT/CS/EC.,

As a Database Administrator (DBA) at our organization based in Gurugram, Udyog Vihar Phase 4, your primary responsibility will be to manage, maintain, and enhance our database systems. You will play a key role in ensuring the integrity, performance, and security of our databases while developing efficient solutions to support our business operations. Collaboration with IT, development, and operations teams will be essential to ensure optimal functionality and support for our databases. Your responsibilities will include installing, configuring, and upgrading database systems such as MySQL, PostgreSQL, Oracle, SQL Server, or NoSQL databases. Monitoring performance, identifying bottlenecks, and implementing optimizations for efficiency will also be part of your day-to-day tasks. Data security, encryption, backups, and access control will be crucial aspects of your role to ensure compliance with security requirements. Additionally, you will be responsible for developing and managing backup and disaster recovery plans to maintain data integrity and continuity. Supporting data migration, import/export activities, and managing data integration with other platforms and applications will be essential. You will troubleshoot any database issues, including performance problems, connectivity issues, and data inconsistencies. Analyzing database growth and recommending scaling solutions for storage and performance will be part of your capacity planning responsibilities. Creating and maintaining database documentation, collaborating with other IT staff, and implementing database strategies will also be part of your role. To qualify for this position, you should have a Bachelor's degree in Computer Science, Information Technology, or a related field, along with proven experience as a Database Administrator (DBA) or in a similar role. Hands-on experience with various database management systems, a strong understanding of database structure, theories, principles, and practices, as well as proficiency in SQL and database programming languages are required. Strong problem-solving skills, attention to detail, familiarity with data management and governance practices, and knowledge of cloud-based database solutions (AWS, Azure, Google Cloud) would be advantageous. The ability to work both independently and collaboratively in a team environment is essential. Preferred skills for this role include experience with database automation and scripting, familiarity with DevOps and CI/CD practices, and knowledge of database performance tuning and query optimization. This position requires a total experience of 3-5 years with at least 5 years of relevant experience. Compensation will be as per industry standards, along with a competitive salary and benefits package. Additionally, you will have opportunities for professional growth and advancement, work in a dynamic and collaborative environment, health, dental, and vision insurance options, flexible working hours, and the potential for remote work.,

Position Overview BOLD seeks a DBA professional to provide support for various MS SQL databases. This person will perform database structure and software maintenance and implementations, support database tuning and consultation, and assist with database configuration implementation. The person will also participate in incident, change, and problem-management activities Company Overview BOLD is an established and fast-growing product company that transforms work lives. Since 2005, we've helped more than 10,000,000 folks from all over America (and beyond!) reach higher and do better. A career at BOLD promises great challenges, opportunities, culture and the environment. With our headquarters in Puerto Rico and offices in San Francisco and India, were a global organization on a path to change the career industry. Key Responsibilities Enhancing the scalability and performance of existing database architecture. Protecting data by developing data security and restoration policies, procedures, and controls. Conducting diagnostic tests and evaluating performance metrics. Developing procedures to ensure data integrity and quality. Performing database maintenance, migration, and upgrading hardware and software. Documenting processes and complying with best practices in database management. Required Skills Knowledge of Physical design of a database cluster, RAID/SAN and likewise. Strong understanding of SQL Server (IaaS and PaaS based on Azure) and on-premise SQL Server setup. Hands-on experience in Unix/Linux command line options. Experience on DB migrations, maintenance and optimization strategies Experience in implementing operational automation using PowerShell/Python automation. Knowledge of indexes, index management, and statistics. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. Ability to detect and troubleshoot SQL Server-related CPU, memory, I/O, disk space and other resource contention. Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking Experience with backups, restores and recovery models. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Azuer PAAS,MSSQL Server Capacity Planning (Backup Share, Disk, CPU, Memory etc.) Able to manage demanding stakeholders on technical solutions and align architect Additional Skills Experience in OLTP environment Basic understanding of MySQL or MongoDB to handle L1 issues

Company Overview: Protectt.ai is the Next Generation & fastest growing Indian Cyber Security organization with specialized product offering on mobile app & transaction security. Protectt.ai is Indias first & only mobile-app security platform covering more than 350 million Smartphones in India. Protectt.ai solutions are unparalleled by virtue of its unique platform solution & Innovation. In India, more than 20+ banks and top financial & govt organizations collaborates with Protectt.ai to secure their Mobile Apps. Protectt.ai has established a strong global presence with offices in India, the USA, and the Middle East. In India, its operations span three key locations: Mumbai (headquarters), Chennai (product innovation hub), and Gurgaon. We have also successfully secured Series A funding led by Bessemer Venture Partners (BVP), a globally renowned venture capital firm known for backing transformative technology companies. This funding marks a significant milestone in our growth journey, enabling us to further strengthen our cybersecurity solutions and expand our market presence. Awards and Recognition: Our innovations have earned multiple prestigious awards, including: Security Product Company of the Year 2023 by Data Security Council of India Cybersecurity Company of the Year 2023 by BWSECURITY Innovative Security Product of the Year 2023: by BWSECURITY Company Link: ( https://www.protectt.ai) Role: Postgres - Database Developer Experience: 5-7 Years Qualification: B. E/ B. Tech/ M.E/ MTech/ MCA Job Location: Chennai Key Responsibilities: We are looking for highly motivated and quick learning individual with great leadership skills and the capacity to efficiently utilize and contribute to your teams technical skills. The ability to understand requirements, provide solutions, and collaborate efficiently and amicably with your team and with clients. The ability to work with the design team to implement mobile strategies. The focus to adapt and respond to challenges as they come up. Excellent time management skills and dedication to achieving high quality work. 1. Design, implement, and optimize database schemas for performance and scalability. 2. Expertise in PostgreSQL, including partitioning, indexing, and stored procedures. 3. Optimize complex SQL queries for efficiency and performance. 4. Experience in segregating OLTP and OLAP to distribute the load. 5. Analytical and Reporting optimization and scaling. 6. Design and manage robust backup and recovery strategies. 7. Automate database operations, including backups and maintenance tasks. 8. Develop data reporting and analytics solutions with SQL and BI tools. 9. Constant awareness with the latest database trends and PostgreSQL features. 10. Knowledge of AWS Postgres RDS will be an added advantage.

C# .NET Developer - Princeton IT Services C# .NET Developer Posted 5 minutes ago Technology that works for you Job Title: C# .NET Developer Location: Gudivada, Andhra Pradesh (Onsite) Job Type: Full-Time Position Summary: We are looking for an experienced C# .NET Developer to join our team in Gudivada, Andhra Pradesh . The ideal candidate will have strong skills in Microsoft .NET technologies , MS SQL Server (including performance tuning) , and reporting/integration tools like SSIS and SSRS . This is a full-time, onsite position. Key Responsibilities: Design, develop, and maintain applications using C# .NET , ASP.NET, and related technologies Develop and optimize stored procedures, views, and queries using MS SQL Server Perform database performance tuning and query optimization Design, develop, and manage SSIS packages for ETL processes Create and manage SSRS reports based on business requirements Collaborate with QA, business analysts, and other developers to deliver high-quality solutions Maintain technical documentation and adhere to coding standards Required Skills & Experience: 4 7 years of experience in C# .NET application development Strong knowledge of MS SQL Server , including performance tuning and query optimization Hands-on experience with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services) Experience in building and consuming RESTful APIs Solid understanding of object-oriented programming (OOP) and software development best practices Good problem-solving and debugging skills Ability to work independently in an onsite environment Preferred Qualifications: Bachelor s degree in Computer Science, Information Technology, or a related field Familiarity with version control systems like Git

Greetings from Aspire Systems!! Currently Hiring for the below Skillset. Job Title : Senior Oracle SQL & PL/SQL Developer Experience : 5 to 8 Years Location : Chennai/ Bangalore/ Kochi Notice : Immediate to 20 days Share CV to safoora.imthiyas@aspiresys.com JD: 5 8 years of hands-on experience in Oracle SQL and PL/SQL development. Strong understanding of relational database concepts and performance tuning. Experience with job scheduling tools. Familiarity with SQL*Loader and data integration tools. Exposure to enterprise environments in domains (Insurance is preferred) Excellent problem-solving and communication skills. Experience working in Agile/Scrum environments. Knowledge of Azure DevOps and Mainframe Knowledge of version control systems (e.g., Git) and CI/CD pipelines. Strong analytical and critical thinking abilities. Effective communication and collaboration with global teams. Adaptability and eagerness to learn new technologies.

Responsibilities Participating in the development of OnCall Analytics Solutions using safe-agile methodologies. Design and implementation of ETL changes as per the customer needs. Supporting the Design and Implementation of functionalities in OnCall Analytics Portal, Configuration Manager and Link Analysis web applications. Design and implementation of continuous integration and deployment Deliver the features (user stories) with utmost quality. Creating cloud offerings of the BI products. Provide ad-hoc analytics support and activities in a collaborative work environment. Should be able to deliver code supporting different versions of MSSQL and environment. Building & deploying custom components on ETL supporting different version. Education / Qualifications B.E, B.Tech, M.Tech (CSE) Advanced analytical and technical skills; MSSQL, SSIS mandatory Extensive hands-on experience on building ETL from scratch. Having knowledge on SSAS and PowerBi additional Query optimization techniques, Performance oriented design planning. Structuring of DataWarehouse efficiently Knowledgeable in Cloud, preferably Azure. Familiarity with build and CI tools. Strong communication skills Understand Cloud Concepts.

Job Role: Senior MS SQL Developer Location: Hyderabad Desired Experience: 2-4 years of experience as an MS SQL Developer or in a similar role Education: Bachelors degree in Computer Science, Information Technology, or a related field. Role Overview We are seeking a highly skilled and experienced Senior MS SQL Developer to join our dynamic team. The ideal candidate will have 2-4 years of relevant experience, with a strong background in database development and management. Prior experience in a SaaS environment is an added advantage. The candidate should possess in-depth knowledge of MS SQL Server and MySQL, including expertise in procedures, functions, triggers, DB backup & restore, temporary tables, and indexes. Key Responsibilities Design, develop, and maintain complex database systems using MS SQL Server and MySQL Write and optimize SQL queries, stored procedures, functions, and triggers to support application development and reporting needs Perform database backup, restore, and recovery operations to ensure data integrity and availability Manage database security by developing and implementing access control mechanisms and ensuring data privacy Optimize and tune database performance, including indexing, query optimization, and troubleshooting slow-running queries Develop and implement database change management and version control processes Collaborate with development teams to design and implement database solutions that support application functionality and performance requirements Conduct database testing and validation to ensure data accuracy and consistency Monitor database systems for performance, reliability, and security issues, and take corrective actions as necessary Provide guidance and mentorship to junior database developers and other team members Key Skills Proficiency in MS SQL Server and MySQL Strong knowledge of SQL programming, including stored procedures, functions, and triggers Experience with database backup, restore, and recovery processes. Expertise in designing and managing indexes and temporary tables Proficient in database performance tuning and optimization techniques Solid understanding of database security and access control mechanisms Familiarity with database change management and version control practices Excellent problem-solving skills and attention to detail Strong communication and collaboration skills Ability to work independently and as part of a team in a fast-paced environment Qualifications Bachelors degree in Computer Science, Information Technology, or a related field. 2-4 years of experience as an MS SQL Developer or in a similar role Experience working in a SaaS product-based environment is an added advantage Certification in MS SQL Server or related technologies is a plus Benefits Competitive salary and performance-based bonuses Comprehensive health insurance plans and accidental coverage Opportunities for professional development and career growth A collaborative and inclusive work environment

Join us as a Senior Full stack developer Tax 1 at Barclays, responsible for supporting the successful delivery of Location Strategy projects to plan, budget, agreed quality and governance standards. Youll spearhead the evolution of our digital landscape, driving innovation and excellence. You will harness cutting-edge technology to revolutionise our digital offerings, ensuring unparalleled customer experiences. To be successful as a Senior Full stack developer Tax 2 you should have experience with Requirement Analysis. Design and develop highly scalable applications in Java, React Expertise in Spring boot and REST API Containerization like Kubernetes, Docker Database design and development, query optimization Some other highly valued skills may include: Self starter - able to thoroughly technically investigate & manage / track / report issues on a timely basis, escalating where required Design and deliver high quality . Net application. Experience in handling production release. Hands on experience in React Experience in containerization platforms The role should meet sprint goals agreed in an Agile delivery model You may be assessed on the key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen strategic thinking and digital and technology, as well as job-specific technical skills. This role is based in Pune. Purpose of the role To design, develop and improve software, utilising various engineering methodologies, that provides business, platform, and technology capabilities for our customers and colleagues. Accountabilities Development and delivery of high-quality software solutions by using industry aligned programming languages, frameworks, and tools. Ensuring that code is scalable, maintainable, and optimized for performance. Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives. Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing. Stay informed of industry technology trends and innovations and actively contribute to the organization s technology communities to foster a culture of technical excellence and growth. Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions. Implementation of effective unit testing practices to ensure proper code design, readability, and reliability. Assistant Vice President Expectations To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions. Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L Listen and be authentic, E Energise and inspire, A Align across the enterprise, D Develop others. OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes. Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues. Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda. Take ownership for managing risk and strengthening controls in relation to the work done. Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function. Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy. Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc). to solve problems creatively and effectively. Communicate complex information. Complex information could include sensitive information or information that is difficult to communicate because of its content or its audience. Influence or convince stakeholders to achieve outcomes. All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset to Empower, Challenge and Drive the operating manual for how we behave.

We are seeking a multi-skilled Senior Database Administrator (DBA) to join our team. The ideal candidate will have expertise in SQL Server database management systems, along with a strong understanding of database architecture, design, and optimization principles. Responsibilities: Install, configure, and maintain SQL Server database software Monitor database performance and tune databases for optimal efficiency Develop and implement backup and recovery strategies to ensure data integrity and availability Perform regular database maintenance tasks, such as database reorganisations, index rebuilds and disaster recovery testing Troubleshoot database-related issues and provide timely resolution Collaborate with developers to optimise database queries and improve application performance Implement database security best practices to safeguard sensitive data Create and maintain documentation related to database configurations, procedures, and standards Stay up to date with the latest database technologies and trends As a senior work with the TTL (Technology Team Leader) to manage the teams workload and act as a stand-in during any absences of the TTL Key Skills Required: Experience with SQL Server database technologies with a range of versions Database installation & configuration experience Significant experience using database backup tools and methodologies Configuration of database replication technologies, such as SQL Server Replication Experience working on performance tuning Clustering techniques such as SQL Server Clustering Experience of patching and upgrading Managing workloads within the Jira product Experience working with Microsoft via their support processes AWS Cloud would be a bonus Qualifications: hands-on experience of database administration Some proven experience of managing and mentoring other database administrators is a significant advantage Proven experience as a Database Administrator, preferably with SQL Server Strong understanding of database management concepts, including normalization, indexing, and transaction management Proficiency in SQL scripting and query optimisation Experience with database performance monitoring and tuning tools Familiarity with database security principles and techniques Excellent problem-solving and troubleshooting skills Ability to work collaboratively in a team environment Strong communication and interpersonal skills Relevant certifications (e.g., Microsoft Certifications, AWS Certifications) are a plus but not essential Experience of managing databases within a cloud environment such as AWS is a plus but not essential

IA-Consultant-Data Engineer SSIS ADF : Elevate Your Impact Through Innovation and Learning Evalueserve is a global leader in deliveringinnovative and sustainable solutions to a diverse range of clients, includingover 30% of Fortune 500 companies. With a presence in more than 45 countriesacross five continents, we excel in leveraging state-of-the-art technology, artificial intelligence, and unparalleled subject matter expertise to elevateour clients' business impact and strategic decision-making. Our team of over4, 500 talented professionals operates in countries such as India, China, Chile, Romania, the US, and Canada. Our global network also extends to emergingmarkets like Colombia, the Middle East, and the rest of Asia-Pacific.Recognized by Great Place to Work in India, Chile, Romania, the US, andthe UK in 2022, we offer a dynamic, growth-oriented, and meritocracy-basedculture that prioritizes continuous learning and skill development, work-lifebalance, and equal opportunity for all. About Insights & Advisory We are a global professional services provider offering research, analytics, and business process support services enabled by our innovative 'mind + machine' approach. We are working with over 300+ Fortune 1000 companies. Our TMT team, cater to 4 of the top 5 global Telecom & Networking Infrastructure companies as well as biggest public cloud providers. About this role We are looking for a skilled and motivated Data Engineer/Analyst with 45 years of experience in data engineering, particularly in migrating on-premises systems to cloud-based environments. This role requires strong expertise in SQL Server, SSIS, Azure Data Factory (ADF), Power BI and Microsoft Fabric. The ideal candidate will have hands-on experience designing, developing, and deploying scalable data solutions in Azure, ensuring seamless data integration and high performance. What you will be doing at Evalueserve Lead and execute the migration of on-premises SQL Server databases to Azure SQL. Migrate and modernize legacy SSIS packages from the file system to Azure Data Factory pipelines. Manage end-to-end Microsoft Fabric migration projects, including planning, execution, and post-migration validation. Design and develop stored procedures, SSIS packages, and ADF pipelines to support business data needs. Collaborate with cross-functional teams to understand requirements and deliver scalable, production-ready data solutions. Ensure data quality, workflow optimization, and performance tuning across all stages of data processing What we are looking for 45 years of hands-on experience in data engineering. Proven expertise in SQL Server (on-premises and Azure SQL). Strong experience in SSIS package development and migration. Proficiency in Azure Data Factory (ADF) and cloud-based data integration. Experience with Microsoft Fabric migration and implementation. Proficient with Power BI and Symantec Data Models, measure and views. Solid knowledge of T-SQL, stored procedures, and query optimization. Preferred Qualifications Relevant Microsoft certifications (e.g., Azure Data Engineer Associate) are a plus. Experience with DevOps practices for data pipelines. Strong communication and collaboration skills. Follow us on https://www.linkedin.com/compan y/evalueserve/ Click here to learn more about what our Leaders talking on achievements AI-poweredsupply chain optimization solution built on Google Cloud. HowEvalueserve isnow Leveraging NVIDIA NIM to enhance our AI and digital transformationsolutions and to accelerate AI Capabilities . Know more about how Evalueservehas climbed 16 places on the 50 Best Firms for Data Scientists in 2024! Want to learn more about our culture and what its like to work with us? Write to us at: careers@evalueserve.com Disclaimer: Thefollowing job description serves as an informative reference for the tasks youmay be required to perform. However, it does not constitute an integralcomponent of your employment agreement and is subject to periodic modificationsto align with evolving circumstances. Please Note :We appreciate the accuracy and authenticity of the information you provide, asit plays a key role in your candidacy. As part of the Background Verification Process, we verify your employment, education, and personal details. Please ensure allinformation is factual and submitted on time. For any assistance, your TA SPOCis available to support you .

We are looking for a talented and experienced Distributed Database (DDB) Programmer, Design Architect or Specialist who is skilled in programming, designing and managing large-scale, distributed database systems that offer scalability to add more servers as needed. This role requires hands-on experience in optimizing database structures for efficient processing of large datasets, advanced query optimization techniques. Main Skills Required: Distributed Database (DDB): Expert knowledge in managing and designing Distributed Databases. Other Skills: SQL: Strong proficiency in SQL for database management and query optimization. Database Technologies: Knowledge of KDB+, ClickHouse, TimeScaleDB, InfluxDB, MS SQL Server, PostgreSQL with Citus etc. Programming Languages: Knowledge of C#/C++. Professional Experience: Proven experience in designing and managing large-scale distributed databases. Strong programming skill. Key Responsibilities: Design and Implement Large-Scale Data: Architect and manage distributed database systems to handle large-scale data. Develop strategies for data distribution and replication to ensure high availability and reliability. Develop and Optimize Complex Queries: Create and refine complex queries for efficient data retrieval and manipulation. Implement query optimization techniques to enhance performance. Database Structure Optimization: Optimize database structures to improve processing speed and storage efficiency. Continuously monitor and tune database performance. Manage Team: Lead and manage a team of database administrators and developers. Provide guidance, mentorship, and support to team members to ensure successful project execution. C/C++ Application: Build high-performance data processing applications in C/C++. Develop efficient algorithms and data structures to handle large-scale data processing tasks. Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand their data requirements. Deliver appropriate data solutions to meet business needs. Troubleshooting and Issue Resolution: Identify and resolve issues related to large-scale data processing. Ensure the integrity and security of the database systems.

We are seeking a PostgreSQL Database Developer with a minimum of 4 years of experience in database management. The ideal candidate should be passionate about technology, dedicated to continuous learning, and committed to providing exceptional customer experiences through client interactions. Qualifications: - Must have a degree in BE/B.Tech/MCA/MS-IT/CS/B.Sc/BCA or related fields. - Expertise and hands-on experience in PostgreSQL, PLSQL, Oracle, query optimization, performance tuning, and GCP Cloud. Job Description: The responsibilities of the PostgreSQL Database Developer include: - Proficient in PL/SQL and PostgreSQL programming, with the ability to write complex SQL queries and stored procedures. - Experience in migrating database structure and data from Oracle to Postgres SQL, preferably on GCP Alloy DB or Cloud SQL. - Familiarity with Cloud SQL/Alloy DB and tuning them for better performance. - Working knowledge of Big Query, Fire Store, Memory Store, Spanner, and bare metal setup for PostgreSQL. - Expertise in tuning Alloy DB/Cloud SQL database for optimal performance. - Experience with GCP Data migration service, MongoDB, Cloud Dataflow, Disaster Recovery, job scheduling, logging techniques, and OLTP/OLAP. - Desirable: GCP Database Engineer Certification. Roles & Responsibilities: - Develop, test, and maintain data architectures. - Migrate Enterprise Oracle database from On-Prem to GCP cloud, focusing on autovacuum in PostgreSQL. - Tuning autovacuum in PostgreSQL. - Performance tuning of PostgreSQL stored procedures and queries. - Convert Oracle stored procedures and queries to PostgreSQL equivalents. - Create a hybrid data store with Datawarehouse, NoSQL GCP solutions, and PostgreSQL. - Migrate Oracle table data to Alloy DB. - Lead the database team. Mandatory Skills: PostgreSQL, PLSQL, Bigquery, GCP Cloud, tuning, and optimization. To apply, please share your resume at sonali.mangore@impetus.com with details of your current CTC, expected CTC, notice period, and Last Working Day (LWD).,