s

Database Admin

For a client of TeamLease Services Ltd
Experience : Freshers
Education : BE/B.Tech
Skills : MySQL
Location : Mumbai
Per Month: Rs. 25,000 - Rs. 40,000
Posted on 18 Sep 20
Apply now
Job DescriptionLast Date 17 Nov 20

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 24 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

  • Database Admin
  • Experience : Freshers
  • Per Month : Rs. 25,000 - Rs. 40,000
  • Job Type : Full Time


Job Type : Full Time
Company Description
TeamLease Services established in 2002, is one of India's leading human resource service companies in the organized segment. A Fortune 500 company listed on both NSE & BSE markets, with eight offices and 1400 clients across the country. The company at present has about 100,000+ live associates/ trainees spread across the country and have till date given employment to 1.5+ million people with an aim to hire millions more.
Apply now
Active Jobs By Role
Accountant (925) Admin (135) Agriculture and Dairy (17) Bartender (1) Architect (120) Beauticians / Spa (185) Bouncer (3) BPO / Customer care (2102) Caretaker / Nanny (10) Carpenter (24) Cashier (0) Cleaner / Washer (28) Construction / Laborer (41) Content Writer (239) Counsellor (138) Cook / Chef (347) Data Analytics (8) Data Entry / Back Office (937) Delivery (425) Design / Animation (698) Digital marketing / SEO (426) Draughtsman/Draftsman (2) Doctor / Physician (130) Driver (59) Electrician (77) Engineer (1791) Engraver (1) Event Planner (5) Fire Fighter (6) Fitter (88) Gardener(Mali) (2) Ground Staff (77) Hospitality Executives (438) Housekeeping (128) HR (1028) Insurance Consultant (19) IT - Mobile Developer (228) Lab Technician (46) IT Hardware Engineer (149) IT Software-Engineer (3141) Language Translator (2) Legal (8) Librarian (0) Mechanic (359) Management Trainee (291) Media / Journalism (43) MIS Executive (11) Moulder (0) Nurse (155) Nutritionist / Dietician (2) Operations (91) Office Assistant / Helper (138) Operator / Machinist (116) Packager (12) Painter (6) Pharmacist / Medical Rep (148) Photographer / Videographer (27) Physiotherapist (5) Plumber (14) Research/JRF/SRF (204) Receptionist / Front Office (275) Retail / Store Executive (349) Rigger (0) Sales / Marketing (3054) Security / Guards (37) Sports Trainer (0) Tailor/ dress designer (81) Teacher (418) Tool & Die Maker (1) Tourist Guide (1) Trainer (37) Waiter / Steward (15) Ward Boy (2) Warehouse Executive (9) Welder (52) Others (2334)

SAFETY ALERT!
Teamlease does not charge any kind of payment for a job.