MySQL Database Administrator Carifer Technologies
Carifer Technologies
Office Location
Full Time
Experience: 3 - 3 years required
Pay: INR 200000 - INR 800000 /year
Type: Full Time
Location: Erode
Skills: database tuning, Database migration, Root Cause Analysis, Documentation, SQL Profiler, resource planning, MySQL database management, Database Cleanup, Database Availability, Security of Clusters, Orchestrating Upgrades, Backups, Provisioning of Database Instances, Development of Database Schema, Development of ERD, replication Configuration, Writing, Optimizing SQL statements, Table Scan, Row Scan, Query Execution Plan, Creating Views, MySQL Event Scheduler, code versioning tools, sqlnosql databases
About Carifer Technologies
Job Description
We are seeking an experienced MySQL Database Administrator (DBA) to oversee the Performance, Tuning, Clean-up, Migration, Availability, and Security of MySQL Instances. You will be responsible for managing Clustered and Non-Clustered Configurations, Orchestrating Upgrades, Backups, Provisioning Instances, and collaborating with other teams. Your role will involve developing Database Schemas and ERDs, identifying Database issues, migrating data, and preparing documentation. Responsibilities: - Provision MySQL instances in Clustered and Non-Clustered Configurations - Ensure Performance, Tuning, Availability, and Security of MySQL Clusters - Develop Database Schema and ERD - Identify Root Causes of Database issues, perform Database Clean-up - Migrate Data between Customer and Product Databases - Prepare Documentation and Specifications - Handle common database procedures like upgrade, backup, recovery, migration - Profile server resource usage, optimize as needed - Collaborate with team members and stakeholders Skills and Qualifications: - Strong MySQL database management skills - Experience with recent MySQL versions - Understanding of MySQL storage engines (InnoDB, MyISAM) - Replication configuration expertise - Proficiency in Database Clean-up and Migrations - Knowledge of MySQL standards and best practices - Ability to write and optimize SQL statements - Familiarity with SQL features like Table Scan, Query Execution Plan - Experience in creating and managing Views - Understanding of MySQL features like Event Scheduler - Resource planning based on specifications - Familiarity with SQL/NoSQL databases (PostgreSQL, MongoDB) - Knowledge of MySQL limitations and workarounds - Proficiency in code versioning tools (SVN, Git) - DBA Certification is a plus If you have 3 to 5 years of experience in MySQL database administration, possess the required skills, and are looking for a Full-Time, Permanent position in Erode, Tamilnadu, we encourage you to apply for this Administrator role.,