Database Migration Engineer

3 semanas atrás


Brazil, BR Mactores Tempo inteiro

Mactores is looking for a highly skilled and experienced Database Migration Engineer (Administrator) to lead and execute the migration project from MS SQL Server to PostgreSQL. The ideal candidate will lead hands-on execution of migrating database tables, schema, and data from MS SQL Server to PostgreSQL. The candidate will also be responsible for performing DBA tasks on PostgreSQL database post-migration.


Responsibilities:

  • Collaborate with stakeholders to understand project requirements and formulate a comprehensive migration plan, ensuring a smooth transition from MSSQL to Postgres.
  • Conduct a detailed analysis of the existing MSSQL database, identifying areas for optimization and performance enhancement before and after migration.
  • Lead the execution of the migration process, overseeing the transfer of data from MSSQL to Postgres, and ensuring data integrity and minimal downtime.
  • Implement monitoring solutions to track the performance of the Postgres database, optimizing and fine-tuning as necessary for optimal system efficiency.
  • Ensure the security of the migrated database by implementing robust access controls, encryption, and other security measures aligned with best practices.
  • Develop and implement comprehensive backup and recovery plans to safeguard data during and post-migration, ensuring minimal data loss in case of unforeseen events.
  • Collaborate closely with application developers and other cross-functional teams to address any application-specific considerations and optimize database interactions.
  • Create detailed technical documentation outlining the migration process, configurations, security measures, and recovery procedures. Provide knowledge transfer sessions to internal teams.
  • Proactively identify and troubleshoot issues during the migration process, providing timely and effective solutions to ensure project success.
  • Manage the end-to-end migration process from MS SQL Server to PostgreSQL, ensuring minimal downtime and maximum efficiency.
  • Execute the migration of database tables, schemas, and data, ensuring data integrity, consistency, and accuracy.
  • Assume responsibility for performing Database Administrator (DBA) tasks on the migrated PostgreSQL database, including performance tuning.


Requirements:

  • 3+ years of hands-on experience in database administration, with a proven track record of leading and executing database migration projects.
  • Extensive expertise in MS SQL Server and PostgreSQL database management, including migration tools, techniques, and best practices.
  • Strong proficiency in SQL, database design, performance tuning, and optimization.
  • Excellent problem-solving skills with a keen attention to detail and a results-driven mindset.
  • Exceptional communication, collaboration, and interpersonal skills, with the ability to work effectively in a fast-paced, dynamic environment.


If you are a seasoned Database Migration Engineer (Administrator) with a passion for executing complex migration projects and possess a solid background in MSSQL and Postgres administration, we encourage you to apply and be a key contributor to the success of this migration initiative at Mactores.



  • Brazil, BR Mactores Tempo inteiro

    We are seeking a skilled AWS Database Migration Engineer to join our team. The ideal candidate will have extensive experience in migrating licensed databases such as Oracle and MSSQL to open-source databases like Aurora PostgreSQL or MySQL on Amazon Web Services (AWS). The candidate should have a minimum of 5 years of experience in database administration...


  • Brazil, BR Sigma Software Group Tempo inteiro

    We are looking for a well-rounded Senior Database Reliability Engineer who will be responsible for the daily operations, ensuring the seamless functioning of databases. This includes executing regular maintenance tasks to enhance performance and establishing routine backup strategies for securing critical data. The position involves investigating and...

  • Lead Data Engineer

    1 semana atrás


    Brazil, BR Mindera - Brazil Tempo inteiro

    Here at Mindera, we are continuously developing a fantastic team and would love it for you to join us. We are looking for experienced engineers with an appetite for solving complex problems and building seamless user interactions to world-class standards.As a Data Engineer, you will be responsible for building, maintaining, scaling, and integrating big...


  • Brazil, BR Langham Recruitment Tempo inteiro

    Senior Online Services Engineer | AAA Gaming Studio | Up to $120k CAD | Fully RemoteLangham are delighted to represent the opportunity for a Senior Online Services Engineer to join a highly reputable AAA-rated gaming studio.With leadership from some of the most well know global gaming companies, this studio works collaboratively as an embedded part of their...

  • SR Engineer

    2 semanas atrás


    Brazil, BR Aloware Tempo inteiro

    **THIS POSITION IS OPEN TO ALL LATAM COUNTRIES**About Us:Founded in 2018, Aloware is a dynamic and fast-growing contact center as a software (CCaaS) startup that has achieved a remarkable 100% year-over-year growth for the past three years. Our transformative calling and texting software caters to a diverse array of industries, primarily serving mid-market...

  • Windows System Engineer

    1 semana atrás


    Brazil, BR iVedha Inc. Tempo inteiro

    MICROSOFT SYSTEM ENGINEERCompany DescriptioniVedha Inc. is a leading NextGen software-powered global cloud managed services provider and managed hybrid cloud services provider. With a reputation for providing innovative solutions, iVedha empowers businesses on their digital transformation journey through disruptive technologies. The company serves clients...

  • MS SQL Engineer

    Há 1 mês


    São Paulo, Brazil, BR Hyqoo Tempo inteiro

    Job Title: My SQL Engineer Location: Hybrid (San Jose Campus Office- 2 days a week) This role ensures operational excellence by maintaining a stable, secure, compliant, and highly available database platform. This role requires a mix of strong hands-on technical skills in automation scripting, solution engineering, platform integration, database...


  • Brazil, BR LawnStarter Tempo inteiro

    LawnStarter is the nation's leading on-demand marketplace for lawn care and related services, allowing hundreds of thousands of customers nationwide to book a service with the tap of a button. But lawn care is only the beginning - our vision is to become the one-stop shop for all home services.Our company is flourishing at an incredible pace, profitable...

  • Data Analyst

    2 semanas atrás


    Brazil, BR Infogain - LATAM Tempo inteiro

    Highly skilled data analyst SQL DB developerThe ideal candidate will be responsible for designing, developing, and maintaining efficient databases and data systems to support data analytics and reporting requirements.Responsibilities:Design and develop data models, database schemas and data pipelines with SQLConduct data analysis of large, complex datasets...

  • Data Engineer

    Há 1 mês


    São Paulo, Brazil, BR CriticalRiver Inc. Tempo inteiro

    Title: Data EngineerLocation: Sao Paulo BrazilRemote: Need to Support in USA PST time zoneDuration: Fulltime Interview process:Live Hacker rank test on Advanced SQL questions.Technical screeningClient live Hacker rank interview. Summary:Need a minimum of 6 years experience in SQL, with hands-on experience in writing complex queries and optimizing database...


  • Brazil, BR Buchanan Technologies Tempo inteiro

    Please note; this is open to candidates throughout LATAM. Salary is up to $50,000 USD with benefits. Opportunity DetailsBuchanan Technologies is seeking an experienced Cloud Infrastructure Engineer to assist our business customers with our Managed Service Cloud offerings. This role will use ones operational, tactical, and technical experience to build strong...

  • SQA Engineer

    3 semanas atrás


    Brazil, BR Telit Cinterion Tempo inteiro

    Primary Objective:We are looking for a detail-oriented and proactive Software Test Engineer to join our dynamic team. The ideal candidate will be responsible for designing, implementing, and executing test plans, identifying and documenting software defects, and collaborating closely with the development team to ensure the delivery of high-quality software...

  • Technical Support Engineer

    2 semanas atrás


    Brazil, BR Sumsub Tempo inteiro

    Sumsub is the one verification platform to secure the whole user journey. With Sumsub’s customizable KYC, KYB, transaction monitoring and fraud prevention solutions, you can orchestrate your verification process, welcome more customers worldwide, meet compliance requirements, reduce costs and protect your business.Sumsub has over 2,000 clients across the...

  • Full Stack Engineer

    Há 4 dias


    Brazil, BR Flatiron Software Co Tempo inteiro

    Job Title: FULL STACK DEVELOPER (REMOTE)About:Flatiron is a global remote software development company with engineers located around the world. We unite experts from diverse backgrounds and experiences in a collaborative culture to deliver exceptional products and services for our clients. As a forward-thinking software engineering company, we provide...

  • Sales Engineer

    Há 4 dias


    São Paulo, Brazil, BR MicroStrategy Tempo inteiro

    MicroStrategy is a pioneer in the BI + AI industry that transforms organizations into smarter businesses through its innovative data-driven solutions. Our success is built on the talent and energy of smart, engaged people.Job DescriptionIf you have a natural passion for new technology, innovation, and new solutions, the Sales Engineer position at...

  • Computer Vision Engineer

    1 semana atrás


    Brazil, BR Glacier Tempo inteiro

    Glacier is a seed-stage startup based in San Francisco that builds in-house computer vision models to power two core products:a robot that identifies and sorts materials inside recycling facilitiesan analytics system that tracks recyclables and reports metrics to key stakeholders in the industry.These technologies are already helping to divert tons of...


  • São Paulo, Brazil, BR o9 Solutions, Inc. Tempo inteiro

    Be Part Of Something RevolutionaryWe have a vision. Our Digital Brain, o9’s AI-powered platform, is being used by global enterprises to drive their digital transformations. The integrated planning and operational efficiencies we provide is helping businesses do more, be more and mean more to the world at large. Because businesses that plan better, reduce...

  • Specialist Golang Developer

    1 semana atrás


    Brazil, BR Mindera - Brazil Tempo inteiro

    Here at Mindera, we are continuously developing a fantastic team and would love for you to join us.We’re looking for Golang Developers with extensive experience who have an appetite for solving complex and interesting problems. Our focus is to develop with high standards, having operational aspects in mind (metrics collection, tracing, etc.) with a...


  • São Paulo, Brazil, BR Canadian Solar Inverter Tempo inteiro

    MAIN PURPOSE AND KEY RESPONSIBILITIES:1. Responsible for answering technical/product questions from sales/customers to provide product solution.2. Responsible for coordinating with related depts to output the deliverable materials for each milestone stage of product launch, including but not limited to product specifications, installation manual and...


  • São Paulo, Brazil, BR Clever Devices Tempo inteiro

    As THE leader in transit technology, Clever Devices' vision is to make meaningful contributions to worldwide mobility. Our goal is to be the leading provider of exciting technology that improves the quality of mobility in communities around the world. We are continuing to grow, and are looking for a System Support Engineer.Job Summary:The System Support...