Database Administrator
Database Administrator
Cyber Advance Solutions Pvt Ltd
Lahore
Job details
Job Type
Full-time
Full Job Description
Cyber Advance Solutions is looking for a Database Administrator, or DBA, who will be responsible for overseeing the maintenance and security measures of company databases. Their duties include monitoring and updating malware protection software to combat potential security breaches, creating account data for authorized individuals to access databases and organizing databases so individuals can find important documents in an efficient manner.
Requirement:
- Responsible for Maintaining the backups and recovery of databases.
- Query optimization task after keeping in loop with concerned developer.
- Preparing the solutions for the high availability of databases like Sql server replication, clustering and always on availability group (Windows Failover cluster service) with the support of System Administrator.
- Schema Comparison of previous schema with the latest schema of development.
- Responsible for executing any type of script in the database.
- Implementing and managing the audit trail of databases.
- Creating and managing the databases and their users.
- Make sure to avoid duplication in the databases.
- Implementing referential integrity, domain integrity in the databases.
- Writing Queries, Stored procedures, function and triggers as required.
- Implementing and managing the indexes as required.
- Developing any type of report
- Creating Fact and dimension tables for data warehouses.
- Creating any report using Power BI Desktop.
- Responsible for performing any type of analytics like prediction of Student marks in the board exam using and training our previous data.
. Must have minimum 5 years of experience
. Must have minimum Bachelor’s Degree in CS/IT
Job Type: Full-time
Salary: From Rs140, 000.00 per month
Application Question(s):
- Current Salary
- Expected Salary
- Notice Period
Education:
- Bachelor’s (Preferred)
Experience:
- DBA: 5 years (Required)
Language:
- English (Preferred)
Application Deadline: 26/06/2022