D-TechWorks - Database Administrator - SQL Server (4-6 yrs)

Job Description :

Key Responsibilities :

- Perform database migrations and upgrades to the latest versions of SQL Server.

- Migrate and manage SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services) components.

- Handle the migration and configuration of roles, logins, and database-level security settings.

- Optimize database performance, ensuring high availability and reliability.

- Implement robust backup, recovery, and disaster recovery strategies.

- Monitor database health, troubleshoot performance issues, and optimize queries.

- Collaborate with cross-functional teams to ensure seamless migration and integration.

Qualifications :

- 4-6 years of experience as a SQL Server DBA.

- Expertise in SQL Server migration and version upgrades.

- Proficiency with SSIS, SSRS, and SSAS migration and administration.

- Hands-on experience with roles, logins, and database security management.

- Strong skills in performance tuning, query optimization, and troubleshooting.

- Knowledge of database backup and recovery strategies.

- Excellent problem-solving and communication skills.

Preferred :

- Familiarity with cloud-based SQL environments (e.g., Azure SQL Database).

- Certification in SQL Server Administration or related technologies.

- The system administrator configures the database server's hardware and implements the operating system, after which the DBA installs and configures the database software.

- The DBA is in charge of ongoing maintenance, such as updates and patches.

- DBAs are responsible for Data extraction, transformation and loading, also known as (ETL), which refers to the efficient import of large amount of data extracted from multiple database management systems (DBMS) into a data warehouse environment.

- The external data is cleaned and transformed to fit the required format before being imported into a central repository.

- Only implementing a database is not the task of the database administrator. Once the database is implemented, they are required to monitor databases for performance issues.

- If a system component slows down processing, the DBA may need to change the software configuration or add more hardware capacity.

- There are numerous monitoring tools available, and understanding what they need to track to improve the system is part of the DBA's job.