Database Administrator

Image-HasTech

Database Administrator

Kyriba
  • Charleston, WV, United States

Description

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.

About The Role

You will be managing, maintaining, and monitoring PostgreSQL, MongoDB and Oracle database systems, ensuring high availability, scalability, and security. You will perform routine database maintenance tasks, including backups, recovery, patching and leading the efforts on optimizing MongoDB and well as troubleshooting and resolving database-related issues in a timely manner.

Essential Duties And Responsibilities
• Performance Optimization:
• Collaborate with software developers to optimize SQL queries and database code for maximum efficiency and performance.
• Implement best practices and industry standards to improve database performance.
• Code Review:
• Review and assess database-related code written by developers for adherence to best practices, performance, and security standards.
• Provide feedback and recommendations for code improvements, with a focus on enhancing query performance.
• Database Security:
• Implement and maintain database security measures to protect sensitive data.
• Monitor and audit database access and activities to ensure compliance with security policies.
• Backup and Recovery:
• Design and implement database backup and recovery strategies to ensure data integrity and availability.
• Conduct regular disaster recovery testing.
• Documentation:
• Create and maintain comprehensive documentation related to database configurations, procedures, and best practices.
• Collaboration:
• Work closely with cross-functional teams, including developers, system administrators, and network engineers, to ensure seamless integration and optimal performance of database systems.
• AWS Migration:
• Participate in the planning and execution of the migration of our database systems to Amazon Web Services (AWS).
• Work closely with the cloud engineering team to ensure a smooth transition to AWS while maintaining data integrity and performance.

Education, Experience And Skills
• Bachelor's degree in Computer Science, Information Technology, or a related field (Master's degree preferred).
• Minimum of 3+ years of hands-on experience in Oracle Database Administration.
• Proficiency in PostgreSQL and MongoDB
• Extensive experience in performance tuning and query optimization.
• Solid understanding of database security principles and Linux/Centos
• Excellent problem-solving and troubleshooting skills.
• Windows Experience.

Base compensation for this role is: $109,500.00 - $138,700.00 annual salary. In addition to the base pay this position includes a variable compensation. The role might also be potentially eligible to long term Incentive. The final package may vary and will be determined by various factors including candidate profile and ideal qualifications as well as specific cost of living circumstances in some specific locations.

Comprehensive benefits package may be found here: www.kyriba.com/company/careers/benefits/

Kyriba believes that everyone has the ability to make an impact, and we are proud to be an equal opportunity employer committed to providing employment opportunity regardless of sex, race, creed, color, gender, religion, marital status, domestic partner status, age, national origin or ancestry, physical or mental disability, medical condition, sexual orientation, pregnancy, military or veteran status, citizenship, and genetic information. See EEO is the Law.

If reasonable accommodation is needed to participate in the job application or interview process and/or to perform essential job functions, please send an email to [email protected]

Responsibilities

  • You will be managing, maintaining, and monitoring PostgreSQL, MongoDB and Oracle database systems, ensuring high availability, scalability, and security
  • You will perform routine database maintenance tasks, including backups, recovery, patching and leading the efforts on optimizing MongoDB and well as troubleshooting and resolving database-related issues in a timely manner
  • Collaborate with software developers to optimize SQL queries and database code for maximum efficiency and performance
  • Implement best practices and industry standards to improve database performance
  • Review and assess database-related code written by developers for adherence to best practices, performance, and security standards
  • Provide feedback and recommendations for code improvements, with a focus on enhancing query performance
  • Implement and maintain database security measures to protect sensitive data
  • Monitor and audit database access and activities to ensure compliance with security policies
  • Design and implement database backup and recovery strategies to ensure data integrity and availability
  • Conduct regular disaster recovery testing
  • Create and maintain comprehensive documentation related to database configurations, procedures, and best practices
  • Work closely with cross-functional teams, including developers, system administrators, and network engineers, to ensure seamless integration and optimal performance of database systems
  • Participate in the planning and execution of the migration of our database systems to Amazon Web Services (AWS)
  • Work closely with the cloud engineering team to ensure a smooth transition to AWS while maintaining data integrity and performance

Qualifications

  • Minimum of 3+ years of hands-on experience in Oracle Database Administration
  • Proficiency in PostgreSQL and MongoDB
  • Extensive experience in performance tuning and query optimization
  • Solid understanding of database security principles and Linux/Centos
  • Excellent problem-solving and troubleshooting skills
  • Windows Experience

Educational Requirements

  • Bachelors Degree

Benefits

  • Base compensation for this role is: $109,500.00 - $138,700.00 annual salary
  • In addition to the base pay this position includes a variable compensation
  • The role might also be potentially eligible to long term Incentive
  • The final package may vary and will be determined by various factors including candidate profile and ideal qualifications as well as specific cost of living circumstances in some specific locations

Summary

Job Type : FULLTIME
Category : Database Administrator
Posted : December 2, 2023
Salary : N/A
Experience : 3 Months

Share With