Responsibilities:
- Assess the existing Oracle database structure and data to determine compatibility and migration requirements
- Extract, Transform, and Load (ETL) data from Oracle to PostgreSQL, ensuring data integrity and consistency
- Test and verify migrated data to ensure accuracy and completeness
- Install, configure, and manage PostgreSQL on AWS Cloud, including setting up database instances and establishing security measures
- Monitor and optimize database performance by analyzing resource utilization, identifying bottlenecks, and implementing tuning techniques
- Implement backup and recovery strategies to ensure data protection and availability
- Conducting routine maintenance tasks, such as applying patches and updates, and performing database health checks
- Develop and maintain scripts and tools to automate database administration tasks, such as backups, and performance monitoring
- Set up and configure scripts to track database performance, identify issues, and generate alerts
- Analyzing database performance metrics and logs to identify optimization opportunities and implement tuning measures
- Create and maintain documentation for database configuration, procedures, and troubleshooting guides
- Collaborate with application developers, system administrators, and other stakeholders to ensure smooth integration and functionality of the database system
- Provide technical support and troubleshooting assistance to resolve database-related issues
- Conduct performance tuning and capacity planning exercises to accommodate future growth and workload requirements
- Stay updated with the latest trends, best practices, and advancements in database technologies, cloud computing, and automation tools
Experience:
- 5+ years of Database Administration experience administering both Oracle and PostgreSQL databases are essential
- Strong understanding of database architecture, data modeling, query optimization, performance tuning, backup and recovery, and security measures
- Experience with data migration projects, specifically migrating data from Oracle to PostgreSQL
- Familiarity with ETL processes, data extraction, transformation, and loading techniques is necessary to ensure a smooth and accurate migration
- Proficiency in working with AWS Cloud platform including deploying and managing databases on Azure, configuring virtual machines, storage accounts etc.
- Strong scripting skills with scripting languages such as SQL, Python, or PowerShell are necessary to automate tasks and processes involved in data migration, monitoring, and tuning.
- Experience in monitoring database performance, analyzing metrics, identifying bottlenecks, and implementing optimization techniques
- Knowledge of monitoring tools specific to Oracle and PostgreSQL, as well as understanding how to interpret and act upon performance data
- Strong problem-solving skills are necessary to identify and resolve issues during the migration process and ongoing maintenance
- Experience troubleshooting database-related problems, investigating errors, and providing effective solutions
- Ability to communicate technical concepts and requirements clearly with various stakeholders, including developers, system administrators, and business users
- Continuously learn and stay updated with the latest advancements in database technologies, cloud platforms, and automation tools is essential for a DBA in this role.
- Bachelor’s degree in Computer Science, Information Technology, or related field or equivalent experience