Key Responsibilities :

- Database Design & Development : Develop, maintain, and optimize MS SQL Server databases for large-scale applications.

- Performance Tuning & Optimization : Improve query performance using indexing, execution plans, and partitioning.

- ETL Development & Data Processing : Design ETL pipelines using SSIS to extract, transform, and load data efficiently.

- Stored Procedures & T-SQL Programming : Write and maintain complex stored procedures, functions, triggers, and views.

- Data Security & Compliance : Implement role-based access control (RBAC), encryption, and backup/recovery strategies.

- Data Integration : Work with APIs and external data sources to integrate with other systems.

- Database Administration : Monitor database health, indexing strategies, failover clustering, and replication.

- Collaboration with Dev & Ops Teams : Work with application developers, DevOps, and business analysts to align database solutions with business needs.

- Documentation & Best Practices : Maintain clear documentation for database architecture, processes, and optimization strategies.

Required Skills and Qualifications :

- Expertise in MS SQL Server, T-SQL, and database design principles.

- Experience in e-commerce systems, including database design and modeling for scalable and high-performance architectures.

- Strong experience in query optimization, indexing, execution plans, and partitioning.

- Proficiency in ETL processes and tools like SSIS, Data Factory, or similar.

- Experience with OLTP/OLAP database design and data warehousing concepts.

- Understanding of high-availability solutions such as replication and clustering.

- Knowledge of cloud-based databases (Azure SQL, AWS RDS) is a plus.

- Ability to work with REST APIs, JSON, and XML for data integration.

- Familiarity with DevOps practices and CI/CD pipelines for database deployment.

- Experience with e-commerce transaction-heavy databases (optional but preferred).

- Strong analytical skills and problem-solving mindset with attention to detail.

- Bachelor's degree in Computer Science or related field.

- Experience working in a similar role for at least 10 years.

- Excellent communication and teamwork skills