Dba Oracle Cloud Oci Home Office

Buscojobs México; Nuevo León; A distancia; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A leading manufacturer of window coverings is seeking an Import Export Database Administrator to manage and maintain the customs import-export database. The role requires proficiency in SQL and SAP, alongside a degree in IT or related fields, and a minimum of 5 years of experience. The company offers a competitive compensation package, generous benefits, and a culture that prioritizes internal development.

Servicios

Competitive compensation package including annual bonus

Generous benefits package

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

Formación

• Minimum of 6 years’ experience as a DBA.
• Preferable to be knowledgeable about the logistics industry.
• Advanced English level required.

Responsabilidades

• Maintain customs import-export database catalogs.
• Reconcile all import and export manifests.
• Control IMMEX inventory balance.
• Execute monthly backflush processes in compliance software.
• Transmit reports to SAT once approved.

Conocimientos

SQL Server Database Administration

Data warehousing concepts

SSIS

Azure Data Factory

ETL

Powershell

NoSQL DB technologies

Git Repository

Educación

Bachelor’s degree in computer science

Herramientas

SAP

DataStage

Descripción del empleo

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