USA_Database Administrator

Pay Rate Range: $ 50.38 – 55.30/hr.
GBaMS ReqID: 10404381Postgres SQL and MySQL DBAJob Description: 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 AvailabilityDisaster 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.
  Skills: Category Name Required Importance Experience
  SkillCategoryTest1_MN PL/SQL Yes 1 4-7 years

Varite