Data Architect

Mandatory Skills Mainframe database (DB2 , VSAM ) and SQL Server, Azure , Hands on experience in Data Migrations and modeling the same. Detailed JD Design and build complex data solutions. Hands on experience working on mainframe database (DB2 , VSAM files) and SQL Server database Hands on experience in data replication solution for forward sync , backward sync and bi-directional sync between mainframe and relational database. Expertise in database design and architecture, data modelling , data mapping & conversion and data load, and creating packages for data migration & transformation using open source and commercial tools for Oracle database. hands on experience for cloud database (AWS / Azure ) Work with technical and end users to understand business requirements and identify database/data solutions. Develop strategies for data acquisitions, recovery, & migration. In-depth expertise with data security, storage solutions, database virtualization and replication as well as other complex database/data technical tools and solutions. Define enterprise-level standards (coding, architectural, migration), platform and tool selection. Good Experience of analyzing functional & non-functional business requirements & converting into technical data requirements. Rich experience in Data modelling for OLTP environment/system Oracle Data Modeller, ERwin data modeler. Rich Experience of designing and implementation of database models (LDM & PDM), data flow diagrams, database schema, DB scripts. Good experience of delivering data management goals & design principal in support of business goals of the organization. Hands on experience in creating enterprise relational database on cloud/n-prem and implement configurations for HA/DR , Replication etc. Hands on experience with shell scripting , migrating files from one server to another , implementing security while sharing files Hands on experience in implementing security when the data migration is in-transit and at rest #J-18808-Ljbffr