Omni Inclusive
Sr. SQL DBA
Omni Inclusive, Dallas, Texas, United States, 75215
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 SSRS7. 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.
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 SSRS7. 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.