Alibaba is looking for an experienced SQL Database Administrator to manage, troubleshoot, and maintain databases with performance improvements and security.
Responsibilities
Database Design and Implementation:
- Creating and optimizing database structures.
- Collaborating with application developers to ensure proper data modeling.
Performance Tuning:
- Monitoring query performance and optimizing SQL queries.
- Utilizing indexing and other optimization techniques to enhance database performance.
Backup and Recovery:
- Establishing and maintaining backup and recovery procedures.
- Conducting regular tests to ensure data can be restored in case of failures.
Security Management:
- Managing user access and permissions.
- Implementing security best practices to protect against unauthorized access and data breaches.
Troubleshooting:
- Identifying and resolving issues, such as connectivity problems, data corruption, or performance bottlenecks.
- Ability to detect and troubleshoot SQL Server-related CPU, memory, I/O, and other resource contentions.
- Implementing proactive monitoring to catch potential problems before they impact users
Upgrades and Patching:
- Planning and executing SQL Server upgrades and applying patches.
- Ensuring compatibility with existing applications during the upgrade process.
Capacity Planning:
- Monitoring and analyzing database usage trends to plan for future resource requirements.
- Scaling database infrastructure to accommodate growing data volumes.
Documentation:
- Maintaining comprehensive documentation for databases, including schema, configurations, and procedures.
- Providing documentation for disaster recovery plans.
Automation:
- Developing and implementing automation scripts for routine tasks.
- Leveraging tools for monitoring, alerting, and automating common DBA activities.
High Availability (HA) Implementation:
- Designing and implementing high availability solutions, such as SQL Server AlwaysOn Availability Groups
- Ensuring databases are configured for maximum uptime and minimal downtime during planned or unplanned outages.
Disaster Recovery (DR) Planning:
- Developing and maintaining robust disaster recovery strategies with a focus on minimizing data loss and downtime.
- Implementing technologies like SQL Server Failover Clustering for DR scenarios.
Monitoring and Alerting:
- Establishing proactive monitoring systems to detect potential issues.
- RedGate Monitoring-Zabbix.
Requirements
5 years+ of work experience as an SQL Database Administrator
BSc degree in a computer discipline or relevant certification
Hands-on experience with database standards and end-user applications
Familiarity with programming languages and APIs
Problem-solving skills and ability to think algorithmically
Familiarity with NoSQL, MySql
Provide 24x7 support for critical production systems
معرفی شرکت
شرکت سفرهای علیبابا، یک جمع بزرگ بیش از 800 نفری از افرادی حرفهای و تاثیرگذار است که در جایگاه رهبر بازار گردشگری ایران، با ارائه همه خدمات سفر بهشکل آنلاین، همسفر مسافران میشود. تلاش همه علیباباییها این است که با توانمندسازی جامعه، دسترسی به تجربه شایسته سفر را برای همه ممکن کنند. اینجا هر روز برای ما «روز اول» است و فرصتی برای رشد و یادگیری. در واقع هیچ سقف و محدودیتی برای خودمان قائل نیستیم و علیبابا را یک کوه بدون قله میبینیم.