8 Mysql Optimization Jobs

As an Individual Contributor at Adobe, you will be part of the Field Engineering, Ultimate Success team, where you will play a crucial role as a technical advisor for Cloud and Magento application tools, optimizations, and solutions. Your main responsibility will be to provide ongoing technical consultation to clients, partners, external developers, and internal teams to ensure successful site launches and ongoing site stability for Magento Cloud customers. Your key responsibilities will include acting as the lead point of contact for customer engagements, building trusted advisor relationships with clients and implementation partners, educating Adobe customers & partners on product features and best practices, defining operational processes for delivering value to merchants and partners, troubleshooting technical issues reported by customers, and providing recommendations for improvements and optimizations based on analytics. Additionally, you will collaborate with project peers, technical experts, project managers, and clients to enable team members with new product features and support, participate in the Adobe technical community to share best practices, and create standardized templates for timely and quality delivery. To succeed in this role, you should have extensive experience in PHP, JavaScript, and scripting languages, in-depth knowledge of Cloud concepts and services, solid foundation in DBMS, experience with version control systems, DevOps, MySQL optimization, web services, Linux/UNIX systems, web servers, requirements discovery, UML analysis, CDN's, network services, caching systems, and large-scale server applications. Communication, presentation, conflict resolution, organizational, and problem-solving skills are essential, along with the ability to work effectively with technical and non-technical audiences, maintain attention to detail, multitask, learn quickly, and excel in a team environment. A degree in Computer Science or Engineering is preferred, and proficiency in English is required. Self-motivation, proactivity, dedication to customer success, innovation, and adaptability to change are key qualities for this role. You will have the opportunity for career growth and continuous learning within Adobe, where creativity and curiosity are celebrated. If you are looking to make a significant impact and be part of a globally recognized work environment, Adobe is the place for you. Join us in creating innovative solutions and engaging experiences that shape the future of digital content.,

You will be joining a mission-driven team at Adobe, where we are dedicated to revolutionizing the digital world by empowering individuals and businesses to create exceptional digital experiences. As a Technical Advisor within the Field Engineering, Ultimate Success team, you will play a crucial client-facing role in providing ongoing technical consultation on Cloud and Magento application tools, optimizations, and solutions. Your responsibilities will include serving as the primary point of contact for customer engagements, building strong relationships with clients and implementation partners, and ensuring successful site launches and ongoing stability for Magento Cloud customers. You will be expected to stay updated on technological advancements, research new solutions, and continuously enhance your skills to provide valuable insights to customers and partners. In addition to technical consultation, you will be responsible for defining operational processes, assisting in DevOps procedures, evaluating analytics for optimization, troubleshooting technical issues, and communicating effectively with stakeholders at all levels. Your role will involve collaborating with internal teams, project peers, and external partners to deliver high-quality solutions within project timelines. To excel in this role, you should have extensive experience in PHP, JavaScript, architecture design patterns, and application lifecycles. Proficiency in Cloud concepts, DBMS, version control systems, web services, Linux/UNIX systems, and Magento-related technologies is essential. Strong communication, organizational, and problem-solving skills are key attributes for success in this position. If you are a proactive, self-motivated individual with a passion for customer success and a drive for innovation, we encourage you to apply. A degree in Computer Science or Engineering is preferred, and fluency in English is required. Join us at Adobe, where we value diversity, equal opportunity, and a collaborative work environment dedicated to making a positive impact in the digital realm.,

You are invited to join our team as a PHP Developer in Chennai. We are seeking individuals who are highly skilled and self-motivated, with a minimum of 3-5 years of experience in PHP development, specifically on the Yii 2.0 platform and PHP MVC framework. In this role, you will be responsible for creating and implementing a diverse range of new web applications, as well as maintaining and enhancing existing applications. As a PHP Developer, your main responsibilities will include developing applications using PHP (Yii framework), JavaScript, MySQL, and HTML. You will collaborate with team members and work independently to build complex web-based applications. Additionally, you will be tasked with maintaining existing codebases by troubleshooting bugs and adding new features. It is essential that you have a deep understanding of our customers" business goals and the interactions within the system. You will work closely with others to define project plans, deliverables, expectations, scheduling, and application functionality. The ideal candidate should be capable of gathering business user requirements and managing projects independently. While being a team player, you should also be able to contribute individually and mentor junior team members effectively. The required skills for this position include proficiency in PHP, JavaScript, MySQL, HTML, LAMP development/coding, MVC Framework (Yii), JavaScript Frameworks (JQuery, Dojo, Ext JS, or Yui), and version control systems (SVN, CVS, GIT, or Mercurial). Knowledge of the LAMP architecture, Laravel framework exposure, efficient MySQL query writing and optimization, Linux systems understanding, Object-Oriented PHP, Test-Driven Development, database architecture, and implementation skills are essential. Furthermore, you should possess strong programming logic, maintain good code-writing style, and ensure proper commenting practices. A comprehensive understanding of HTML is also required for this role. If you are passionate about PHP development and possess the necessary skills and experience, we encourage you to apply for this exciting opportunity.,

IT Database Analyst Hands-on exposure of Technology Lifecycle Management / Migration of Databases to latest vendor supported versions, Implementation & Configuration of MySQL database, Implement HA/DR solution and Backup/Recovery strategy, Database Migration /Upgrade Experience on MYSQL, Ability to automate repeatable tasks, Support problem resolution; participate and advise in requirement gathering phase, Ability to identify & perform Performance tuning as part of the migration, Participate in product evaluations, design review session, data requirement meetings. Responsibilities: Implementation & Configuration of MySQL database Implement HA/DR solution and Backup/Recovery strategy. Database Migration / Upgrade Experience on MYSQL Ability to automate repeatable tasks. Support problem resolution; participate and advise in requirement gathering phase. Ability to identify & perform Performance tuning as part of the migration. Participate in product evaluations, design review session, data requirement meetings. Open to work in extended shifts for productions releases i.e., during US daytime hours / weekends Mandatory Skills: 5+ years of experience MYSQL DBA, Migration of databases

What will you be doing Operate, maintain, and administer solutions contributing to customer infrastructures operational efficiency, availability, and visibility. Planning maintenance activity, design documentation, and standard procedures Provide Root Cause Analysis reports for outages/incidents (ITIL - Problem Management) Observe and provide feedback on the current state of the client s infrastructure, and identify opportunities to improve resiliency, reduce incident occurrence, and automate repetitive administrative and operational tasks. Contribute to, improve, and maintain team documentation about client systems and infrastructure, procedures, policies, and schedules. Gather and document information about client environments through audit activities, and analyze the information to identify opportunities for improvement and application of best practices. Work collaboratively with teammates to contribute to the continuous improvement of our working culture. Act as a technology leader for clients, as well as drive client discussions on technology road maps. Participate in an on-call rotation in an escalation capacity. What do we need from you Experience working with Google and AWS Clouds (including infrastructure as code deployment with Cloud Formation, Terraform, Opsworks, etc) Scripting and automation of administrative tasks using Python and Scala is a must Solid understanding of microservices architecture and container technologies (Kubernetes is a must, Docker, lxc, etc) Clear understanding of software development lifecycles and best practices from an infrastructure point of view (PRs, merge, rebase, etc) Understanding the end-to-end operations of a Business System vs components. Comprehensive systems hardware and network troubleshooting experience Common Linux distribution platform installation, configuration, performance tuning, and cloud migration. TCP/IP networking, NIC bonding, and network services configuration (DNS, NTP, DHCP, SMTP, etc) Operation and administration of virtual infrastructure, including experience with at least one hypervisor (VMware, Hyper-V, KVM, etc.) Ability to describe IaaS, PaaS, SaaS, pros and cons of each, use cases for virtualization and cloud Administration of web servers and supporting technologies, including network load balancers Experience with the design, development, and deployment of Puppet System and application error investigation, troubleshooting of access/availability issues including deep multi-system root cause analysis Experience managing networking devices, such as switches and firewalls from a variety of vendors Solid understanding of DevOps tools, processes, and culture Ability to pick up new technologies quickly Ability to provide accurate work scheduling and task estimations for work delivery

What will you be doing Operate, maintain, and administer solutions contributing to customer infrastructures operational efficiency, availability, and visibility. Planning maintenance activity, design documentation, and standard procedures Provide Root Cause Analysis reports for outages/incidents (ITIL - Problem Management) Observe and provide feedback on the current state of the client s infrastructure, and identify opportunities to improve resiliency, reduce incident occurrence, and automate repetitive administrative and operational tasks. Contribute to, improve, and maintain team documentation about client systems and infrastructure, procedures, policies, and schedules. Gather and document information about client environments through audit activities, and analyze the information to identify opportunities for improvement and application of best practices. Work collaboratively with teammates to contribute to the continuous improvement of our working culture. Act as a technology leader for clients, as well as drive client discussions on technology road maps. Participate in an on-call rotation in an escalation capacity. What do we need from you Experience working with Google and AWS Clouds (including infrastructure as code deployment with Cloud Formation, Terraform, Opsworks, etc) Scripting and automation of administrative tasks using Python and Scala is a must Solid understanding of microservices architecture and container technologies (Kubernetes is a must, Docker, lxc, etc) Clear understanding of software development lifecycles and best practices from an infrastructure point of view (PRs, merge, rebase, etc) Understanding the end-to-end operations of a Business System vs components. Comprehensive systems hardware and network troubleshooting experience Common Linux distribution platform installation, configuration, performance tuning, and cloud migration. TCP/IP networking, NIC bonding, and network services configuration (DNS, NTP, DHCP, SMTP, etc) Operation and administration of virtual infrastructure, including experience with at least one hypervisor (VMware, Hyper-V, KVM, etc.) Ability to describe IaaS, PaaS, SaaS, pros and cons of each, use cases for virtualization and cloud Administration of web servers and supporting technologies, including network load balancers Experience with the design, development, and deployment of Puppet System and application error investigation, troubleshooting of access/availability issues including deep multi-system root cause analysis Experience managing networking devices, such as switches and firewalls from a variety of vendors Solid understanding of DevOps tools, processes, and culture Ability to pick up new technologies quickly Ability to provide accurate work scheduling and task estimations for work delivery

Coordinating, analyzing, designing, implementing and administering solutions. Recommending best practices for improvements to current operational processes. Configuring and maintaining SQL Server database servers. Troubleshooting operational problems. Administering proactive daily checks. Responding to monitoring alerts. Communicating status and planning activities to customers and other team members. Participating in the teams rotational shift pattern and on-call coverage rotation plan. What do we need from you 3 years or more of experience as a SQL Server DBA Installing, configuring and upgrading SQL Server databases. SQL Server Administration including: Managing Server and Database storage. Performance tuning of database server. Designing and implementing various backup/recovery strategies. SSRS & Power BI, SSIS, and BI experience. Coding scripts, procedures, functions, etc.

What you will be doing: You'll work closely with the customer teams to understand their needs, in both a project based and long term support capacity. You'll create and document database standards, create optimized queries, indexes, and data structure. Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support. Use database vendor provided tools and Pythian developed accelerators to performance tune various database systems, specific queries and applications scenarios. Diagnose and address database performance issues using performance monitors and various tuning techniques. Identify areas of opportunity and recommend appropriate improvement suggestions. Work with our site reliability engineering organization to help configure and deploy high-availability and disaster recovery solutions for critical applications to meet customers needs. Cross-functional training in Mongo, Ansible and Python are encouraged. When you're not fixing things, you'll be authoring new blog posts on interesting topics for our open-source community to digest, creating new articles in our customer facing knowledge base for more frequently seen issues, and hosting webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community. What we need from you: 5-8 years of overall experience required as a Database Consultant (DBC) for this role The position requires specialized knowledge and experience in installing, configuring and upgrading MySQL databases MySQL Administration. Debugging skills, MongoDB and Scripting/automation tooling experience is a huge plus. Strong ability to work in both a team oriented environment and also under minimal supervision. Strong ability to adapt and to learn quickly. Good customer service focus with the ability to handle customer expectations and priorities. Disciplined in their learning process. Self-motivated. Keen attention to detail. Good analytical, evaluative, and problem-solving abilities. Effective organizational skills. Demonstrate sound work ethics. Very good documentation skills. Nice to have - Understanding of current IT service standards such as ITIL. Scripting (bash/python) and Ansible experience is a huge plus. Excellent written and verbal communication skills. Contributor to Open Source projects relevant to MySQL, MongoDB or other database or infrastructure software.