Freshersworld does not charge any amount for job placement. Beware of fraudsters who ask you to pay on the pretext of giving a job. Know More

Post A Job

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

featured-job FEATURED JOB

Database Admin

For a client of TeamLease Services Ltd
experience-icon 0 Years
salary-icon 25000 - 40000 Monthly
Expired

Posted: 18 Sep 20

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

Job Particulars

Education BE/B.Tech
Who can apply Freshers
Hiring Process Face to Face Interview
Employment TypeFull Time
Job Id1001329
Job Category
SkillsMySQL
Locality Address
Country India

About Company

NA
Jobs By Location
Others also searched for
ARE YOU A FRESHER? REGISTER NOW
Looking for your first Dream Job?
Update Resume
Upload Resume
Active Jobs By Type
View all