Database Admin Jobs in Mumbai - For a client of TeamLease Services Ltd
Job Description
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
