Data Base Administrator, Grade G4/G5 Total Experience: 6-10 Years
Job Responsibilities:
Manage various databases through multiple product lifecycle environments, from development to mission-critical production systems
Configure and maintain database servers clusters and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modelling techniques to ensure development and implementation support efforts to meet integration and performance expectations.
Build database systems of high availability and quality depending on each end user's specialized role.
Minimize database downtime and manage parameters to provide fast query responses.
Provide proactive and reactive data management support and training to the team. Perform tests and evaluations regularly to ensure data security, privacy and integrity.
Monitor database performance, implement changes and apply new patches and versions when required.
Independently analyse, solve, and correct issues in real-time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes.
Assist developers with complex query tuning and schema refinement.
Perform scheduled maintenance and support release deployment activities after hours. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Skills Requirements:
Strong knowledge in MySQL DB administration having 6-10 years hands-on experience Support MySQL databases for production and development.
Participate in large, complex database/ application deployment, migration, patching, consolidation and upgrade projects. Setup and monitor backups; implement and test recovery techniques; diagnose and fix performance issues.
Strong knowledge in High Availability configuration on databases with Master- Slave and Master- Master Replication or Group Replication. Experience with performance optimization (server/ query tuning).
Good Scripting knowledge in shell scripts.
Good to have experience with writing stored procedures, triggers and events. Experience with Percona toolkit.
Provision MySQL instances, both in clustered and non-clustered configurations
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, optimize and tweak as necessary
Proficient in use of NoSQL database in High Availability and fault tolerance environment (MongoDB / Cassandra).
Good to Have :
- Knowledge of any other NoSQL databases like Cassandra.
- Cloud platforms like AWS and their Services for Data and analytics.
- Desirable to have a good understanding of Infrastructure architecture.
- Knowledge of monitoring tools like Nagios, Grafana.
Keyskills: mysql database certified mysql database administrator Database Administration NoSQL MySQL Database Management Cassandra Mariadb MongoDB mysql cluster MySQL Database Administration
Quick Heal Technologies Limited Over 25 Years of Quick Heal Security Quick Heal Technologies Ltd. (Formerly Known as Quick Heal Technologies Pvt. Ltd.) is one of the leading IT security solutions company. Each Quick Heal product is designed to simplify IT security management across the length an...