Sql Database Developer

OverviewSQL Database Developer role at Zurich Insurance.Zurich Capability Center is currently hiring a SQL Database Developer.Skill SetSQL 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 Systems (DBMS) : Experience with various DBMS platforms like Oracle, SQL Server, PostgreSQL, etc.Stored Procedures and Functions : Proficiency in writing and optimizing stored procedures, user-defined functions, triggers, and views.Performance Tuning : Skills to optimize SQL queries and database performance through indexing, query rewriting, and database configuration.ETL (Extract, Transform, Load) : Familiarity with ETL processes to efficiently move and transform data between systems.Troubleshooting and Debugging : Ability to diagnose and resolve database-related issues like slow queries, locking, and concurrency problems.Good to haveVersion Control : Understanding of version control systems (e.g., Git) for managing database schema changes and SQL scripts.Data Security : Knowledge of SQL security best practices, including user management, permissions, and data encryption.Data Modeling : Ability to create efficient data models and ER diagrams to represent database structures.MySQL Skill Set (Specific to MySQL)Installation and Configuration : Experience in installing and setting up MySQL server and client applications.SQL Syntax for MySQL : Proficiency in using MySQL-specific SQL syntax, functions, and data types.MySQL Workbench : Familiarity with MySQL Workbench for database design, administration, and development tasks.MySQL Security : Ability to configure MySQL security settings, manage user privileges, and implement encryption.Database Monitoring : Experience with monitoring MySQL database performance and health using tools like MySQL Enterprise Monitor or open-source alternatives.Stored Procedures and Triggers : Proficiency in creating stored procedures, functions, and triggers using MySQL syntax.Good to have (MySQL)Replication and Clustering : Understanding of MySQL replication for high availability and scalability, as well as clustering options.Backup and Recovery : Skills to perform database backups and implement recovery strategies using tools like mysqldump or MySQL Enterprise Backup.High Availability Solutions : Knowledge of MySQL high availability solutions like MySQL InnoDB Cluster or Percona XtraDB Cluster.Other expectationsExperience with JSONExperience with job schedulersAbility to Support / Perform End-to-End TestingDevelopers must have excellent analytical skills to understand the business requirements and design the software according to their needsAttention to details, problem-solving and critical thinking abilitiesFunctional knowledge in Insurance industry is a huge plus.LocationPosition available only for candidates located in Mexico City, State of Mexico, or Guadalajara.

Please apply only if you reside in one of these areas.Who We AreLooking 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.

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.Seniority levelMid-Senior levelEmployment typeFull-timeJob functionInformation TechnologyIndustriesInsurance and Financial ServicesReferrals increase your chances of interviewing at Zurich Insurance by 2x

#J-

• Ljbffr