Database Administrator ARTECH INFOSYSTEMS PRIVATE LIMITED

About ARTECH INFOSYSTEMS PRIVATE LIMITED

Job Description

Sure, here's a rewritten version of the job description:

Responsibilities:

• Database Design and Architecture: Develop and maintain robust database structures.
• Database Servers Monitoring and Administration: Oversee the health and performance of database servers.
• MySQL Installation/Configuration/Upgradation: Install, configure, and upgrade MySQL 5.5 and above on Linux platforms.
• Replication Management: Ensure the maintenance of MySQL Master/Slave and Master/Master replication setups.
• Performance Optimization: Enhance MySQL server performance for long queries, create necessary indexes, use appropriate data types for columns, and tune MySQL parameters.
• Storage Engine Expertise: Possess excellent knowledge of MySQL storage engines, particularly InnoDB, MyISAM, CSV, and Federated.
• Daily DBA Activities: Perform routine DBA tasks such as backups, monitoring, query optimization, and performance tuning.
• Database Security: Maintain database security by creating and managing users and roles, and assigning privileges.
• Collaboration with Development Team: Work closely with the application development team to assist with daily operations.
• Environment Synchronization: Create development, staging, and production database instances, and synchronize these instances across environments.
• Large-Scale Database Management: Manage large-sized production databases efficiently.
• Performance Tuning: Optimize various parameters like maxconnections, sortbuffersize, keybuffersize, readbuffersize, tablecache, etc., in the production environment.
• Automated Database Dumps: Implement automated incremental database dumps.
• Cluster Server Setup: Set up and manage cluster servers.
• Database Imports and Exports: Handle large database imports and exports.
• Database Migration: Facilitate database migration between different server environments.
• Database Mirroring and Log Shipping: Set up database mirroring and log shipping.