3 Replication Configuration Jobs

We are seeking an experienced MySQL Database Administrator (DBA) to oversee the Performance, Tuning, Clean-up, Migration, Availability, and Security of MySQL Instances. You will be responsible for managing Clustered and Non-Clustered Configurations, Orchestrating Upgrades, Backups, Provisioning Instances, and collaborating with other teams. Your role will involve developing Database Schemas and ERDs, identifying Database issues, migrating data, and preparing documentation. Responsibilities: - Provision MySQL instances in Clustered and Non-Clustered Configurations - Ensure Performance, Tuning, Availability, and Security of MySQL Clusters - Develop Database Schema and ERD - Identify Root Causes of Database issues, perform Database Clean-up - Migrate Data between Customer and Product Databases - Prepare Documentation and Specifications - Handle common database procedures like upgrade, backup, recovery, migration - Profile server resource usage, optimize as needed - Collaborate with team members and stakeholders Skills and Qualifications: - Strong MySQL database management skills - Experience with recent MySQL versions - Understanding of MySQL storage engines (InnoDB, MyISAM) - Replication configuration expertise - Proficiency in Database Clean-up and Migrations - Knowledge of MySQL standards and best practices - Ability to write and optimize SQL statements - Familiarity with SQL features like Table Scan, Query Execution Plan - Experience in creating and managing Views - Understanding of MySQL features like Event Scheduler - Resource planning based on specifications - Familiarity with SQL/NoSQL databases (PostgreSQL, MongoDB) - Knowledge of MySQL limitations and workarounds - Proficiency in code versioning tools (SVN, Git) - DBA Certification is a plus If you have 3 to 5 years of experience in MySQL database administration, possess the required skills, and are looking for a Full-Time, Permanent position in Erode, Tamilnadu, we encourage you to apply for this Administrator role.,

As an experienced MySQL Developer with over 4 years of experience, you will be joining Xemplar Insights, a software and solutions company based in Hyderabad. Xemplar Insights specializes in leveraging smartphone technology, AWS cloud, and data science to drive digital strategies for insurance companies and commercial businesses. In this role, you will have the opportunity to work with a talented team in a fast-paced environment, focusing on innovative solutions for P&C insurance clients and large commercial businesses. Your primary responsibilities will include provisioning MySQL instances, database administration, tuning, backup, and disaster recovery, ensuring the performance, security, and availability of databases, as well as collaborating with team members and clients. To succeed in this role, you should have a strong proficiency in MySQL database management, experience with MySQL storage engines like InnoDB and MyISAM, and knowledge of replication configuration. Additionally, you should be skilled in writing and optimizing SQL statements, have experience with code versioning tools like Git/SVN, and hold an Engineering graduate or B.Tech degree with a focus on Computer Science. Soft skills such as fluency in English, outstanding leadership and organizational abilities, consultative approach in discussions, and excellent written and verbal communication skills are essential for this role. Your patience and understanding of cultural differences will also be valuable assets in this dynamic work environment.,

As a Database Administrator at our organization, your primary responsibility will be to create and manage multiple databases, ensuring optimal performance and capacity planning. You will be tasked with monitoring and tuning database performance using tools such as Query Store, DMVs, and SQL Profiler. It will be crucial for you to maintain data integrity and security by managing roles and permissions of database users. Additionally, you will utilize SQL Profiler for database tuning, generating traces, execution plans, identifying performance bottlenecks, deadlocks/contention, and resolving them. You will also play a key role in developing strategies and implementing solutions for managing backups, restoration, and replication. Creating and managing constraints and indexes, as well as supporting software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures, will be part of your daily tasks. Proactive housekeeping/archiving and shrinking of databases will also be within your scope of work. In this role, you will manage production, QA, Stage, and development database environments. Creating detailed documentation, including diagrams of database infrastructure, will be essential. It is important for you to learn relevant business processes, understand the data flow, criticality, and dependencies, and effectively coordinate and communicate with all stakeholders, including internal teams and clients. To qualify for this position, you should hold a Bachelor's or Master's degree in computer science or equivalent and have a total of 3-5+ years of experience in MSSQL Database administration using SQL Server 2014/2016/2017/2019/2022 versions. Experience in SQL Server Clustering and HA technologies, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) is required. Expertise in cloud platforms such as AWS, Azure, etc., sound knowledge of RDBMS concepts, database architecture, and SQL/T-SQL are essential. You should be proficient with SQL Server Profiler for monitoring and troubleshooting database activity and performance, with the ability to develop procedure documents and maintain detailed database-related documents. An innovative approach to work, constantly seeking to upgrade systems to more efficient technologies, and the ability to organize work efficiently under stress, changing priorities, and time constraints are valuable skills for this role. Additionally, experience with MySQL/PostgreSQL/MongoDB in a Linux environment, including Backup, replication configuration for DR purposes, and familiarity with compliance guidelines like SOC II, FINRA, and best practices like ITIL, Change/Incident Management would be advantageous. Morningstar is an Equal Opportunity employer. Our hybrid work environment offers the opportunity to work remotely and collaborate in-person each week. We believe that we are most effective when we intentionally come together regularly, at least three days each week. We provide a range of benefits to enhance flexibility as needs change, ensuring that no matter where you are, you have the tools and resources to engage meaningfully with your global colleagues.,