SQL Developer

hace 4 semanas

CiudaddeMéxicoToreo, México Zurich Insurance Company Ltd. A tiempo completo

Zurich Capability Center is currently hiring a:

SQL Developer

  1. SQL Proficiency: Strong command over SQL (Structured Query Language), including knowledge of querying, filtering, joining, and aggregating data.
  2. Database Design: Understanding of database design principles such as normalization, indexing, and schema optimization.
  3. Database Management Systems (DBMS): Experience with various DBMS platforms like Oracle, SQL Server, PostgreSQL, etc.
  4. Stored Procedures and Functions: Proficiency in writing and optimizing stored procedures, user-defined functions, triggers, and views.
  5. Performance Tuning: Skills to optimize SQL queries and database performance through indexing, query rewriting, and database configuration.
  6. ETL (Extract, Transform, Load): Familiarity with ETL processes to efficiently move and transform data between systems.
  7. Troubleshooting and Debugging: Ability to diagnose and resolve database-related issues like slow queries, locking, and concurrency problems.
  8. Advanced English level: Mandatory

 

Good to have:

  1. Version Control: Understanding of version control systems (e.g., Git) for managing database schema changes and SQL scripts.
  2. Data Security: Knowledge of SQL security best practices, including user management, permissions, and data encryption.
  3. Data Modeling: Ability to create efficient data models and ER diagrams to represent database structures.

 

MySQL Skill Set (Specific to MySQL):

  1. Installation and Configuration: Experience in installing and setting up MySQL server and client applications.
  2. SQL Syntax for MySQL: Proficiency in using MySQL-specific SQL syntax, functions, and data types.
  3. MySQL Workbench: Familiarity with MySQL Workbench for database design, administration, and development tasks.
  4. Performance Optimization: Knowledge of MySQL-specific performance tuning techniques such as query caching, indexing strategies, and configuration settings.
  5. MySQL Security: Ability to configure MySQL security settings, manage user privileges, and implement encryption.
  6. Database Monitoring: Experience with monitoring MySQL database performance and health using tools like MySQL Enterprise Monitor or open-source alternatives.
  7. Stored Procedures and Triggers: Proficiency in creating stored procedures, functions, and triggers using MySQL syntax

 

Good to have:

  1. Replication and Clustering: Understanding of MySQL replication for high availability and scalability, as well as clustering options.
  2. Backup and Recovery: Skills to perform database backups and implement recovery strategies using tools like mysqldump or MySQL Enterprise Backup.
  3. High Availability Solutions: Knowledge of MySQL high availability solutions like MySQL InnoDB Cluster or Percona XtraDB Cluster.

 

Other expectations:

  • Experience with JSON
  • Experience with job schedulers
  • Ability to Support / Perform End-to-End Testing
  • Developers must have excellent analytical skills to understand the business requirements and design the software according to their needs
  • Attention to details, problem-solving and critical thinking abilities
  • Functional knowledge in Insurance industry is a huge plus.

 

Who we are 

 Looking for a challenging and inspiring work environment where you can make a difference? At Zurich millions of individuals and businesses place their trust in our products and services every day. Our 53,000 employees worldwide form the basis of our success, enabling, businesses and communities to face a world of risk with confidence. Imagine if you could help people do this all over the world. You’d give them confidence and reassurance by protecting what they love most. It’s a big challenge, but you will be supported by a world-class team who believe in helping you to reach your full potential and deliver on our promises. 

So be challenged. Be inspired. Help us make a difference. 

At Zurich we are an equal opportunity employer. We attract and retain the best qualified individuals available, without regard to race/ethnicity, religion, gender, sexual orientation, age, or disability

. 

  • SQL Developer

    hace 3 semanas

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a: SQL Developer SQL Proficiency: Strong command over SQL (Structured Query Language), including knowledge of querying, filtering, joining, and aggregating data. Database Design: Understanding of database design principles such as normalization, indexing, and schema optimization. Database Management...

  • M365 Senior Developer

    hace 2 meses

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a:M365 Senior DeveloperYour Skills and Experience As a M365 Developer, your skills and qualifications will ideally include: Position requires a Bachelor's degree, or foreign equivalent, in Computer Science, Applied Computer Science, or a closely related field of study, plus 5 years of experience in the job...

  • M365 Senior Developer

    hace 3 semanas

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a:M365 Senior DeveloperYour Skills and Experience As a M365 Developer, your skills and qualifications will ideally include: Position requires a Bachelor's degree, or foreign equivalent, in Computer Science, Applied Computer Science, or a closely related field of study, plus 5 years of experience in the job...

  • M365 Senior Developer

    hace 2 meses

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a: M365 Senior Developer Your Skills and Experience   As a M365  Developer, your skills and qualifications will ideally include:     Position requires a Bachelor’s degree, or foreign equivalent, in Computer Science, Applied Computer Science, or a closely related field of study, plus 5...

  • M365 Senior Developer

    hace 3 semanas

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a: M365 Senior Developer Your Skills and Experience   As a M365  Developer, your skills and qualifications will ideally include:     Position requires a Bachelor’s degree, or foreign equivalent, in Computer Science, Applied Computer Science, or a closely related field of study, plus 5...

  • Net Developer

    hace 2 semanas

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability center is looking for : Web Developer Job Description Acts in the highest level technical role as an individual contributor and/or team lead for the most complex computer applications and/or application initiatives. Utilizes a thorough understanding of available technology, tools, and existing designs. Works on the most complex...

  • Net Developer

    hace 1 semana

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability center is looking for : Web Developer Job Description Acts in the highest level technical role as an individual contributor and/or team lead for the most complex computer applications and/or application initiatives. Utilizes a thorough understanding of available technology, tools, and existing designs. Works on the most complex...

  • .Net Developer

    hace 2 meses

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability center is looking for :     Web Developer       Job Description Acts in the highest level technical role as an individual contributor and/or team lead for the most complex computer applications and/or application initiatives.  Utilizes a thorough understanding of available technology, tools, and existing...

  • .Net Developer

    hace 3 semanas

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability center is looking for :     Web Developer       Job Description Acts in the highest level technical role as an individual contributor and/or team lead for the most complex computer applications and/or application initiatives.  Utilizes a thorough understanding of available technology, tools, and existing...

  • Sharepoint Developer

    hace 1 día

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a: SHAREPOINT DEVELOPER About the Role:   In depth knowledge of SharePoint admin portal and app development in the SharePoint eco system Ability to create/ modify and customize native SharePoint applications as well as SharePoint power apps and power automate SharePoint Development skills with SPFX...

  • Desarrollador Mobile

    hace 2 meses

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a:                                                                                                                                       Mobile Developer   As a Senior Developer, your main responsibilities will...

  • Desarrollador Mobile

    hace 3 semanas

    CiudaddeMéxico-Toreo, México Zurich Insurance Company Ltd. A tiempo completo

    Zurich Capability Center is currently hiring a:                                                                                                                                       Mobile Developer   As a Senior Developer, your main responsibilities will...