DBA- Mongo DB

Job Description

• The successful candidate will be a production database-administration competency in our News Technology Services / New Tech Infrastructure team and will take ownership of supporting the Dow Jones/News UK / News Corp Australia/ Realtor corporate databases including performance, reliability and security of data in a core database competency.
• The Database Administrator will be primarily experienced in MongoDB. Working experience of MySQL/Aurora Administration is an additional mandatory requirement. Knowledge of Cloud technologies is required for this position. Additionally, theyll be involved in administration of databases and their eco-systems; will support release, incident, problem, business continuity management practices; will patch, upgrade and comply with audit controls; will continuously improve database service quality to ensure stability and high availability. You are experienced in implementing; securing, supporting and upgrading enterprise infrastructure, ensuring the infrastructure, which runs corporate applications, are correctly monitored and highly available as required.
• Additionally, knowledge of one of PostgreSQL or Redshift will be an advantage.
• Candidates will need to possess working knowledge of Cloud technologies of AWS and Azure including Compute (EC2, Auto Scaling, Lambda etc), Storage (S3, EFS, EBS etc.), Network (VPC, ELBs, Route 53 etc).
• Candidates are expected to work in a rotating 24 x 5 model and also provide on-call support as required by business.
Service Design
• To ensure scalability, availability and security of the database infrastructure.
• To manage the governance process for technical policy, standards and guidelines.
• To drive best practice designs that promote stability and operational efficiency
Service Technologies
• To provide guidance on core database competency to business in:
• Minimum of 5 years of experience working with MongoDB, MySQ and/or other databases.
• Should possess knowledge and concept of infrastructure and databases.
• Amazon AWS Database & Related Technologies - RDS & EC2 hosted databases.
• Should have a reasonable understanding of AWS.
• Certification in core competency preferred. (desired, but not required)
• Good understanding of platform O/S (Linux & Windows)
• Good understanding of platform scripting (Bash, PowerShell)
• Good Understanding of database / application interfaces ( SQL*Net, jdbc, odbc)
Responsibilities
• Provide 24*7 supports for production, development, and test databases.
• Be responsible for standard databases administration duties: including, but not limited to, installation, patching and change migration, monitoring, backup and recovery.
• Build, upgrade, migrate and maintain databases.Should possess strong security concepts and data protection strategies including encryption and fine-grained access controls.
• Implement proper security and access controls and keep the databases patched for security vulnerabilities.
• Should have sufficient knowledge of hardware and software load balancers.
MongoDB:
• Strong working knowledge of databases with relevant certifications.
• In depth knowledge of MongoDB 2.x, 3.x and 4.x versions.
• Experience with MongoDB Atlas, Cloud Manager and OPS Manager.
• Depth in multiple storage engines like MMAP, WiredTiger and In-Memory.
• Hands on experience in TLS/SSL, LDAP certificate configuration.
• Good understanding of security standards and best practices.
• In-depth knowledge of MongoDB management (Installation, Upgrade, Backup and Recovery, Replication, Sharding, Monitoring, Performance tuning).
• Strong understanding of database structures, theories, principles, and practices.
• Configure mongod as a service.
• Resolving the data replication lag.
• Automate the daily routine tasks.
• Data migration between on-prem to Cloud.
MySQL/Aurora:
• Must be familiar with all replication technology: master-master, master-slave, circular etc.
• Should support/Administer i.e. manage, maintain and monitor Aurora databases in AWS and on-prem MySQL databases.
• Should have sound knowledge on the Cluster and parameter groups and CLIs.
• Possess a working knowledge of database internals including locks, waits, transaction consistency, data integrity, recovery paths etc.
• Knowledge of containerization such as Docker or Kubernetes and EKS services would be a huge plus.
• Must have performed MySQL/Aurora (cloud) database upgrades and patching with minimum downtime (rolling upgrades/patches).
• Should have experience in migrating on-prem MySQL databases to RDS using different methods like DMS, Replication etc.
• Should have worked directly with developers and engineers to review database models and design, indexes and queries.
• Perform database backups and recovery.
• Must know techniques of backing up tables, databases, utilities for backup and restoring them to a point-in-time or restore a master.
• Design and build Disaster Recovery strategies

Keyskills :
mongo dbaws