Description

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
• 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

Skills

Mandatory Skills : AWS Database Service, PostgreSQL Migration

Key Skills

Education

Any Graduate