MySQL DBA

Job Responsibilities:

• Server Monitoring: Monitor server performance and respond to alerts promptly. Troubleshoot and resolve system and network issues.
• Server Disk Cleanup: Regularly analyze and clean up server storage to optimize performance and resource allocation.
• Deployment of New Linux Instances: Create and configure new Linux server instances based on project requirements. Ensure proper security measures and updates during deployment.
• DNS Management: Manage DNS records, domains, and configurations for internal and external services.
• Backing up/Archiving Logs: Implement backup and archiving strategies for server logs to maintain data integrity and facilitate auditing.
• MySQL Backups: Create and manage automated backups of MySQL databases to ensure data integrity. Develop disaster recovery plans.
• System Administration Strategies: Develop and implement system administration strategies to enhance server performance, security, and scalability. Stay updated with industry best practices and emerging technologies

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
• Proven experience as a Linux Administrator or similar role (5+ years).
• Proficiency in Linux server administration (CentOS, Ubuntu, etc.).
• Strong knowledge of: Server monitoring tools (e.g., Nagios, Zabbix). Configuration management tools (e.g., Ansible, Puppet). Virtualization and containerization (e.g., Docker, Kubernetes). DNS management (e.g., BIND, AWS Route 53). Backup solutions (e.g., Bacula, AWS Backup). Log management and analysis (e.g., ELK Stack, Graylog). Database administration (e.g., MySQL, MariaDB). Security best practices and firewall configuration. Scripting languages (e.g., Bash, Python). Version control systems (e.g., Git). Cloud platforms (e.g., AWS, Azure, Google Cloud). Monitoring and alerting tools (e.g., Grafana, Prometheus). Networking concepts (TCP/IP, routing). System administration strategies and documentation. Excellent problem-solving skills and the ability to work independently.

• Strong communication and teamwork skills.

Roles and Responsibilities 

Build database systems of high availability and quality depending on each end user’s specialised role

Design and implement database in accordance to end users information needs and views

Define users and enable data distribution to the right user, in appropriate format and in a timely manner

Use high-speed transaction recovery techniques and backup data

Minimise database downtime and manage parameters to provide fast query responses

Provide proactive and reactive data management support and training to users

Determine, enforce and document database policies, procedures and standards

Perform tests and evaluations regularly to ensure data security, privacy and integrity

Skills

Proven working experience as a Database Administrator

Hands-on experience with database standards and end user applications

Excellent knowledge of data backup, recovery, security, integrity and SQL

Familiarity with database design, documentation and coding

Previous experience with DBA case tools (frontend/backend) and third party tools

Problem solving skills and ability to think algorithmically

Degree in a computer discipline or relevant certification

Job Description:

MySQL - DBA L3 Support

# 7 -10  years of experience in MySQL, handled multiple versions & flavors of MySQL servers both for standalone & enterprise version, Data center and VM/Cloud setup.

# Strong database Configuration and troubleshooting / problem solving skills.

# Strong knowledge of database backup and recovery concepts and practices.

# Enabling disabling scheduled Jobs on MySQL Server

# Work with Dev and DevOps engineers to ensure that all needed data is gathered and provided to them for any performance issues

# Experience in managing both on-prem DB as well as VM / cloud based DBs

# Maintenance of backups (perform backups, monitor backup, report obsolete backups)

# Maintenance of user access (creating user accounts, dropping user accounts, granting privileges)

# Maintenance of log and trace files (remove, initialize, archive them)

# Knowledge on SQL scripts

# Managing Database administration includes Daily health checks, Database tuning, Query optimization & Backup & Replication

# Experience in alert configurations using existing alerting tools or scripts

Job Title – Sr. Database Developer and DBA MS SQL Server

Job Location – Bangalore

Experience – 8 to 10 years

CTC – 10-12 LPA

Job Description

• 8-10 years of industry experience with an appropriate University technology degree (BE,BTech,MCA)
• Should have extensive Hands-on experience in managing RDBMS Production and application DBA for MS-SQL Database.
• Must be proficient in MS-SQL programming and can handle complex logic.
• Knowledge of data structure and algorithms is a plus.
• Must have good experience in SSIS and SSRS using MSSQL Sever 2016 or later
• Monitoring, maintaining, Query tuning, performance tuning, cluster management for all RDBMS Production and application (MS-SQL).
• Database server administration with focus on security, automation, tuning, optimization, and standardization of new and deployed systems.
• Be able to work as a DBA lead and individual contributor for RDBMS platform.
• Will be responsible for database server planning with regards to scalability, redundancy, and data preservation of backend systems.
• Will develop High Availability Clustered server/network RDBMS topologies.
• Write comprehensive documentation, help develop tools to monitor systems performance, and work on optimization and tuning of various systems.
• Working with Production support teams on troubleshooting Incidents on a 24x7 basis. Looking for Sr. Sql Server DBA Who Would Provide Technical Support In Analysis, Design, Testing, And Deployment Of All Database Platform.