Ms Sql Database Administrator

Key Responsibilities:

• Design, implement, and maintain robust database architectures usingSQL Server, MySQL, and PostgreSQL
• Develop and optimize complexSQL queries, stored procedures, views, and triggers
• Performdatabase performance tuningincluding indexing strategies, query optimization, and execution plan analysis
• Design and maintainER diagramsand data models using tools likeER/Studio, Lucidchart, or dbdiagram.io
• Implement and testbackup and recovery strategies, includingpoint-in-time recoveryandHA/DR solutions
• Managedatabase security, including user roles, permissions, encryption (at rest and in transit), and audit logging
• Automate routine tasks usingPowerShell, Bash, or Python, including backups, monitoring, and maintenance
• Monitor database health using tools likeSQL Server Agent, Nagios, Grafana, Datadog, AWS CloudWatch, or Azure Monitor
• Work withcloud platformssuch asAWS (RDS, Aurora, DynamoDB)andGoogle Cloud (Cloud SQL, BigQuery)
• Collaborate with development and infrastructure teams to ensure database reliability, scalability, and performance