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

• 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