Database Administrator - Amazon RDS (7-10 yrs)

Role: PostgreSQL DBA

Location : Hyderbad

Experience: 7-10 years

- Working experience on Amazon Aurora RDS

- Experience in handling migration from onprem to Amazon cloud

- Hands on in PostgreSQL migrations from other RDBMS

- Hands on in PostgreSQL Native replications

- Create the objects in the database such as triggers indexes etc

- Monitor the performance of the database and ensure optimum performance

- Identify potential issues in the database to solve them early

- Knowledge on Auto Vacuum jobs and Customized VACUUM on certain tables and columns

- Maintain backups and perform disaster recovery in case a disaster destroys the database

- Monitor security and prevent any unauthorized access to the database

- Schedule consistent maintenance on the server

- Maintain database schema

- Manage database availability

- Give best practice guidance to the development team

- Resolve any production data issues

- Tablespace management

Role management :

- Develop automation technologies to accelerate the process of data loading

- Develop relational databases

- Ensure data integrity

- Manage user access and permissions by adding and removing users as required

- Maintain the database using different utilities This includes using pgctl and psql

- Database Recovery

- Installation and Maintenance

- Database Administration Backups Performance Tuning Security Data Modelling

- Troubleshooting

- Knowledge and hands on with Sheel and Perl scripting

- Available for 24x7 support and able to handle the P1P2 MI calls

- Abiding to ITIL v4 framework

Skills :

Mandatory Skills :

- AWS Database Service, Azure Database Service, PostgreSQL-DB Administration,

- RedHat Linux Administrator, Windows Server