5.0 - 9.0 years

0 Lacs

pune, maharashtra

On-site

As an Analyst specializing in MySQL Database Administration, you will be responsible for performing technical research, analysis, design, and architecting of IT Database systems. Your primary objective will be to ensure that the documented business and technical requirements are met and implemented to industry best practice standards. This includes driving short and long-term architecture strategy for IT Database systems, communicating and validating database architecture with technology services and development management teams, and leading technical design discussions with Development and project team members to ensure compliance with documented requirements. Your key responsibilities will involve installing, configuring, maintaining, and managing database systems, schema, tables, indexes, procedures, and permissions. You will also be tasked with creating backup/recovery of MySQL databases, ensuring successful SQL Transactional Replication, tracking performance metrics of maintained databases, identifying potential capacity/performance issues, and conducting regular performance tuning, indexing, and normalization of database systems. Additionally, you will develop and test SQL scripts for task automation and reporting, provide monitoring support for critical database servers and supporting services, and meet project deliverables for new or changes to existing technology within project requirements. Furthermore, you will be expected to install, migrate, and administrate MySQL to Mariadb, ensure minimal server downtime resulting from maintenance and improvements during non-production hours, identify opportunities to reduce costs while maintaining functionality and support, improve technology performance and stability, and enhance existing processes to increase productivity. Other responsibilities include managing db patching, db upgrade/migration, resource monitoring, requirement analysis, developing and documenting issue resolution knowledge base, and providing second and third level support for all database systems. Availability for on-call 24/7 support is also a requirement for this role. To qualify for this position, you should possess a Bachelor's degree in Information Technology, Computer Science, or a related discipline, along with a minimum of five years of experience in database administration. Additionally, you should have at least three years of administrator experience in an IT Enterprise organization that follows ITIL methodologies. Proficiency in installing, configuring, integrating, and administering MySQL within the Linux/LAMP stack is essential, along with hands-on experience supporting Highly Available (HA) database environments with clustering solutions. Experience in systems engineering design, analysis, integration, and life-cycle engineering for large information systems projects is also required. Preferred qualifications include experience in a multi-tiered architecture environment supporting B2B and/or hosting operations, familiarity with open-source software including LAMP software bundle, and working knowledge in NoSQL/MongoDb. Strong written and verbal communication skills, the ability to work effectively in a team, and excellent project management abilities are also desirable traits for this role.,

Posted 1 week ago

Apply

Analyst-Database Admin Mphasis

3.0 - 7.0 years

0 Lacs

pune, maharashtra

On-site

You will be responsible for performing all technical research, analysis, design, and architecting of IT Database systems to ensure that the documented business and technical requirements are met while adhering to industry best practice standards. It will be your duty to drive short and long-term architecture strategies for IT Database systems and communicate and validate database architecture with the technology services and development management teams. As an Analyst in MySQL Database Administration, you will lead technical design discussions closely with Development and project team members to ensure that the documented requirements are being met within proposed solutions. Your tasks will include installing, configuring, maintaining, and managing database systems, schema, tables, indexes, procedures, and permissions. You will also be responsible for creating backup and recovery procedures for MySQL databases and ensuring the successful occurrence of SQL Transactional Replication. Monitoring the performance metrics of maintained databases, identifying potential capacity or performance issues, and conducting regular performance tuning, indexing, and normalization of database systems will be part of your responsibilities. Additionally, you will develop and test SQL scripts for task automation and reporting, provide monitoring support for critical database servers and supporting services, and meet project deliverables within project requirements. Your role will also involve tasks such as installing, migrating, and administrating MySQL to Mariadb, ensuring limited server downtime during maintenance and improvements, identifying cost-reducing opportunities while maintaining adequate functionality and support, and providing second and third-level support for all database systems. You will need to be available for on-call 24/7 support and possess excellent written and verbal communication skills. To qualify for this position, you should have a Bachelor's degree in Information Technology, Computer Science, or related discipline, along with a minimum of five years of experience in database administration. You should also have a minimum of three years of administrator experience in an IT Enterprise organization practicing ITIL methodologies. Additionally, thorough training and demonstrated analytical and technical skills in installing, configuring, integrating, and administering MySQL within the Linux/LAMP stack are required. Preferred qualifications include experience working within a multi-tiered architecture environment, supporting B2B and/or hosting operations, familiarity with open-source software including LAMP software bundle, and working knowledge in NoSQL/MongoDb.,

Posted 2 weeks ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.