Empresa

CIKUME, S.A. DE C.V.

Descripción de la Empresa

Edición, diseño y desarrollo de programas informáticos

Departamento

San Salvador

Localidad

San Salvador

Salario

2450

Tipo de Contratación

Tiempo Completo

Descripción de la Plaza

Looking for a Data Analyst with commercial experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server, PostgreSQL, and BI suite (Development, UAT and Production Environment).

Requisites:
• Strong technical knowledge in PostgreSQL Server and Microsoft SQL Server
• Worked Extensively on ETL process.
• Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.


Good to have:
• PostgreSQL replication system supporting cascading.
• Expertise in writing complex MDX, DMX and XMLA queries with PostgreSQL.
• PostgreSQL Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL/PL/SQL/SQL Lexicon, Stored Procedures, Functions and Cursors and Triggers
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Microsoft Analysis Services.
• SQL BI Developer/ Power BI/ Data Analyst

Mínimo Nivel Académico Requerido

Universidad Completa

Mínimo Nivel de Inglés Requerido

Excelente

Mínima Experiencia Laboral Requerida

3-4 años
Búsquedas Relacionadas
Empleos en San Salvador