3+ MySQL DBA Jobs in Jaipur | MySQL DBA Job openings in Jaipur

Job Description

POSITION: Quality Assurance Automation Analyst

DESCRIPTION:

The Quality Assurance Automation Analyst works with the QA staff to perform Quality Assurance Automation planning, application testing and developing scripts using established automated testing tools before and after production implementation. Focus on creating test scripts, and frameworks and executing functional, regression and end-to-end automated scripts for products' front-end and back-end applications. This role is responsible for executing the automated regression tests before release and on demand. The candidate should be willing to step into a Manual QA role and perform Manual Testing on a need basis.

RESPONSIBILITIES:

• Accountable for the Quality Automation planning and testing of the application for the assigned projects.
• Performs timely reporting of planning and testing efforts.
• Develop and maintain automated scripts for all product testing using Selenium WebDriver with Java implementation. 
• Develop manual and automated test cases/scripts.
• Able to shift between Automation and Manual Testing tasks on a need basis.
• With support from QA staff and the configuration team, writes and executes test cases for the projects assigned.
• Achieves and maintains excellent content knowledge of assigned products.
• Perform daily; weekly, monthly and on-demand execution automated regression tests.
• Identify and document issues found in modules and products during automated regression to assist with easy recreation.
• Communicate daily and weekly progress.
• Collaborates with management to continuously provide input to improve the QA process.
• Performs other duties as assigned.

REQUIREMENTS:

• Minimum of 3-5 years of experience in software testing with 2-3 years of experience in developing automation scripts using Selenium Web Driver.

• Saas industry experience is preferred

• Experience in developing Automation Frameworks from scratch. 

• Strong in Java programming (Core JAVA) 

• Experience using Selenium Grid is preferred.

• Good knowledge of Web Services.

• Working knowledge of web technologies including basic knowledge HTML, CSS, JavaScript, and DOM

• Experience in QA Methodologies - Agile preferred

• Experience in analysing requirements & create Test scenarios.

• Knowledge of Defect Management Process & Defect lifecycle.

• Working knowledge of Test Management Tool.

• Working knowledge of database (e.g. MySQL).

Roles and Responsibilities 

Build database systems of high availability and quality depending on each end user’s specialised role

Design and implement database in accordance to end users information needs and views

Define users and enable data distribution to the right user, in appropriate format and in a timely manner

Use high-speed transaction recovery techniques and backup data

Minimise database downtime and manage parameters to provide fast query responses

Provide proactive and reactive data management support and training to users

Determine, enforce and document database policies, procedures and standards

Perform tests and evaluations regularly to ensure data security, privacy and integrity

Skills

Proven working experience as a Database Administrator

Hands-on experience with database standards and end user applications

Excellent knowledge of data backup, recovery, security, integrity and SQL

Familiarity with database design, documentation and coding

Previous experience with DBA case tools (frontend/backend) and third party tools

Problem solving skills and ability to think algorithmically

Degree in a computer discipline or relevant certification

About this role

We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career.  You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and  MongoDB/ Cassandra.

What You’ll Do

• Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team. 
• Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
• Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
• Work with our developers to optimize and tune their SQL queries.
• Assist in application development, debugging, and optimization with respect to data concerns.
• Provide input in the design and implementation of backup, recovery, and DR strategy
• Review application and database design for compliance.

What You’ll Need

• Ability to script in a high-level language like Python, Ruby, etc for Automation. 
• 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.
• 4+ years of experience in database design and DevOps on AWS.
• Must demonstrate a clear understanding of logical and physical database design and standards. 
• Experience in columnar data warehouse solutions like Redshift or Snowflake. 
• Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.
• Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience

Bonus Points If You Have

• Experience with NoSQL solutions such as Cassandra/MongoDB etc.
• Experience with software development life cycle (SDLC) in an agile environment
• Hands-on production experience with Big Data applications such as Spark.
• Knowledge of development best practices (source control with Git, continuous integration, automated testing).