Senior Data Engineer

Basic English A2, Database, DBA, Engineer, Technology
Latam
July 23, 2024
Full Time
Urgent

Apply for this job

Email *
Full Name *
CV Attachment *
Browse

Upload file .pdf, .doc, .docx

Job Description

We are seeking an experienced Database Administrator to join our team. The ideal candidate will possess advanced knowledge in installing database engines on Windows and Linux platforms and be proficient in managing both relational and non-relational databases. This role focuses on optimizing database performance, managing backups, and ensuring data integrity and availability across various environments. Experience in leading technical projects and working within agile methodologies is also required.

Main Responsibilities:

  • As a Database Administrator, you will be responsible for installing and configuring database systems, including SQL Server, PostgreSQL, and Oracle, on Windows and Linux platforms. You will manage both relational and non-relational databases, handle backups, restorations, and recovery operations, and optimize database performance, including tuning stored procedures, materialized views, regular views, and tables.
  • You will be expected to develop and maintain stored procedures and views, ensuring the integrity and security of the databases. You will manage databases across different environments, such as Development, QA, and Production, ensuring smooth migrations and deployments. Designing and implementing ETL processes and integrating data from various sources will be a key part of your role, ensuring data consistency and accuracy. You will lead technical projects, ensuring timely delivery and adherence to project goals, while utilizing agile methodologies for project management and team collaboration.
  • It will be essential to utilize basic AWS services, such as S3, EC2, RDS, Redshift, Glue, and Athena, for managing data lakes and other database-related tasks. Additionally, you will lead and mentor a team of database administrators and developers, fostering a collaborative and productive team environment.

Requirements:

  • The ideal candidate will have advanced knowledge of database installations on Windows and Linux, with proficiency in managing SQL Server, PostgreSQL, and Oracle databases. Experience with both relational and non-relational databases is crucial, along with strong knowledge of stored procedures, materialized views, and regular views.
  • Experience in SQL query optimization and performance tuning is required, as is familiarity with JDBC, ODBC, and ODATA connections. The candidate should have experience in ETL processes and data integration, as well as managing database backups, restorations, and disaster recovery. Proficiency in PL/SQL is necessary, alongside experience in technical project management and agile methodologies. Basic knowledge of AWS services related to data lakes, such as S3, EC2, RDS, Redshift, Glue, and Athena, is required, along with proven experience in leading and mentoring teams.

Desirable Skills:

  • Desirable certification in database management or related fields,
  •  Advanced knowledge of additional database systems.
  • Experience with data warehousing and big data technologies.
  • Strong scripting and automation skills.
  •  Familiarity with cloud database solutions.

Benefits:

  • Competitive salary.
  • Remote work options.
  •  Opportunities for professional growth and development.
  •  Access to courses and certifications

Related Jobs