Roles of DBA

A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In general, these include basic:

• Recoverability – Creating and testing Backups
• Integrity – Verifying or helping to verify data integrity
• Security – Defining and/or implementing access controls to the data
• Availability – Ensuring maximum uptime
• Performance – Ensuring maximum performance
• Development and testing support – Helping programmers and engineers to efficiently utilize the database.

The role of a database administrator has changed according to the technology of database management systems (DBMSs) as well as the needs of the owners of the databases. For example, although logical and physical database design are traditionally the duties of a database analyst or database designer, a DBA may be tasked to perform those duties.

The Database Administrator is responsible for designing, developing and implementing programs, as required, to support the technical capabilities.

• Develop new or maintain existing databases based on specifications
• Develop, implement and maintain unit tests of database programs (i.e, SQL, etc)
• Share knowledge by effectively documenting work
• Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
• Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Design & implement data models and database designs into physical databases.
• Install and maintain database software.
• Manage backup and recovery of databases.
• Manage security of database structures and corporate data held within databases.
• Develop database procedures, triggers and SQL scripts for development teams.
• Maintain database changes from Development, QA to Production.
• Assist in the definition and implementation of database standards.
• Monitor databases for errors and perform problem determination when necessary.
• Design and implement highly available production systems.

Qualifications:

• Bachelor degree in technical discipline; or equivalent professional experience
• Experience writing complex SQL, triggers, and procedures
• Ability to work with minimal direction, yet also able to work in team environment.
• Relational database analysis and modeling experience.
• Experience configuring database network connectivity.
• Understanding of database backup and recovery techniques.
• Experience in fast paced production or operational system arena
• Clear and effective written and verbal communication skills
• Hands on and ownership personality..