
Database Administrator
Salary undisclosed
Checking job availability...
Original
Simplified
Perform daily monitoring of RDBMS production logs and email alerts to detect errors or issues for the databases and database servers. 2-5 years of experience in database support, with strong mid-level database administration skills. Able to support DBA role for PostgreSQL, Oracle, MSSQL. Prepare and update the documentation procedures for DB technical process. Develop, update & enhance the script used for Daily repetitive task. Review all errors seen in DB error log and fix problem. To log service request with respective DB vendors for solutions required. Carry out database backup and restorations as and when needed. Familiar with the database native backup methods. Ability to monitor and troubleshoot database native replication such as Oracle Dataguard and MSSQL Always On. Ability to monitor and troubleshoot database cluster services such as Oracle RAC and MSSQL Cluster Ability to monitor and administrate Oracle ASM storage. Analyse DB growth trends and project storage threshold and provide reports to storage admin. Monitor and identify efficiency of DB & online recovery log files and enhance to meet growth requirements. Monitor and identify DB network component for efficiency and update parameter when necessary. Ability to carry out extractions and deployments on databases in accordance to the process and governance defined. Ability to extract AWR reports. Experience in Installation, Store and Support Should be mid-level DB skillset. Responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission-critical Production PostgreSQL databases. Responsible for all Logical and Physical backup & recovery even PITR recovery Manage Clusters and upgrading/migrating various PostgreSQL database version. Performance Tuning, Replication, and develop database automation scripts and maintenance. Provide technical guidance for integration, testing, design, development, planning of new production systems/databases. Skills Needed: PostgreSQL/ Oracle/MSSQL/Mongodb, Oracle Dataguard, MSSQL, PITR recovery Manage Clusters and upgrading/migrating various PostgreSQL database version, Oracle ASM storage, Oracle RAC, Oracle DB, Cluster. Database Management Tools Oracle SQL Developer – For managing Oracle databases. SQL Server Management Studio (SSMS) – For managing Microsoft SQL Server. MySQL Workbench – For MySQL administration and development. pgAdmin – A popular GUI for managing PostgreSQL. Toad for Oracle / SQL Server / MySQL – A comprehensive database management tool. DBeaver – Universal database tool supporting many DBs. HeidiSQL – Lightweight tool for MySQL, MariaDB, and PostgreSQL. Navicat – Cross-platform database development and management. Monitoring & Performance Tools SolarWinds Database Performance Analyzer Redgate SQL Monitor Oracle Enterprise Manager Percona Monitoring and Management (PMM) New Relic Database Monitoring Zabbix – Open-source monitoring tool with database support. Nagios – Customizable infrastructure monitoring including DBs. Backup & Recovery Tools Veeam Backup & Replication Oracle RMAN (Recovery Manager) SQL Safe Backup (IDERA) mysqldump / mysqlpump pgBackRest – Backup tool for PostgreSQL. Barman – Backup and recovery manager for PostgreSQL. Query Optimization & Tuning Tools SQL Sentry Plan Explorer ApexSQL Plan Oracle AWR (Automatic Workload Repository) Query Store (SQL Server built-in feature) EverSQL – Online SQL query optimizer. Security & Audit Tools Imperva SecureSphere IBM Guardium Oracle Audit Vault SQL Server Audit DataSunrise Database Security Automation & Scripting Tools Ansible – Infrastructure automation, including database tasks. Terraform – For provisioning infrastructure including DBs. PowerShell / Bash – Scripting for automation and maintenance. Liquibase – Database schema change management. Flyway – Version control for your database.