About the Role:
Key Responsibilities:
Database Development & Maintenance
Design, develop, and maintain SQL Server databases to support business applications.
Write complex T-SQL queries, stored procedures, user-defined functions, views, triggers, and table-valued functions.
Create and manage indexes, partitions, and schemas for performance optimization.
Implement data integrity, referential constraints, and best practices for database design.
Performance Optimization:
Analyze query execution plans and perform query tuning to improve performance.
Monitor database performance using tools like SQL Profiler, Extended Events, and DMVs.
Identify and resolve database bottlenecks, deadlocks, and blocking issues.
Data Management & Integration:
Develop and maintain SSIS (SQL Server Integration Services) packages for ETL processes.
Work with large datasets and handle data cleansing, transformations, and migrations.
Database Security & Backup:
Implement user roles, permissions, and data encryption for security.
Schedule and monitor database backups and recovery plans.
Ensure high availability and disaster recovery mechanisms are in place.
Collaboration & Documentation:
Work closely with application developers, business analysts, and QA teams to deliver robust solutions.
Prepare technical documentation for database designs, stored procedures, and deployment steps.
Participate in code reviews and enforce best coding practices.

Keyskills: T-SQL Functional SQL Server Development Stored Procedures SQL Server Triggers
Techbooks International Pvt. Ltd Aptara enriches content for capitalizing on all digital mediums. Providing full content life-cycle production from content creation and design, to new media enhancements, content technology solutions, and production for all mobile devices and platforms. Aptara d...