**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**
The following duties and responsibilities are required. Other duties may be assigned.
- 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**
To perform this job successfully, an individual must possess sufficient abilities in the following skills:
- 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

📌 Senior Database Administrator (Monterrey)
🏢 PRO TRANS INTERNATIONAL
📍 Monterrey