Open Source Database Administrator(Sme)

4 days ago

Mumbai, India Change Leader Full time

**JOB DESCRIPTION**

**OpenSource Database Administrator OR DBA (SME)**

**Experience**:8- 15 yrs

**Location**:Mumbai

**Primary Skills**:

- Postgres SQL 10, 11, 13, 14.
- MYSQL 5.5, 5.6, 5.7 ,8
- Mongo DB 3, 4, 6
- **8+ years **of experience as a OpenSource DBA or similar role
- Certification in one or more DB systems.

**Desired Skills & Respsonsibilities**
- Performs regular strategic analysis of the DB infrastructure and makes recommendations on improvements and/or new systems required to meet business needs and future capacity.
- Ability to provide 24x7 support.
- Manage the backup and restoration of systems.
- Participate in Disaster Recovery (DR) preparation and testing.
- Available during P1/P2/P3 issues and guide the team ensuring timely support and usage of proper escalation matrix
- Produce basic project plans, root cause analysis documents, change/risk assessments, and product management documentation
- Monitoring database efficiency
- Create and update documentation including SOP and Work Instructions

Technical & Functional skills
- A good knowledge of the physical database design.
- A good understanding of the underlying operating system(Unix(RHEL)).
- CONFIGURATION, ADMINISTRATION AND MANAGEMENT OF POSTGRESQL/MYSQL/MongoDB Databases
- PERFORMANCE TUNING AND DB MAINTENANCE AT DATABASE LEVEL.
- PERFORM DB UPGRADATION/ PATCHING.
- Partitioning (Partition Tables and it’s type understanding Range, Hash etc)
- Indexing (Local and Global Index, its benefits and drawbacks).
- Worked on Heavy databases 100+ TB.
- PERFORMING BACKUP AND RECOVERY, REPLICATION, DR-DRILL.
- Establish and maintain sound backup and recovery policies and procedures.
- PERFORMING AND MANAGING LOGICAL AND PHYSICAL BACKUPS IN POSTGRESQL AND MYSQL.
- Different backup and recovery scenarios understanding.
- Restoration backup (point in time recovery, datafile restoration).
- Implement and maintain Database security (create and maintain users and roles, assign privileges)
- Perform database tuning and performance monitoring - Plan changing understanding, how to fix plan
- TROUBLESHOOTING ON A DAILY BASIS FOR PREVENTING ISSUES AND
- PROVIDING CAPACITY PLANNING.
- MONITORING THE PRODUCTION POSTGRESQL ALERT LOGS FOR
- DATABASE ERRORS.
- MONITOR THE CLIENT CONNECTIVITY USING PG_HBA.CONF FILES.
- Work as part of a team and provide 24x7 support when required (Weekend supports)

  • Oracle Database Administrator

    6 days ago

    Mumbai, India Change Leader Full time

    **JOB DESCRIPTION** **Oracle Database Administrator [SME]** **Experience**:10+ years **Location**:Mumbai (Goregaon, Airoli) **Primary Skills**: - Oracle DBA's Exp., Oracle 10g, 11g, 12c, 19C versions (18 & 19 Additional benefits), Oracle 10g, 11g, 12c, 19C versions (18 & 19 Additional benefits). - Installation, configuration and upgrading of Oracle server...

  • MSSQL Database Administrator

    4 weeks ago

    Navi Mumbai, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator: Experience: 5-7 years Skill: DBA – MSSQL Role: L3 Job brief A professional mid level Database Administrator (DBA) with Good technical skill who can keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and...

  • MSSQL Database Administrator

    4 weeks ago

    Navi Mumbai, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator: Experience: 5-7 years Skill: DBA – MSSQL Role: L3 Job brief A professional mid level Database Administrator (DBA) with Good technical skill who can keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and...

  • MSSQL Database Administrator

    4 weeks ago

    Navi Mumbai, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator:Experience: 5-7 yearsSkill: DBA – MSSQLRole: L3Job briefA professional mid level Database Administrator (DBA) with Good technical skill who can keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend...

  • MSSQL Database Administrator

    4 weeks ago

    Navi Mumbai, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator:Experience: 5-7 yearsSkill: DBA – MSSQLRole: L3Job briefA professional mid level Database Administrator (DBA) with Good technical skill who can keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend...

  • MSSQL Database Administrator

    4 weeks ago

    Navi Mumbai, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator:Experience: 5-7 yearsSkill: DBA – MSSQLRole: L3Job briefA professional mid level Database Administrator (DBA) with Good technical skill who can keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend...

  • MongoDB Database Administrator

    2 hours ago

    Mumbai, Maharashtra, India Techberry Infotech Pvt Ltd - Database Managed Service Full time

    We're Hiring: MongoDB Database Administrator (DBA)Location:Mumbai (On-site)Experience:2–4 YearsNotice Period:Immediate to 30 Days Role OverviewWe are looking for a skilledMongoDB Database Administratorto manage, optimize, and support MongoDB environments in production and non-production systems. The ideal candidate will have strong hands-on experience...

  • Oracle & SDE Database Administrator

    7 days ago

    Mumbai, India Reliance Industries Limited Full time

    Position: Oracle & SDE Database Administrator Brief Function Administer Oracle, SQL & No-SQL Databases with SDE administration Responsible for - Knowledge of Databases like Oracle & open source databases. - Well versed with Esri’s ArcSDE technology for administering Geodatabases. - Knowledge of Kubernetes with micro services architecture understanding. -...

  • Oracle & SDE Database Administrator

    6 days ago

    Mumbai, India Reliance Industries Limited Full time

    Position: Oracle & SDE Database Administrator Brief Function Administer Oracle, SQL & No-SQL Databases with SDE administration Responsible for Knowledge of Databases like Oracle & open source databases. Well versed with Esri’s ArcSDE technology for administering Geodatabases. Knowledge of Kubernetes with micro services architecture understanding. Install...

  • Oracle & SDE Database Administrator

    5 days ago

    Mumbai, India Reliance Industries Limited Full time

    Position: Oracle & SDE Database Administrator Brief Function Administer Oracle, SQL & No-SQL Databases with SDE administration Responsible for Knowledge of Databases like Oracle & open source databases. Well versed with Esri’s ArcSDE technology for administering Geodatabases. Knowledge of Kubernetes with micro services architecture understanding. Install...