Title: SQL DBA
Duration: 6+ Months
Location: Houston, TX /5 days on
Highlighted are must have SSIS, SSRS,
Required:
Job Summary
Seeking a senior SQL Database Administrator skilled with T-SQL, SSIS, SSRS, security, backup and recovery experience to support DBA team in a fast-paced Need to be onsite 4 days a week (at least for first couple of months and then based on workload may switch to 3 days onsite schedule).
Responsibilities and Essential Duties:
- Installation, upgrade, migration and administrationof SQL Server (2012, 2014, 2016, 2017 and 2019)
- T-SQL >Proficient in writing complex SQL Creating new, modifying and debugging existing stored procedures, functions and ;
- SSIS (SQL Server Integration Services) >Expert in developing and deploy new SSIS packages, migrating and debugging existing SSIS packages (both package and project deployment model).
- SSRS (SQL Server Reporting Services) >Install and configure Manage access and Hands-on experience in creating, deploying new SSRS reports, migrating existing SSRS Also, debugging SSRS reports for run time issues and ;
- Performdatabase backups, restores and ;
- Performance tuning covering index management, T-SQL queries, databases and host ;
- Maintaindatabase securityincluding user ;
- Review and apply database security ;
- Actively monitoring of SQL server alerts and issues in production and non-production ;
- Troubleshoot and perform root cause analysis of problems, recommend and implement ;
- Perform T-SQL code reviews and migration of code from non-production to production ;
- Promote system reliability, efficiency and maintenance by implementing company standards, policies, procedures and industry ;
- Good team player with effective communication and interpersonal skills.
- Ability to work independently taking ownership of technical ;
- Ability to be flexible with evolving and emerging projects while supporting daily operational ;
- Provide status reporton completed, on-going and future assignments/projects on regular ;
- Writes and maintains documentation on processes critical to support and future ;
- Experience working in a 24x7
DBA, SQL BDA , SSIS, SSRS, TQSQL,database security