Open Source Database Administrator(Sme)

1 day 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)

  • Open-Source DBA Manager

    1 week ago

    Navi Mumbai, Maharashtra, India Clover Infotech Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Job Summary:The Open-Source DBA Manager will lead database management, optimization, and strategy for open-source databases, such as PostgreSQL, MySQL, and MariaDB, in a production environment. The role includes overseeing a team of DBAs, ensuring high database performance, security, and reliability, and collaborating with engineering and DevOps teams. The...

  • PostgreSQL Database Administrator

    2 weeks ago

    Mumbai, India Ashnik Full time

    **Open Positions: 1**:** Location**: Mumbai** **The Position**: Ashnik is looking for a talented and passionate person to join our Technical Delivery Team in Mumbai. **Qualification and Experience**: - 4 to 5 years of hands on administration experience of working on PostgreSQL Database - Experience of working in a production support environment -...

  • Database Administrator

    3 days ago

    Ghansoli, Navi Mumbai, Maharashtra, India Austral International Co. Full time

    **Employment Type**: Full-time **Experience Required**: - **L2 Level**: Minimum 4+ years of experience in ClickHouse - **SME Level**: Minimum 6+ years of experience in ClickHouse **Educational Qualification**: - Bachelor's degree (B.E./B.Tech/MCA) in Computer Science or a related field preferred. We are looking for passionate and experienced **ClickHouse...

  • MSSQL Database Administrator:

    3 weeks ago

    Mumbai, Maharashtra, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator:Experience: 7+ yearsSkill: DBA – MSSQLRole: L3Job briefA professional Senior 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

    2 weeks ago

    Mumbai, Maharashtra, India SumCircle Technologies Private Limited Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    JD for MSSQL Database Administrator:Experience: 5-7 yearsSkill: DBA – MSSQLRole: L2Job 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

    2 days ago

    Mumbai, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator: Experience: 5-7 years Skill: DBA – MSSQL Role: L2 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

    7 days ago

    Mumbai, Maharashtra, India SumCircle Technologies Private Limited Full time

    JD for MSSQL Database Administrator:Experience: 5-7 yearsSkill: DBA – MSSQLRole: L2Job 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...

  • Oracle Database Administrator

    1 day ago

    Mumbai, India FIS Global Full time

    **Position Type**: Full time **Type Of Hire**: Experienced (relevant combo of work and education) **Education Desired**: Bachelor's Degree **Travel Percentage**: 1 - 5% **Oracle Database Administrator - 5 to 9yrs -**Mumbai/Bangalore** Are you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the most...

  • Database Administrator

    1 day ago

    Mumbai, India Dinero Software Full time

    Greetings of the Day!! Dinero Software Pvt. Ltd. Is an innovative Software Development Company that utilizes the latest technologies to bring the best software for our client’s needs. **Database Administrator**: - Mumbai, India - Fulltime - Eligibility: Any Graduate - (2 to 4 Years Relevant Experience) - Salary: Best in industry - No. Of opening - 01 -...

  • Sme - Database

    7 days ago

    Mumbai, India Microland Full time

    Additional details **Level** - P3**Requirement location** - India - Mumbai**Number of Position** - 1**Employment type** - ML**Cluster/Group** - Microland Delivery**Business Unit** - APAC**Department** - Data Center - Tech Ops**Job Description**: Required Skill Technology - Database|Knowledge of High Availability (HA) and Disaster Recovery (DR)...