Database Administrator MySQL MS SQL

Key Responsibilities:

• Design scalable reliable databases aligned with performance goals.
• Develop efficient SQL queries stored procedures and functions for MS SQL Server and MySQL.
• Implement data modeling and schema design based on project needs.

• Set up and configure MS SQL Server and MySQL environments.
• Conduct routine database maintenance including backups indexing and data integrity checks.
• Monitor and optimize database performance to meet business requirements.
• Ensure robust security access control and compliance.

• Manage data migrations across MS SQL MySQL and other systems.
• Handle data transformation and integration tasks with ETL tools.
• Write scripts for data import/export processes.

• Identify and resolve database issues including performance bottlenecks deadlocks and errors.
• Provide support for databaserelated troubleshooting.
• Work closely with developers and IT teams to improve database interactions.

• Maintain documentation on database structures configurations and processes.
• Generate business intelligence reports and queries as needed.
• 
  

Required Skills and Qualifications:

• Technical Expertise: Proficiency in SQL query optimization and database indexing.
• Database Management: Strong experience in MS SQL Server (TSQL SQL Server Management Studio) and MySQL (MySQL Workbench).
• Performance Tuning & Optimization: Ability to use monitoring tools to diagnose and resolve database performance issues.
• Backup & Recovery: Skilled in implementing backup strategies transaction logs and pointintime recovery.
• Security Management: Knowledge of rolebased access control data encryption and best practices in database security.
• Scripting & Automation: Familiarity with PowerShell Bash or Python for task automation and ETL processes.
• Cloud Experience: Understanding of cloudbased databases like Azure SQL Amazon RDS or Google Cloud SQL.

• Excellent Communication Skills: Ability to convey complex database concepts to both technical and nontechnical stakeholders.
• Collaboration: Effective teamwork with developers data analysts and IT personnel.

performance tuning,azure,databases,backup strategies,database,sql server management studio,mysql workbench,powershell scripting,ms sql,google cloud,azure sql,transaction logs,microsoft sql server,t-sql,google cloud sql,sql server,powershell,data encryption,cloud,python,amazon rds,mysql,security,bash,query optimization,sql,cloud-based databases,point-in-time recovery,database indexing,etl tools