AWS Database Administrator; DBA – Oracle & NoSQL DBA

Overview

Big Bear.ai is seeking a Senior
Database Administrator (DBA) to join our team. The ideal candidate will have a strong background in managing and optimizing both Oracle and No

SQL databases. Project teams utilize Oracle RDS and AWS managed databases including Postgres and Document

DB, and Mongo

DB, also hosted in AWS. This role requires a thorough understanding of the advantages of No

SQL databases such as the scalability, flexibility, and performance gains and the disadvantages compared to relational databases. The ideal candidate will also have hands-on experience with failover and recovery, backups, migration of on-premises databases to AWS, and proficiency with AWS services. The successful candidate should be passionate about ensuring database performance, availability, and security, and experienced in debugging complex challenges and handling data warehouses.

• Database Management:
  Administer, maintain, and implement permissions, policies and procedures for ensuring the secure connectivity and integrity of databases
• Performance Tuning:
  Monitor database performance, implement changes and apply new patches and versions when required to ensure optimal performance. Work closely with the application teams to optimize the application interaction with No
  
  SQL
• Failover and Recovery:
  Design and execute database backup and recovery strategies, including failover planning and testing
• Migration and Upgrade:
  Lead migration projects from on-premises databases to AWS, relational databases to No
  
  SQL, including planning, execution, and validation of database migrations and upgrades
• Security and Compliance:
  Ensure database security measures are in place, including access controls and audit logging. Comply with all applicable data privacy laws and regulations
• Data Warehousing:
  Manage and optimize AWS Redshift instances and other data warehousing solutions for scalable and efficient data storage and analysis
• Monitoring:
  Utilize AWS Cloud Watch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications
• Troubleshooting and Support:
  Provide support for complex database issues, including troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, etc.

Looking for a candidate with the ability to handle Oracle Prod issues and carry the Oracle Duty Phone on a rotational basis. The candidate must have solid No

SQL (Document

DB and Mongo

DB) skills as more and more applications are leveraging No

SQL databases. Solid experience of migrating databases from on-prem to cloud is a must.

• Bachelor’s degree in Computer Science, Information Technology, or related field and at least 10 years of relevant experience
• Database Expertise:
  Proven experience as a DBA with expertise in Oracle and No
  
  SQL databases
• AWS Managed Databases:
  Extensive experience with AWS Document
  
  DB database services
• Failover and Recovery:
  Solid experience in database failover, recovery procedures, and disaster recovery planning
• Migration
  
  Experience:
  
  Demonstrated experience with migrating on-premises databases to AWS
• Technical
  
  Skills:
  
  Proficient in Mongo
  
  DB Query Language (MQL), database design, and data modeling. Familiarity with AWS CLI, SDKs, and Cloud Watch
• Communication
  
  Skills:
  
  Excellent verbal and written communication skills

• Certifications:
  
  AWS or relevant database certifications (e.g., Oracle Certified Professional, AWS Associate Architect)
• Scripting
  
  Skills:
  
  Experience with scripting languages (g., Python, Bash) for automation of database tasks
• Monitoring Tools:
  Deep familiarity with database monitoring tools, especially AWS Cloud Watch, for performance monitoring and alerting
• Enterprise Database Management:
  Experience with large enterprise database design, implementation, and optimization, for example, Oracle RDS on Exadata. Experience with Oracle Real Application Clusters (RAC)
• Experience with Document DB
• Experience with Big Query is a plus

Big Bear.ai is a leading provider of AI-powered decision intelligence solutions for national security, supply chain management, and digital identity. Customers and partners rely on Bigbear.ai’s predictive analytics capabilities in highly complex, distributed, mission-based operating environments. Headquartered in McLean, Virginia, Big Bear.ai is a public company traded on the NYSE under the symbol BBAI. For more information, visit (Use the "Apply for this Job" box below). and follow Big Bear.ai

on Linked In:  and X: @Big Bearai.

Big Bear.ai is an Equal opportunity employer all protected groups, including protected veterans and individuals with disabilities.