05 ago
|
BlueGrace Logistics
|
Zapopan
05 ago
BlueGrace Logistics
Zapopan
Job Summary:This role is responsible for developing relational database and related reporting solutions that support information systems by studying operations; designing, developing, and deploying solutions; supports and guides data modeling and data access strategies for the software development team.
**Duties and responsibilities**:- Enforce referential integrity and business constraints- Identify and create indexes to improve database performance- Tune existing T-SQL queries/stored procedures to improve performance- Ensure that new database code meets company standards for readability, reliability, naming conventions, and performance**Qualifications**:- Bachelor's degree in recognized program for information systems or computer science or equivalent experience required.
- 2+ years of SQL Server database development experience.
- Strong experience with SQL Server queries for all CRUD operations- Comfortable with complex joins, nested subqueries,
etc.- Strong experience with stored procedure creation.
- Performance tuning/query refactoring a strong plus.
- Ability to provide quality customer service and teamwork while managing multiple tasks and projects under competing deadlines a must.
- Excellent verbal and written communication skills.
- Understanding of IT principles and an ability to communicate technical concepts effectively to a varied audience.
- Working with Azure and RedGate Tools- Using Git as source control for backend code- Understanding or working knowledge of DevOps process- Working on an Agile/Scrum team- General DBA knowledge (backups, restores, AlwaysOn, Job Scheduling, Alerting, etc.)- Extraction, Transformation and Loading (ETL) (Microsoft SSIS)- Report Development (Microsoft SSRS)- Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
📌 Data Engineer - Guadalajara, Mx (Zapopan)
🏢 BlueGrace Logistics
📍 Zapopan