Database Administrator - MongoDB SME

Overview

Database Administrator - MongoDB SME

Remote | US Based

Ability to obtain a Public Trust Required

 

SummaryOur client provides reliable, effective, and innovative technology solutions that advance federal, state, local, and nonprofit missions. Their technologists and consultants are passionate about solving complex challenges that impact millions of lives. Also, our client takes a Mindful Modernization approach in delivering our application modernization, grants management systems, government data analytics, and advisory services. Mindful Modernization is our client's way of delivering mission impact by aligning our government customers’ strategic objectives to measurable outcomes through people, processes, and technology.

 

Responsibilities

Our client is looking for a Database Administrator - Mongo SME to join their team! As a Database Administrator - SME you will work on a team to help the customer overcome their most difficult challenges in database management.

• Gather internal and external customer database requirements, data, and diagrams for analysis, design, development, implementation and evaluation of database change requests
• Review, recommend and update baseline schemas and provide infrastructure recommendations for enhancement
• Employ expertise in the development and sustainment of databases, dashboards, and performance/data trend analysis
• Use customer service expertise to help manage customer expectations, requirements, team tasks, and organize large amounts of data to use for instrumentation into an enterprise database solution
• Provide technical solutions to a wide range of difficult problems
• Provide on-the-job training to application POCs and database users
• Standard support hours are between 7 am – 9 pm EST and may include on-call support during weekends, holidays, or off-hours if/as required

 

Requirements

• At least 7 years’ experience in system and database administration and tuning using MongoDB, Oracle (19c and above) AND PostgreSQL in a Cloud-based enterprise environment.
  • Support for Redis is also a plus
• 2+ years’ experience with Oracle Golden Gate replication, Oracle Enterprise Manager, and/or Mongo Ops
• Mongo-specific hands-on experience required:
  • Installing and configuring MongoDB on servers including VMs and AWS-based EC2VMs
  • Analyzing and optimizing MongoDB based on transactional volume, data flow, query/report requirements to perform to expectations
  • Identifying and providing resolution for shortcomings or issues identified to include design, implementation, security, performance or architecture
  • Significant working knowledge of distributed database deployment, monitoring, and management
  • Working with development teams in an Agile scrum environment
  • Backup and Disaster recovery expertise for Cloud-Based MongoDB deployments
• Oracle-specific required expertise required:
  • Use of OEM to monitor, manage, and optimize Oracle
  • Backup and Disaster recovery experience
  • Monitor Oracle logs, ensure performance baselines are maintained, troubleshoot Oracle issues
  • Resolve database performance/lag issues
  • Query optimization and problem resolution with Oracle 19C instances
• Hands-on working Postgres experience to include instantiating Postgres instances, troubleshooting and resolving issues, monitoring performance, identifying issues and concerns, as well as making recommendations on possible corrective action
• Experience with AWS EC2 instances for db hosting including start/stop and scaling
• 3+ years’ experience with AWS GovCloud, specifically AWS RDS Oracle implementations and multi-region data architectures
• Experience withthe following is required:
  • Linux and Windows OS
  • Shell and Pythion Scripts
  • Recommending baseline thresholds, database monitoring, and database/infrastructure recommendations
  • Experience gathering and organizing large amounts of data to use for instrumentation into an Enterprise database solution
  • Experience creating technical documentation and working as part of an Agile team and participating in Agile ceremonies

 

Preferred Requirements

• Experience working with Atlassian tools (Jira, Confluence)
• Previous experience working with the VA is a plus
• Experience with ServiceNow Visual Task Boards
• Ability to work with customers and manage schedules
• Ability provide excellent verbal communication skills to effectively communicate technical information and recommendations to both technical and non-technical stakeholders