Data Archive Engineer
Labcorp
Bengaluru, Karnataka, India
The data archive engineer will work with IT database professionals and with application groups to identify opportunities for archiving data from operational databases. Types of databases that are expected to be source of data are DB2, Oracle, MS SQL Server, Sybase, Postgres and other relational databases on distributed systems. Archiving may also be required from nonrelational legacy databases. The data archive engineer will assist archive business analyst in preparing the business case for potential applications. The analyst will define the appropriate requirements and archiving strategy for each application. After an application is approved for implementation, the data archive engineer will identify operational data sources that will be used for acquiring data for the archive and associated metadata that describes the data. The data archive engineer will analyze the data and metadata to determine it's accuracy and completeness. Metadata will be enhanced to overcome shortcomings. The data engineer will design data structures that will be extracted for archiving and their archive representation. Policies for when to extract data and when to discard data from the archive will be developed. A storage policy will be created that considers long-term retention requirements, data loss protection and cost. The data engineer will be responsible for the proper scheduling and execution of database archiving tasks. The analyst will also provide assistance to users in developing access to information in the archive. This will include finding the relevant archive structures, interpreting the metadata, and possibly formulating access queries. We seek smart, focused, passionate self-starters who bring energy, new ideas and practical experience to a fast-paced and dynamic team, are obsessed with delivering useful and elegant solutions, and care deeply about their customers and each other.