Senior Database Administrator (PostgreSQL & MySQL)

Overview

On Site
$50+
Contract - W2
Contract - 6 Month(s)

Skills

MySQL
PostgreSQL
SQL DBA
MySQL DBA
Data Integrity
Data Archiving
Disaster Recovery
Encryption
Backup
Access Control
Recovery
Regulatory Compliance
Database
SQL
Amazon RDS
Amazon Web Services
Storage
Stored Procedures
High Availability
Remote Desktop Services
Performance Tuning
Auditing
Backup Administration
Capacity Management
Management
Optimization

Job Details

Senior Database Administrator (PostgreSQL & MySQL)

**Min Exp required: 9+ years

Role Description:

Postgres SQL and MySQL DBA

Database Management / Optimization - Design and implement database schemas, ensuring data integrity and optimal performance. - Optimize SQL queries and stored procedures for application efficiency. - Perform proactive and reactive performance tuning, including query analysis, indexing strategies, and parameter group configuration. - Manage database capacity planning and storage scaling. - Implement and manage data archiving and retention policies.
Security / Access Control - Manage user accounts, roles, and permissions within PostgreSQL and MySQL RDS instances and other databases. - Implement and enforce security best practices, including encryption in transit and at rest. - Monitor and audit database access and activity for security compliance. - High Availability
Disaster Recovery - Configure and manage multi-AZ deployments for high availability. - Implement and test backup and recovery strategies using RDS automated backups and manual snapshots. - Develop and maintain disaster recovery plans for database instances.
Monitoring / Troubleshooting - Utilize AWS monitoring tools (CloudWatch, Performance Insights, Enhanced Monitoring) to analyze database performance and identify bottlenecks. - Troubleshoot and resolve database-related issues, including performance degradation, connectivity problems, and data corruption. - Set up and manage alerts for critical database events.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.