Database Architect - Kolkata, West Bengal, India - Kaapro Management Solutions
Description
Opening: 1 Nos- Job ID:
Employment Type:
Full Time- Reference:
Work Experience: 6.0 Year(s)
To 15.0 Year(s)- CTC Salary: 12.00 LPA TO 15.
00 LPA- Function: IT Software - System Programming- Industry: IT-Software/Software Services- Location:
- Kolkata
**- Core Responsibilities:
- Core MySQL, MongoDB and MySQL Enterprise monitoring.
- Extensive work experience on query optimization, script optimization, other related optimization tools and
- Design and create database objects such as data table structures, stored procedures, views, Triggers,
- Data migration, backup, restore & recovery, resolving performance issues, blocking and deadlocks.
- Implement and Monitor 2Node Active\Passive SQL Clustering to provide High Availability for mission.
- Implement and maintain security and integrity controls including backup and disaster recovery strategies for document management system and MySQL databases.
- Help in translating business requirements into technical design specifications and preparing highlevel documentation for the Database Design and Database Objects.
- Create alerts and notifications, operator, Database mail configuration for system errors, insufficient resources, and fatal database errors.
- Data analytic like Power BI, Tableau
- Database partitioning, replication, Migration
- Able to handle large database (more than 1 TB)
- Integrated MySQL with Windows Active directory security for database/table level permissions
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Coordinate and work with other technical staff to develop relational databases and secondary databases, identify inefficiencies in current databases and investigate solutions.
- Diagnose and resolve database access and security issues.
- Plan and execute data migrations between different database systems.
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Ensure all database systems meet business and performance requirements.
- Creating and scheduling Jobs in MySQL, ETL, deploy SQL patches, Perform Data Migration Activity.
- Coordination with respective OEMs/Vendors.
Requirements:
- Minimum experience 6-12 Yrs.
- Education qualification BE/ BTECH/ MCA/ M TECH/BCA or any graduate with technical knowledge
- Based Location:
Key Skills:
- Database Architect
- Mysql
- Mongodb
- Database Administration
Company Profile:
We are one of the leading primary - producers in India, - TMT Rebar and Structural -.
Guided by a philosophy to produce safe and sustainable -, it is a pioneer in quality - products, operating with cutting-edge technology in order to meet the stringent requirements of its reputed customers both in India and abroad.
Operating for over six decades and now an INR 25 billion group, we have emerged as a large, growing, competitive, and multi-product - organization by delivering quality material through innovation, excellence, and dedication.
More jobs from Kaapro Management Solutions
-
Industrial Engg in Bangalore
Bengaluru, India - 1 week ago
-
Sales Coordinator
Ahmedabad, India - 1 week ago
-
Brand, Social Media and Ecommerce Team
Ahmedabad, India - 1 week ago
-
IT Officer
India - 1 week ago
-
Cook - Veg/nonveg
Kolkata, West Bengal, India - 1 week ago
-
Cafe Operator
Navi Mumbai, India - 1 week ago