Database Developer

Mexico City, MXFull-timeRemoteAbout UsThe Ksquare Group was established in 2014 in Dallas TX, we are an international company with a presence in different countries such as Mexico, the USA, India, and Dominican Republic currently being more than 250 Ksquarians and growing. We offer technological solutions through multidisciplinary Pods specifically designed to meet our customer’s needs. Depending on the skills required by every project, the best professionals are selected to bring all their talent together into achieving mutual goals. We authentically care about the comfort, wellbeing, and career growth of all our employees making sure integrity, innovation, leadership, accountability, and collaboration continuously stand by one and each one of us. We believe and trust all our outstanding professionals and realize how special they are but what makes us even special is the family we have become through the years.Job Summary**Responsibilities**:Management reserves the right to add, modify, change, or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the essential functions of the job.Creates scripts and packages for data integration, synchronization, data maintenance, CDC, or bug fixes.Analyzes, defines, and documents system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.Solves complex problems and takes a broad perspective to identify solutions.Leads projects and provides guidance to functional teams as needed.Good working knowledge of performance turning of complex SQL queries to make things faster, better, easier to maintain and manage as per business requirements.Ability to understand business requirements, write complex queries to generate reports as neededResponsible for administrative maintenance of relational database systems.Applies understanding of relational database concepts and query languages to design required summary or aggregation tables to support analysis.Writes and maintains functional and technical specifications. Interprets internal or external issues and recommends solutions/best practices.Performs other job-related duties as assigned.**Requirements**:Bachelor's Degree in Computer Systems Engineering or related fields.**Experience**: Minimum of four (4) years of experience in database development, including data conversion, integration, and synchronization.Database Table Management, Code/Modify/Troubleshoot Stored Procedures, Functions, Documentation, Schedule maintain/modify Database jobs, Performance Tuning.Experience with T-SQL, CDC, SSIS, SSRS, SQL 2008, 2012, 2014, 2016, 2022.Knowledge of Data modeling and design principles; integration and synchronization techniques; database tasks (job scheduling, performance tuning); analysis and reporting tools; scripting languages (e.g., Python, Perl); version control systems (e.g., Git).Skill in Writing complex SQL queries and stored procedures; analysis and problem-solving; attention to detail and accuracy; managing multiple projects and priorities; identifying, troubleshooting, and resolving database issues; documenting technical processes and solutions.Ability to Design and implement efficient database solutions; collaborate with other departments and vendors; remain up to date with new technologies and best practices; take initiative and ownership of projects; communicate complex technical concepts to diverse audiences.The Ksquare Group does not and shall not discriminate based on race, color, religion, gender, gender expression, age, national origin, disability, marital status, sexual orientation, or military status, in any of its activities or operations. These activities include, but are not limited to, hiring, and firing of staff, selection of volunteers and vendors, and provision of services. We are committed to providing an inclusive and welcoming environment for all members of our staff, clients, volunteers, subcontractors, vendors, and clients. As an equal opportunity employer. We will not discriminate and will take affirmative action measures to ensure against discrimination in employment, recruitment, advertisements for employment, compensation, termination, upgrading, promotions, and other conditions of employment against any employee or job applicant on the bases of the conditions previously mentioned.Why will you love working with us?We thrive to reach out to tomorrow.We are a world class team who work together across cultures and disciplines.Transparency and challenging projects that will let you grow and learn.We offer to you trust, sensibility and welfare, because you are important to us.