Ensuring the firms data is stored correctly, optimizing it for the differentdata lifecycle stagesof production, reporting, and long term storage
Undertakedatabaseperformance monitoring and tuning, problem resolution, availability management,capacity management, change management and security access management to ensure the continuous provision of service of thedatabaseand integrated platform environments
Perform complex backup and recovery tasks fordatabaseand applications infrastructure environments. Design thedatabaserecovery and backup policyand procedures in accordance with business requirements
Planning out strategies forDB migration, DB consolidation and driving it end to end.
Provide data lifecycles strategies from production to the data warehouse, ensure performance, security, and availability of databases
Prepare documentation fordatabasedesign and maintenance processes
Experience with the usage of query and insight tools
MySQLdatabaseengine knowledge - InnoDB
Data migration from on-premise databases toCloud-baseddatabaseplatformslike Azure and AWS technology Stacks
PerformdatabaseAd-hoc backups and restores when required
Provide 24x7 support for critical production systems
Develop secure solutions and knowledge of regarding information security
Required Skills and Knowledge:
4+ years of minimum experiencewith recent versions of MySQL / MariaDB and hands-on working with large scale/databaseof minimum 1TB
Proficient in writing and optimizing SQL statements, with strong proficiency in MySQLdatabasemanagement
In-depth knowledge of MySQL features, such as its event scheduler, Triggers, SP, Indexing, Sharding etc
Excellent Analytical and organization skill
Knowledge of MySQL's underlying storage engines
Knowledge of limitations in MySQL/MariaDB and their alternates in contrast to other popular relational databases.
Hands-on knowledge and experience in any one or more scripting languages such as PHP / .Net / Python / Batch / Power Shell / Shell Script
Certification in Oracle Certified MySQL Developer or Oracle Certified MySQLDBAwill be an advantage
Must have experience in different types of backups and replication methods with hands-on knowledge of backup tools
Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end
Ability to configure and maintaindatabaseservers and processes, including monitoring of system health and performance
Must have Azure PaaS /DBaaS exposure.
Good communication skills are a must.
What we offer:
The opportunity to work within a fast-growing, progressive, and global-acting company
Career development opportunities and the chance to really progress
Flat and lean organization ensuring short time-2-market
Competitive salary and benefits
skills MySql DBA, DB Migration, Azure Paas/DBaaS qualification M.E/M.Tech, B.E/B.Tech, MCA, BCA
Employement Category:
Employement Type: Full time Industry: Recruitment Functional Area: IT Role Category: Database Administrator (DBA) Role/Responsibilies: database administrator
Randstad India is a division of Dutch-based Randstad Holding NV, a Dutch multinational human resource consulting firm headquartered in Diemen, the Netherlands.