· Creation & managing Database schema, tables, tablespaces and users, roles & groups.
· Performance tuning, Query tuning by generating and explaining plan for SQL queries.
· Expert in DBA functions like managing databases, backups
& restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.
· Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.
· Monitoring Alert Log, scheduled jobs and troubleshooting database problems.
· Understanding of basic database fundamentals: multi- version control, concurrency, transactions, locking.
· Analyze, recommend, and implement configuration for Optimized Performance.
· Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.
· Expert with setting and trouble shoot replication.
· Ability to configure and trouble shoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
· Understanding of UNIX environment with shell scripting.
· Ability to identify defects in the environment and proactively intervene to reduce downtime.
· Server configuration and client authentication.
· In-depth knowledge of Database Security.
· Data Replication - Streaming replication.
· Any other required tasks
Starlink is part of the Ooredoo Group of companies established back in 2006. Starlink is the first retailer for mobile and accessories. Since then Starlink has branched out to become one of the largest outsource-managed services provider in multiple areas such as: IT, installations, maintenance and contact centers.