About Globals:
Globals has drastically grown from a small home office to a globally recognized enterprise offering world-class quality solutions on Cybersecurity, ERP Systems, Predictive Analytics and Enterprise Application Development for various industries including Defense, Education, Government, Financial Services and Transport Industries. Globals has enabled its customers to be game-changers in their industry through its disruptive and innovative solutions.
Globals is certified as a "Great Place to Work" organization for its great work culture that helps its team members manage work-life, have dedicated hours to upskill and reskill themselves, and most important to ensure that the projects that they are working on are always unique, challenging their status quo every time. Our unique work culture has made us one of the world’s fastest-growing technology companies as recognized and featured by The Economist.
Our excellence in technical stewardship and service-offering expertise has facilitated our clients ranging from individual entrepreneurs to Fortune Global 500 – to explore new business opportunities, reduce their operational costs significantly and boost their revenues. Today, Globals enjoys a strong position in the industry as a high-performing leader through its technology innovation and remarkable domain expertise.
Globals is a CMMI Level 3 certified company.
About the Job Role:
We are seeking a skilled Senior Database Developer with expertise in ETL processes, specifically using Microsoft SQL Server. As a developer, you will be responsible for designing, developing and maintaining SQL databases and applications. Primarily, you will focus on writing efficient and optimized SQL queries, stored procedures and database structures. You will also design and implement ETL processes to extract, transform and load data from various sources into target systems. Additionally, familiarity with ASP.NET MVC will allow you to contribute to web application development projects and collaborate with developers working on the front-end.
Key Responsibilities:
- Design and develop SQL databases, tables, views and indexes based on project requirements.
- Develop and optimize SQL queries, stored procedures and database structures to support application development, data analysis and reporting needs.
- Design, develop and implement ETL processes using ETL Tool to extract data from various sources, transform and load it into target systems.
- Perform data modelling and database schema design to ensure data integrity and optimal storage efficiency.
- Collaborate with software developers to integrate SQL code with applications, troubleshoot issues, and optimize database interactions.
- Work closely with data analysts and stakeholders to understand their data requirements and translate them into database structures and queries
- Monitor database performance, identify bottlenecks and data inconsistencies within the SQL code and ETL processes.
- Conduct thorough testing and debugging of SQL code to ensure data accuracy and application functionality.
- Document database design, data models, ETL workflows and SQL code to maintain a comprehensive knowledge base for future reference.
Requirements & Skills:
- Proven 4+ yrs of work experience as a SQL Developer with a strong focus on Microsoft SQL Server.
- In-depth knowledge of SQL and T-SQL programming.
- Proficient in developing complex SQL queries, stored procedures and functions.
- Hands on experience with ETL tools and processes, specifically Microsoft SQL Server Integration Services (SSIS).
- Good understanding of ASP.NET MVC framework for web application development.
- In-depth knowledge of database concepts, data modelling and schema design.
- Hands on experience with query optimization techniques and performance tuning.
- Familiarity with database administration tasks, such as user management and backup/restore operations.
- Strong analytical and problem-solving skills to identify and resolve database-related issues.
- Attention to detail and ability to prioritize tasks in a fast-paced environment.
- Excellent communication skills to work effectively with cross-functional team.
- Bachelor's degree in Computer Science, Information Technology or Equivalent Masters or a related field.