SSE / LA - SSE / LA Oracle DBA with 2yrs Postgres DBA

SSE / LA - SSE / LA Oracle DBA with 2yrs Postgres DBA

Position Description

6 to 10 years of total DBA experience with 2+ years Postgres DBA and remaining as Oracle DBA

The scope of work includes Database administration and DB server management activities. Works independently under limited supervision and applies knowledge and experience as a DBA. Possess sufficient knowledge and skills to effectively deal with all DBA tasks, issues and to prevent issues in future. Ensure planning and on time execution of all tasks with good quality

Your future duties and responsibilities

Responsible for managing all databases and DB servers of the project.

Ensure high availability of database and prevent issues

Standard DBA activities such as creation of schemas / databases, grants, backup-recovery strategy, cluster / high availability setup, helping other teams when needed, research and implement new features / tools / technologies and other project specific DBA activities.

Alerts and monitoring

Investigate and resolve all incidents / issues

Act as a SPOC for all DB related tasks / issues during your shift. Discuss & Coordinate with Developers and Other teams as needed to provide next steps / solution on the issue / task as needed.

Part of rotational shifts and off hours on-call support

Good to have - performance tuning of queries and database instances

Required qualifications to be successful in this role

Bachelor s degree with relevant experience

Primary Skill :

1. 6 to 10 years of total DBA experience with 2+ years Postgres DBA and remaining as Oracle DBA

2. Tools used in Postgres and Oracle for Backup-recovery, cluster / high availability, performance etc.

3. Excellent verbal and written communication skills

Secondary Skill (good to have / optional) :

4. OCP DBA certification

5. Performance Tuning

6. Scripting languages such as Shell, Python etc.