Pridesys IT Limited
Pridesys IT Limited
Pridesys IT Limited
Follow
More jobs from this company
Summary
- Vacancy: 1
- Location: Dhaka
- Experience: 5 to 8 years
- Published: 4 Nov 2024
Requirements
Education
- Bachelor of Science (BSc) in Computer Science & Engineering
-
OCP (DBA) Certification is required
-
Oracle Cloud
-
Azure or any cloud certifications are preferable.
Experience
- 5 to 8 years
- The applicants should have experience in the following business area(s):
Software Company, IT Enabled Service, Consulting Firms
Additional Requirements
- 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 & Context
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.
Skills & Expertise
AWSAzure Cloud Administration
Azure
Database Administrator (DBA)
Compensation & Other Benefits
- 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
Workplace
Work at office
Employment Status
Full Time
Job Location
Dhaka