Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, and functions.
Extensively used tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
Collaborate with software developers to integrate database functionality into applications.
Participates in analyzing production issues when necessary to determine the root cause of an issue and help determine the necessary course of action for resolution.
Perform data modeling and implement best practices for data integrity and security.
Responsible for creating and updating ER diagrams, process flows, architectural diagrams, configuration docs, functional specs, and other database assets as required.
Create and optimize SQL queries for data retrieval and reporting.
Troubleshoot and resolve database performance issues and bottlenecks.
Manage and monitor database backups, maintenance plans, and recovery strategies.
Ensure data consistency and compliance with industry standards and regulations.
Stay up-to-date with emerging trends and technologies in database development.
