6+ DBA Jobs in Mumbai | DBA Job openings in Mumbai

About Wekan Enterprise Solutions

Wekan Enterprise Solutions is a leading Technology Consulting company and a strategic investment partner of MongoDB. We help companies drive innovation in the cloud by adopting modern technology solutions that help them achieve their performance and availability requirements. With strong capabilities around Mobile, IOT and Cloud environments, we have an extensive track record helping Fortune 500 companies modernize their most critical legacy and on-premise applications, migrating them to the cloud and leveraging the most cutting-edge technologies.

Job Description

We are looking for a skilled MongoDB Database Administrator (DBA) to support and maintain client database systems within our services organization. The MongoDB DBA will be responsible for managing day-to-day database operations, ensuring optimal performance, security, and availability of database environments. This role requires working closely with clients, stakeholders, and teams to resolve issues, implement changes, and deliver database solutions that meet business and technical requirements.

Location - Onsite Navi Mumbai

Employment Type: Full-time

Key Responsibilities:

• Install, configure, and manage MongoDB EA on-premise databases for applications, ensuring high availability and optimal performance.
• Implement and maintain MongoDB database clusters, including replica sets and sharded clusters, ensuring data distribution and fault tolerance.
• Perform regular database performance tuning and optimization to maximize query efficiency and reduce response time.
• Implement backup and recovery strategies to ensure data availability and minimize downtime.
• Monitor and troubleshoot MongoDB database issues, including performance bottlenecks, query optimization, and replication problems.
• Execute and support version upgrades and migrations.
• Document database configurations,and troubleshooting steps to maintain a comprehensive knowledge base.
• Provide guidance and troubleshooting support on MongoDB
• Provide regular updates to stakeholders on issue status.

Requirements:

• Proven work experience as a MongoDB Database Administrator, with a focus on setting up and managing MongoDB databases.
• Strong understanding of MongoDB architecture, including replica sets, sharded clusters, and data distribution.
• Proficiency in MongoDB database performance tuning and optimization techniques.
• Experience with MongoDB backup and recovery strategies, including point-in-time recovery and disaster recovery procedures.
• Knowledge of MongoDB security features and best practices for securing MongoDB databases.
• Familiarity with MongoDB monitoring and diagnostic tools, such as MongoDB Cloud Manager, Ops Manager, or third-party solutions.
• Strong problem-solving and troubleshooting skills, with the ability to identify and resolve complex database issues.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
• MongoDB certifications (e.g., MongoDB Certified DBA) are highly desirable.
• Bachelor’s degree in Computer Science, Business, or related field with 5+ years of relevant experience.

Job Title: MySQL Database Administrator (DBA)

Experience: 4+ Years

Location: Chembur , Mumbai

Joining Timeline: Within 2 weeks preferred

Job Summary: We are looking for a skilled and experienced MySQL Database Administrator with a minimum of 4 years of hands-on experience to manage, maintain, and optimize our database systems. The ideal candidate should be well-versed in MySQL database architecture, performance tuning, backup & recovery, and ensuring high availability.

Key Responsibilities:

Install, configure, and maintain MySQL database servers.

Monitor database performance and implement changes for improvement.

Perform regular backups and recovery operations.

Optimize database performance through query optimization and indexing.

Ensure database security, integrity, and high availability.

Manage database replication and clustering setups.

Troubleshoot and resolve database-related issues.

Plan for capacity and database growth.

Collaborate with development and DevOps teams for schema design, deployment, and upgrades.

Key Requirements:

Minimum 4 years of hands-on experience in MySQL DBA roles.

Strong knowledge of MySQL versions 8 .0 +

Experience with MySQL replication (master-slave, master-master).

Proficient in performance tuning and query optimization.

Experience with backup and recovery strategies .

Familiarity with MySQL monitoring tools

Understanding of database security best practices.

Knowledge of Linux/Unix systems and shell scripting.

• Manage SQL Server databases 
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide 24x7 support for critical production systems

• Installing and maintaining the Oracle database software.
• Creating storage database structures with high-level security features.
• Altering storage structures to meet the evolving needs of the company.
• Setting up database user accounts.
• Training users on how to access the information in the database.
• Finding and debugging malfunctioning programs affecting the database integrity.
• Creating autonomous database backups.
• Regularly updating the database security protocols.

• Design, develop, implement and maintain our core Oracle applications.
• Maintain our SQL / PLSQL processes.
• Ensure DB availability.
• Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
• Actively seek to optimise and simplify our architecture.
• Take ownership of performance and capacity monitoring aspects of the DB.
• Execution of data migration jobs and scripts as required.
• Assist the infrastructure team in sizing hardware used for the DB.
• Support and collaborate with product developers.
• Contribute to the creation and maintenance of disaster recovery plans.
• Work closely with the application vendors, co-ordinate and manage the DBA activities.
• Own and follow up with Vendors/Stakeholders & their DBAs when required.
• Create a reliable backup strategy. Ensure database backups are appropriately
• executed and periodic restorations are exercised to ensure backup quality.
• Determine and document DB policies, procedures and standards.
• Performance testing and evaluation to ensure data security, privacy and integrity.
• Identification of bottle necks and deadlock issues.
• Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
• Install upgrades and security patches.
• Alter storage structures to meet the evolving needs of the company.
• Set up database user accounts.
• Train users on how to access the information in the database.
• Find and debug malfunctioning programs affecting the database integrity.
• Create autonomous database backups.
• Regularly update the database security protocols.

Desired Skills:

• Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
• Technical degree preferable (B.E. / B. Tech).
• Must experience with an organisation that has 24x7 reliability on its database.
• Must have experience with Oracle Exadata.
• Must Operating system experience in Linux.
• Must hands on knowledge of Shell scripting on Linux Platform
• Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
• Must hands on knowledge of SQL / PLSQL.
• Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
• Knowledge of Partitioning.
• Knowledge of architecture design principles.
• Good problem solver, focused and dedicated developer with ability to work on
• your own as well as with a team.
• Hands on experience with DB standards and end user applications-translating
• capacity requirements into infrastructure deployment technology.
• Strong practical experience of ORACLE in a production environment (Ver 19c).
• Must be a self-starter with a strong attention to detail.

• Key responsibility is to design, develop & maintain efficient Data models for the organization maintained to ensure optimal query performance by the consumption layer.
• Developing, Deploying & maintaining a repository of UDXs written in Java / Python.
• Develop optimal Data Model design, analyzing complex distributed data deployments, and making recommendations to optimize performance basis data consumption patterns, performance expectations, the query is executed on the tables/databases, etc.
• Periodic Database health check and maintenance
• Designing collections in a no-SQL Database for efficient performance
• Document & maintain data dictionary from various sources to enable data governance
• Coordination with Business teams, IT, and other stakeholders to provide best-in-class data pipeline solutions, exposing data via APIs, loading in down streams, No-SQL Databases, etc
• Data Governance Process Implementation and ensuring data security

Requirements

• Extensive working experience in Designing & Implementing Data models in OLAP Data Warehousing solutions (Redshift, Synapse, Snowflake, Teradata, Vertica, etc).
• Programming experience using Python / Java.
• Working knowledge in developing & deploying User-defined Functions (UDXs) using Java / Python.
• Strong understanding & extensive working experience in OLAP Data Warehousing (Redshift, Synapse, Snowflake, Teradata, Vertica, etc) architecture and cloud-native Data Lake (S3, ADLS, BigQuery, etc) Architecture.
• Strong knowledge in Design, Development & Performance tuning of 3NF/Flat/Hybrid Data Model.
• Extensive technical experience in SQL including code optimization techniques.
• Strung knowledge of database performance and tuning, troubleshooting, and tuning.
• Knowledge of collection design in any No-SQL DB (DynamoDB, MongoDB, CosmosDB, etc), along with implementation of best practices.
• Ability to understand business functionality, processes, and flows.
• Good combination of technical and interpersonal skills with strong written and verbal communication; detail-oriented with the ability to work independently.
• Any OLAP DWH DBA Experience and User Management will be added advantage.
• Knowledge in financial industry-specific Data models such as FSLDM, IBM Financial Data Model, etc will be added advantage.
• Experience in Snowflake will be added advantage.
• Working experience in BFSI/NBFC & data understanding of Loan/Mortgage data will be added advantage.

Functional knowledge

• Data Governance & Quality Assurance
• Modern OLAP Database Architecture & Design
• Linux
• Data structures, algorithm & data modeling techniques
• No-SQL database architecture
• Data Security