Job Summary:
The SQL Database Administrator is responsible for the design, implementation, maintenance, and performance of SQL Server databases. This role ensures the availability, security, and optimal performance of database systems that support critical business applications.
Key Responsibilities:
- Install, configure, and maintain SQL Server instances
- Monitor database performance and tune queries, indexes, and configurations
- Perform regular backups and ensure disaster recovery strategies are in place
- Implement and manage high availability and disaster recovery (HA/DR) solutions
- Manage database security including roles, permissions, and encryption
- Perform data migration, import/export, and ETL operations
- Troubleshoot database issues and provide 24/7 support as needed
- Automate routine tasks using scripts and maintenance plans
- Collaborate with developers and other IT staff for application support
- Maintain comprehensive documentation of database systems and procedures
Required Skills and Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or related field
- 3+ years of experience as a SQL Database Administrator
- Proficient in SQL Server installation, configuration, and maintenance
- Strong knowledge of T-SQL, stored procedures, triggers, and functions
- Experience with backup, restore, and disaster recovery planning
- Familiarity with SQL Server Agent jobs, SSIS, and performance tuning
- Understanding of database security and user access management
- Good problem-solving, communication, and documentation skills
Preferred Qualifications:
- Microsoft Certified: Azure Database Administrator Associate or equivalent
- Experience with cloud-based databases such as Azure SQL or AWS RDS
- Familiarity with PowerShell scripting and automation tools
- Knowledge of database replication, clustering, and Always On Availability Groups
- Experience with monitoring tools like Redgate, SolarWinds, or SQL Sentry
