Full Job Description
Summary: The Oracle, PostGre & MySQL DBA - Senior should have advanced knowledge of Oracle, PostGre & MySQL databases including creation and implementation of fully functional database clusters, ability to maintain multiple development, QA and production environments with strong experience in performance tuning.
Responsibilities
Responsible for supporting new and existing Oracle, PostGre & MySQL database systems and will help guide best practices in database administration and introduce innovation with automation.
Responsible for designing, deploying, and maintaining MongoDB database clusters that will enable and enhance software products and systems used every day by large groups of users.
Maintains standards and design of physical data storage, maintenance, access and security administration.
Creates/maintains backup and recovery strategies on database management systems.
Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
Installs, configures and maintains high availability server solutions.
Troubleshoots alerts (alert log, jobs, disk group, etc.) and performance issues. Performs database performance tuning tasks.
Implements multiple projects along with the production support.
Will perform on-call support.
Requirements
Requirement:
• Overall, 5-8 years of experience working with information management systems in development, maintenance, administration, database management or related information systems skills.
• Minimum 5 years of Oracle, Postgre, MongoDB & Cassandra database management systems in testing, implementation, maintenance and administration in a multiple platform environment.
• Expertise in database/data design and architectural principles and methodologies.
• Upgrades of Oracle, PostGre & MySQL, database migrations and updates and application of database patches
• Backup and restores, export and import of data to and from Oracle, PostGre & MySQL, run time configuration of Oracle, PostGre & MySQL
• Monitoring server, database, collection level, and using various monitoring tools related to Oracle, PostGre & MySQL.
Education: Bachelor's degree in Computer Science, Engineering, Information Technology, Business, or a related discipline/field; OR equivalent combination of education and relevant experience.