Position: Database Designer
Responsibilities
- Works closely with product management team and application development team to design logical model as ER Diagrams.
- Performance Tuning of SQL and database schema.
- Owns Logical & Physical Data Models.
- Owns Enterprise Data Dictionary.
- Owns and Defines Metadata, Data Sources, Business Rules, Data Rules, Extract Rules and Transformations.
- Ensure Consistency across Implementations.
- The production of appropriate scripts that will realize the necessary database changes within different environments.
- Defines naming conventions and standards for database objects.
- Defines Data Archive/Purge Standards.
- Provide best practices and data solutions to meet the data needs of our business.
- Analyze performance and scalability requirements, perform data security analysis, and translating these to database design specifications.
- Perform DBA activities like Backup, Restore, Migration to newer versions of the RDBMS etc.,
Mandatory Skills
- Minimum 6 yrs experience in Oracle 8/8i/9i/10g and Oracle tools
- Experienced in designing databases for a J2EE distributed system.
- Data modeling/database designing using Modeling tools like Erwin.
- Working knowledge of Database Objects (triggers, packages, views, procedures and functions)
- Performance Tuning
- Good understanding of SQL and writing effective SQL commands.
- Excellent communication skills.
Preferred Skills
- ETL, Data Warehouse and Reporting tools.
- PLSQL Development
About the Company: Confidential
Additional Notes: Valid Passort
Experience: 6-8 Years
Education Requirements: BE/B.Tech/MS/M.Tech/MCA/M.Sc.
Contact: Kalyan, kalyan.d@careernet.co.in, +91 080 6655 0146