Operations Engineer

Operations Engineer

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 education

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