DB Developer(SQL) IRC266737

Description

.

Requirements

We are looking for a Database Developer having 5+ years of Exp. to work on our digital marketing solutions to deliver the best insight experience for our major search customers.

Our ideal candidate is good at writing complex SQL scripts/procedures/functions, problem solver and a learner at heart. You should have a very high degree of comfort in SQL programming language.

 

Understand and translate business needs into data models supporting long-term solutions.

Develop high performing PL/SQL procedures for both OLTP and batch operations. Must exhibit deep understanding and experience in database and PL/SQL tuning at both logical and system levels.

Hands on experience of building complex and large data management systems

Expertise on at least one of RDBMS system (Oracle, PL/SQL Server, etc.)

Provide expertise in database design, development data modelling and architecture

Hands on experience of building complex and large data management systems

Hands on working experience of functioning of multiple database systems/technologies

Hands on in writing complex queries, triggers, functions, packages and procedures

Can Independently create and maintain Application schema upgrade scripts

Manage complex relationships and rules-based systems

Understand how to leverage infrastructure for solving such large scale problems.

Develop tools and contribute to open source wherever possible.

Adopt problem solving as a way of life – always go to root cause! Support the code you write in  production

Work with the Application Development team to implement data strategies, build data flows and develop conceptual data model.

Job responsibilities

Should have experience of resolving performance issues, query optimization, database tuning, interpreting query execution plans, resolving deadlocks etc.

You have previously worked on building data pipelines ingesting and transforming large number of events per minute and terabytes of data per day.

You have worked with any sql interface before and have experimented or heard about nosql implementation and understand when to use one over the other. Preferably, you have worked with cloud based big data processing platform such as Google Cloud DataProc.

You are passionate about producing clean, maintainable and testable code part of real-time data pipeline.

You can connect different services and processes together even if you have not worked with them before and follow the flow of data through various pipelines to debug data issues.

You understand issues with ingesting data from applications in multiple data centres across geographies, on-premise and cloud and will find a way to solve them.

Working knowledge of linux environment is a plus

Previous experience of working with Google tools/gadgets is a big plus

Strong leadership and management skills .

Data Warehousing/Data Modelling – Very strong SQL, data modelling and transformation

Skills – with the ability to manipulate large data-sets, automate processes and debug scripts.

Creation and monitoring of reports.

Extracting, manipulating and analyzing data.

What we offer

Culture of caring. At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you’ll experience an inclusive culture of acceptance and belonging, where you’ll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders. 

Learning and development. We are committed to your continuous learning and development. You’ll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic. With our Career Navigator tool as just one example, GlobalLogic offers a rich array of programs, training curricula, and hands-on opportunities to grow personally and professionally.

Interesting & meaningful work. GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you’ll have the chance to work on projects that matter. Each is a unique opportunity to engage your curiosity and creative problem-solving skills as you help clients reimagine what’s possible and bring new solutions to market. In the process, you’ll have the privilege of working on some of the most cutting-edge and impactful solutions shaping the world today.

Balance and flexibility. We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life. Your life extends beyond the office, and we always do our best to help you integrate and balance the best of work and life, having fun along the way!

High-trust organization. We are a high-trust organization where integrity is key. By joining GlobalLogic, you’re placing your trust in a safe, reliable, and ethical global company. Integrity and trust are a cornerstone of our value proposition to our employees and clients. You will find truthfulness, candor, and integrity in everything we do.

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.