What are the responsibilities and job description for the Database Administrator position at GraceMark Solutions?
Job Title: Database Administrator
Location: Phoenix, AZ (Onsite)
Duration: 6 Months
Job Description:
"*10 years of experience as DBA.
*Install, configure, monitor, and maintain MySQL and MemSQL (SingleStore) database servers in on-premises and cloud environments.
*Perform routine MySQL server patching, version upgrades, and security hardening.
*Conduct MemSQL/SingleStore version upgrades, including planning, testing, and rollback procedures.
*Manage user access, roles, permissions, and security policies across all database platforms.
*Monitor database performance, identify bottlenecks, and implement query and index optimizations.
*Ensure high availability and disaster recovery through replication, failover, and backup/restore strategies.
*Administer and manage GCP Cloud SQL instances (MySQL and PostgreSQL), including provisioning, scaling, maintenance windows, and failover configurations.
*Manage Cloud Spanner instances including schema design, performance tuning, and monitoring.
*Administer BigQuery datasets, tables, access controls, partitioning strategies, and cost optimization.
*Implement and manage Cloud SQL read replicas, automated backups, and point-in-time recovery.
*Configure and manage IAM roles and VPC networking for secure database access in GCP.
*Plan, design, and execute database migrations from on-premises to GCP, including MySQL to Cloud SQL, and legacy systems to BigQuery or Spanner.
*Use tools such as Database Migration Service (DMS), mysqldump, Datastream, or custom ETL pipelines for seamless migrations.
Salary : $45 - $49