- Installing, upgrading, configuring, testing and migrating of databases
- Managing all database related access permissions and privileges
- Performing databases normalization and optimization
Data backup /recovery and database continuity planning
- Developing, managing,testing and carrying out backup and recovery plans/processes for various sites(replication, redundancy, clustering,etc.)
Configuration and Desgin
- Mapping out the conceptual physical and logical designs for planned database landscape (Database type,version, methodology). Build database schema, tables, procedures, permissions and views.
- Implement data models and database designs, together with any web-based programming stack(PHP,ASP,JSP,RUDY,etc)
- Monitoring performance and managing parameters as well as Capacity Planning.
- Implementation of any security mechanism (Encryption)
- Scripting on server-side as well as Client -side (if required)
- Working closely with IT-related projects with I.T. Manager(s) as well as web/software programmers
- Communicating regularly with technical, applications and operational staff to ensure database integrity and security
- Performing database documentation, including data standards, procedures, schemas,structures as well as User Access Matrix.
- Reports generation (Daily health checks,task checklist, outage reports)