Sr. SQL DBA

Job Description: This role is essential in safeguarding and recovering critical data in the event of system failures. Essential Skills and Competencies: • Proven experience as a SQL Database Administrator with a focus on backup and restore operations. • Strong expertise in Microsoft SQL Server (SQL Server 2019 and SQL Server 2022). • Proficiency in PowerShell scripting, and SQL Server Management Studio (SSMS). • Experience in SSIS and SSRS development. • Experience with database performance tuning and optimization. • Knowledge of high availability and disaster recovery solutions . • Excellent problem-solving and troubleshooting skills. • Strong communication and teamwork abilities. • Relevant certifications (e.g., Microsoft Certified Database Administrator) are a plus. Required Technical Skills: 1. Database Administration: • Administer, monitor, and maintain SQL Server databases to ensure optimal performance, availability, and security. • Perform routine database maintenance tasks such as indexing, integrity checks, and statistics updates. 2. Backup and Restore: • Develop and implement robust backup and recovery strategies for databases to minimize data loss and downtime. • Execute database backups and perform periodic restores to validate the integrity of backup files. 3. Database Security: • Implement and manage database security measures, including user access control, roles, and permissions. • Ensure compliance with security policies and take proactive measures to protect sensitive data. 4. Performance Optimization: • Monitor database performance, identify bottlenecks, and optimize query performance. • Tackle issues related to query optimization, indexing, and resource utilization. 5. SSIS Development: • Design, develop, and implement ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS). • Collaborate with data management team and business users to understand data integration requirements. • Optimize and troubleshoot SSIS packages for efficient data movement. 6. SSRS Development: • Create, modify, and maintain SQL Server Reporting Services (SSRS) reports. • Collaborate with business users to define reporting requirements. • Ensure the accuracy and timeliness of reports generated by SSRS 7. High Availability and Disaster Recovery: • Set up and maintain high availability solutions like SQL Server AlwaysOn Availability Groups and clustering. • Develop, test, and implement disaster recovery plans to minimize data loss in the event of a system failure. 8. Database Upgrades and Patch Management: • Plan and execute database upgrades and apply patches and service packs as necessary. • Ensure database systems are up-to-date and secure.