MTC is one of India's leading global HR Consulting firm specializing into multiple facets of HR, Knowledge Services-Trainings & Assessments & Consulting. MTC started operations in 2007 with a vision to set new benchmarks while delivering on niche turnkey assignments in the industry. With time we have evolved to cater to a diverse set of clients spread across different geographies. We constantly strive to maximize our client's ROI (Return on Investment) and work on increasing the top line (Revenue) of the client's business by delivering the best. MTC has reached out to an array of clients with functions such as Recruitments, Consulting & Knowledge Services through its team of young & dynamic professionals.
SQL Technical Architect - New Delhi/ NCR
10/14/2016 2:05:02 AM
SQL Technical Architect
New Delhi/ NCR
Data Arch :
Good Programming knowledge in SQL Server and BI technologies like SSIS and SSRS,TSQL coding
Datawarehouse architecture and concepts
Data modeling exposure and Basics of data modeling
Primarily responsible for driving the Ops Releases and Production issues: Design and code reviews
Owns all technology architecture deliverables in the program
Responsible and accountable for technical excellence of application
Responsible for delivery of all technical (non-functional) requirements in the release
Represent application team in all architecture reviews
Ensure that CIO standard processes and methods are followed.
Review application, data and technical architecture deliverables throughout to ensure quality and requirement traceability
Work with Integration architecture team to get integration governance signoff on integration arch deliverables.
Responsible for ensuring CIO standard software usage in development environment
Good to have following skills
Database Architect is responsible to develop and maintain the conceptual, logic and physical data models.
This person should be able to analyze the functional and technical requirements and translate it design the best data model that suits the needs meeting the CIO standards for Data modeling.
Document benchmarks and procedures needed to optimize performance.
Ensure that all guidelines are followed.
Provide input on any design decisions for interfacing or integrating databases.
Update logical and physical database designs with changes.
Work with the application designer and technical architect to design changes to the database required by approved service requests.
Design, maintain and enhance design data dictionaries, physical and logical database models, and performance tuning.
Maintain a central data repository for the applications.