31 jul
|
BlueGrace Logistics
|
Zapopan
31 jul
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