Description

Key Skills: AWS, Oracle, PostgreSQL, SQL, SQL DBA

Roles and Responsibilities:

  • Administer and maintain databases across AWS, Aurora PostgreSQL, Oracle, and MySQL platforms
  • Monitor database performance, implement tuning strategies, and apply patches and updates as needed
  • Support database design, architecture, and optimization aligned with business requirements
  • Troubleshoot and resolve database-related issues in coordination with development and DevOps teams
  • Implement backup and recovery strategies to ensure data protection and business continuity
  • Manage user roles, permissions, and access controls to enforce data security and compliance
  • Plan and execute on-premise to cloud (AWS) database migrations, ensuring minimal downtime
  • Utilize AWS Database Migration Service (DMS) for real-time and batch replication
  • Perform regular system audits and housekeeping activities to maintain cost-effective database environments
  • Use SQL and PL/SQL for querying, reporting, and migration activities
  • Automate database tasks using scripts and tools to improve operational efficiency
  • Maintain documentation, including standard operating procedures and change logs
  • Ensure databases adhere to regulatory compliance, security protocols, and best practices
  • Provide ongoing technical support and troubleshooting for database environments
  • Collaborate with cross-functional teams to evaluate new database tools, protocols, and platforms

Experience with Snowflake and monitoring tools like Datadog is a strong advantage

Skills Required:

  • Must-Have:
    • Strong experience in AWS, Aurora PostgreSQL, and Oracle database administration
    • Solid understanding of SQL, SQL tuning, and database performance optimization
    • Hands-on experience with database migration, especially to AWS
    • Knowledge of backup/recovery, security, and database access management
  • Nice-to-Have:
    • Experience with AWS DMS, Snowflake, and Datadog
    • Proficiency in automation scripting for database administration
    • Familiarity with compliance frameworks and cloud security standards

Education: Bachelor's degree in Computer Science, Information Technology, or a related field

Education

Any Graduate