Database Administrator

Role & responsibilities

Job Sumary:

Hiring for a national level online platform which facilitates financing of Receivables of Micro, Small and Medium Enterprises (MSME) from buyers through financiers. TREDS is in the business of opening accounts, uploading, accepting, discounting and settlement of Invoices and Bills of Exchange by way of Factoring and Reverse Factoring and provide such other services as permitted by the RBI from time-to-time. An online receivable discounting platform for facilitating the short-term financial transactions in a smooth and efficient manner among the financers, buyers and sellers.

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 creatin 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.
• Analyse 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.

Technologies

• Bachelors degree in computer science, Software Development, or related field.
• Database Administration Certification in any one of the following databases: Oracle, MS-SQL, MySQL, Postgres.
• A minimum of 2 years hands-on experience as a DBA in one or more of the above Database technologies. MS-SQL DBA experience shall be preferred.
• Working knowledge of AWS DB technologies like RDS shall be an added advantage.
• Knowledge of Cloud computing/Elastic computing across virtualized environments shall be a plus.
• Excellent written and verbal communication skills and high level of personal integrity.
• Good organizational skills.