MYSQL DBA

 Job Responsibilities:

• Adhering to SLAs

• Reporting to the Track Lead / Team Lead

• Helping team members in case of Issues/Technical Problems

• Handling tickets / requests

• Troubleshooting technical issues

• Ensuring that the processes are adhered to

• Responsible for successful completion of Installation, configuration and migration

• Ensure maximum uptime according to the SLA

• Responsible for building / maintaining a test environment

• Improves and maintains customer and employee satisfaction

• Implementing new technologies and design changes

• Implementing Backup/Restoration Strategy for 24x7 operation support

• Applying patches/upgrades to maintain security level Technical Requirements

• Installation of Oracle Software/Database Pre-requisites

• Oracle Database Basic Administration and Latest Features

• Maintain instance parameters and system settings

• Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump

• Applying and Testing security patches to the databases

• Managing User Accounts

• Experience in cloning using cold backup, hot-backup and RMAN backup

• Capacity Planning in terms of Growth of Database

• Automated File and Storage Management

• Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery

• Experience in basic Performance Tuning and Monitoring using various tools such as AWR, TKPROF and Explain Plan

• Availability Management for Databases

• Database Resource Management and Task Scheduling

• Scheduling Database Backups, taking Logical Backups & Physical Backups

• Implementing Database Security Policy.

Soft Skills:

• Excellent communication and conversation skills (Verbal and Written)

• Good documentation skills

• Good working knowledge of MS OFFICE

• Should have a good customer handling skill

• Able to handle unforeseen situations

• High level of acceptance

• Can drive HCL’s value and its methodology

Other Skills / Experience:

• Worked on Production systems

• Experience with Database Migration, Installation, Upgrades and Patching - Datacenter understanding

• Knowledge of Other RDBMS is a Plus

• Experience in PL/SQL and worked on ER Diagrams

• Working Knowledge on Cluster ware