Database Administrator (DBA)اسنپ مارکت
درباره موقعیت شغلی
درباره شرکت
سطح ارشدیت
موقعیت مکانی
نوع همکاری
ساعت کاری
خدمت سربازیOverview:
We are looking for a Database Administrator (DBA) to manage, maintain, and monitor SQL Server databases while ensuring the health, performance, and availability of our data services. In this role, you will analyze and optimize queries, stored procedures, views, functions, indexes, and ETL processes; troubleshoot locking, blocking, and deadlock issues; manage database users, permissions, and security requirements; and implement auditing and change-tracking mechanisms. You will collaborate closely with BI, Data Engineering, Infrastructure, and Product teams to improve the quality and efficiency of data services, and you will create and maintain technical documentation and operational procedures.
Responsibilities:
Qualifications:
We are looking for a Database Administrator (DBA) to manage, maintain, and monitor SQL Server databases while ensuring the health, performance, and availability of our data services. In this role, you will analyze and optimize queries, stored procedures, views, functions, indexes, and ETL processes; troubleshoot locking, blocking, and deadlock issues; manage database users, permissions, and security requirements; and implement auditing and change-tracking mechanisms. You will collaborate closely with BI, Data Engineering, Infrastructure, and Product teams to improve the quality and efficiency of data services, and you will create and maintain technical documentation and operational procedures.
Responsibilities:
- Manage, maintain, and monitor SQL Server databases
- Ensure the health, performance, and availability of data services
- Analyze and optimize queries, stored procedures, views, functions, and indexes
- Identify and resolve locking, blocking, and deadlock issues
- Analyze and optimize ETL processes
- Manage database users, permissions, and security requirements
- Implement and monitor database auditing and change-tracking mechanisms
- Collaborate with BI, Data Engineering, Infrastructure, and Product teams to improve the quality and efficiency of data services
- Create and maintain technical documentation and operational procedures
Qualifications:
- Minimum 3 years of experience in SQL Server Administration
- Strong knowledge of T-SQL, query tuning, and execution plan analysis
- Strong knowledge of performance tuning
- Strong understanding of indexing, locking, blocking, and deadlock troubleshooting
- Solid understanding of data warehouse concepts and ETL processes
- Familiarity with high availability concepts (Always On, Replication, Log Shipping)
- Familiarity with Windows Server
- Proficiency in SSIS
- Familiarity with software development and programming concepts
- Familiarity with database auditing, monitoring, and troubleshooting
- Strong analytical and problem-solving skills
- High sense of ownership and accountability
- Effective communication and cross-functional collaboration skills
- Ability to learn quickly, adapt to change, and manage priorities in a dynamic and agile environment
درباره شرکت
Snapp Market, the largest online supermarket holding company in Iran, encompasses a range of diverse services in the supermarket industry. These services include Hyper Line, our online supermarket service offering scheduled delivery, Express Line, our fast delivery online supermarket service, Smart Line, our online chain supermarket service (Dark Store), and Market Pro Line, our wholesale supply service. These services have been designed and implemented with the aim of integrating operations, creating synergies, and providing a better shopping experience for our users.
The organization's core values lie in intelligence, dynamism, and reliability in delivering online supermarket services, driven by a team of over a thousand dedicated professionals.
The organization's core values lie in intelligence, dynamism, and reliability in delivering online supermarket services, driven by a team of over a thousand dedicated professionals.
