Database Engineer

As a database engineer you would be responsible for designing and building our product database with enterprise standards. You would be handling all database requirements throughout the development lifecycle.

KEY RESPONSIBILITIES : Design and develop efficient data models and data warehouses to support business intelligence and analytics needs Design and develop dimensional models, star schemas ad OLAP cubes to enable complex analytics and reporting Build and maintain fact and dimension tables, ensuring proper relationships and key structures Build ETL processes to extract data from source systems, transform and cleanse data, and load into data warehouse Implement SQL queries, stored procedures, triggers, and functions to support data warehouse and data marts Monitor ETL performance and fine-tune SQL code for optimal efficiency Perform root cause analysis on data discrepancies and work to resolve issues Collaborate with business analysts and end users to understand reporting needs and improve BI systems Provide technical assistance to resolve all database issues related to performance, capacity and access. Ensure data integrity and quality in database systems. Maintain standard design considerations while building application DB Maintain Privacy by design and Data governance Implement normalization and build optimized and robust database by design Create required documentation like data dictionaries, mapping documents, ER diagrams etc Keep current on data warehouse best practices, trends, and technologies

PREFERRED QUALIFICATIONS & REQUIRED SKILLS : Bachelor’s degree in computer science, Information Systems or related field, Masters preferred 5+ years of experience in Database Modelling and ETL Tools Must have worked on designing databases and involved in data modelling activities to set up a new application DB. Expert in SQL including complex queries, joins, subqueries, and stored procedures etc Must have experience in MySQL and AWS Redshift At least 5 years of proven experience using MySQL RDBMS and Data warehouses Experience in ETL tools like DMS, Talend, SSIS, scripting in a Unix like env. Experience in building data validation reports and data profiling. Broad awareness of database workloads and use cases, including performance, availability, and scalability. Demonstrated proficiency in database performance tuning, optimization and troubleshooting Familiarity with Amazon Web Services (EC2, EBS, S3, etc.) Exposure to Cloud database design and principles – AWS preferred Experience in Data governance and ability to create domain-driven schemas. Experience in SQL, R / Python programming and optimization Ability to handle large and complex databases. Good communication skills with the ability to collaborate with all stakeholders to gather requirements. Excellent problem solving and analytical skills. Knowledge on Machine Learning algorithms is a bonus

PERKS OF JOINING :

The Culture : most companies talk about their values, we live them. Supportive Culture :

We value teamwork, mentorship, and professional development, and we show it by providing top-notch employee experience and training programs, and incentivizing team growth. Work-Life Balance :

We support a hybrid work model and encourage our employees to create a healthy balance between personal and professional life. Rewards and Recognitions :

Competitive compensation, annual and spot bonuses, and a focus on recognizing hard work with well-earned rewards are part of our DNA. Innovative Work :

Contribute to cutting-edge solutions for e-commerce and SaaS businesses.

The Work : stability of a market leader with the hunger for innovation and growth of a start-up Impactful & Broad Role :

You will have a seat at the table when it comes to key management decisions, drive critical marketing strategy and decisions, and have a voice in key product and user experience decisions. Growth Opportunities :

Learn and grow from market veterans, take advantage of a fast-paced, collaborative environment, and enjoy the ability to move up the ladder when you earn it. Competitive Benefits :

Access comprehensive insurance for health (incl. parents), life and personal accident.

ABOUT SILVERMINE GROUP : Silvermine Group is the largest & most trusted provider of regulatory compliance services for the heavy trucking and transportation industries. Our compliance automation platform is secure, cloud-based, and certified by the IRS - helping over 100,000 customers every year file federally required documents - such as IRS Form 2290, Form 8849, and MCS-150 - accurately, securely, and on time. Our technology, highly skilled customer support, and relentless focus on product improvement and growth ensures that our customers’ equipment stays on the road and their businesses keep humming.

Website : Silvermine Group

Products : eform2290

emcs150 Apply on : careers@silverminegroup.com

Location : Bangalore