SQL Server DBA
Rayan Pardaz Kavosh Co. – Full Time
July 2022 – Up to the present
Tehran, Iran
Hybrid
https://rpkavosh.ir
+98-(21) 88 540 480
I lead SQL Server performance optimization initiatives across enterprise-grade systems. My role involves diagnosing slow-running queries, restructuring indexes, improving database structures, and implementing high-availability and disaster recovery strategies. I regularly collaborate with cross-functional teams to ensure data solutions align with evolving business goals.
Key Responsibilities & Achievements
Database Architecture & Optimization
- Designed and implemented scalable, high-performance database solutions, aligning with complex business requirements.
- Developed efficient database schemas, ensuring data integrity, normalization, and optimized indexing strategies.
- Led SQL Server performance tuning initiatives, identifying and resolving bottlenecks to improve query execution times.
- Implemented advanced indexing techniques and SQL Server window functions to enhance data retrieval efficiency.
SQL Server Performance & Administration
- Conducted real-time performance monitoring, utilizing Redgate and ApexSQL tools for database analysis, tuning, and troubleshooting.
- Managed database security policies, defining user roles, permissions, and authentication measures for data protection.
- Created and maintained SQL Server backup and disaster recovery strategies, ensuring business continuity.
- Developed automation scripts in PowerShell & T-SQL to streamline database maintenance and operational efficiency.
ETL, Data Integration & Development
- Designed and deployed ETL (Extract, Transform, Load) solutions using SQL Server Integration Services (SSIS) for seamless data processing.
- Developed complex T-SQL scripts, stored procedures, and functions for efficient database interactions.
- Provided technical support and troubleshooting, resolving database-related issues and optimizing workflows.
Leadership & Technical Strategy
- Managed the Product Development Team, overseeing project lifecycles, development processes, and database enhancements.
- Led cross-functional collaboration with developers, system administrators, and business analysts to deliver data-driven solutions.
- Implemented Agile methodologies, optimizing team efficiency and aligning database solutions with business objectives.
Skills & Expertise
SQL Server Administration & Security Query Optimization & Performance Tuning Database Design & Data Integrity ETL & Data Integration (SSIS) T-SQL Programming & Stored Procedures Cloud & On-Premises Database Solutions Redgate & ApexSQL Tools for Performance Monitoring Backup & Disaster Recovery Strategies Active Directory & Storage Area Network (SAN) Integration Agile Project Management & Team Leadership
Throughout my career at Rayan Pardaz Kavosh, I have been committed to delivering high-performance, scalable, and secure database solutions that drive efficiency and business growth. My expertise in SQL Server, query optimization, and database security allows me to transform complex data challenges into seamless, high-speed solutions.
If you need an expert in SQL Server performance tuning, database optimization, or ETL development, let’s connect!