Manuel is a Senior IT professional with 8+ years of industry experience in different roles; combining software quality assurance, software testing, and database management in delivering high-quality solutions for clients. He applies the lastest system engineering principles and best practices throughout the lifecycle of projects - building and improving its reliability and facilitating positive outcomes.
Provide designs, guidance and support for performance tuning and optimization of development operations of database backend systems.
Handle the automation of day-to-day management functions on projects; working on advanced troubleshooting including diagnostics and resolution of issues.
Provide off-hours support on projects including being on call when needed.
Executed periodic data loads and provided support for various mission-critical web-based projects within Newtech by applying expertise in backup, restore processes and user access.
Oversaw project management tasks to ensure successful planning and execution of all projects assigned and wrote T-SQL scripts and Stored Procedures to automate database administration.
Provided end-to-end database support to teams on projects, troubleshot and fixed databases when unexpected problems arose and delivered components to meet project deadlines.
Worked as a member of the software development team; supporting and assisting projects with test plans, cases and processes requirements.
Handled various testing methods on projects; validating requirements and delivering QA reports that determine product quality and release readiness within Newtech.
Documented software defects using a bug tracking system; flagging bugs and relaying issues to software engineers.
Created, maintained and ran test cases/test scripts in ALM and implemented quality standards on test plans, cases and functional requirements.
Conducted manual or automated testing on different software solutions and reviewed user requirement documents to ensure that requirements are testable.
Wrote custom SQL queries to capture and produce data samples on projects.
Produced database solutions for the data modernization project;
handling the design of scripts, iterating new database objects to ensure data integrity, writing unit tests on all scripts to check naming conventions per the client's documentation, and produce solutions to ensure that table dependency on the project is addressed.
Oversaw the maintenance of all the databases that support the core functionality of the application; handling tasks on database sync, integrity, data and performance. Wrote scripts to handle data insertion and deployment to testing and staging environments - including backup, data mockup, and deployment as well as the configuration of those environments.
Handled the separation of the previous project into two separate versions of the solution - using different environments to ensure data consistency; through data consistency by writing data insertions, mockup, and configuration scripts. Worked with the QA team to ensure successful database deployment - testing the core functionality.
