Job Description

SQL DBA

Exp- 5+ Years

Core Knowledge Areas

  • Execution Flow
    • Understanding of SQL query execution plans
    • Ability to analyze step-by-step query processing
  • SQL Profiler
    • Experience in using SQL Profiler for monitoring and troubleshooting
    • Identifying performance bottlenecks through trace analysis
  • System Tables & Index Statistics
  • Familiarity with sys tables to fetch metadata and statistics
  • Ability to evaluate index usage and efficiency
Performance Optimization Techniques

  • Query Optimization
    • Writing simplified queries for better efficiency
    • Using Common Table Expressions (CTEs) effectively
  • Indexing Strategies
    • Knowledge of Clustered and Non-Clustered indexes
    • Choosing appropriate indexing methods based on workload
  • Partitioning
    • ...

Apply for this Position

Ready to join Zorba AI? Click the button below to submit your application.

Submit Application