Database Administrator
Minimum Qualification: BE/B.Tech/MCA/MSc
Experience & Skills required:
Candidate should be a self-motivated, highly-experienced MySQL Database Administrator. The DBA is responsible for development of best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, capacity management, backup and recovery, database replication setup/management, database clustering and ongoing database change reviews. The candidate has to maintain large-scale and very high transactional MySQL databases on Linux platform.
- Minimum 5 years of relevant experience
- Strong command of SQL and SQL server tools
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards
- Understanding of relational and dimensional data modelling
- PowerShell and Unix shell scripting skills
- Familiarity with SSAS, SSIS, SSRS is preferred
- MCSE/MCSA certifications preferred
- Experience with Linux and Windows Server environments
- Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
- Experience with cloud services (AWS, Microsoft Azure) is desirable
Job Description:
- Installing and upgrading the database server and application tool
- Allocating system storage and planning storage requirements for the database system
- Modifying the database structure, as necessary, from information given by application developers
- Enrolling users and maintaining system security
- Ensure DB & Data security at all times in development, testing, staging and production environment.
- Ensuring compliance with database vendor license agreement
- Controlling and monitoring user access to the database
- Monitoring and optimizing the performance of the database
- Planning for backup and recovery of database information
- Maintaining archived data
- Backing up and restoring databases
- Generating various reports by querying from database as per need
- Managing and monitoring data replication
- Acting as liaison with users
- Prepare reports and metrics and present it to management.
- Any other work assigned by Director, CSG
Job Vacancies: 3
Job Type: Full Time
Job Level: Mid Level
Years of Experience: 7
Salary Type: Negotiable
Job Location: Bengaluru