SQL Developer

Tariful pe oră: Doar pentru membri

Disponibilitate: Doar pentru membri

Disponibilitate de a călători: La nivel mondial

Statut profesional: Freelancer

Ultima actualizare: 29 Iul. 2024

Experiența totală de muncă:

Cunoștințe lingvistice: Română,

Performanță personală

I have extensive experience working with Microsoft SQL Server, including database design, development, and administration. My expertise spans various aspects of SQL Server, such as: Schema Design: Proficient in designing database schemas, including tables, indexes, and relationships, to ensure data integrity and optimal performance. Stored Procedures and Functions: Skilled in writing complex stored procedures, functions, and triggers to encapsulate business logic and enhance database functionality. T-SQL: Expertise in Transact-SQL (T-SQL) for querying, manipulating, and managing data efficiently. Performance Tuning and Optimization Query Optimization: Experienced in analyzing and optimizing slow-running queries using execution plans, indexing strategies, and query refactoring. Index Management: Adept at creating and maintaining indexes to improve query performance and reduce I/O operations. Database Maintenance: Implemented maintenance plans for regular backups, index rebuilding/reorganization, and database integrity checks. Query Optimization: Experienced in analyzing and optimizing slow-running queries using execution plans, indexing strategies, and query refactoring. Index Management: Adept at creating and maintaining indexes to improve query performance and reduce I/O operations. Database Maintenance: Implemented maintenance plans for regular backups, index rebuilding/reorganization, and database integrity checks. Replication: Configured and managed SQL Server replication (snapshot, transactional, and merge) for data distribution and synchronization. Clustering and Always On: Implemented SQL Server clustering and Always On Availability Groups to ensure high availability and disaster recovery capabilities.

Aptitudini