SQL Database Administrator – Archon Resources

admin

  • Install, configure, and upgrade SQL Server databases (versions 2012 and above)

  • Monitor database performance and proactively address performance issues

  • Implement and manage database security policies, roles, and access controls

  • Perform backup and recovery operations using native SQL Server tools and third-party solutions

  • Design and maintain high availability and disaster recovery solutions (e.g., Always On, Log Shipping, Replication)

  • Develop and maintain T-SQL scripts, stored procedures, triggers, and views

  • Collaborate with development and infrastructure teams on database design, architecture, and optimization

  • Conduct regular database health checks and maintenance (indexing, statistics updates, etc.)

  • Monitor and tune SQL queries for optimal performance

  • Maintain documentation for architecture, processes, and procedures

  • Ensure compliance with data protection and privacy policies (e.g., GDPR, HIPAA)

    • Read more here: Source link