Sign In
 [New User? Sign Up]
Mobile Version

MySQL Senior IT Analyst_IQN_

Bengaluru, KA
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

As an Information Technology (IT) Analyst (MySQL), you will have the opportunity to work both independently and with a cooperative team on complex projects that may span multiple infrastructure components or applications. You will develop your professional network and leadership skills, assisting in the creation and support of IT Solutions that enable Caterpillar success. Further, you will contribute real value by developing, integrating, and/or supporting in-house and purchased applications or infrastructure solutions in order to solve business problems.Job Duties/Responsibilities may include, but are not limited toResponsibilitieso Establish the DB environment - plan, design, develop/changeo Administer all DB objectso Monitor and optimize DB performance and capacityo Provide Technical Consultation to DBAs and Application Analystso Resolve problems identified via Monitoring/Health Checko Provide architect solutions to support database consolidation and centralization of existing applications from remote locationso Perform Root cause analysis on critical incidents and take preventive measureso Provision MySQL instances on stand-alone and HA environments.o Should have experience on different HA solutions and its implementationso Ensure performance, security, and availability of databaseso Prepare documentation and specifications as neededo Handle common database procedures, such as upgrade, backup, recovery, migration, etc.o Profile server resource usage, optimize and tweak as necessaryo Collaborate with other team members and stakeholdersSkills and Qualificationso Strong proficiency in MySQL flavour Oracle MySQL. Exposure to MariaDB and Percona is an added advantage. o Decent experience with recent versions of MySQL (5.5 and 5.6)o Good understanding of MySQLs underlying storage engines, such as InnoDB and MyISAMo Experience with replication configuration in MySQLo Knowledge of de-facto standards and best practices in MySQLo Proficient in writing and optimizing SQL statementso Knowledge of MySQL features, such as its event scheduler, triggers etco Ability to plan resource requirements from high level specificationso Knowledge of limitations in MySQL and their work around in contrast to other popular relational databaseso Proficient in writing shell scriptso Good understanding of UNIX, especially Linux OS internalso Basic knowledge on Networking and Firewall concepts.o Exposure to NagiosXI and Percona tools is an added advantage.
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering)

Experience: 8-12


Application Programming | Database Administration (DBA) | System Administration | Systems Programming
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News