| Sr. SQL DBA :: Dallas TX(Day 1 Onsite) at Dallas, Texas, USA |
| Email: [email protected] |
| Greeting from Iconic Infosys !! Iconic Infosys is an IT Development & IT Staffing firm with more than a decade of experience in providing IT Staffing Solutions & Services. Our expertise is in sourcing and deploying highly skilled IT Specialist into mainstream and niche technologies to meet clients Temporary, Permanent & SOW project needs. Title: Sr. SQL DBA Location: Dallas TX(Day 1 Onsite) Duration : Long Term 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. Please provide the below details for submission along with Visa copy & Photo ID copy, I94/Passport# Candidate Details Candidate Full Name (As per SSN) Current location (City and State) Open for relocation to work location (Yes/No) Contact/Phone # Address Skype ID Visa Type Visa Validity (Month & Year) /Work Authorization Date of Birth (Month & Year Only) Passport Number SSN( Last 4 Digits) Bachelors details (University /College & Passing year) Masters details (University/College & Passing year) Total IT experience (Years) Onsite [USA/Canada] Experience (Years) Profile Reason for Job Change Availability to join post selection Interview availability (Preferred time slots for next 3 days) -- Thanks & Regards, Naren Email: [email protected] -- To post to this group, send email to [email protected]. Keywords: information technology Idaho Texas |
| [email protected] View all |
| Wed Jan 10 23:59:00 UTC 2024 |