8 Db Optimization Jobs

About The Role Project Role : Application Support Engineer Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems. Must have skills : MySQL Database Administration Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Support Engineer, you will act as software detectives, providing a dynamic service that identifies and resolves issues within various components of critical business systems. Your typical day will involve collaborating with team members to troubleshoot problems, analyzing system performance, and ensuring the smooth operation of applications that are vital to business functions. You will engage with stakeholders to understand their needs and provide timely solutions, contributing to the overall efficiency and effectiveness of the organization.Management Level:10Work Experience :5-7 yearsWork location:NoidaMust Have Skills: MySQL Database Administration, Azure Database for MySQL Flexible Server, RDS MySQL, MySQL on Azure, AWS Aurora and MySQL Cluster management.Good To Have Skills: Upgradation, Migrations, expertise in Performance tuning, MySQL/AWS Aurora and PostgreSQL Database Administration Roles & Responsibilities:MySQL/Azure Database for MySQL Flexible Server/AWS RDS MySQLDevelop, design, and maintain highly available and scalable databases.Resolve production database issues including database tuning, optimization, and database recovery.Perform MySQL installation, upgrades, data migration across homogeneous and heterogeneous multiple database server architectures/systems.Monitor the performance of production databases, identify areas where performance needs to be improved and provide fixes/solutions for the performance issues.Develop database tools to automate existing database tasks.Respond appropriately to emergency technical support situations and produce quick and effective solutions to database technical problems under high pressure.Work with database personnel to design physical and logical databases to support present / future business applications.Participate in an on-call rotation and other duties as defined by management. Must be able to work 24/7 rotational shifts.Managing Client requests independently.Performing database failover and switchover activities in Azure Database for MySQL Flexible Server, ensuring high availability and business continuity best practices are followed.Hands-on experience with Azure Database for MySQL features such as Flexible Server HA, zone-redundant deployments, scaling, and maintenance window configurations, along with a solid understanding of cloud-based high availability concepts.Zeal to perform under strict deadlines and continuously learn new tools/technologies, especially in Azure ecosystem.Troubleshooting database & performance issues, optimizing queries, and tuning configurations at the database level to enhance overall system responsiveness.Monitoring and analyzing Azure monitoring logs and alerts (Azure Monitor, Log Analytics, Metrics, Alerts), addressing issues proactively to ensure uninterrupted service.Good exposure to backup and recovery methods in Azure Database for MySQL, including point-in-time restore (PITR) and cross-region backups.Exposure to community-based tools and utilities for MySQL performance monitoring, schema comparison, and automation.Supporting database migrations (on-prem Azure or cross-region), version upgrades, and patching activities, ensuring seamless transitions with minimal downtime. Professional & Technical Skills: Experience in working with managed databases on the cloud like Azure Database for MySQL Flexible Server, MySQL on Azure VMs (IaaS), RDS MySQL and Aurora.Experience in incremental backup and schedule backup.Experience with MySQL and Managing Azure MySQL Cluster.Expertise in snapshot, import/export, and DB optimization with the help of explained plans.Expertise in database migration from MyISAM format to Inno dB storage engine to increase performance and betterment of integrity constraints.Experience in performance tuning, Master/Master and Master/Slave Replication.Experience in database backup and restore.Experienced in upgrading MySQL/MariaDB server using in-place upgrade method for minor releases and logical upgrade method for major releases followed by MySQL/MariaDB Upgrade utility.Strong technical knowledge in Azure PaaS MySQL, AWS RDS, Aurora MySQL. Professional Attributes:1.Good communication skills and ability to articulate technical issues/requirements accurately and succinctly in a manner that business users can understand.2.Good presentation skills.3.Ability to multi-task and participate in large, complex, and concurrent projects.4.Good to have Azure Administrator/ AWS Database specialty certified Additional Information:- The candidate should have minimum 3 years of experience in MySQL Database Administration.- This position is based at our Noida office.- A 15 years full time education is required. Qualification 15 years full time education

As a Java Full Stack Development Lead at the Assistant Vice President level, you will be responsible for participating in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. Your primary objective in this role will be to contribute to applications systems analysis and programming activities. Your key responsibilities will include: - Conducting tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establishing and implementing new or revised applications systems and programs to meet specific business needs or user areas. - Monitoring and controlling all phases of the development process including analysis, design, construction, testing, and implementation, while also providing user and operational support on applications to business users. - Utilizing in-depth specialty knowledge of applications development to analyze complex problems/issues, evaluate business process, system process, and industry standards, and make evaluative judgments. - Recommending and developing security measures in post-implementation analysis of business usage to ensure successful system design and functionality. - Consulting with users/clients and other technology groups on issues, recommending advanced programming solutions, and installing and assisting customer exposure systems. - Ensuring essential procedures are followed and helping define operating standards and processes. - Serving as an advisor or coach to new or lower-level analysts. - Operating with a limited level of direct supervision, exercising independence of judgment and autonomy. - Acting as a Subject Matter Expert (SME) to senior stakeholders and/or other team members. - Appropriately assessing risk when making business decisions, with a focus on the firm's reputation and compliance with applicable laws, rules, and regulations. Qualifications required for this role include: - 8+ years of hands-on application development experience, along with 3+ years of Technical Lead experience. - Experience with Java 17 or higher, PL/SQL (Oracle 19c), Spring Boot 3.0, Hibernate/JPA, Microservice, and distributed applications. - Knowledge of Angular 14+, JavaScript, and DB Design and Optimization. - Familiarity with technologies such as Kafka, Docker, Kubernetes. - Financial Services experience. - Design skills for new development. - Experience in leading the development of full-stack software solutions involving front end, middleware, and backend. - Experience in working on agile projects, with knowledge in DevOps practices and CI/CD pipelines. - Good verbal communication skills. - Proactive working attitude, quick learning ability, strong ownership and responsibility, good communication skills, and team spirit. Education requirement: - Bachelors degree/University degree or equivalent experience Please note that this job description provides a high-level overview of the work performed. Other job-related duties may be assigned as required.,

The Applications Development Intermediate Programmer Analyst position is an intermediate level role where you will be responsible for contributing to the establishment and implementation of new or updated application systems and programs in collaboration with the Technology team. Your main objective will be to assist in applications systems analysis and programming activities. You will utilize your knowledge of applications development procedures and concepts, along with basic understanding of technical areas, to identify and define necessary system enhancements. This includes using script tools, analyzing code, and consulting with users, clients, and other technology groups to recommend programming solutions. You will also be involved in installing and supporting customer exposure systems and applying fundamental knowledge of programming languages for design specifications. As an Applications Development Intermediate Programmer Analyst, you will analyze applications to identify vulnerabilities and security issues, conduct testing and debugging, and serve as an advisor to new or lower level analysts. You will be responsible for identifying problems, analyzing information, and making evaluative judgements to recommend and implement solutions. Additionally, you will resolve issues by applying acquired technical experience and exercising autonomy and judgement. In this role, you will act as a subject matter expert to senior stakeholders and team members, assess risk in business decisions, and ensure compliance with laws and regulations. Your responsibilities will also include driving compliance with policies, demonstrating ethical judgment, and managing control issues with transparency. The ideal candidate for this role should have at least 5 years of hands-on application development experience and 3+ years of Technical Lead experience. Proficiency in Java 17 or higher, PL/SQL (Oracle 19c), Spring Boot 3.0, Hibernate/JPA, Microservice, and distributed application is required. Experience with Angular 14+, JavaScript, DB Design and Optimization, Kafka, Docker, and Kubernetes is a plus. Financial Services experience is also necessary. Candidates should possess design skills and be experienced in leading the development of full stack software solutions involving front end, middleware, and backend. Experience in agile projects, DevOps practices, and CI/CD pipelines is preferred. Strong verbal communication skills, proactive working attitude, quick learning ability, ownership and responsibility, and good team spirit are desirable qualities. A Bachelors degree or equivalent experience is required for this role. This job description offers a high-level overview of the responsibilities. Additional job-related duties may be assigned as needed.,

The Applications Development Intermediate Programmer Analyst position is an intermediate level role where you will participate in establishing and implementing new or revised application systems and programs in coordination with the Technology team. Your main objective will be to contribute to applications systems analysis and programming activities. You will be responsible for utilizing your knowledge of applications development procedures and concepts, as well as basic knowledge of other technical areas, to identify and define necessary system enhancements. This includes using script tools, analyzing/interpreting code, consulting with users, clients, and other technology groups on issues, recommending programming solutions, installing and supporting customer exposure systems. Additionally, you will apply fundamental knowledge of programming languages for design specifications, analyze applications for vulnerabilities and security issues, conduct testing and debugging, and serve as an advisor or coach to new or lower level analysts. In this role, you will identify problems, analyze information, and make evaluative judgments to recommend and implement solutions. You will resolve issues by identifying and selecting solutions based on acquired technical experience and guided by precedents. The position requires the ability to operate with a limited level of direct supervision, exercise independence of judgment and autonomy, act as a Subject Matter Expert to senior stakeholders and/or other team members. You will need to appropriately assess risk when making business decisions, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients, and assets. This includes driving compliance with applicable laws, rules, and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct, and business practices, as well as escalating, managing, and reporting control issues with transparency. Qualifications: - 5+ years of hands-on application development experience, with 3+ years of Technical Lead experience - Experience with Java 17 or above, PL/SQL (Oracle 19c), Spring Boot 3.0, Hibernate/JPA, Microservice, and distributed application - Angular 14+, JavaScript, and DB Design and Optimization are a plus - Familiarity with technologies such as Kafka, Docker, Kubernetes - Financial Services experience required - Design skills are necessary for this role - Experience in leading the development of full stack software solutions - Proficiency in working in agile projects, knowledge of DevOps practices, and CI/CD pipelines - Good verbal communication skills - Proactive working attitude, quick learning ability, strong ownership and responsibility, good communication skills, and team spirit Education: - Bachelor's degree/University degree or equivalent experience This job description provides a high-level overview of the work performed. Other job-related duties may be assigned as required.,

The client, a large IT service company, is seeking a candidate for the position of Pega CDH Developer in Pune/Bangalore. This role requires 6 to 8 years of experience with a salary of up to 22 LPA and joining within 15 days. The primary skills needed include Pega PRPC Version 8.x/7.x Development and integration. In this role, you will be responsible for developing Pega decisioning constructs to implement new marketing campaigns, real-time decisioning modules, and providing post-implementation support. Key competencies and requirements include 6+ years of experience in Pega Decisioning and marketing, PEGA certifications, solid experience in PEGA Customer Decision Hub in the Telecom industry, knowledge of integration protocols, Oracle, Cassandra, SQL, Java, JSP, J2EE, XML, EJB, and the ability to troubleshoot and resolve complex production issues. Your key responsibilities will involve the development of new/existing strategies, upgrades, and technical improvements, L3 support as per agreed SLAs, preparing packages and installations, finding technical improvements and applying best practices, improving the technical performance of the application, aligning internally on solutions, optimizing DB queries, making strategies and campaigns configurable, estimating effort for stories and tasks, and participating in team ceremonies and meetings.,

We're hiring a skilled Web Developer with AWS expertise to build and manage dynamic websites. Must have strong experience in AWS services, MySQL/PostgreSQL optimization, Git-based workflows, and full-stack development with high security standards!

Roles & Responsibilities: PHP Laravel Developer (Mid-Level) Proficient in LARAVEL with VueJS programming language with OOPS is a must. Knowledge of development technologies including PHP, JavaScript, HTML, jQuery, SQL, Bootstrap, and CSS (Media Queries). MERN Stack Knowlede will be added advantage. Understanding and Experience on XPath and XML / XSLT based development experience. Active experience integrating custom code with 3rd party web services. Basic Website caching and database optimisation skills. knowledge and experience of building, maintaining, and upgrading WordPress CMS websites independently will be an additional advantage. Knowledge of existing inbuilt WordPress basics and functions. NextJS will be an added advantage if prfessional experices is there. Creation of custom post types, taxonomies, short codes, Creation of plugins/widgets written to confirm with the WordPress coding standards. Git/Repository experience is must Formulating a website design that is responsive and error-free Creation of clean, logical, well-documented and re-usable code Theme/Template integration Basic of Data Structures like Trees, Sorting and Searching Technique Working & Practical experience of Design Patterns and its usages. Solid understanding of stateful & stateless widgets Enthusiastic & motivated to learn and grow Git version control knowledge & experience is a must Knowledge in API integration Required to have Fluent English language skills Preferred candidate profile We are looking for a passionate, creative, and efficient problem solver. Must be dedicated, passionate, and hard-working. Attitude is everything. Excellent verbal communication skills. Must be able to work with a team and collaborate remotely. Proactive, Honest, Trustworthy, Hard workers and self-starters. Eager to learn and grow.

Greetings From Proconnect!!! Hands-on experience as SQL DBA. Install, configure and maintain SQL Server databases Monitor performance and tune SQL queries and indexes Manage backups, restores and disaster recovery planning Grant and manage user permissions securely Schedule and monitor jobs using SQL Server Agent