Esta oferta de trabajo no está disponible en tu país.

Senior Database Engineer

ScioColonia México, Mexico

Hace 6 días

Descripción del trabajo

2 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

We’re a dynamic team at one of the Best Places to Code companies based in Mexico. Our mission? To create fully-fledged platforms using a wide range of tools and technologies.

Keep reading if you’re passionate about clean, elegant code and love collaborating with experts!

What We’re Looking For : Senior Database Engineer

4+ years’ experience in database design, development, and management, including knowledge of SQL and one or more database management systems such as Oracle, SQL Server, or MySQL.
Strong and recent experience in MS SQL Server with a focus on :

T-SQL (stored procedures development and maintenance)

Performance optimization : index fragmentation, interpreting execution plans, query optimization

SSIS, creating packages, troubleshooting, and performance optimization

4+ years’ experience in data warehouse, data modeling, ETL, BI projects

Strong and recent experience in Power BI

Handling multiple data sources

Data transformation (Power Query, M Language)

DAX (Data Analysis Expressions)

4+ years’ SQL experience with the ability to develop, tune and debug complex SQL applications is required

Knowledge in schema design, developing data models and proven ability to work with complex data is required

Understanding of best practices for building different data architectures including a Data Mesh, Data Fabric, Data Lake, Data Warehouse and supporting analytical architectures.

Good interpersonal, analytical, problem-solving, and organizational skills

Responsibilities

Designing and developing databases : The senior database developer is responsible for designing and developing efficient, secure, and scalable databases / marts to meet the organization's needs. This involves creating data models, tables, indexes, and other database objects.

Writing database scripts and queries : A database developer is responsible for writing SQL scripts and queries to extract, manipulate, and manage data. They must ensure that the queries are optimized for performance and security.

Designing, reengineering, and troubleshooting advanced MS SQL queries, Power BI dashboards, and SSIS (SQL Server Integration Services) packages.

Creating / updating ETL (Extract, Transform, Load) specifications and supporting documentation

Collaborate on the design & build of a reporting data infrastructure

Interface with product owners and key stakeholders in Project Management, Business, QA, and Technology Operations to ensure high quality delivery of software projects

Work with business analysts to understand business requirements and use cases

How to Apply : If this sounds like the perfect fit for you, send your resume in English to humancapital@sciodev.com. We’ll keep you updated throughout the process.

Feel free to reach out if you have any questions or need further details!

Seniority level

Seniority levelMid-Senior level

Employment type

Employment typeFull-time

Job function

Job functionInformation Technology

IndustriesIT Services and IT Consulting

Referrals increase your chances of interviewing at Scio by 2x

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Crear una alerta de empleo para esta búsqueda

Senior Database Engineer • Colonia México, Mexico