Project Role : Infra Tech Support Practitioner
Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting.
Must have skills : MySQL Database Administration
Good to have skills : NA
Minimum
3 year(s) of experience is required
Educational Qualification : Graduate
Summary:
Review and integrate all application requirements, including functional, security, integration, performance, quality, and operations requirements. Review and integrate the technical architecture requirements. Provide input into final decisions regarding hardware, network products, system software and security.
Roles & Responsibilities:
• Develop, 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 application.
• Participate in an on-call rotation and other duties as defined by management. Must be able to
work in 24/7 rotational shifts.
• Managing Client requests independently.
• Performing Database Failover ensuring best practices for Aurora Engine is followed.
• Hands On experience with Aurora Features and understanding of High Availability concepts.
• Zeal to perform under strict deadlines and learn new tools/technologies.
• Troubleshooting database & performance issues and query optimization at database level
enhancing overall system responsiveness.
• Monitor and analyze database logs, addressing issues to ensure uninterrupted service.
• Good exposure of logical backup and recovery methods.
• Exposure to community-based tools for MySQL and Aurora MySQL.
• Support database migrations, upgrades, and patches, ensuring seamless transitions.
Professional & Technical Skills:
• Must Have Skills: Database Administration, MySQL, RDS MySQL, Aurora, AWS Aurora MySQL
Cluster management.
• Good To Have Skills: Upgradation, Migrations, expertise in Performance tuning, MySQL/AWS
Aurora.
• Experience in working with managed databases on the cloud like AWS RDS MySQL and Aurora.
• Experience in incremental backup and schedule backup.
• Experience with MySQL and Managing Aurora MySQL Cluster.
• Expertise in snapshot, import/export, and DB optimization with the help of explained plans.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase
performance and betterment of integrity constraints.
• Experience in performance tuning, MySQCircular, 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 AWS RDS, Azure PaaS MySQL, Aurora MySQL.
• Good communication skills and ability to articulate technical issues/requirements accurately
and succinctly in a manner that business users can understand.
• Good presentation skills.
• Ability to multi-task and participate in large, complex, and concurrent projects.
• Good to have AWS Solution Architect Associate / AWS Database specialty certified.
Additional Information:
• Educational Qualification: Knowledge on ITIL standard and best practices 16 years of full-time
education.
• Should be flexible for 24/7 environment Lead/handle P1/P2 calls.
Graduate
About Accenture
Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with 750,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. We are uniquely able to deliver tangible outcomes because of our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song. These capabilities, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities. Visit us at www.accenture.com
Equal Employment Opportunity Statement
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.
Accenture is committed to providing veteran employment opportunities to our service men and women.