SRE 3 - DBA

Angel One Limited

3 - 5 years

Work from home

Posted: 06/10/2023

Job Description

Job Roles & Responsibilities:


l  Administration and management of PostgreSQL databases

l  Performance tuning and optimization of databases

l  Replication and clustering setup and maintenance

l  Participate & working in restore, patching activities, Backup and recovery of databases

l  & Backup Reporting.

l  Security management, including user management and data encryption.

l  Monitor and troubleshoot database issues.

l  Plan and implement database upgrades and patches.

l  Manage and Optimize PostgreSQL databases in RDS and Aurora

l  Automate tasks using Shell script or Python

l  On-Call support for critical incidents

 

DESIRED CANDIDATES:


l  Experience with Cloud databases like AWS RDS,Aurora Azure Database for PostgreSQL

l  Worked on Postgres tools such as PGadmin IV, pgbench, pgpool etc

l  Worked on utilities like pgdump, pgdump_all, pgrestore, pgarchivecleanup, pgconfig

l  Good knowledge on Architecture

l  Should understand and follow Standard Operating Procedures and Knowledge base articles

l  Scripting Knowledge and Automation skills

l  Strong verbal and written communications skills are desirable

 

Primary Skills:


PostgreSQL, LinuxRHEL, AWS


Secondary Skills:


MySQL, MS SQL

About Company

Angel One Limited, formerly Angel Broking Limited, is an Indian stockbroker firm established in 1996. The company is a member of the Bombay Stock Exchange, National Stock Exchange of India, National Commodity & Derivatives Exchange Limited, and Multi Commodity Exchange of India Limited. It is a depository participant with Central Depository Services Limited (CDSL). Angel Broking was incorporated on 8 August 1996 as a private limited company. Later, Angel Broking was incorporated as a wealth management, retail, and corporate broking firm in September 1997. In November 1998, Angel Capital and Debt Market Ltd. gained membership in the National Stock Exchange as a legal entity. The company opened its commodity broking Division in April 2004. In November 2007, Birla Sun Life Insurance joined hands with Angel Broking for the distribution of its insurance products. The International Finance Corporation bought an 18% stake in Angel Broking for ₹152 crore (equivalent to ₹457 crore or US$57 million in 2023) in December 2007. The company opened an office in Karol Bagh, New Delhi in October 2012.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).