Role description

Level P4

Location USA east coast west coast

Timing

• Primary Shift 600 AM EST to 200 PM EST East Coast
• Secondary Shift 1000 AM MST to 600 PM MST Mountain Standard Time
• AfterHours Support Overtime coverage for critical Priority 1 incidents during active engagement periods
• Coverage Window 14hour operational span with 1hour shift overlap for seamless handoff and knowledge transfer
• Role MangoDB senior administrator

Job Responsibilities

• 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 NoSQL
• Failover and Recovery Design and execute database backup and recovery strategies including failover planning and testing
• Migration and Upgrade Lead projects from onpremises and AWS hosted databases relational databases to NoSQL 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
• Define and implement backup strategies per data retention requirements
• Diagnose and resolve production issues as needed 24x7
• Develop and document best practices for maintenance monitoring migration and failover strategies
• Monitoring Utilize AWS CloudWatch 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

Qualifications

• Required Skills and Experience
• The candidate must have solid NoSQL DocumentDB and MongoDB skills as more and more applications are leveraging NoSQL databases
• Database Expertise Proven experience as a DBA with expertise in NoSQL databases MongoDB

AWS Managed Databases Extensive experience with AWS MangoDB RDS database services

Failover and Recovery Solid experience in database failover recovery procedures and disaster recovery planning

Technical Skills Proficient in MongoDB Query Language MQL database design and data modeling Familiarity with AWS CLI SDKs and CloudWatch

Communication Skills Excellent verbal and written communication skills

Desired Skills and Experience

Certifications AWS or relevant database certifications

Scripting Skills Experience with scripting languages eg Python Bash for automation of database tasks

Monitoring Tools Deep familiarity with database monitoring tools especially AWS CloudWatch for performance monitoring and ing

Enterprise Database Management Experience with large enterprise database design implementation and optimization

Experience with MongoDB

Experience with Big Query is a plus

Highly selfmotivated with the desire to embrace new database technologies and must be able to work independently or within a team in a high demand and dynamic environment

Strong team player with excellent written and verbal skills

Ability to work in a fastpaced development environment with a broad scope of responsibilities

Selfmotivated passionate about software and driven to achieve committed milestones

Strong communication skills Comfortable with collaboration open communication and reaching across functional borders

Customer Requirements

Clearance Ability to obtain and hold a public trust position and favorable suitability based on a CBP Background Investigation

Citizenship Must be a US Citizen

Location Availability EST and MST hours and flexible to attend on call hours and extended timeline for any major incidents This team utilizes an oncall schedule

Compliance Ability to provide data for any background verification related health and employment as per customer guidelines