We are seeking an experienced Database Administrator (DBA) to manage, maintain, and optimize all existing database systems — including Microsoft SQL Server, MySQL, and Azure SQL Managed Instances.
The ideal candidate will be responsible for ensuring high availability, performance, security, and data integrity across all database environments.
This role requires deep technical expertise in database administration, T-SQL development, backup/recovery strategies, and monitoring/troubleshooting.
Key Responsibilities
Database Administration & Maintenance
- Manage and maintain MS SQL Server, MySQL, and Azure SQL Managed Instance environments (production, UAT, and development).
- Install, configure, patch, and upgrade database servers and tools.
- Implement and manage database backup and recovery strategies (native backups, BCP, export/import utilities, and automated backup jobs).
- Ensure databases are highly available, secure, and performant.
- Regularly perform health checks, index optimization, statistics updates, and space management.
Performance Monitoring & Troubleshooting
- Monitor database performance using tools such as SQL Profiler, Azure Monitor, SSMS Performance Dashboard, SolarWinds, Redgate SQL Monitor, Nagios, or similar.
- Identify and resolve performance bottlenecks, blocking/deadlock issues, and slow-running queries.
- Perform root cause analysis (RCA) for database outages or performance issues and implement preventive measures.
Development & Query Optimization
- Write and optimize T-SQL queries, stored procedures, functions, views, and triggers.
- Collaborate with developers to ensure efficient database design and query performance tuning.
- Support deployment of scripts and changes across environments following best practices.
Security & Compliance
- Manage database users, roles, and permissions in alignment with company security policies.
- Ensure data encryption, auditing, and compliance with regulatory standards (e.g., GDPR, HIPAA if applicable).
Automation & Documentation
- Automate routine DBA tasks (e.g., backups, monitoring, alerts, and maintenance plans).
- Maintain up-to-date documentation for all databases, configurations, procedures, and change logs.
- Support disaster recovery planning and testing.
