Hoy
summary
do you have a passion for databases? Do terms like rdbms, nosql, mongodb, ssis and star schema bring a smile to your face? Do you like challenges as small as digging into a problematic sql statement execution plan, or as large as migrating massive amounts of data for bi reporting environments? Can you wrangle replication? Backslap bad schema? Dropkick indecent developer code because “it’s not sargable”. Well do we have the position for you!
essential duties and responsibilities
* manage high-transactional sql server databases through many product lifecycle environments ranging from development to mission-critical production.
* implement, configure, maintain and monitor performance of all database systems using database audit tables, logs and performance analyzers like dpa.
* independently track, analyze, research, solve, implement and document approved changes for real-time issues.
* refine, automate and document all current and future dba processes with documents, diagrams, operational procedures and architectural designs.
* assist developers with critical complex query tuning, index suggestion, and ddl changes.
* share 24x7x365 support for our production critical systems.
* perform scheduled maintenance and support code release deployment activities after-hours.
* cross-train peers and team members by sharing domain and technical skills expertise.
* interface with the bi reporting team to support their data warehousing needs from our many transactional data stores.
* design, review and implement disaster recovery plans for database services across the organization.
qualifications
* sql server database administration
* data warehousing concepts like cleaning, transformation, integration, consolidation and replication.
* ssis
* azure data factory
* etl
* powershell
* nosql db technologies like postgres, cosmosdb and mongodb
* git repository
education and/or experience
bachelor’s degree in a computer science technology program from a four-year college or university and a minimum of 6 years’ experience as a dba. Preferable to be knowledgeable about the logistics industry.
protrans
import export database administrator
hoy
hunter douglas is the world’s leading manufacturer of window coverings and a major manufacturer of architectural products. We are a brand that you know and trust. With more than 100 years of innovation, we’ve defined our industry with proprietary products that deliver revolutionary style and functionality and can be found in millions of homes and commercial buildings globally.
one of the pillars of our north american division is spread across four different sites in mexico, where a blend of manufacturing and fabrication occurs. At each location, we pride ourselves on exemplary safety and employee-first standards, pioneering production processes to be best in class. Our focus on quality and growth makes us an employer of choice and helps us maintain our culture of excellence.
position overview
the position is the gatekeeper of the customs import-export database, performing regular updates to its catalogs on approved changes by the import-export manager. Works directly with the provider on software performance and maintenance updates, as well as projects related to changes in customs regulations or company requirements.
what you'll do
* maintain and control the immex inventory balance in the customs compliance software under the threshold period required by mexican customs law by type of operation (18 months for in, 6 months for v1, etc)
* reconcile all import and export manifests (pedimentos) against the datastage file that’s received by sat
* execute the monthly backflush process in the customs compliance software against the reconciled datastage inventory to get to the pcn/hts quantity balance and generate an executive summary
* cross-reference the backflush report against the sap inventory by pcn to identify offenders
* transmit the monthly backflush report to sat once approved by the import-export manager
* direct point of contact with the software provider for maintenance updates or other requirements
* maintain and control project logs for hourly service packages
* work in conjunction with local it on database backups
who you are
* engineering in it systems, comercio exterior y aduanas, lae, or similar
* 5 years experience
* advanced english level
* proficiency in sql and sap
what's in it for you
* competitive compensation package including annual bonus
* generous benefits package including major medical expenses and life insurance
* 14 days of vacation
* 75% vacation premium
* paid time off
* 30 days of christmas bonus
* food vouchers and cafeteria service
* savings fund
* career developmental opportunities
* a company culture that prioritizes internal development
hunter douglas is an equal opportunity employer and complies with applicable employment laws. Eoe/m/f/vet/disabled are encouraged to apply.
li-jf1
li-onsite
#j-18808-ljbffr