13 Aug
|
Atlantic Publishers and Distributors
|
New Delhi
13 Aug
Atlantic Publishers and Distributors
New Delhi
We are seeking an experienced Database Developer (SQL Automation Specialist) to join our team. This hybrid role involves not only designing, setting up, and managing SQL databases but also developing automation solutions for seamless inventory uploads and data synchronization across various websites and systems. The ideal candidate will have strong SQL expertise, an understanding of database architecture, and the ability to implement automation processes to support productive, accurate, and timely inventory management.
Key Responsibilities:
Database Design and Setup:
- Design, implement, and maintain database systems to store and manage inventory and product data across multiple websites and platforms.
- Configure and set up new SQL databases for various web applications, ensuring scalability, security, and performance.
- Create database schemas, tables, relationships, and indexes, and implement data normalization and optimization techniques.
- Ensure high availability and performance of the databases by regularly performing database tuning and optimization.
SQL Query Development:
- Write complex SQL queries for data manipulation, analysis, and reporting, ensuring optimal performance.
- Optimize queries to improve data retrieval speed and reduce server load.
- Develop stored procedures, triggers, and views to support efficient database operations.
- Automation of Inventory Uploads: Develop and maintain automated processes for bulk inventory uploads across multiple websites and platforms.
- Implement data integration pipelines to ensure real-time or scheduled updates of inventory information across various systems.
- Use scripting languages (e.g., Python, PowerShell) and SQL to automate data extraction, transformation, and loading (ETL) processes for inventory updates.
Data Synchronization:
- Ensure that inventory data across multiple websites is consistent and up to date.
- Build and maintain automated workflows for synchronizing inventory data between internal d
📌 Database Developer (New Delhi)
🏢 Atlantic Publishers and Distributors
📍 New Delhi