Database Administrator

• 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 projects from on premises and AWS hosted databases 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
• 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 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

Qualifications

Required Skills and Experience

• The candidate must have solid No
  
  SQL Document DB and MongoDB skills as more and more applications are leveraging No
  
  SQL databases
• Database Expertise Proven experience as a DBA with expertise in No
  
  SQL 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 Cloud Watch
• 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 Cloud Watch 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 self motivated 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
• Self motivated 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