Database Admin recruitment in Mumbai - For a client of TeamLease Services Ltd

MySQL / MariaDB / Oracle Software Installation and database creation in Windows/Linux platforms

 Writing complex queries, Triggers, Stored Procedures, Functions, Fetch records in Json formats

 Creating Indexes

 Designing Database tables for application

Table Partitioning based on list and range partition

 Configure MySQL / MariaDB Master-Slave and Galera Cluster Replication (Innodb Cluster)

 Configure Maxscale 2.4 database proxy (Read-Write Splitter)

 MySQL / MariaDB Backup (Full, Incremental and Partial) and recovery, repair and optimize tables.

 MySQL / MariaDB utilities like mysqldump, Percona Xtrabackup and mariabackup

 Point-In-Time Recovery

 Log analysis, Maintaining documents of production server error log’s reports.

 Monitoring IOPS, CPU utilization and connections in AWS and prevent deadlock sessions

 Responsible for Performance monitoring and SQL tuning

 Scheduling jobs using crontab

 Clone database in another environment using AWS and modify Default Parameters.

 Maintaining Database Security (create and maintain USERS and roles, assign privileges)

 Multiplexing of control files and redo log files

 Applying force switch to redo log files

 Maintaining and configuring database files

 Creating Tablespaces and adding/resizing of datafiles

 Grant/Revoke privileges/roles & control Access on Database

 Performing status checks by monitoring the Alert logs, Trace files of the database

 Configuring database in Archive log mode.

 Applying Data pump for backup and restore

 Backup of database objects/Schemas using EXPDP/EXP

 Restoration of database objects/Schemas using IMPDP/IMP

 Restore and Recover database using RMAN utility

 Performance Monitoring & analyzes using AWR report

 Patch Management using opatch utility

 Killing inactive sessions/long running queries & releasing session locks