Database Administrator

Database Administrator

Posted 1 week ago by 1756181716

Negotiable
Outside
Remote
USA

Summary: The Database Administrator role involves managing and optimizing various database environments, including Azure SQL, MySQL, and PostgreSQL. The position requires expertise in performance tuning, migration, backup, and security compliance, along with collaboration with cross-functional teams. The ideal candidate will have extensive experience in database administration and automation. This role is fully remote and classified as outside IR35.

Key Responsibilities:

  • Manage, monitor, and maintain Azure SQL, MySQL, and PostgreSQL environments.
  • Ensure high availability, reliability, and optimal performance across all database systems.
  • Diagnose and resolve slow-running queries and performance bottlenecks.
  • Design and implement indexing strategies, query tuning, and schema/database refactoring.
  • Perform seamless database migrations across environments and platforms.
  • Configure and manage replication, read/write replicas, and synchronization strategies.
  • Develop and maintain robust backup and disaster recovery plans.
  • Regularly test and validate restore strategies to minimize downtime.
  • Implement strong access control, authentication, and password management policies.
  • Ensure compliance with security standards and industry best practices.
  • Develop scripts and automation for routine administrative tasks.
  • Implement auto-scaling and optimization strategies for large-scale workloads.
  • Partner with DevOps, Cloud, and Development teams to meet application and infrastructure needs.
  • Provide expertise in database design, schema creation, and query optimization.

Key Skills:

  • 10+ years of experience as a Database Administrator or similar role.
  • Strong expertise in Azure SQL, MySQL, and PostgreSQL.
  • Hands-on experience with database performance tuning and optimization.
  • Proficiency in database migration, replication, and scaling strategies.
  • Experience with backup/recovery solutions and disaster recovery planning.
  • Knowledge of database security, compliance, and access control policies.
  • Scripting skills (e.g., PowerShell, Bash, Python, or SQL scripts) for automation.
  • Excellent problem-solving skills and ability to work cross-functionally with teams.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Key Responsibilities:

Database Administration & Management

  • Manage, monitor, and maintain Azure SQL, MySQL, and PostgreSQL environments.

  • Ensure high availability, reliability, and optimal performance across all database systems.

Performance Optimization

  • Diagnose and resolve slow-running queries and performance bottlenecks.

  • Design and implement indexing strategies, query tuning, and schema/database refactoring.

Migration & Replication

  • Perform seamless database migrations across environments and platforms.

  • Configure and manage replication, read/write replicas, and synchronization strategies.

Backup & Recovery

  • Develop and maintain robust backup and disaster recovery plans.

  • Regularly test and validate restore strategies to minimize downtime.

Security & Compliance

  • Implement strong access control, authentication, and password management policies.

  • Ensure compliance with security standards and industry best practices.

Automation & Scaling

  • Develop scripts and automation for routine administrative tasks.

  • Implement auto-scaling and optimization strategies for large-scale workloads.

Collaboration & Support

  • Partner with DevOps, Cloud, and Development teams to meet application and infrastructure needs.

  • Provide expertise in database design, schema creation, and query optimization.

Required Skills & Experience:

  • 10+ years of experience as a Database Administrator or similar role.

  • Strong expertise in Azure SQL, MySQL, and PostgreSQL.

  • Hands-on experience with database performance tuning and optimization.

  • Proficiency in database migration, replication, and scaling strategies.

  • Experience with backup/recovery solutions and disaster recovery planning.

  • Knowledge of database security, compliance, and access control policies.

  • Scripting skills (e.g., PowerShell, Bash, Python, or SQL scripts) for automation.

  • Excellent problem-solving skills and ability to work cross-functionally with teams.

Nice to Have:

  • Experience with cloud-native database services (AWS RDS, Google Cloud Platform Cloud SQL).

  • Exposure to DevOps practices, CI/CD pipelines, and Infrastructure-as-Code tools (Terraform, Ansible, etc.).

  • Familiarity with monitoring tools (Grafana, Prometheus, New Relic, etc.).