Database Architect - Salt Lake City, India - Seamus Management Services LLP

Seamus Management Services LLP
Seamus Management Services LLP
Verified Company
Salt Lake City, India

1 week ago

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter
Description

Job Location :
Kolkata


Position :
Database Architect

Experience : 6 to 12 years

Salary : 13 lpa to 15 lpa

Qualifications
:
BE/ BTECH/ MCA/ M TECH/BCA or any graduate with technical knowledge

Industry :
Top IT


Background Required :
From Software Industry Only

Joining :
As soon as possible


Note :
Work From Office


Skills:

Core Responsibilities:


  • Core MySQL, MongoDB and MySQL Enterprise monitoring.
  • Extensive work experience on query optimization, script optimization, other related optimization tools and
- techniques including Performance monitoring.

  • Design and create database objects such as data table structures, stored procedures, views, Triggers,
- reports, Database Administration, Configuration, Maintenance and Support.

  • 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.
- critical events, database mirroring, replication, and log shipping.

  • 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.

Salary:
₹1,300, ₹1,500,000.00 per year


Schedule:

  • Morning shift

Ability to commute/relocate:

  • Rajarhat, Salt Lake City ,

West Bengal:
Reliably commute or planning to relocate before starting work (preferred)


Application Question(s):

  • Notice Period
  • Current Salary

Education:


  • Bachelor's (preferred)

Experience:

Database Architect: 6 years (preferred)

  • Core MySQL, MongoDB and MySQL Enterprise monitoring: 6 years (preferred)
  • Creating and scheduling Jobs in MySQL,

ETL:
6 years (preferred)

  • Implement and Monitor 2Node Active\Passive

SQL:
6 years (preferred)

  • Data analytic like Power BI, Tableau
: 6 years (preferred)
- data table structures, stored procedures, views, Triggers: 6 years (preferred)


Language:


  • English (preferred)

Speak with the employer
More jobs from Seamus Management Services LLP
See all jobs of Seamus Management Services LLP