Technical Architect
About The Position
Roles & Responsibilities: Excellent experience in design and build complex data solutions. Hands on experience working on mainframe database (DB2 , VSAM files) and SQL Server database Experience for cloud database migration (preferably AWS) Experience in data replication solution for forward sync, backward sync and bi-directional sync between mainframe and relational database. Rich experience in Data modelling for OLTP environment/system Oracle Data Modeler, ERwin data modeler. Rich Experience of designing and implementation of database models (LDM & PDM), data flow diagrams, database schema, DB scripts. 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. 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. Good experience of delivering data management goals & design principal in support of the organization's business goals. Hands on experience in creating enterprise relational databases on cloud/on-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.
Requirements
- Experience working on mainframe database (DB2 , VSAM files) and SQL Server database
- Experience for cloud database migration (preferably AWS)
- Experience in data replication solution for forward sync, backward sync and bi-directional sync between mainframe and relational database
- Experience in Data modelling for OLTP environment/system Oracle Data Modeler, ERwin data modeler
- Experience of designing and implementation of database models (LDM & PDM), data flow diagrams, database schema, DB scripts
- 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
- In-depth expertise with data security, storage solutions, database virtualization and replication as well as other complex database/data technical tools and solutions
- Experience of analyzing functional & non-functional business requirements & converting into technical data requirements
- Experience of delivering data management goals & design principal in support of the organization's business goals
- Experience in creating enterprise relational databases on cloud/on-prem and implement configurations for HA/DR, Replication etc.
- Experience with shell scripting, migrating files from one server to another, implementing security while sharing files
- Experience in implementing security when the data migration is in-transit and at rest
Responsibilities
- Design and build complex data solutions
- Work with technical and end users to understand business requirements and identify database/data solutions
- Develop strategies for data acquisitions, recovery, & migration
- Define enterprise-level standards (coding, architectural, migration), platform and tool selection
- Analyze functional & non-functional business requirements & converting into technical data requirements
- Deliver data management goals & design principal in support of the organization's business goals
- Create enterprise relational databases on cloud/on-prem and implement configurations for HA/DR, Replication etc.
- Implement security when the data migration is in-transit and at rest
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Professional, Scientific, and Technical Services
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
