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