Mandate Skill :
· Strong technical expertise on SQL, NoSQL and databases like PostgresDB, SQL Server, CosmosDB, MongoDB, Cassendra and Cloud DB
· Minimum 10 + years of experience in production DB management
· Working experience on relational database and non relational database administration
· Working experience in advanced DB management, backup/recovery and tuning.
· Has good hands-on MySQL, Postgresql and Maria database installation, creation, configuration and fine tuning
· Good experience in MySQL different versions (MySQL-5.6.x,5.7.x and 8.x)
· MariaDB - Good experience in MariaDB different versions (MariaDB-10.x,11.x)
· MIria DB Installation, version upgrade, replication, backup and restore, Performance tuning and query tuning and Monitoring
· Must have good experience in AWS cloud MariaDB in ec2 and RDS.
· PostgreSQL - Good experience in AWS PostgreSQL RDS and Aurora.
· Postgresql DB Backup and restore, performance tuning
· Must have good experience in AWS cloud database services like RDS MySQL, Aurora MySQL.
· Redshift - AWS redshift configuration, installation, backup and restore, DB version upgrade, User management, Database Migration.
· Must have good experience in AWS DMS.
· Migration database from physical servers to AWS cloud DB services and configuring ETL replication from RDS to redshift through AWS DMS.
· Should possess work experience on migration/upgradation projects On premise or On-premise to cloud.
· Manage SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems.
· Have a good understanding and exposure on project deliverables and timely delivery.
· MongoDB - MongoDB installation, backup and restore, user management.
· Good to have knowledge in AWS document DB.
· Experience with Linux and Windows Server environments
· Extensive experience with database technologies (MySQL, Maria, PostgreSQL, Redshift MongoDB)
· Experience with cloud services (AWS, Microsoft Azure) a plus
Any Graduate