Data Base Consultant (RDMS Architecture)

TAT IT Technolgies; Muscat; On-site; OMR 15,000 - 20,000; Full time

Job summary

A forward-thinking company is seeking a skilled Database Consultant with over 6 years of experience in RDBMS architecture and database management. This pivotal role involves ensuring data security, optimizing performance, and maintaining high availability for critical banking databases. The ideal candidate will have a strong background in Unix administration and ETL technologies, along with a proactive approach to problem-solving. Join this innovative firm to make a significant impact in the banking sector by deploying robust database solutions and enhancing data integrity and performance. If you are passionate about database technology and eager to contribute to a dynamic team, this opportunity is perfect for you.

Qualifications

• 6+ years of experience in database management and RDBMS architecture.
• In-depth knowledge of Unix administration and scripting for database tasks.

Responsibilities

• Implement and maintain security features like TDE and data masking.
• Monitor database performance and ensure efficient access to data.

Skills

ETL technologies

Transparent Data Encryption (TDE)

database management

data masking

data warehousing

RDBMS architecture

Unix administration

security

performance optimization

Job description

We have an urgent requirement for a Database Consultant (RDBMS Architecture) for one of our banking clients in Oman.

Experience: 6+ years

Banking Domain: Must

Key Responsibilities:

• Experience in database management and RDBMS architecture with in-depth experience in Unix administration and scripting required for database administration.
• Implement and maintain security features like TDE (Transparent Data Encryption) and data masking.
• Good experience in data warehousing concepts in analyzing and ETL technologies.
• Install, upgrade, and configure database software, ensuring proper version control and maintenance, including applying fixes and keeping databases and related tools healthy.
• Monitor database performance and ensure fast, efficient access to data and adequate resources. Regularly optimize performance using checklists and set processes.
• Ensure databases comply with security policies and standards, including Trust Domain and IT Security Policy.
• Ensure databases meet recovery goals (RPO and RTO) and maintain high availability (HA) and disaster recovery (DR) setups. Regularly test backup and recovery procedures.
• Investigate and resolve database problems through a structured problem management process.
• Optimize performance by performing database reorganizations and automating repetitive tasks.
• Forecast database growth and manage storage usage, cleaning up data based on retention policies.
• Design and implement database backup and recovery strategies.
• Implement database failover technology for reliability.
• Estimate future hardware needs and user load growth.
• Deploy new database solutions as needed by the organization.

Skills: ETL technologies, Transparent Data Encryption (TDE), database management, data masking, data warehousing, RDBMS architecture, Unix administration, security, performance optimization.