Senior Database Administrator

Job Description

Title: Senior Database Administrator

Company Name: Pridesys IT Limited

Vacancy: 1

Age: Na

Job Location: Dhaka

Salary: --

Experience:

• 5 to 8 years
• The applicants should have experience in the following business area(s): Software Company, IT Enabled Service, Consulting Firms

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

• OCP (DBA) Certification is required

• Oracle Cloud

• Azure or any cloud certifications are preferable. 

• 5 to 8 years
• The applicants should have experience in the following business area(s): Software Company, IT Enabled Service, Consulting Firms

• Sound Knowledge on SQL and PL/SQL Install, patch and maintain all Oracle software Install Oracle Apex 21/22, ORDS & upgrade Apex version Maintenance oracle Apex application users, workspace, backup & upload Apex application, approve all production schema changes Control all migrations of Oracle schema objects Design and implement all type of backup & recovery system Implement Oracle failover technology.
• Strong knowledge on RAC multimode with clear concept in SAN Storage and DATA Guard (Single Instance, 2 node RAC to Single instance & 2 node RAC to 2 Node DG) is highly preferred.
• Expert in Linux/Unix mandatory (RHCE certification is added extra advantage).
• Knowledge in installation Windows server, Oracle Linux, Red hat Linux, Centos, Ubuntu, RAID, HDD Partition. Bash, Shell scripting.
• Basic knowledge in Network Security, Cyber Security, System Security, Router, Switch etc.
• Depth knowledge in oracle database parameter. Knowledge in Oracle Cloud, advanced SQL server experience.

Responsibilities:

• Expected to have optimization experience in Oracle 9i/ 10g/ 11g/12c/19c/21c databases: optimizing indexes, plans, memory usage, fragmentation handling, DML/DDL lock, Database Event trigger etc.
• Have to maintain proper documentation of work as per the company policy. 
• Should be self-motivated, self-learner, high achiever and ability to work under extreme pressure and should have mentality to work in a team.
• Design and implement Oracle PL/SQL solutions To design, document and implement effective data solutions using standard SQL objects like stored procedures, tables, views, functions, Package, Oracle VPD etc.
• To design, document and implement ETL solutions using SSIS plus administration of existing packages.
• To implement reporting solutions using SSRS and report manager and to support existing reporting solutions.
• Responsible for managing all Databases (Oracle, MS SQL, MS Sql, MariaDB, MongoDB).
• Oversees DB security, troubleshoots and fixes DB failures, schedules and executes backups, and prepares data restoration/disaster recovery plans, tracks/monitors database performance and activity.
• Ensure security through access controls, backups and firewalls, manage network servers and technology tools, DNS Server configuration, maintenance & troubleshooting.

• Weekly 2 holidays
• Salary Review: Yearly
• Lunch Facilities: Partially Subsidize
• Festival Bonus: 2

• Excellent and friendly working environment

• Good opportunity for career progression

• Snacks and Tea/Coffee

• Other benefits as per company policy