Database Administrator

In the Role of the Database Administrator, you will mainly be working on
PostgreSQL and be a support for Oracle and MySQL(SMT tickets).
You will be performing tasks in Postgresql as follows:
• Up-gradation from Postgres 9.6 to 13 latest version
• Installed Postgresql required extensions(Postgis, Raster, geo database etc.)
• Developed the backup script using pg_basebackup.
• Schedule and monitor the backup every day.
• Troubleshoot database connectivity issues or performance issues. Resolve technical or
functional issues for the application whenever necessary.
• Setup Streaming replication and monitor.
• Configure necessary parameters in the PostgreSQL.conf file and raise Firewall request for
postgres port
• Communicate with Application team whenever needed
• Performing Database patching co-ordinate with LSA(OS admin team)
For Oracle and MySQL :
• Monitoring the backup.
• Perform Script executions according to the SMT ticketing system.
• Perform Database alignments.
• Resolve application customer queries.
• User and Tablespace creation in Oracle
• Database and User creation in MySQL
• Resolving Login issues in MySQL
• Perform DB deployments for Oracle
RDBMS used: Oracle, MySQL, PostgreSQL
You will also be involved in different tasks such as :
• Technical documentation
• Arrange the meeting with third party support or application team via Teams
• Creating necessary DB sever report for trend.
• Filling timesheets on time
KNOWLEDGE AND SKILLS
We’re looking for a person having :
• A Bachelor degree, equivalent to minimum 3 years of studies or higher degree
• At least 3 years of experience in total
• Relevant experience at the same function
• Experience on the databases Oracle, MySQL and PostgreSQL with a special focus on
Postgre and Oracle.
• Knowledge of SQL language
• Knowledge of the Monitoring Tool (PRTG)
Certification required or willingness to get certified ASAP on the following :

• Oracle Database Administrator Certified
• SQL

50-100 EUR/hr

File name:

File size: