Sign In
 [New User? Sign Up]
Mobile Version


Bengaluru, KA
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Mapping out the conceptual design for a planned database in outline;Considering both back end organization of data and front end accessibility for end users;Refining the logical design so that it can be translated into a specific data model;Further refining the physical design to meet system storage requirements;Installing and testing new versions of the database management system (DBMS);Maintaining data standards, including adherence to the Data Protection Act;Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata );Controlling access permissions and privileges;Developing, managing and testing backup and recovery plans;Ensuring that storage, archiving, backup and recovery procedures are functioning correctly;Working closely with project managers, developers, product management and product architectsCommunicating regularly with technical, product and operational staff to ensure database integrity and security;Responsible for the performance, integrity and security of a database; ensures data remains consistent across the database; data is clearly defined; users access data concurrently, in a form that suits their needs; there is provision for data security and recovery control (all data is retrievable in an emergency).CRITICAL WORK FUNCTIONSAnalyze, design, develop and implement databasesCreate, refine and adapt conceptual and logical data models;Determine target environment and/or platform; identify access and concurrency requirements;Identify backup and recovery requirements and create recovery plan;Identify high-level business rules for data models; Perform research and analyze requirements;Install and deploy databases; Integrate high-level business rules with code;Produce business and technical documents.Perform Database Administration and MaintenanceAdminister and enforce standards;Analyze monitoring data;Apply upgrades and fixes and migrate to new versions;Audit database systems;Create and implement maintenance plan for regular integrity checks;Develop and implement monitoring plan;Maintain physical organization of database objects;Manage backup and recovery both on-site and off-site;Plan and manage physical resource requirements and enhancementsPerform Database TestingDevelop test plan and system; perform tests;Develop test procedures; document test results and make recommendations. REQUIREMENTS6-9 years administering and architecting DBMS; Bachelor s degree or equivalent experience;Significant experience with Microsoft SQL server, MySQL, MS/Access;Experience with MS/Reporting Services and other Reporting/Analytic tools (i.e. Business Objects, Crystal);Experience in both the Windows/Linux platforms;Experience with privacy and security compliance regulations; HIPAA is highly desirable;Experience implementing Data Management, Backup and Recovery processesData cleansing, updating, editing and validation techniques;Data privacy rules, laws, and implementation techniques; legal requirements for archiving;Data storage and access within government regulation, and corporate policies;Developing database stored procedures, triggers, foreign key constraints, and validation (code) tables;Backup and recovery techniques; Hot/cold backups, operating system copies, archiving, log files;Code and scripts to move data between systems; data conversion techniques;Techniques for data replication, data validation and mapping between systems and after conversions;Experience with Database Performance Management; tuning and capacity planning;Experience with Database modeling for both transactional and data mining environments;Experience with Data Visualization tools and techniques.
Additional Degree: BE/ B.Tech (Engineering) | BCA (Computer Application)

Experience: 6-9


Data Warehousing | Database Administration (DBA) | Quality Assurance/Testing | Software Engineer
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News