All offersKrakówDataMSSQL Consultant
MSSQL Consultant
Data
HCLTech

MSSQL Consultant

HCLTech
Kraków
Type of work
Full-time
Experience
Mid
Employment Type
Permanent
Operating mode
Hybrid

Tech stack

    MS SQL
    regular

Job description

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.