Post Job Free
Sign in

MY SQL DBA Administration

Company:
Cognizant
Location:
Hyderabad, Telangana, India
Posted:
May 14, 2024
Apply

Description:

MySQL-JD

Experience in MySQL database architecture, logical and physical design, MySQL 5.7, MySQL 8 versions, and MySQL Enterprise Monitoring

Hands-on experience on HA Configuration, multi master, innodb cluster, etc.

Must have strong knowledge of Linux/Unix & Windows.

Knowledge of shell scripting (e.g., Bash, Perl).

Good knowledge of ITIL processes

Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.

Responsible for regular backups and PITR recovery of databases.

Responsible for regular maintenance on databases (e.g., Re-indexing, Archiving).

Responsible for Query tuning and preventative maintenance.

Tools: MEM, MEB, mydumper, open source monitoring tools, xtrabackup, MySQL Work bench.

High Availability: MySQL master-slave, multi master replication, InnoDB Cluster, Knowledge on NDB cluster.

• Handle specific technologies within projects.

• Contribute to HLD, LLD, Implementation and test plans.

• Participate in technical audits.

• Identify opportunities for automation, standardization and stabilization of environment.

• Understand technical requirement and translate into design.

• Lead TIP initiatives and coordinate with CoE for the implementation of the same.

• Prepare/update/review run books/SOP/knowledge articles on specific technology areas.

• Plan Prepare and execute change process and change implementation and standardize the change process.

• Contribution to reducing COD by performing the following:

• Left shift,.

• Identifying and driving the CSI and automation initiatives.

• Prepare templates, checklist and guidelines on Due diligence, Transitions and KT.

People / Team.

• Enabling the L1/L2 team members to enhance their skill sets.

• Deliver technology training through Academy and/or within project group for technologies/ tools.

• Participate in recruitment and act as a buddy to new hires.

• Proactively support team building and on boarding efforts via mentoring contributions.

• Contribute to knowledge management activities by creating case studies, technical artifacts, and reference architectures related to your technical domain.

Must Have Skills

MySQL DB Administration

MySQL-JD

Experience in MySQL database architecture, logical and physical design, MySQL 5.7, MySQL 8 versions, and MySQL Enterprise Monitoring

Hands-on experience on HA Configuration, multi master, innodb cluster, etc.

Must have strong knowledge of Linux/Unix & Windows.

Knowledge of shell scripting (e.g., Bash, Perl).

Good knowledge of ITIL processes

Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.

Responsible for regular backups and PITR recovery of databases.

Responsible for regular maintenance on databases (e.g., Re-indexing, Archiving).

Responsible for Query tuning and preventative maintenance.

Tools: MEM, MEB, mydumper, open source monitoring tools, xtrabackup, MySQL Work bench.

High Availability: MySQL master-slave, multi master replication, InnoDB Cluster, Knowledge on NDB cluster.

Schedule: Full-time

Shift: Day Job

Travel: No

Apply