Database administrator

*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