Database Administration:
- Manage the installation, configuration, and ongoing maintenance of MS SQL databases.
- Ensure high levels of performance, availability, and security.
2. Performance Optimization:
- Conduct performance tuning and optimization of MS SQL queries and server configurations.
- Monitor and analyze database performance metrics to proactively address potential issues.
3. Query Optimization:
- Optimize SQL queries and provide guidance to developers for efficient database interactions.
4. Backup and Recovery:
- Develop and implement robust backup and recovery strategies to safeguard data and minimize downtime.
5. Troubleshooting:
- Diagnose and resolve database-related issues promptly, collaborating with cross-functional teams when needed.
6. Scripting and Automation:
- Utilize scripting languages to automate routine database tasks and streamline operational processes.
7. Collaboration:
- Work closely with application developers, system administrators, and other stakeholders to meet business requirements.
8. Documentation:
- Maintain comprehensive documentation of database configurations, changes, and troubleshooting procedures.
9. Security Management:
- Implement and enforce MS SQL security protocols, ensuring compliance with industry standards and regulations.
10. Database Design and Planning:
- Contribute to database design decisions, offering insights into schema design and optimization.
11. Continuous Learning:
- Stay updated on the latest MS SQL releases, features, and best practices in database management.
12. Disaster Recovery Planning:
- Contribute to the development and testing of disaster recovery plans to minimize data loss and downtime in critical scenarios.
13. Scaling and High Availability:
- Implement and manage strategies for database scaling and high availability to support growing business needs.
14. Communication:
- Effectively communicate technical information to both technical and non-technical stakeholders.
Informujemy, że administratorem danych jest HCL POLAND SP.Z O.O. z siedzibą w 32-080 Krakowie (dalej jako "administrator...more