Junior Database Administrator

Aftab Currency Exchange Ltd

٦ دن پہلے شائع ہوئی 195 نے دیکھا Report Job

PKR. 100,000 - 175,000/Month

Who we are:

ACE Money Transfer is a UK-based company headquartered in Manchester, United Kingdom. The company is an online International remittance service provider for customers from the UK, Canada, Australia, and the European Union, including Switzerland.

ACE group of companies has a diversified portfolio, including digital wallet services in the UK and real estate, advertising businesses, and software solutions in Pakistan.

We are looking for a talented individual to join our team in the role of a Junior Database Administrator who will focus 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 an 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.
Setup and manage replication topologies for high availability.
Manage database security granting/revoking permissions and ensuring security practices are in place and followed as part of the overall IT security initiative. Makes recommendations for the on-going 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.
Setup 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, testing policies, and practices are in place and followed to minimize the risk of data loss.
Participate in 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.

Required Skills:

Bachelor\\\'s degree in computer science, computer engineering, or information systems; Or master\\\'s degree 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 (AlwaysOn, 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 drive projects through to completion.
Knowledge of concurrently optimizing the DBMS for functionality, tuneability, reliability, supportability, availability, scalability and extensibility, normalization, and referential integrity.

مہارتیں

MySQL Amazon WebServices (AWS) Microsoft Azure MSSQL

نوکری کی تفصیلات

صنعت:

بینکنگ / مالیاتی خدمات

شعبہِ افعال:

ڈیٹا بیس انتظام (DBA)

کل عہدے:

1 اشاعت

نوکری کی شفٹ:

دوپہر

نوکری کی قسم:

مستقل

نوکری کا مقام:

کھاریاں, پاکستان

جنس:

کوئی ترجیح نہیں

کم از کم تعلیم:

بیچلرز

کیریئر کی سطح:

نوآموز

کم از کم تجربہ:

1 سال

اس سے پہلے درخواست دیجیۓ:

اکتوبر ۱۲, ۲۰۲۴

تاریخِ اِشاعت:

ستمبر ۱۱, ۲۰۲۴

Aftab Currency Exchange Ltd

بینکنگ / مالیاتی خدمات · 201-300 ملازمین - کھاریاں

پیروی کریں

Aftab Currency Exchange Ltd. is a UK incorporated Company that is part of the well-established Aftab group companies and has been operating in the North West of England since 2002. Our head office was the starting point of the UK success story when we commenced business with retail clients and two business associates we now have our London branch in South West London and have over the past 9 years expanded our coverage through the use of agents across the UK and now boosts a network of more than 280 business associates and agents using the Aftab Currency Exchange name which we have worked hard to maintain our credibility and trusts within the Pakistani community.