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