Database Administrator

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.

• Experience  4 - 8 years
• Key Skills for Software Developer C++, Linux :
• - Looking only for candidates who can join immediately or max 10 day
• - should be able to work independently with no handholding
• - the ability to work with C/C++ code on Windows/Linux platforms
• - Database knowledge of MSSQL, Oracle, MySQL/MariaDB, ideally other ones too: Saphana, Teradata, Postgres.
• - Ability to work on their own fixing defects
• - should be able to understand secure coding practices
• - should have the Ability to work independently and with the team across different time zones

 SQL Server DBA duties and responsibilities

• Experience in  both sql server DBA and DBA developer

•             Configure and maintain database servers and processes

•             Monitor system's health and performance

•             Ensure high levels of performance, availability, sustainability and  security

•             Analyze, solve, and correct issues in real time

•             Provide suggestions for solutions

•             Refine and automate regular processes, track issues, and document changes

•             Assist developers with query tuning and schema refinement

•             Perform scheduled maintenance and support release deployment activities

•             Database programming skills(writing and understanding Procedures , scripts..)

Good to have experience to SSIS,SSAS SSRS or any reporting tools.

• Experience working with community version PostgreSQL version 13 (or higher)
• Experience investigating/troubleshooting PostgreSQL performance issues with native Postgres catalog and statistics
• Familiarity with streaming and logical replication, HA, Backup and Recovery and Maintenance utilities including setup, configuration and monitoring.
• Strong troubleshooting and analytical skills
• 5+ years of PostgreSQL DBA experience

JD-

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.