Database Administrator (DBA)

Job Description

Title: Database Administrator (DBA)

Company Name: MySoft Limited

Vacancy: 3

Age: 24 to 32 years

Job Location: Dhaka (Shewrapara)

Salary: Negotiable

Experience:

• At least 2 years
• The applicants should have experience in the following business area(s): Software Company, IT Enabled Service
• Freshers are also encouraged to apply.

• Bachelor of Science (BSc) in Computer Science & Engineering

• At least 2 years
• The applicants should have experience in the following business area(s): Software Company, IT Enabled Service
• Freshers are also encouraged to apply.

• Age 24 to 32 years
• Only Male

• Perform SQL and PL/SQL operational tasks to maintain database functionality and integrity.

• Configure and maintain database servers on both Linux and Windows platforms, including ASM (Automatic Storage Management) and LVM (Logical Volume Manager).

• Configure and maintain Data Guard and Active Data Guard for disaster recovery and high availability solutions.

• Implement and enforce security rules at the database level to ensure data security and auditing compliance.

• Monitor database logs (alert, trace) for any unexpected situations and take appropriate actions.

• Perform performance tuning activities using tools such as AWR (Automatic Workload Repository), Optimizer, Execution Plan, SQL Profile, and Advisor.

• Implement and monitor data export/import (Expdp/Impdp) and backup strategies using tape, network, or remote backup solutions.

• Implement and manage RMAN (Recovery Manager) for full, incremental, differential, and cumulative backups.

• Perform database point-in-time recovery and restore operations using RMAN in case of abnormal issues.

• Manage database migration, synchronization, version upgrades, and applying patches as necessary.

• Monitor database performance and health using Oracle Cloud Control or Enterprise Manager.

• Provide database administration support for MySQL, MSSQL, PostgreSQL, and other database systems as required.

• Install, configure, and maintain Oracle Apex Application Server to support web application development and deployment.

• Set up and manage the integration of Jasper Reports with Oracle Apex to generate and distribute reports efficiently.

• Develop and maintain strong expertise in REST API concepts and principles.

• Collaborate with development teams to design and implement RESTful APIs for integrating various applications and systems.

• Configure and manage authentication and authorization mechanisms for secure access to REST APIs.

• Configure and maintain application servers such as Tomcat, Weblogic, Nginx, JBoss on Linux and Windows platforms.

• Configure and manage Apache virtual hosts, load balancing, SSL, DNS, and file and mail server configurations.

• Create and configure AWS, Oracle Cloud, and Google Cloud instances and servers for applications and databases.

• Deploy web applications Java, Apex, and Oracle Forms to servers which is Linux or Windows operating systems.