Job Title: |
|
Database Administrator |
Category: |
|
Database Administrator (DBA) |
Total Positions: |
|
1 |
Job Location: |
|
Karachi |
Gender: |
|
No Preference |
Minimum Education: |
|
Bachelors |
Career Level: |
|
Experienced Professional |
Minimum Experience: |
|
3 Years6 Years |
Salary Range: |
|
PKR 0 to 0 per Month |
Apply By: |
|
Jun 4, 2021 |
|
|
|
|
|
|
|
|
Job Description: |
Hiring Database administrator for a premier Analytics company, focusing on Business Intelligence, Performance, and Data Management solutions and services.
- It is an award winning Data Analytic company.
- Its major clientele include Engro and Soneri Bank
What Are We Looking For
- Ensure database performance by performing periodic database health-checks, troubleshoot bottlenecks, fine-tune SQL queries, dissect execution plans, and effectively manage database indexes.
- Proactively identify issues by regular monitoring of database logs, SQL Agent logs, Windows Events logs, and WFCS logs.
- Collect performance related information using Extended Events, SQL Trace, and Profiler etc.
- Secure databases by managing user roles & permissions, monitor SQL logins, harden database firewall, encrypt backups, and mask sensitive data.
- Ensure 24x7 availability of SQL databases by planning and implementing High Availability & Disaster Recovery (HADR) using Always On, mirroring, log shipping, and replication etc.
- Keep databases up-to-date by installing new cumulative updates (CUs), service packs (SPs), and GDRs.
- Upgrade SQL databases to latest versions with minimal downtime by proactively finding and fixing compatibility issue.
- Manage size of huge database tables by using compression, partitioning, sharding, and archiving etc.
- Manage multiple environments like production, development, and UAT.
- Perform data merging & consolidation by creating, managing, and monitoring SSIS ETL packages.
- Liaise with vendors for creating new application databases, upgrade existing databases, and provide technical knowledge in resolving database related issues.
- Assist audit teams in database auditing, ensure data integrity, and license compliance for all database servers.
Other Details
- Salary: Upto 150K
- Experience: 3+ Years
|
Company Information |
|
Company Name: HR WAYS (PRIVATE) LIMITED Company Description: HR WAYS (PRIVATE) LIMITED
|
|