Pakistan Job Openings
ACE Properties
Jr. Database Administrator
Khāriān
FULL TIME
September 9, 2024
Junior Database Administrator
We are looking for a talented individual to join our team in the role of a Junior Database Administrator who will focus on improving the efficiency and availability of our databases. This candidate must have strong analysis and troubleshooting skills while experience managing enterprise class databases will be added advantage.
Duties And Responsibilities
- Ensure that databases are optimally configured, and work with the development team to optimize the use of the database from the application perspective, including query profiling, table indexing, file layout, etc.
- Perform database-related performance tuning and optimization as suggested by statistics gathered, such as improving and revising poorly written queries, rebuilding/updating table indices and statistics, performing database cleanups and archives, reconfiguring default configuration, and other database tuning processes that help to improve the performance of the system.
- Set up and manage replication topologies for high availability.
- Manage database security by granting/revoking permissions and ensuring security practices are in place and followed as part of the overall IT security initiative. Makes recommendations for the ongoing security and dual-control aspects of database control and operation. Perform periodical audit of database access rights to prevent unauthorized access compliance with regulatory requirements.
- Set up and maintain highly available database architectures.
- Knowledge of SQL tools.
- Implement operational automation.
- Design, implement, and test disaster recovery scenarios for minimizing RTO and meeting RPO goals.
- Ensure that database backups are always current and available for all production databases, and testing policies, and practices are in place and followed to minimize the risk of data loss.
- Participate in an on-call rotation schedule.
- Assist team with application issues.
- Participate in the analysis and staging process of application developments, application deployments/installation through a release process and other various support functions in the system development life cycle.
- Organizes large-scale complex DB projects into manageable deliverables and activities.
- Bachelor's degree in computer science, computer engineering, or information systems; Or master's degree in computer science, computer engineering, or information systems.
- 1+ years' experience in database administration
- Knowledge of T-SQL programming writing SQL functions, procedures, and complex queries.
- Knowledge of database cluster technologies (Always On, failover clusters, mirroring, log shipping, etc.).
- Knowledge of data conversion technologies.
- Strong analysis and troubleshooting skills including experience with Profilers.
- Proactive self-starter with the ability to drive projects through to completion.
- Knowledge of concurrently optimizing the DBMS for functionality, tuneability, reliability, supportability, availability, scalability and extensibility, normalization, and referential integrity.
Pay: From Rs100,000.00 per month
Ability to commute/relocate:
- Lahore: Reliably commute or planning to relocate before starting work (Required)
- Bachelor's (Preferred)
- DBA: 1 year (Preferred)
New Job Alerts
TATA Pakistan
Management Trainee - Quality (Female)
Karāchi
FULL TIME
September 20, 2024
View Job DescriptioniB12
Experienced US Trucking Lead Generator & Dispatcher (7pm-3am) *** Office Job in Multan***
Multān
FULL TIME & CONTRACT
September 20, 2024
View Job DescriptionNormeca International
Women Medical Officer
Sanghar
CONTRACT
September 20, 2024
View Job DescriptionAgribusiness Support Fund
Project Coordinator - Team Lead
Islamabad
September 20, 2024
View Job DescriptionZRG International (pvt) Ltd.
Business Analyst
Karāchi
FULL TIME
September 20, 2024
View Job DescriptionLooking for similar job?
ACE Money Transfer
Senior Database Administrator - Hybrid
Lahore
FULL TIME
August 23, 2024
View Job DescriptionACE Money Transfer
Junior Database Administrator
Khāriān
FULL TIME
September 11, 2024
View Job DescriptionACE Money Transfer
Senior Database Administrator - Hybrid
Lahore
FULL TIME
September 9, 2024
View Job DescriptionNew Job Alerts
TATA Pakistan
Management Trainee - Quality (Female)
Karāchi
FULL TIME
September 20, 2024
View Job DescriptioniB12
Experienced US Trucking Lead Generator & Dispatcher (7pm-3am) *** Office Job in Multan***
Multān
FULL TIME & CONTRACT
September 20, 2024
View Job DescriptionNormeca International
Women Medical Officer
Sanghar
CONTRACT
September 20, 2024
View Job DescriptionAgribusiness Support Fund
Project Coordinator - Team Lead
Islamabad
September 20, 2024
View Job DescriptionZRG International (pvt) Ltd.
Business Analyst
Karāchi
FULL TIME
September 20, 2024
View Job Description