database Administrator

Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.

database Administrator Job Description Template

Our company is looking for a database Administrator to join our team.

Responsibilities:

  • Controlling and monitoring user access to the database;
  • Maintaining archived data on tape;
  • Creating primary database storage structures (tablespaces) after application developers have designed an application;
  • Planning for backup and recovery of database information;
  • Creating primary objects (tables, views, indexes) once application developers have designed an application;
  • implementing and administering database documentation, guidelines, policies and procedures;
  • Create technical documents where ever applicable;
  • Manage Always on fail over cluster;
  • Ensuring compliance with database vendor license agreement;
  • Develop T-SQL automation scripts;
  • Backing up and restoring the database;
  • Improve database monitoring using various monitoring tool;
  • Generating various reports by querying from database as per need;
  • Be involved in everything related to relational (and also NoSQL) databases: design, maintenance, migrations, administration, configuration, etc;
  • accepting responsibility for the processes, procedures and operational management associated with system security and disaster recovery planning.

Requirements:

  • IT-Software / Software Services;
  • Good to have : Experience in any one of the scripting languages (bash, python);
  • Mandatory : Exceptional knowledge of PostgreSQL (experience with MySQL is a plus);
  • A bachelor s degree in Computer Science or equivalent;
  • Depends upon the project/program needs;
  • Industry;
  • Experience with Bucardo is a plus;
  • Successful completion of a Bachelor’s Degree or relevant database experience;
  • Experience in performance optimization techniques;
  • Experience with databases of 1-10TB in size is a plus;
  • 2-4 years hands-on experience on PostgreSQL;
  • Experience in Database Administration – configuration, backup/restore, replication, etc;
  • Excellent troubleshooting and communication skills.