MSSQL SQL Developer

Job Description:

The MSSQL SQL Developer plays a crucial role in designing, implementing, and maintaining the MSSQL database for our organization. This role involves working with other teams to understand their database requirements, writing and optimizing SQL queries, and ensuring data integrity and performance. The MSSQL Developer will also be responsible for database administration tasks, such as backups, security, and troubleshooting.

Candidate must have following skills

Candidate must have MIN 7 years’ experience with Sql developer profile.

DB design /Stored Procedures/ Triggers / Tables /Query plan.

Good understanding on SQL Queries / Joins / Indexes / Jobs etc.

Analyze slow or poorly performing queries and optimize them for improved database efficiency.

Stay Updated with the latest MSSQL developments, trends, and best practices.

Responsibilities

Database Design: Design, develop, and implement MSSQL databases based on the organization's requirements, ensuring data models are efficient and scalable.

SQL Query Optimization: Write, optimize, and maintain complex SQL queries to retrieve and manipulate data efficiently. Maintain comprehensive documentation of the database schema, configurations, and procedures. Plan and execute database version upgrades and patch installations as needed.

Data Security: Implement and manage database security measures, including access control, encryption, and auditing, to protect sensitive data.

Performance Tuning: Monitor and analyze database performance, identifying and resolving bottlenecks and optimizing database queries and configurations for improved performance.

Data Migration: Plan and execute data migration projects when necessary, ensuring data consistency and minimal downtime.

Troubleshooting: Investigate and resolve database-related issues and errors, collaborating with other teams to diagnose and fix problems.

Collaboration: Collaborate with software developers and other stakeholders to understand their database requirements and provide support in database-related tasks.