Aris Rayaneh Co. – Full time
January 2018 – June 2022
Arak, Iran
On-site
www.arisrayaneh.com
info@arisrayaneh.com
+98-(21) 91 00 13 23
As a Senior SQL Server Database Administrator and Performance Tuning Expert at Aris Rayaneh (2004–2022), I specialized in designing and implementing robust database solutions, optimizing query performance, and ensuring high database availability and security. My role included managing complex ETL processes, advanced troubleshooting, and mentoring technical teams, consistently enhancing database performance and reliability.
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 Aris Rayaneh, 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!