Type Here to Get Search Results !

Khushhali Microfinance Bank Limited Jobs Assistant Database Administrator

Khushhali Microfinance Bank Limited Jobs Assistant Database Administrator 

Location: Corporate Office, Islamabad

Division: Database Administration

Department: Information Technology

What You Will Do

ADBA position primarily entails work on tasks targeted to ensure both excellent uptime of the database systems as well as continuous research for improvement within this specific technology domain and associated processes. The ADBA should have good understanding of Open Source Databases operations for Micro Services Architecture, and Data warehouse scenarios, along with hands-on skills. Has good knowledge of best practices and a passion for ensuring highest standards of uptime through proactive monitoring, pre-emptive tuning and general attention to detail.

What You Will Do

Open Source Databases (SQL & NOSQL)

  • End To End Management of Open Source Databases including the design, implementation and support.
  • Managing/Running Databases in Docker Container.
  • Implement/Manage the Database Caching.
  • Offloading site setup and Management.
  • Installation, configuration, upgrading, administrating, monitoring, troubleshooting, cloning, patching, backup and restore of Open Source databases.
  • Manage users and security.
  • Make database backups and performing recovery when necessary.
  • Explore & Implement the Open Source Tools (Monitoring).
  • Proactively monitor the database's health and taking preventive or corrective action (approved only) as required.
  • Monitor and tune performance issues.
  • Create and maintain database operations handbook for frequently/routinely performed tasks
  • Monitor application related jobs and data replication activities.
  • Develop environment provision (Backup restoration & Point in time recovery).
  • Write database procedures, functions and triggers and well-tuned queries.
  • Monitor Database tools usage to review and ensure the system is operation at optimal levels.
  • Database Growth Monitoring to proactive manage underlying storage and recommend solutions as required.

Data Management

  • Establish the Data Ware House
  • Write and Monitor the ETL/ELT (OpenSource Pentaho or Python).
  • Install, configure and maintain the Hadoop (Clustered)

Database Support & Troubleshooting

  • Provide second level support for day-to-day operations to internal departments for Production, Disaster Recovery and Development sites.
  • Proactive monitor all databases alerts.

Database Implementation

  • Install & Configure Open source databases.
  • Facilitate issue related to database administration.
  • Inter and intra Team Coordination skills.

What You Need

  • Minimum qualification Bachelors in Information Technology or in Computer Science with emphasis on database systems.
  • Minimum 3 years of hands-on database administration experience. Prior work experience in a banking environment would be an added advantage.
  • Excellent knowledge, understanding & hands on in Open Source databases (PostgreSQL, PostgreNoSQL, Cassandra, MongoDB, Maria DB, MySQL)of Open Source database’s HA & DR.
  • Hands-on experience in establishing the High Availability/Clustering (Shared Nothing Architecture) and To setup and manage the Disaster Recovery including role transition.
  • Good understanding of Database Essential for Micro Services.
  • Concept of Container Database.
  • Cache Database Concepts.
  • Data Warehouse, Data Lake and Big Data Basic Concepts.
  • Database & Data Integration Concepts.
  • Query optimization and performance tuning.
  • Strong database backup & recovery concepts.
  • Good working knowledge and hands-on experience of NoSQL, tuning and optimization.
  • Good analytical and problem solving skills.
  • Good Data Ware House Concepts.
  • ETL/ELT Writing Skills.
  • Exhibits and upholds KMBL’s values and social performance objectives.
  • Shell Scripting.
  • NoSQL
  • Data Migration

Note: We are an equal opportunity employer and value talent diversity at our Bank. We do not discriminate on the basis of age, color, gender, marital status, race, religion, or disability status. Therefore, all qualified candidates, especially females, are welcomed and encouraged to apply on our positions

Post a Comment