Job Description
Project Role :Data Architect
Project Role Description :Define the data requirements and structure for the application. Model and design the application data structure, storage and integration.
Must have skills :Microsoft SQL Server Integration Services (SSIS)
Good to have skills :NA
Minimum
2 year(s) of experience is required
Educational Qualification :15 years full time educationKey ResponsibilitiesAssist in planning:Run assessments, document findings, prepare checklists, and collect environment details.Develop migration scripts:Write T-SQL and PowerShell automation under senior guidance, and document usage.Execute backups & restores:Perform full/differential backups, test restores and validate schema/data integrity.Perform migration testing:Run regression tests, validate row counts/checksums, and log results.Support cutover tasks:Execute assigned migration steps (backups, restores).Monitor & report:Track migration progress, log errors, escalate issues, and monitor system health during hypercare.Documentation:Maintain runbooks, migration steps, and post-migration validation reports.Required SkillsBasic SQL Server administration (backups, restores, jobs, security roles).Hands on experience with Microsoft SQL server (version 2016 and above) and SQL Server Management Studio (SSMS)SQL development/T-SQL scripting for routine tasks.Familiarity with DMA & SSMS upgrade tools.Testing & validation skills.Documentation & communication.
Additional Information:
The candidate should have minimum 2 years of experience in Microsoft SQL Server Integration Services (SSIS).This position is based at our Hyderabad office.A 15 years full time education is required.
Qualification15 years full time educationJob Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Architect / Consultant
Employement Type: Full time
Contact Details:
Company: Accenture
Location(s): Hyderabad
Keyskills:
data architect
sql development
server management
administration
sql server
sql
scripting
automation
regression
powershell
server administration
design
ssis