Responsibilities/ Skills

• Database Administration:
  • Manage the installation, configuration, and ongoing maintenance of MS SQL databases.
  • Ensure high levels of performance, availability, and security.
• 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.
• Query Optimization:
  • Optimize SQL queries and provide guidance to developers for efficient database interactions.
• Backup and Recovery:
  • Develop and implement robust backup and recovery strategies to safeguard data and minimize downtime.
• Troubleshooting:
  • Diagnose and resolve database-related issues promptly, collaborating with cross-functional teams when needed.
• Scripting and Automation:
  • Utilize scripting languages to automate routine database tasks and streamline operational processes.
• Collaboration:
  • Work closely with application developers, system administrators, and other stakeholders to meet business requirements.
• Documentation:
  • Maintain comprehensive documentation of database configurations, changes, and troubleshooting procedures.
• Security Management:
  • Implement and enforce MS SQL security protocols, ensuring compliance with industry standards and regulations.
• Database Design and Planning:
  • Contribute to database design decisions, offering insights into schema design and optimization.
• Continuous Learning:
  • Stay updated on the latest MS SQL releases, features, and best practices in database management.
• Disaster Recovery Planning:
  • Contribute to the development and testing of disaster recovery plans to minimize data loss and downtime in critical scenarios.
• Scaling and High Availability:
  • Implement and manage strategies for database scaling and high availability to support growing business needs.
• Communication:
  • Effectively communicate technical information to both technical and non-technical stakeholders.