Invoicemart – Database Administrator
Job Description
Job Title – Database Administrator
Experience – 2+ Years
Location – Thane
Interview Mode – Face to Face
Roles and Responsibilities
• Should have good knowledge on, Microsoft SQL Server, as a Database Admin
• Strong expertise in MS SQL Server (2016/2019/2022) administration.
• Proficiency in T-SQL for query writing and optimization.
• Experience with backup/restore strategies, log shipping, and replication.
• Knowledge of Windows Server administration and Active Directory integration.
• Familiarity with cloud platforms (AWS RDS for SQL Server).
• Understanding of data security, compliance, and auditing requirements.
• Excellent problem-solving and communication skills.
• 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.
• 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
• Bachelor’s degree in computer science, Software Development, or related field.
• Database Administration Certification in any one of the following databases: MS-SQL,
• 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.
• 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.
About Company
Invoicemart is a digital invoice discounting platform by A. TREDS (Trade Receivable Discounting System) Ltd, a joint venture between Axis Bank and B2B e-commerce company mjunction.
It is a platform which connects MSME suppliers (sellers) and their corporate buyers to multiple financiers. This platform enables discounting of invoices of the MSME sellers against large buyers who are in the ERP system, through a transparent auction mechanism that ensures assertion of the billing at competitive market rates.
The platform allows MSME suppliers to avail loans quickly and at competitive interest rates which will in turn helps increase their working capital efficiency without impacting their relationship with their buyers.
The integrated customer ERP systems empowers it sellers, buyers and financiers, with the ease of doing business by reducing processing time for seamless transactions. Users/Customers also benefit from flexible repayment terms which help them manage their payables better.
The platform makes sure that the buyers are top rated by leveraging their credit profile thus ensuring low risk of default. All the funds disbursed via Invoicemart qualify for priority sector lending.
A. TReDS received approval from the RBI for operations in July, 2017.
The key management team at Invoicemart includes Mr.Rajiv Anand, the Chairman & Mr.Prakash Sankaran, the Managing Director and CEO.