Job
Description
Key Responsibilities: Install, configure, and maintain Microsoft SQL Server databases. Monitor system performance and ensure database availability and reliability. Perform database tuning and optimization using native monitoring and troubleshooting tools. Manage database backup, restore, and recovery processes. Implement and maintain database security (e.g., create and manage roles and permissions). Create and maintain documentation of database systems and procedures. Write and optimize SQL queries, stored procedures, and triggers. Conduct regular database health checks and audits. Troubleshoot and resolve database-related issues. Support data migration, data transformation, and data integration efforts. Work closely with developers and IT teams to ensure high-performance database systems. Exposure to SSIS , SSRS , or SSAS . Design, install, configure, and maintain SQL Server databases across development, testing, and production environments. Plan and implement high availability (HA) and disaster recovery (DR) solutions. Monitor database performance and proactively address issues to ensure system availability and responsiveness. Automate routine DBA tasks using tools like PowerShell or SQL Server Agent Jobs. Develop and optimize complex T-SQL scripts, stored procedures, views, and triggers. Perform regular database backups, restoration tests, and security audits. Collaborate with application developers to optimize queries and database performance. Manage user access, roles, and security settings to ensure data protection. Lead or assist in data migration. Required Skills and Qualifications: Proven experience as a SQL Server Database Administrator. Strong understanding of database structure, theories, principles, and practices. Hands-on experience with database standards and end-user applications. Proficient in T-SQL, stored procedures, and SQL Server tools. Experience with SSMS, SQL Profiler, and other monitoring tools. Knowledge of High Availability (HA) and Disaster Recovery (DR) options. Familiar with database design and development best practices.
