Hi
This is Priyanshu from Shef Solutions. Hope you are doing Well, I have a job position for you. Position: SQL DBA Location: Houston, TX Duration: Long term Contract JOB DESCRIPTION: Highlighted are must have SSIS, SSRS, TQSQL. 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 environment. 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 administration of SQL Server (2012, 2014, 2016, 2017 and 2019)
- T-SQL > Proficient in writing complex SQL queries. Creating new, modifying and debugging existing stored procedures, functions and triggers.
- 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 SSRS. Manage access and subscription. Hands-on experience in creating, deploying new SSRS reports, migrating existing SSRS reports. Also, debugging SSRS reports for run time issues and performance.
- Perform database backups, restores and refreshes.
- Performance tuning covering index management, T-SQL queries, databases and host resources.
- Maintain database security including user management.
- Review and apply database security patches.
- Actively monitoring of SQL server alerts and issues in production and non-production environments.
- Troubleshoot and perform root cause analysis of problems, recommend and implement resolutions.
- Perform T-SQL code reviews and migration of code from non-production to production databases.
- Promote system reliability, efficiency and maintenance by implementing company standards, policies, procedures and industry best-practices.
- Good team player with effective communication and interpersonal skills.
- Ability to work independently taking ownership of technical tasks.
- Ability to be flexible with evolving and emerging projects while supporting daily operational tasks.
- Provide status report on completed, on-going and future assignments/projects on regular basis.
- Writes and maintains documentation on processes critical to support and future enhancements.
- Experience working in a 24×7 environment.
|
