Operations Engineer

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 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.15 years full time education

About Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.

Visit us atwww.accenture.com

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, militaryveteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicablelaw. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.