Unit, Application and Load Tester for SQL (Freelancer)

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.

We are seeking a skilled and experienced SQL Unit, Application, and Load Testing Specialist to join our team. As a SQL Testing Specialist, you will be responsible for ensuring the quality and reliability of our SQL-based applications and systems through comprehensive unit testing, application testing, and load testing. Your expertise will contribute to the delivery of robust, high-performance, and scalable database solutions.

What you will do?

• Develop and execute thorough unit test plans and test cases for SQL queries, stored procedures, triggers, and other database components.
• Verify data accuracy, integrity, and consistency through rigorous testing methodologies.
• Identify and document defects, inconsistencies, and performance bottlenecks for resolution.
• Collaborate with software development teams to understand SQL-based application requirements and functionality.
• Design and implement effective test scenarios, scripts, and test cases to validate application behaviour.
• Conduct functional, regression, and integration testing for SQL-based applications.
• Perform data validation and ensure seamless integration with other systems.
• Plan, develop, and execute load testing strategies to assess the performance and scalability of SQL databases.
• Monitor and analyze system performance under various load conditions.
• Identify and address performance issues, bottlenecks, and potential scalability problems.
• Generate detailed reports with performance metrics, analysis, and recommendations.
• Documentation and Reporting:
• Create and maintain comprehensive test documentation, including test plans, cases, and results.
• Collaborate with cross-functional teams to provide clear, concise reports on testing activities, findings, and recommendations.
• Contribute to the continuous improvement of testing processes, methodologies, and tools.

What are we looking for?

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven work experience as a SQL Tester or Database Quality Assurance Specialist.
• Strong knowledge of SQL, relational databases, and query optimization techniques.
• Experience with testing frameworks and tools, such as SQLUnit, JUnit, or similar.
• Proficiency in writing complex SQL queries, stored procedures, and triggers.
• Familiarity with database management systems (DBMS) like MySQL, Oracle, or SQL Server.
• Understanding of software development life cycle (SDLC) and testing methodologies.
• Knowledge of performance testing tools like JMeter or LoadRunner is a plus.
• Excellent analytical thinking and problem-solving abilities.
• Strong attention to detail and ability to identify edge cases and potential risks.
• Capacity to analyze performance data and recommend optimizations.
• Effective verbal and written communication skills.
• Ability to collaborate with cross-functional teams, developers, and stakeholders.
• Proactive attitude, with a focus on teamwork and knowledge sharing.

Life at Mactores

We care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.

1. Be one step ahead

2. Deliver the best

3. Be bold

4. Pay attention to the detail

5. Enjoy the challenge

6. Be curious and take action

7. Take leadership

8. Own it

9. Deliver value

10. Be collaborative

We would like you to read more details about the work culture on https://mactores.com/careers 

The Path to Joining the Mactores Team

At Mactores, our recruitment process is structured around three distinct stages:

Pre-Employment Assessment: 

You will be invited to participate in a series of pre-employment evaluations to assess your technical proficiency and suitability for the role.

Managerial Interview: The hiring manager will engage with you in multiple discussions, lasting anywhere from 30 minutes to an hour, to assess your technical skills, hands-on experience, leadership potential, and communication abilities.

HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.

At Mactores, we are committed to providing equal opportunities in all of our employment practices, and we do not discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This policy extends to all aspects of the employment relationship, including recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs. All employment decisions will be made in compliance with these principles.

Note: Please answer as many questions as possible with this application to accelerate the hiring process.