SQL Database Administrator

Job Location : Thane (Head Office)

Skills : good knowledge on MySQL, Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch, Cassandra, MariaDB, IBM Db2

Edu : Bachelor’s degree in computer science, Software Development, or related field.

Roles and Responsibilities

• Should have good knowledge on MySQL, Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch, Cassandra, MariaDB, IBM Db2
• Able to Choose the right hardware and software for the database, considering factors such as the size of the database, the number of users, and the performance requirements.
• Configure the database for the company's needs, including creating user accounts, granting permissions, and setting up database parameters.
• Perform regular maintenance on the database servers, such as patching the operating system and database software, applying security updates, and backing up the database.
• Monitor the performance and health of the database servers and troubleshoot and resolve any issues that arise.
• Develop and implement backup as well as recovery plans / jobs that meets the company's data recovery requirements, considering factors such as the frequency of backups, the type of backups, and the retention period for backups.
• Develop a recovery plan to restore databases in the event of a failure, considering factors such as the type of failure, the recovery time objective (RTO), and the recovery point objective (RPO).
• Set up database monitoring tools to track key performance metrics, such as CPU usage, disk I / O, memory usage, and query execution times.
• Analyze database performance data to identify trends and patterns, and to identify any areas where performance is suboptimal.
• Investigate the root cause of performance issues, such as slow queries, inefficient indexes, and database bottlenecks.
• Implement tuning solutions to improve database performance, such as rewriting inefficient queries, creating new indexes, and adjusting database parameters. Perform other database maintenance tasks, such as defragmenting indexes and shrinking databases.
• Monitor database usage and audit database activity to identify suspicious activity.
• Develop and implement database security standards and procedures, covering areas such as password management, data encryption, and access control.
• Work with developers to fix database design or code issues that are causing problems.
• Create and maintain database indexes to improve the performance of database queries.

Requirements

Technologies

Benefits

About client :

Talworx is an emerging recruitment consulting starting up, we are hiring for our client which is a , a leading fast growing fintech organization and largest player in online receivables discounting business ventured by Axis bank. They facilitate financial transactions between financers, buyers and sellers through our digital marketplace platform.