Jumio
DWH Engineer I
Job Summary
This role focuses on managing and optimizing SQL Server databases, including performance tuning, security, and backup strategies. The candidate will troubleshoot issues, automate maintenance tasks, and collaborate with development teams on database design. Strong proficiency in T-SQL and experience with SSIS packages are essential. The role also emphasizes data governance, capacity planning, and implementing best practices for database management.
Required Skills
Job Description
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 [email protected].
Jumio
Accelerate customer onboarding, combat fraud, and ensure compliance with Jumio's industry-leading identity verification platform.
See more jobsSafe Remote Job Search Tips
Verify Employer Thoroughly
Research the company's identity thoroughly before applying. Check for a professional website with contacts, active social media, and LinkedIn profiles. Verify details across platforms and look for reviews on Glassdoor or Trustpilot to confirm legitimacy.
Never Pay to Get a Job
Legitimate employers never require payment for applications, training, background checks, or equipment. Always reject upfront payment requests or demands for bank details, even if they claim it's for purchasing necessary work gear on your behalf.
Safeguard Your Personal Information
Protect sensitive data like SSN, bank details, or ID copies. Share this only after accepting a formal, written job offer. Ensure it's submitted via a secure company system or portal, never through insecure channels like standard email attachments.
Scrutinize Communication & Interviews
Watch for communication red flags: poor grammar, generic emails (@gmail), vague details, or undue pressure. Be highly suspicious of interviews held only via text or chat apps; legitimate companies typically use video or phone calls.
Beware of Unrealistic Offers
If an offer's salary or benefits seem unrealistically high for the work involved, be cautious. Research standard pay for similar roles. Offers that appear 'too good to be true' are often scams designed to lure you into providing information or payment.
Insist on a Formal Contract
Always secure and review a formal, written job offer or employment contract before starting work or sharing final personal details. Ensure it clearly defines your role, compensation, key terms, and conditions to avoid misunderstandings or scams.