Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Cloud Engineer

Priority Technology Holdings

5 - 8 years

7 - 10 Lacs

Chandigarh

Posted:3 days ago| Platform:

Apply

Skills Required

Performance tuning MS SQL Database design MySQL Windows Resource management AWS Technical support Auditing Python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job_Description":"

The Senior Database Administrator (DBA) is responsible for providing technical support for the database environment including assisting the development and organization of the databases and implementation of new technologies. It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible.

He should be able to work closely with other team members, do research work, able to do POC independently, take ownership of the DBA activities, and be capable of multi-tasking.

The candidate should have strong knowledge in MySQL with more than intermediate level.

Able to work in Shifts if required - Morning, Evening & Night
Presence in OnCall meetings if required
Work with Junior DBAs to implement technical solutions
Able to follow and work with Lead DBAs/Manager collaboratively
Working in shifts or implementing Change Requests as per companyrequirements including weekends
Creating tickets in Jira for each and every task of the DBA activities
Advanced knowledge of any Database Architecture(MS SQL/MySQL/ AWS RDS)
Define roles for User and Access Management with other security implementations
Reviewing of Database Scripts
Help the development team on Database Design
Configure and manage MySQL databases on AWS RDS, Aurora, and on-premise environments.
Configure and manage SQL Server databases in Windows-based environments, handling installation, configuration, backups, and optimization.
Manage MongoDB Atlas clusters, including creation, configuration, performance monitoring, and scaling.
Manage AWS RDS and Aurora replicas for MySQL databases to ensure load balancing and high availability.
Perform AWS RDS instance sizing and scaling, adjusting resources based on workload requirements and cost optimization.
Monitor database performance, implement query optimization, and create indexing strategies to ensure high performance.
Troubleshoot database issues, analyze logs, and optimize queries for performance enhancements using tools such as Amazon CloudWatch, Enhanced Monitoring, Performance Insights, and Slow Query Logs for MySQL.
Automate regular database tasks such as backups, monitoring, and scaling adjustments using Python and Shell scripting.
Develop and implement backup and recovery strategies for MySQL, SQL Server, and MongoDB Atlas using tools like MySQL Dump, Percona XtraBackup, Windows SQL Server backup strategies.
Ensure point-in-time recovery (PITR) capabilities and test disaster recovery processes regularly to guarantee business continuity.
Optimize database replication, clustering, and high availability solutions for MySQL (on AWS RDS, Aurora), SQL Server (Always On Availability Groups in Windows environments).
Patch and upgrade MySQL, SQL Server databases in both cloud and on-premise environments with minimal downtime and operational disruption.
Perform routine health checks, database cleanup, and schema optimization tasks to ensure high performance.
Implement automated monitoring using Datadog, Percona Monitoring, MongoDB Atlas Monitoring, Amazon CloudWatch, and other tools to ensure databases are operating efficiently.
Set up alerts and dashboards to monitor key metrics such as CPU, memory, disk I/O, query performance, replication lag, and shard performance for MySQL, SQL Server
Review and analyze audit logs, slow query logs, and performance insights to troubleshoot and resolve performance bottlenecks.
Oversee seamless database migrations from on-premise systems to AWS RDS, Aurora utilizing tools like AWS Database Migration Service (DMS) for MySQL
Plan, execute, and test MySQL, SQL Servers version upgrades while minimizing downtime and operational disruptions.
Develop and implement archival strategies to handle large data volumes while ensuring efficient data storage and retrieval for MySQL, SQL Server
Requirements

Strong experience with MySQL Cluster Replication, AWS RDS Replicas, backup/recovery strategies, and high availability solutions for both MySQL and SQL Server (on Windows)

Proficiency in MySQL, SQL Server performance tuning, query optimization, and indexing strategies.

Experience with automated monitoring using tools such as Datadog and AWS CloudWatch.

Expertise in Python and Shell scripting for automating database administration tasks.

Experience with basic Linux administration for MySQL environments, and Windows Server for SQL Server.

Knowledge of AWS RDS, Aurora, EC2, IAM, and CloudWatch.

Familiarity with MySQL database replication, clustering, and high availability configurations, as well as Always On Availability Groups for SQL Server.

Expertise in SQL, schema design, data migration, and ETL processes.

Understanding of cloud cost optimization and resource management strategies.

Comfortable with 24x7 support, shift work, and on-call responsibilities
Education and Experience Requirements :

Bachelors/Masterdegree in Computers or related field .

5-8 years experience as a MySQL DBA, SQL Server DBA, and AWS RDS managing & expertise in cloud and on-premise environments.

Benefits

5 Days Working

One Complimentary Meal per Day

Internet Reimbursement

Gym Reimbursement

Group Medical Insurance

Mental Health support benefits

Relocation Assistance (if Applicable)

More Jobs at Priority Technology Holdings

Senior DotDot Net Developer

Chandigarh

4.0 - 8.0 yrs

INR 6 - 10 Lacs

Analyst, Customer Support Voice (MXC Rekeys)

Chandigarh

1.0 - 5.0 yrs

INR 3 - 7 Lacs

Account Manager

Chandigarh

6.0 - 7.0 yrs

INR 10 - 12 Lacs

Senior UI/UX Designer

Chandigarh, Chandigarh, India

7.0 - 10.0 yrs

INR 7 - 10 Lacs

Database Support Lead

Chandigarh, Chandigarh, India

8.0 - 13.0 yrs

INR 8 - 13 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Priority Technology Holdings

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Cloud Engineer