Open Source Database Administrator(Sme)

1 week 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

    3 weeks ago

    Mumbai, India Clover Infotech Private Limited Full time

    Job Openings Open-Source DBA Manager​ Experience 7-12 Years Location Mumbai/Navi Mumbai 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,...

  • Open-Source DBA Manager

    3 weeks ago

    Mumbai, India Clover Infotech Private Limited Full time

    Job Openings Open-Source DBA Manager​ Experience 7-12 Years Location Mumbai/Navi Mumbai 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 Administrator

    1 week 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

    6 days ago

    Mumbai, Maharashtra, India SumCircle Technologies Private Limited Full time ₹ 5,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...

  • Open-Source DBA Manager

    2 days 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...

  • MSSQL Database Administrator

    6 days 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

    5 days 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

    1 week 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

    2 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

    1 week 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...