DWH Engineer I
Role Purpose: The role is to bring in best standards towards bringing the orchestration of several ETL workflows that gets created over time, but would need to be optimised for better throughput of the system resources. Also to bring in the governance on SQL query design and kill/terminate long running queries consuming system specs thereby enabling an efficient operational process, economical to maintain and scale
Example 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
- 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.
Experience and Qualifications:
- 1-3 years of relevant experience in deep understanding of DBA management, data governance & standards, and associated technologies (Azure, SQL Server, Oracle, Post Gre)
- 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.
- Strong Verbal, written communication and documentation skills,
Great to have Experience and 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
@Work :Our newest office, Jumio is in Prestige Tech Park III and growing fast. A hub of technical excellence with Machine Learning enablement at its core the engineers and team are committed to learning and innovation. They set the bar high. In a recent culture survey these attributes were rated particularly highly in Jumio’s Indian offices
Jumio Values:
IDEAL: Integrity, Diversity, Empowerment, Accountability, Leading Innovation
Equal Opportunities:
Jumio is a collaboration of people with different ideas, strengths, interests and cultures. We welcome applications and colleagues from all backgrounds and of all statuses.
About Jumio:
Jumio is a B2B technology company dedicated to eradicating online identity fraud, money laundering and other financial crimes to help make the internet safer. We leverage AI, biometrics, machine learning, liveness detection and automation to create solutions that are trusted by leading brands worldwide and respected by industry thought leaders.
Jumio is the leading provider of online identity verification, eKYC and AML solutions. With a global footprint, we’re expanding the team to meet strong client demand across a range of industries including Financial Services, Travel, Sharing Economy, Fintech, Gaming, and others.
Applicant Data Privacy
We will only use your personal information in connection with Jumio’s application, recruitment, and hiring processes, as described in Jumio’s Applicant Privacy Notice. If you have any questions or comments, please send an email to privacy@jumio.com.
Create a Job Alert
Interested in building your career at Jumio? Get future opportunities sent straight to your email.
Apply for this job
*
indicates a required field