Job Type Full Time - This position requires you to be located in Baja California. Candidates who are not in this location will be rejected. By law benefits starting on your hire date Monday to Friday schedule Weekly payment Additional Time Off beyond those required by law Appreciation gifts based on seniority Wholesale store membership sponsorship Telehealth and Wellness events and activities Birthday bonus, and more great appreciation benefits Education & professional training sponsorship Monthly events with sponsored lunch or snacks Additional information Employment Type: Full Time - On-site at the Zventus Center Of Excellence Location in Ensenada, B. C. This position requires you to be located in Ensenada, Baja California. Candidates who are not in this location will be rejected. Schedule Monday to Friday, 7 AM to 5 PM PT At Zventus, employee benefits vary by team, job activity, and individual performance. Please refer to specific details during the interview process. 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. Works on problems of complex scope where analysis of situations or data requires a review of a variety of factors. Job Qualifications/Requirements Bachelor's degree in Computer Science, or IT related field, or 3+ years 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 Power Shell. 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. Zventus, founded in 2016, has challenged the traditional outsourcing model, prioritizing our employees as the key to success. We believe in building collaborative partnerships, and transforming outdated methodologies into dynamic and strategic alliances. With you, this transformation, with our diverse team of top-tier talent, we support the needs of mid-size companies, Fortune 500 companies, and emerging start-ups alike. #J-18808-Ljbffr

📌 Database administrator (Centro)
🏢 Zventus
📍 Centro