Job Description:
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.
Salary Range : $140,000-$160,000 a year
Salary Range
$140,000-$160,000 a year
Desired Candidate Profile
Qualifications : BACHELOR OF COMPUTER SCIENCE