IN_Senior Associate_SQL DBA_Digital Integration_Advisory_Kolkata

Job Description & Summary: A career within….

Responsibilities:

Looking for an experienced Senior Database Administrator (DBA) and Developer with 6-8 years of hands-on experience working with both SQL and NoSQL databases. Candidate is expected to have strong expertise in designing, developing, and optimizing complex queries, including aggregate queries, joins, and projections, with a deep understanding of data normalization principles. A strong specialization in MongoDB Atlas is essential, who will lead efforts in managing and scaling cloud-based NoSQL data infrastructure. Responsibilities · Design, develop, and maintain complex database architectures for both SQL (e.g., MS SQL Server, MySQL, PostgreSQL) and NoSQL (primarily MongoDB & MongoDB Atlas) environments. · Write and optimize aggregate queries, joins, and projection operations to maximize query performance and efficiency. · Apply advanced normalization techniques to improve data integrity and reduce redundancy. · Manage database security, backup, and recovery strategies to ensure high availability and data protection. · Lead database migration and replication projects across on-premises and cloud platforms (MongoDB Atlas). · Collaborate with software development teams to design efficient data models and robust query solutions.

· Monitor database performance, identify bottlenecks, and implement remediation strategies. · Develop automated scripts and tools for database maintenance, monitoring, and optimization. · Provide expert guidance on data governance, compliance, and best practices related to SQL and NoSQL technologies. · Mentor junior DBAs and developers, conducting code and query reviews to ensure quality standards. · Stay up to date with emerging trends and technologies in database design, development, and cloud solutions. Key Skills · Bachelor’s degree in Computer Science, Information Technology, or a related field. · 5-8 years of professional experience as a DBA and database developer focused on SQL and NoSQL databases. · Strong proficiency in MongoDB and MongoDB Atlas, including experience designing schemas optimized for aggregation pipelines. · Proven expertise writing complex aggregate queries, joins, projections, and manipulating data structures effectively. · Deep understanding of normalization and denormalization techniques and when to apply each. · Hands-on experience with relational databases such as MS SQL Server, MySQL, PostgreSQL, or similar.

· Skilled in performance tuning and query optimization across both SQL and NoSQL platforms. · Experience with cloud platforms and database-as-a-service environments, especially MongoDB Atlas. · Strong scripting skills (e.g., Python, Shell, PowerShell) for automation and tooling. · Familiarity with database security best practices, backup/restore, and disaster recovery planning. · Excellent problem-solving skills and the ability to troubleshoot complex database issues. · Strong communication and collaboration skills with an ability to work effectively both independently and in cross-functional teams. Preferred Qualification & Knowledge · MongoDB Certified DBA or Developer certification. · Experience with containerization and orchestration tools such as Docker and Kubernetes. · Knowledge of monitoring tools like Prometheus, Grafana, or MongoDB Ops Manager, Kibana. · Experience working in Agile/Scrum software development environments. · Familiarity with data modeling tools and visualization platforms. · Knowledge of ElasticSearch including cluster setup, index management, query DSL, relevancy tuning, and performance optimization is preferred.

Mandatory skill sets: · 5-8 years of professional experience as a DBA and database developer focused on SQL and NoSQL databases.

Preferred skill sets:

· MongoDB Certified DBA or Developer certification. · Experience with containerization and orchestration tools such as Docker and Kubernetes. · Knowledge of monitoring tools like Prometheus, Grafana, or MongoDB Ops Manager, Kibana.

Years of experience required:

5-8 Years

Education qualification:

B.Tech/B.E