Radamatic - SQL Developer - Database Solutions (5-12 yrs)

Job description :

- Candidates should have a minimum of 5 years of experience in MS SQL database development. The candidates will be evaluated based on the following areas.

- Candidate should have experience of 5 years Database designing and Database Development experience.

- Development of high-quality database solutions using database technologies like Microsoft SQL Server, Microsoft Azure etc.

- Database modeling and design using the normalized method with proper documentation.

- Must have experience with SQL Server Objects in terms of creating, maintaining, and optimizing. i.e., Table, Views, Function, Stored Procedures, Dynamic SQL, Triggers, etc.

- Develop T-SQL scripts and procedures for data migration, data correction, and data validation.

- Analyze existing SQL queries for performance improvements.

- Creating appropriate Indexes based on the requirements and maintenance.

- Should have experience in using different technologies like SSIS, Azure Data Factories, Linked Servers, External Table, T-SQL, .Net, etc.

- Must have experience in Performance tuning and optimization techniques.

- Strong experience in SQL server Execution Plan and problem-solving.

- Must have experience in core DBA activities with MS SQL Server.

- Backup & Restore activities and strategies.

- Performance & resource monitoring and fixing.

- Database creation and code review.

- Database Deployment using DEV, QA & Production environment.

- Should have the experience to maintain security, auditing, creating, and maintaining users etc.