JOB CATEGORY
IT/Technology
EMPLOYMENT TYPE
Full-time
JOB LEVEL
Mid Career
YEARS OF EXPERIENCE
5-6 Years
LANGUAGE
Arabic
Jobseeker Gender
Male
Description
MISBAH MIRZA Email:[email protected] ENGINEERMobile: 00974-66550307 Summary:To achieve a growth-oriented position in a professionally managed and dynamic organization, which enable me to broaden my current skills and challenge my various abilities in a competitive environment and having adequate authority and responsibilities. Professional Summary: Having 5+ years of experience in IT Industry with strong skills in MySQL Server Database Administration. Excellent knowledge and solid experience in MySQL Architecture and Database Design Expert-level knowledge in MySQL's logical Architecture, Concurrency control, Transactions (ACID), Multiversion Concurrency Control and MySQL's Storage Engines Experience in Optimizing a poorly designed or badly indexed schema and improved performance upto 600% in high traffic and high revenue generating web applications. Excellent knowledge and solid experience in PL/SQL code Query Tuning and Optimization, Restructure quires and Query optimizer hints Excellent knowledge and hands on experience of Optimizing MySQL server settings on General Tuning, Tuning MySQL's I/O Behavior, Tuning MySQL Concurrency and Workload-Based Tuning. Expert-level MySQL Replication skills with Master-Slave, Master-Master, Master and Multiple Slaves, Master-Master in Active-Active Mode, Ring, Pyramid replications set up, replication troubleshooting and Replication failover alerts on heavy load application Expert-level knowledge on MySQL Backups and Recovery, Logical and Raw backups, Increment backups, Parallel backup and Crash recovery Expert-level knowledge on Operating System and Hardware Optimization, Balancing Memory and Disk Resources, RAID Performance Optimization, Choosing Hardware for a Slave. Excellent knowledge in creating new databases and users, Administrating security levels Privileges, setup schedule backups and failover alerts, Import and Export backups, crash recovery, using mysql utilities, data encryption and monitoring scripts. Excellent Knowledge in Shell and Perl Scripting and configure for Backup and Replication failover alerts and other monitoring alerts. Education Profile: Bachelor of Engineering (Computer science) FROM Jawahar lal NehruTechnological University. Professional Experience: “InfoStairs Technologies” from Jan 2012 to Jan 2017. Technical Skills: Operating Systems : UNIX/LINUX, Windows 2003/2000/XP Languages : SQL Databases :MY-SQL5.0/5.1/5.5/5.6. Networking : CCNA,CCNP,BlueCoat Firewall Work Experience: Project Details: Client: E-wings E-Wings Retail Corporation, business of manufacturing goods and beverages with factories all over the globe. This has many products with different flavors and the product Sales is through many channels like CSD, institutional and Dealership including INDIA, USA, AUSTRALIA, ENGLAND and GERMANY. At present the company's products and Sales data is stored at their respective branches. Responsibilities: Database design support and administration of MySQL. Configure the my.cnf. Managed users and their privileges. Implemented scheduled backups & recovery strategies. MYSQL performance tuning and optimization. Tuning InnoDB, managing memory usage. Migrated data from MSAccess to Mysql. Setup of Master-Slave replication and troubleshooting. Implemented and maintained two-way replication. Restoring the tables when tables are crash. Support application developers with any and all database related activities. Up gradation of Mysql Client and Server. Client Name: Hexagrid Operational Data Stores.Role:My SQL DBA PROJECTS DETAILS: Hexagrid consistently strives to address real business needs through easily administered yet highly advanced IT infrastructure automation software. We believe that technology should simplify the business of IT through functional, implementable solutions that save time and money. Hexagrid understands that integrated technology solutions form a solid foundation upon which people build successful businesses. Hexagrid's revolutionary approach to Infrastructure as a Service (IaaS) exemplifies this philosophy. Responsibilities Establish and maintain backup recovery policies and procedures. Setup, upgrade and administer MySQL database servers for Production, Development and R&D use. Creation of databases and users and assigning necessary privileges to them. Configure the my.cnf. Maintain backups and monitoring system health. Restore the data whenever data crashes. Taking daily backup and incremental backup and restoring databases if required. Optimization of queries which take long times to execute. Track down and troubleshoot database performance issues to ensure optimal performance of variousapplications and databases. Work as part of a team and provide 24×7 whenever required. Project: STAT Track Client: Tristar Insurance Group, USA Environment: Mysql, Java, Flex 3 &AS3 IDE: Sqlyog Web Application Server: Apache Http server Role: Mysql DBA Project Description: Tristar want to investigate insurance claims raised by client, So that they want to send this client claims to Investigation Company (Frasco) . For sending information Investigations company provide a web service. We have to access that web service and send information to Investigation company and get file number generated by then. Responsibilities: Understanding the functional specifications and architecture. Design database using MySQL. MySQL Performance tuning and Query optimization Involved in Development as part of Developer and security person. Database support and MySQL administration. Scheduling jobs for database backup, replication failover alters using shell scripting Backups under load, failover strategies, and recovery from replication issues • Project: HRM Client: Johnson and Dugan, USA. Organization: Solivar Soft Pvt. Ltd. Environment: Java web service, JDBC, MySql, Flex. Role: Mysql DBA Project Description: Clients want to automate Human resource management process using ADP's Human resource management solution. ADP published many web services for HRM and cobra administration. We have to access that web service, process data and show to client using Flex (GUI) Responsibilities: Understanding the functional specifications and architecture. Tuning InnoDB, managing memory usage, and tuning file systems for maximum throughput. Mysql Performance tuning and Query optimization Database support using multiple stored routines. Mysql administration and Database support. backups under load, failover strategies, and recovery from replication issues Project: EASLight Client: Product Database Mysql Role: Mysql DBA Project DescriptionEnterprise Application Systems Light (EASLight) is a Software-as-a-Service (SaaS) offering that allows enterprises to turn complex business process applications to on-demand software. Our quick-build process enables customization and configuration in days and weeks, not years and months. EASLight is lightweight, highly customizable, modular software development system that is perfect for enterprises who want to quickly develop hosted applications. This Product is ideal for companies with unique business needs where COTS software is not a solution. Companies who don't want or can't manage software development teams or don't want to manage hardware will also benefit greatly from the ease of maintenance and hassle free software system Responsibilities: Understanding the functional specifications and architecture. Involved in Development of Whole Module. Database design using Mysql 5.0. Implemented Mysql Replication (Master - Slave), Server Administration, Mysql Enterprise monitoring, backup and recovery fail over alters using shell scripting Scheduling jobs for database backup and recovery. Data migration from sql server 2005 to mysql. Database, server and query optimization in mysql Personal Details: Marital status : Un MarriedNationality : IndianLanguage Known : English, Arabic, Hindi, Urdu, Telugu.Driving License : Valid India Driving License Passport No : Z2460918Passport issue date : 09/04/2013Passport expires date : 08/04/2023 Transferable Engineer visa Available (awal) Thanks,MISBAH MIRZA
Information
