ACS Reference letter Sample for Database Administrator
The database administrator manages and maintains the database systems. The ICT units help in the analysis of data objects and their relationships to other data objects. The database administrator creates a conceptual model of how data items relate to each other. The tasks that they conduct are database security, database monitoring and troubleshooting, and planning for future growth. They also recommend optimisations of existing databases and design physical database. They develop the appropriate documentation for all tests procedures for databases and also prepare procedures for a backup process for various operating systems.
Tasks of a Database Administrator
- designing and maintaining database architecture, data structures, tables, dictionaries and naming conventions to ensure the accuracy and completeness of all data master files
- performing the operational establishment and preventive maintenance of backups, recovery procedures, and enforcing security and integrity controls
- implementing and administering database documentation, guidelines, policies and procedures
- testing database systems and upgrades, such as debugging, tracking, reproduction, logging and resolving all identified problems, according to approved quality testing scripts, procedures, and processes
- accepting responsibility for the processes, procedures and operational management associated with system security and disaster recovery planning
- liaising with security vendors, suppliers, service providers, and external resources; analyzing, recommending, installing and maintaining software security applications; and monitoring contractual obligations, performance delivery, and service level agreements
- troubleshooting and providing service support in diagnosing, resolving and repairing server-related hardware and software malfunctions, encompassing workstations and communication infrastructure
- preparing and maintaining documentation, policies and instructions, and recording and detailing operational procedures and system logs
- ensuring that the design of computer sites allows all components to fit together and work properly, and monitoring and adjusting the performance of networks
- continually surveying the current computer site to determine future network needs and making recommendations for enhancements in the implementation of future servers and networks
Employment Reference Letter Sample (Text Version)
To whomsoever it may concern
To whomsoever it may concern
This is to certify that Shresti Mahat was working with Eduon Technology at Bagbazar, Kathmandu, Nepal as a Full-Time employee from Mar 13, 2008, to Sep 8, 2017 as a Database Administrator.
Her roles and responsibilities are as follows.
ICT related roles and responsibilities
- Develop and maintains all databases required for development, testing, and production usage.
- Performs ongoing tuning of the database instances.
- Installs the database software and configures it for use. As updates and patches are required, the DBA handles this on-going maintenance
- Data Extraction, Transformation, and Loading of data that have been extracted from multiple systems into a data warehouse environment.
- Specific Data Handling, unstructured data types such as images, documents, or sound and video files.
- Creating Backup and Recovery of the database to preserve valuable data and save time and money
- Setting up employee access and authentication to maintain database security
- Monitoring databases for performance issues and performs on-going system maintenance. The database administrator needs to make configuration changes to the software or add additional hardware capacity.
- Troubleshooting if a problem or issue arises, restore lost data or correct a point to minimize damage, and quickly understand and respond to challenges when they occur.
Managerial related roles and responsibilities
- Makes a plan and implement backup and recovery of the database.
- Controls migrations of programs, database changes, reference data changes, and menu changes through the development life cycle process.
- Developing database documentation, including data standards, procedures, and definitions for the data storage.
- Carrying out capacity planning