12 ago
|
Zventus
|
Ensenada
**Database Administrator**
Join Zventus, a leader in business & technology services to US-based companies.
- 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 while ensuring their performance and stability.
- Create and implement changes to databases based on the requirements of the end-user
- Ensure data quality and integrity.
- Works on problems of complex scope where analysis of situations or data requires a review of various factors.
**Job Qualifications/Requirements**
- Bachelor's degree in Computer Science, or IT related field, or equivalent work experience
- 3+ years of related experience
- Experience working with Microsoft SQL Server (2012+ )
- Solid coding techniques to develop complex views, stored procedures, and functions using T-SQL
- Experience importing data from text file formats, linked server connections, APIs, and web services
- Experience creating mapping document/s between source and target data structures
- 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
- Experience in troubleshooting all types of ETL issues
- Ability to write custom scripts using shell scripts such as PowerShell
- 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
**Benefits**:
- All benefits by law
- Monday to Friday
- Weekends off!
- Two days of paid time off annually.
- Between 7 and 11 paid holiday days annually.
- Remote work allowance (Teletrabajo) above the market average.
- Office / Hybrid opportunities
- Meal subsidy (MXN 1000 Monthly) via voucher card.
- Private health, life, and dental insurance
- Sponsorship for wholesale store memberships (COSTCO/SAMS CLUB), prescription glasses, birthday benefits, and more.
- Wellness events and activities
- Sponsorship for Scholarships & Professional Training
- Career growth opportunities
- Monthly employee engagement events
- Sponsored lunch, snacks, and coffee events
- Professional Training & Development opportunities
**Additional information**:
- Employment Type: Full-time
- Schedule Monday to Friday 7 AM to 5 PM PT
- After six months eligible for hybrid work based on meeting performance expectations
- _Please, submit your CV in English_
**Experience**:
- PHP: 1 year (preferred)
**Language**:
- English (required)
Work Location: In person
Application Deadline: 28/02/2025
📌 Database Administrator (Ensenada)
🏢 Zventus
📍 Ensenada