This position requires you to be located in Baja California. Candidates who are not in this location will be rejected.

Job Description

- Primarily responsible for creating database tables, structures, views, functions, stored procedures, schemas, and dictionaries to facilitate the ETL of data within Microsoft SQL Server.
- Responsible for developing and maintaining Microsoft SQL Server databases whilst also ensuring their performance and stability.
- Create and implement changes to databases based on the requirements of the end user
- Ensure data quality and integrity.
- Work on problems of complex scope where analysis of situations or data requires a review of a variety of factors.

Benefits

- Monday to Friday
- Weekends off!
- All benefits by law
- Altia SmartCity
- Discounts to Gym, Restaurants, and Stores
- Office / Hybrid opportunities
- Meal subsidy (80 LPS) and transportation
- Private health, life, and dental insurance
- PriceSmart, Prescription Glasses, Birthday benefits, and more
- Wellness events, activities, and soccer team
- Compensation days
- Career growth opportunities
- Monthly employee engagement events
- Sponsored lunch, snacks, and coffee events
- Professional Training & Development opportunities

Additional information:

- Please submit your CV in English.
- Employment Type: Full-time.
- Schedule: Monday to Friday, 8 AM to 6 PM CT
- After six months, eligible for hybrid work based on meeting performance expectations.
- At Zventus, employee benefits vary by team, job activity, and individual performance. Please refer to specific details during the interview process.

Job Qualifications/Requirements

- Job Qualifications/Requirements
- Bachelor's degree in Computer Science, or an IT-related field, or 3+ years of equivalent work experience.
- Solid coding techniques to develop complex views,



stored procedures, and functions utilizing T-SQL required. Minimum 2+ years hands on experience preferred.
- Experience working with Microsoft SQL Server, SQL Server Agent, and stored procedure development, execution and scheduling.
- Experience developing ETL processes and troubleshooting all types of ETL issues.
- Experience evaluating SQL query performance and implementing solutions.
- Experience creating mapping document/s between source and target data structures.
- Ability to write custom scripts using shell scripts such as PowerShell.
- Excellent knowledge of data transformations of all types, including calling custom scripts, applying complex logic, etc.
- Experience importing data from text file formats, linked server connections, APIs and web services.
- Solid knowledge of database design to produce sound logical and physical data models.
- Ability to understand and analyze system interdependencies, data structures, and data models.
- Experience with varied forms of data design, such as online transaction processing, online analytical processing, data warehousing, operational data stores, and decision support systems.
- Knowledge of one or more database management systems to install, upgrade, configure, design, develop, implement, secure, tune, monitor, and maintain required database objects.
- Good verbal and written communication skills are a must.
- Analytical and problem-management skills and the ability to resolve complex data issues.
- Ability to immediately adapt to changing requirements and conditions.
- The ability to work in a fast-paced environment is essential.
- Familiarity with real estate concepts is a plus.
- Familiarity with real estate concepts a plus.

Job Type: Full-time

Language:

- english (Required)

Location:

- Ensenada, B.C. (Required)

Work Location: In person

📌 Database Administrator (Ensenada)
🏢 Zventus
📍 Ensenada