Senior Staff Engineer (Database Administrator - MongoDB, PostgreSQL)
- Full-time
- Service Region: South Asia
Company Description
👋🏼We're Nagarro.
We are a Digital Product Engineering company that is scaling in a big way! We build products, services, and experiences that inspire, excite, and delight. We work at a scale — across all devices and digital mediums, and our people exist everywhere in the world (17500+ experts across 36 countries, to be exact). Our work culture is dynamic and non-hierarchical. We are looking for great new colleagues. That is where you come in!
Job Description
Requirements
- Minimum 7+ years of experience in a senior technical database administration role within large, complex organizations.
- Proven and essential experience working within the banking or financial services sector.
- Relevant database certifications in MongoDB, PostgreSQL, MySQL, or Cassandra are required.
- Excellent knowledge in MongoDB database administration, including architecture, internals, replicasets, and sharding.
- Excellent knowledge in Ops Manager for MongoDB operations.
- Excellent knowledge in PostgreSQL database administration, including architecture, internals, high availability, and clustering.
- Excellent knowledge in database patching, upgrades, backup, and restore mechanisms for both MongoDB and PostgreSQL.
- Excellent knowledge in database auditing, logging, and security best practices.
- Excellent knowledge in database performance tuning, diagnostics, and migration.
- Good knowledge of SQL and PG PL/SQL.
- Good knowledge of Unix/Linux operating systems.
- Good knowledge of Agile working practices and modern automation technologies such as Ansible, Jenkins, and Terraform.
- Good knowledge of scripting languages, specifically Bash and Python.
- Excellent knowledge in MySQL database administration, including architecture, internals, HA, clustering, and monitoring is preferred.
- Good knowledge in Cassandra database administration, including architecture, internals, HA, clustering, and monitoring is preferred.
Responsibilities
- Provide senior-level administration, management, and support for MongoDB, PostgreSQL, and other database systems in a 24/7 banking environment.
- Design, implement, and maintain robust high availability and disaster recovery solutions using replication, clustering, and sharding technologies.
- Plan and execute database patching, upgrades, and migrations with minimal downtime and risk.
- Implement and manage comprehensive backup, restore, and recovery procedures to ensure data integrity and availability.
- Perform proactive database performance tuning, monitoring, and capacity planning.
- Enforce database security policies, implement auditing, and ensure compliance with financial sector regulations.
- Utilize Ops Manager and other monitoring tools to ensure database health and performance.
- Develop and maintain automation scripts and leverage infrastructure-as-code tools for database provisioning and management.
- Collaborate with development and infrastructure teams within an Agile framework to support project deliverables.
- Create and maintain documentation for database architectures, procedures, and configurations.
- Provide mentorship and guidance to junior team members and act as a subject matter expert.
Qualifications
Bachelor’s or master’s degree in computer science, Information Technology, or a related field.