DBA Project Manager
Mphasis · New York, United States · 2 wk ago
On-siteInformation Technology$90k–$174k/yrFull-time
Responsibilities
- Design and implement scalable data models, including advanced schema design, indexing, and sharding strategies for high-volume datasets
- NoSQL Data Design and implementation: Design flexible schemas, indexes, and aggregation pipelines in MongoDB to support high-speed, unstructured, and semi-structured application data
- Data Governance & Metadata: Manage data governance standards, metadata management, and data lineage for both event streams and historical data stores
- Performance Tuning: Optimize complex queries, manage the Aggregation Framework, and troubleshoot system bottlenecks
- Infrastructure Management: Maintain high availability through replica sets, perform database upgrades, and define backup and disaster recovery procedures
- Security & Compliance: Enforce data protection, manage roles and permissions, and ensure compliance with security standards (e.g., PII, PCI)
- Integration & Migration: Develop backend APIs (e.g., Node.js, Python, Java) and manage ETL/ELT processes or data migrations between SQL and NoSQL environments
Qualifications
- Core Expertise: 5 to 8+ years of experience of MongoDB features, BSON data structures, and the MongoDB Aggregation Framework
- Tools: Proficiency with MongoDB Atlas, Compass, and the MongoDB Shell
- Cloud Environments: Familiarity deploying and managing databases on cloud-native platforms like AWS, GCP, or Azure
- Programming Languages: Proficiency in backend languages such as Python, Java, or JavaScript
- Integration: Kafka: manage, support and integrate event-driven architecture, topics, schemas, and event payloads. Flink & Spark: manage, support and integrate for stateful stream processing and large-scale batch ETL pipelines.