Database Administrator

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
Experience: Senior
Job Type: Direct Hire

Apply for this position

Allowed Type(s): .pdf, .doc, .docx