Operations Engineer

3 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

Remote

Job Type

Full Time

Job Description

Project Role :

Operations Engineer

Project Role Description :

Support the operations and/or manage delivery for production systems and services based on operational requirements and service agreement.

Must have skills :

MySQL Database Administration

Good to have skills :

NA

Minimum 3 Year(s) Of Experience Is Required

Educational Qualification :

15 years full time educationCore Responsibilities
  • Core MySQL, MSSQL Databases
  • 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 2-Node 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 high-level 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)
  • Experience with MySQL Backup tools and Monitoring tools
  • Experience with other database systems such as MSSQL Server.
  • Knowledge of cloud-based database services (e.g., Amazon RDS, Google Cloud SQL).
  • Familiarity with database automation and orchestration tools (e.g., Ansible, Terraform).
  • Understanding of containerization technologies (e.g., Docker, Kubernetes).
  • 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.
  • Unix shell scripting and the ability to automate routine tasks
  • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
  • Proficient in writing and optimizing SQL statements
  • Experience with replication configuration in MySQL
  • Must be ready to support environments remotely while on on-call
  • Ability to plan resource requirements from high level specifications -Should be comfortable for 24x7 support., 15 years full time education

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Accenture in India logo
Accenture in India

Business Consulting and Services

Dublin 2 San Francisco

RecommendedJobs for You

Gurgaon, Haryana, India

bangalore, bangladesh, zimbabwe, uganda, noida, chennai, sri lanka, andhra pradesh, hyderabad, gurugram, kolkata, pune, mumbai city, ghana, delhi, kenya, egypt