About the Role: We are looking for a highly skilled SQL Server Developer with at least 5 years of hands-on experience in designing, developing, optimizing, and maintaining SQL Server databases. The ideal candidate will have a strong background in writing complex T-SQL queries, stored procedures, functions, triggers, and views, along with expertise in performance tuning and query optimization. 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.
Designation : Legal Analyst Location : Noida Contact Person : Sonakshi Gupta (HR) Roles and Responsibilities The Legal Analyst will be responsible for performing Regulatory Content Management of multiple Regulators. The Legal Analyst will be responsible for the prompt, accurate and efficient populating of Metadata fields in the CMS Tool in accordance with the link based updates supplied in the Excel sheet. The candidate will be responsible for checking for Rules from the updates and categorizing it based on whether the Rules has been Introduced / Amended / Referenced / Repealed. The candidate will also be responsible for identifying Citations and adding Rules Mentioned in the update. The Legal Analyst will be responsible for the addition, amendment and deletion of Rules in the respective regulatory library of each monitored Regulatory Body maintained on the CMS Tool. The candidate will also be responsible for contribution to related Filler Projects. Required Candidate profile Prior legal review and analysis experience in a legal analyst role. Prior work experience with content summarization and management. Good command over English language Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook). Kindly mark your attendance or apply by sharing your updated resume o below mentioned email ID sonakshi.gupta@aptaracorp.com