Database Administrator

**Overview of Role**

+ **Knowledge of a second database technology which could be one of PostgreSQL will be an added advantage.**

+ **Additionally, knowledge of MongoDB and No-SQL will be an added advantage** **.**

+ **Service Design**

**To ensure availability and security of the database infrastructure.**

**To manage the governance process for technical policy, standards and guidelines.**

**To drive best practice designs that promote stability and operational efficiency.**

+ **Service Technologies**

+ **To work on core database technologies in**:
+ **Oracle - Database Concepts and administration.**

+ **Basic knowledge of Cloud hosted DB technologies. Oracle on AWS-EC2/RDS.**

+ **Minimum of 4 to 7 years of experience working with Oracle, Postgres,Aurora PostgreSQL and/or other databases.**

+ **Should possess knowledge and concept of infrastructure and databases.**

+ **Amazon AWS Database & RelatedTechnologies - RDS & EC2 hosted databases.**

+ **Should have a reasonable understanding of AWS.**

+ **Monitoring - Oracle OEM, SolarWinds, Script Based Tools**

+ **HA & replication - Oracle Data Guard, Log Miner &RAC.**

+ **Backup Solutions - Oracle RMAN, Datapump, Export/Import**

+ **Amazon AWS Database & RelatedTechnologies - Oracle RDS (Desired)**

+ **Core competency on Oracle 11g/12c/ 19c / Grid Control Database Administration.**

+ **Certification in core competency preferred. (desired, but not required)**

+ **Good understanding of AWS RDS and EC2 instances. (desired, but not required)**

+ **Good understanding of platform O/S (Linux / Windows)**

**Responsibilities**

**Database Management**:
+ **Provide 24*7 support for production, development, and test databases.**

+ **Be responsible for standard database administration duties: including, but not limited to,installation, patching and change migration, monitoring, backup and recovery.Build, upgrade, migrate and maintain databases.**

+ **Administer, install, configure, and maintain Oracle databases (12c,19c,23c etc.) in both on-premises and AWS environments.**

+ **Installation, configuration and administration of data replication technologies: Data Guard, Active Data Guard.**

+ **Ensure database availability, reliability, and high performance through proactive monitoring, maintenance, and optimization.**

+ **Implement and support Oracle RAC (Real Application Clusters), Data Guard, and other high-availability solutions.**

**Cloud Database Administrations**:
+ **Design, deploy, and manage Oracle databases hosted on AWS services, including Amazon RDS, EC2, and S3.**

+ **Utilize AWS-native tools like CloudWatch, RDS Monitoring, and Newrelic to monitor and maintain cloud database environments.**

+ **Assist with database migrations to the cloud (on-prem to AWS) and ensure smooth operations in the cloud environment.**

+ **Should have experience RDS/Aurora (cloud) database upgrades and patching with minimum downtime (rolling upgrades/patches).**

+ **Should have experience in migrating the databases using DMS,replication etc.**

**Operational Responsibilities**

+ **Responsible for maintaining services to agreed Service Levels through effective management and communication to all parties.**

+ **Responsible for alerting the Leadership team, Service managers and Business of any issues that impact production or result in reduced resilience during a production period.**

+ **Is involved in the maintenance and regular testing of tier 0 disaster recovery plans**

+ **Ensuring that system failures are contained and resolved with minimum business impact and that steps are taken to manage failures in IT delivery.**

+ **To join the Incident Management team during major incidents.**

+ **To ensure timely weekly preparation of brief management reports.**

+ **Oversee changes to ensure mínimal disruption and compliance with change processes.**

+ **Provide timely participation in follow-on problem focus groups.**

+ **Involved in updates for operational procedures and associated support documentation.**

+ **To at all times follow and encourage ITIL best practice.**

**Backup Recovery & Security Compliance**:
+ **Use RMAN backup/recovery and deployment.**

+ **Using RMAN, Oracle Data Pump, and proprietary AWS tools, prepare and implement solutions for database backups and disaster recovery.**

+ **Carrying out regular recovery tests and validations is a must to guarantee data integrity.**

+ **Ensure proper database security measures are in place, including user management, encryption etc.**

+ **Work with app team for upgrading the major and minor version for Oracle & Postgres.**

+ **Maintain and review database audit trails to ensure compliance with organizational and regulatory policies.**

+ **Prepare reports on database security, user access, and system changes.**

**Performance Tuning and Optimization**:
+ **Monitor and tune Oracle database performance, including query optimization, indexing, and SQL performance.**

+ **Use tools like Oracle E