Posted Sep 03, 2024 108 views
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
Skills
Job Details
Magnatec Systems
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.
What is your Competitive Advantage?
Similar Job Titles
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Ali Aziz
CEO
Shopistan
Aqib Irshad
Head of HR, Training & OD
FINCA
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Muzammil Baig
Digital Marketing Manager
IT Services Group
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Zohaib Ali
Marketing Manager
Digital Online Devices
