We are looking a Database Engineer (DBE) with 4+ years of experience specially in MS SQL, who will manage and support 24x7 production databases as well as development databases to ensure maximum availability of database resource for various applications specially FinTech. He should have the hands-on experience of Tables creation, sql query writing, stored procedures, user defined function, indexex etc. He should perform the DBA related tasks in key areas of System Administration, Database Administration, Backup, Archive & Restore Management, Performance Management & Reporting Perform capacity planning, performance monitoring and tuning, Strategies defined for backup/recovery techniques, and problem determination and resolution.

The DBA will be responsible for the availability, performance, integrity and security of the databases. Primarily with MySQL on Linux.

Responsibility over Production / Development Servers:

  • Responsible for performing query optimization in addition to assist/reviews/feedback to stakeholders in writing complex queries, stored procedures/functions, views, DDL/DML scripts.
  • Core responsibilities includes installation, administration, operations, support, and maintenance, monitoring & upgrading of database servers to ensure availability, security with optimal performance.
  • Work closely with the development team and production teams.
  • Maintains quality of service by establishing and enforcing organization standards.
  • Troubleshoot complex database issues in an accurate and timely manner ensuring compliance to SLAs / OLAs.
  • Maintain database operational, disaster recovery, and backup procedures/processes to ensure continuous availability and speedy recovery.
  •  User Management
  •  Security Management
  •  Space Management
  •  Backup and Recovery
  • Workload Management
  • Unix Shell and Batch Scripting
  • System Performance Monitoring
  • Exposure as a Development DBA.
  • Coordinate Software/Hardware Upgrade Activities.
  • Strong debugging skills

Skills & Attributes:

  • Working experience as a DBA in MySQL is essential but experience in Oracle & MSSQL will be a plus
  • Should have worked in Unix platforms.
  • Understanding of Logical Data Model/Physical Data Model.
  • Understanding of Normalization and De-normalization concept.
  • Ability to write efficient SQL & exposure to query tuning.
  • Should have good working knowledge on UNIX shell scripting.
  • Should have good understanding of data archive/restore policies.
  • Should be good at users/objects/rights management.
  • Strong working knowledge of Database platforms and its internal engine, storage & memory architecture/processes.
  • Monitor system's health and performance
  • Ensure high levels of performance, availability, sustainability, and security.
  • Analyze, solve, and correct issues in real-time.
  • Must be familiar with working and managing enterprise level mission critical databases with considerable size 2+ TBs

Qualification:

Bachelors/Masters in Computer Sciences or in any relevant field

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

صنعت:
کل عہدے:
2 آسامیاں
نوکری کی شفٹ:
پہلا پہر
نوکری کی قسم:
نوکری کا مقام:
جنس:
مرد
کم از کم تعلیم:
بیچلرز
ڈگری کا عنوان:
Computer Sciences or in any relevant field
کیریئر کی سطح:
تجربہ کار پیشہ ور
کم از کم تجربہ:
4 سال
اس سے پہلے درخواست دیجیۓ:
ستمبر ۲۱, ۲۰۲۴
تاریخِ اِشاعت:
ستمبر ۱۸, ۲۰۲۴

Magnatec Systems

مشیران · 301-600 ملازمین - لاہور

Trusted experienced and professional dedicated teams for offshore development for your next project. We outsource professionals on the basis of required skills. Best offshore software development and IT outsourcing company Since we started, Magnatec Systems delivering IT outsourcing services worldwide for all type of industries. We provide high-quality solutions with its more than 200 skilled professionals including web developers, mobile application developers, analysts and creatives. We at Magnatec Systems, helping organizations to propel further and go beyond developing completely new categories & introducing new products & services faster than ever before. We are passionate about the digital world and value its endless possibilities. Delivering robust & scalable web and mobile apps for the Mobile-First world for a variety of business verticals... iOS, Android, cross-platform solutions, you name it, the mobile dev team has built hundreds of apps over the last decade. Leverage the power of AngularJS, the heroic HTML based framework, to build dynamic web apps. Need to run complex algorithms? Want extra security or custom features? Choose .NET as the programming language. PHP web application framework helps you to create fast, secure web applications and provide you technical freedom. Need a comprehensive and professional SEO services to get your business more visibility in search? Build personal sites, blogs, portfolios and even e-commerce sites on WordPress. Manage easily, all by yourself. We build applications and help migrate your existing software including SaaS and PaaS solutions to the cloud.

آپ کو کس حوالے سے برتری حاصل ہے؟

اپنے بارے میں ہماری پیشہ ورانہ رائے اور تقابلی جائزہ حاصل کیجیۓ
اپنی سی وی کو موءثر بنانے کیلئے ہماری ماہرانہ مشاورتی ٹیم سے رابطہ کریں
روزی پریمیئم کو آزمائیں

ملتی جلتی نوکریاں

Database Developer

Contour Software, کراچی, پاکستان
اکتوبر ۲۹, ۲۰۲۴ شائع ہوئی

Senior Database Developer (Oracle and Java)

Contour Software, لاہور, پاکستان
اکتوبر ۲۹, ۲۰۲۴ شائع ہوئی

Database Developer

Pakistan Revenue Automation (Pvt) Ltd, اسلام آباد, پاکستان
ستمبر ۰۴, ۲۰۲۴ شائع ہوئی

Database Developer (Oracle and Java)

Contour Software, لاہور, پاکستان
اکتوبر ۲۹, ۲۰۲۴ شائع ہوئی
تمام دیکھیں
I found a job on Rozee!