DWH Engineer I

Summary

Join Jumio and optimize several ETL workflows for better system resource throughput. Implement governance on SQL query design, terminating long-running queries to ensure efficient operations. Install, configure, and upgrade SQL Server instances. Monitor database performance, identify bottlenecks, and implement performance tuning. Design, implement, and test backup and recovery strategies for disaster recovery. Troubleshoot and maintain SSIS packages. Implement and maintain database security, managing permissions and auditing activities. Perform database maintenance tasks and collaborate with development teams on database design and optimization. Document database configurations, maintenance procedures, and best practices.

Requirements

• Hands-on experience with SQL Server installation, configuration, and administration
• Strong proficiency in T-SQL for writing, debugging, and optimizing queries
• Proven track record in troubleshooting and maintaining SSIS Packages
• Knowledge of backup/recovery processes and disaster recovery planning
• Good understanding of database security principles and access control
• Experience automating database maintenance tasks
• Strong analytical and problem-solving skills
• Ability to communicate and collaborate with cross-functional teams
• 1-3 years of relevant experience in deep understanding of DBA management, data governance & standards, and associated technologies (Azure, SQL Server, Oracle, Post Gre)
• Strong Verbal, written communication and documentation skills

Responsibilities

• Install, configure, and upgrade SQL Server instances
• Monitor database performance, identify bottlenecks, and implement performance tuning for queries and indexes
• Design, implement, and test backup and recovery strategies for disaster recovery
• Troubleshoot, maintain, and optimize SSIS packages
• Implement and maintain database security, manage permissions, and audit activities
• Perform database maintenance: index rebuilds, updates, integrity checks, and automate tasks using SQL Server Agent or PowerShell
• Diagnose and resolve database issues, provide support to end-users and developers
• Monitor database growth, plan for future capacity, and ensure resource availability
• Collaborate with development teams on database design and optimization
• Document database configurations, maintenance procedures, and best practices

Preferred Qualifications

• Practical knowledge of industry frameworks for DBA, such as MS SQL Server Best practices, DAMA
• Leveraging AI to build self healing capabilities
• Automated Error Handling and self heal
• Self Optimization
• Analyze historical data and predicts future trends enabling proactive adjustments to ETL process