What are the responsibilities and job description for the Database Administrator position at ApTask?
Job Description
Title: Database Administrator
Project Location: Frisco TX/Berkeley Heights NJ/Alpharetta GA Onsite
Project Type: Contract
Mandatory Skills: Relational - PostgreSQL and MySQL Database
Roles & Responsibilities:
Database Planning & Monitoring:
Monitor, plan, and coordinate secure data solutions in alignment with data requirements.
Design and build data models and schemas to support application requirements.
Create and maintain databases, tables, views, stored procedures, and other database objects.
Create database metric alerts.
Plan back-ups, test recovery procedures, and clone database.
Database Performance & Optimization:
Performance-tune databases, manage storage space, and administer database instances
Create and manage keys and indexes
Work closely with the application development teams to resolve any performance-related issues and provide application support.
Documentation Process Produce and maintain documentation on database structure, procedures, and data standards.
