• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 2nd Aug 2022

Your future duties and responsibilities
• Interacting with business and IT teams of various application to understand their data, database and flow within the systems
• Analyzing the application DB to identify the relations, foreign keys, constraints based on scope provided by application team
• Work with DBA and Data Modeller to design new in-scope data model for every application to be used by Optim to archive and purge the data
• Should coordinate and work with all stake holders such as App team, DBA, Business, Legal others to come to common grounds for designing a working model for every app.
• Should be open to learn new tools and technologies and also shift within project needs.
• Complete work following Agile development methodology and concepts


Required qualifications to be successful in this role
• Expertise in SQL writing and Data Analysis
• Expertise in understanding RI, constraints, data relation and flow
• 4-5 years of experience in several types of databases – DB2 (LUW/Mainframe), Oracle, PostgreSQL, Hadoop others
• Experience in analyzing the database and coming up with solution design per business and application needs
• Expertise in communicating with DBA, understanding all DBA terminologies and working closely with them.
• Experience in testing, debugging and solution designing
• Experience in requirement gathering
• Experience with production environment handling
• Experience in solely handling client business calls and gathering requirements and working with client DBAs.