Mysql
Collaborative Application Specialist offering in-depth knowledge of software development. Qualified to manage databases, test software and manage web applications. Professional and hardworking with a pleasant demeanor and a commitment to making sure systems are running at optimum levels.
Domain: Digital Services-Media and communications & Business
- Worked as an Onsite QA & Support Engineer for the client NXT Digital in
the domain of Digital Services, Media and Communications, and Business.
NXTDIGITAL - Brief Summary:
NXTDIGITAL is India's leading digital television services provider,
utilizing the innovative Headend-in-the-Sky (HITS) platform.
Combining the benefits of cable and DTH technologies,
NXTDIGITAL offers a world-class TV viewing experience.
With a strong technical foundation, NXTDIGITAL ensures
superior quality and scalability of operations.
The company has made significant inroads in rural and semiurban areas, serving over 3.5 million digital subscribers through
4500+ Local Cable Operators (LCOs).
NXTDIGITAL delivers 650+ television services, including highdefinition (HD) channels and radio services.
By providing a wide range of channels and content,
NXTDIGITAL meets subscribers' demand for greater choice and
satisfaction.
NXTDIGITAL aims to be the preferred choice of consumers by
providing superior service and quality content in today's
converged world of entertainment.
- Identified and resolved technical issues, ensuring the root causes of
production errors were established and escalated serious concerns when
necessary.
- Coordinated with IT groups and external vendors to ensure effective
application services, maintaining the reliability of all applications.
- Conducted independent research and gathered information to provide
in-depth analysis for resolving production issues.
- Supervised alerts related to application and system procedures, providing
proactive services.
- Checked and resolved issues related to OTPs, SMS, login/registration, and
transactions, ensuring smooth customer transactions and resolving errors.
- Checked API logs and forwarded them to the team, verified logs from
Putty, and checked request responses.
- Executed daily queries in MySQL database, acted as a data analyst,
2019-10 – Current
.
extracted data as per client requirements, corrected meta-data errors,
and generated reports on a daily basis, including transaction reports.
- Performed load checking and balancing on portals, conducted tests on
production applications.
- Designed production support procedures, policies, and documentation
for efficient support and maintenance.
- Possessed 4 years of strong experience in executing MySQL database
operations. Demonstrated proficiency in DDL, DQL, DML, DCL, and TCL
commands. Installed and configured MySQL, created tables, extracted
data, and performed backups.
- Provided expertise in support and testing for web and app development.
- Possessed knowledge of HTML, CSS, JavaScript, jQuery, JSON, and XML.
- Supported e-commerce, collection, web, and application systems.
- Familiarity with manual and sanity testing, as well as QA methodologies
and processes.
- Checked logs, API request-response, and provided production support,
working on Firebase.
- Managed design changes by adding or removing messages, images,
and PDFs on client applications.
- Handled major maintenance activities and performed tasks like killingstarting workers.
- Collaborated closely with the developer team and website manager to
ensure smooth operations.
- Mentored and coached team members on QA topics and strategies.
- Supported the company in maintaining a work environment focused on
quality, communication, collaboration, integration, and teamwork.
- Created and achieved product quality objectives, ensuring adherence
to product specifications.
- Fixed identified issues to increase productivity and streamline workflows.
- Wrote and maintained detailed internal documentation on developed
.
systems.
- Designed, documented, and executed test scenarios to identify software
bugs.
• Improved application stability through proactive monitoring, issue identification, and prompt resolution of incidents.
• Assisted in the development of user guides and knowledge base articles for increased self-service capabilities.
• Streamlined support processes for improved end-user experience and reduced resolution times.
• Supported end-users in navigating complex applications, guiding them through features and functions while troubleshooting issues as needed.
• Contributed to application testing efforts, identifying defects and collaborating with developers on fixes prior to release.
• Continuously updated technical skills through training sessions, industry certifications, and participation in relevant conferences to provide top-notch support for evolving technologies.
• Enhanced application performance by identifying and resolving technical issues in a timely manner.
• Conducted root cause analysis on recurring incidents to identify opportunities for improvements in application design or support procedures.
• Developed custom scripts for automating routine tasks resulting in increased efficiency within the team''s daily operations.
• Provided comprehensive training for users to ensure smooth adoption of new applications and features.
DOMAIN: Digital Signage Software
QA testing
Mysql
Linux
Windows
Puuty
WinScp
S3 browser
Firebase
Postman
DSS
Advanced SQL Database Administration
Advanced SQL Database Administration
MySQL Data Analysis & Business Intelligence
MySQL Database Administration: Beginner SQL Database Design
Beginner MySQL Business Intelligence
LINUX COMMAND LINE