We are seeking a highly skilled and proactive Database Administrator (DBA) with expertise in managing MySQL, SQL Server (on Windows-based environments), AWS RDS, Aurora, on-premise databases, and MongoDB Atlas. The ideal candidate will have a strong background in database replication, clustering, high availability, backup and recovery strategies, performance optimization, and automation. Proficiency in Python, Shell scripting, and MongoDB Atlas as a secondary skill is essential, alongside extensive experience in SQL Server administration on Windows environments. Familiarity with modern monitoring tools like Datadog and Percona is also required.
Key Responsibilities:
1. Database Management & Optimization

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.
2. Backup & Disaster Recovery

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, and MongoDB Atlas backup strategies.

Ensure point-in-time recovery (PITR) capabilities and test disaster recovery processes regularly to guarantee business continuity.

Perform regular disaster recovery tests for MySQL, SQL Server, and MongoDB Atlas databases.

Automate backup processes and manage backup verifications using Python or Shell scripting.
3. Security & Compliance

Implement and enforce database security policies by managing access controls, user permissions, and encryption mechanisms for MySQL, SQL Server (on Windows), and MongoDB Atlas.

Stay updated with MySQL, SQL Server, and MongoDB Atlas security threats and ensure that all database systems adhere to internal and external security compliance standards.

Automate security tasks such as enforcing encryption or auditing user access using Python or Shell scripting.
4. High Availability & Scalability

Optimize database replication, clustering, and high availability solutions for MySQL (on AWS RDS, Aurora), SQL Server (Always On Availability Groups in Windows environments), and MongoDB Atlas.

Ensure auto-scaling configurations for MySQL databases on AWS and SQL Server on-premise to meet fluctuating demands.

Implement and manage read replicas and MySQL Cluster Replication for MySQL, and Always On Availability Groups for SQL Server to ensure fault tolerance and load balancing.

Leverage MongoDB Atlas features like Auto-Scaling, Sharding, and Replica Sets to ensure high availability and performance.
5. Maintenance & Upgrades

Patch and upgrade MySQL, SQL Server, and MongoDB Atlas 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.

Automate maintenance tasks such as patching, cleanup, and schema migrations using Python or Shell scripting.
6. Monitoring & Reporting

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, and MongoDB Atlas.

Review and analyze audit logs, slow query logs, and performance insights to troubleshoot and resolve performance bottlenecks.

Use Python and Shell scripting to create custom monitoring solutions and automate the reporting of database health metrics.
7. Cost Optimization

Monitor and manage AWS RDS, Aurora, and MongoDB Atlas resource utilization, identifying opportunities for cost savings through Reserved Instances, right-sizing, and other cost-optimization techniques.

Regularly review and adjust configurations for storage, CPU, and memory to prevent over-provisioning and ensure cost-effectiveness.

Automate resource tracking and cost analysis tasks using Python and Shell scripting.
8. Database Migration & Upgrades

Oversee seamless database migrations from on-premise systems to AWS RDS, Aurora, and MongoDB Atlas, utilizing tools

like AWS Database Migration Service (DMS) for MySQL and MongoDB Atlas migration tools.

Plan, execute, and test MySQL, SQL Server, and MongoDB Atlas version upgrades while minimizing downtime and operational disruptions.

Automate migration tasks using Python and Shell scripting for efficiency.
9. Archival & Cleanup Strategies

Develop and implement archival strategies to handle large data volumes while ensuring efficient data storage and retrieval for MySQL, SQL Server, and MongoDB Atlas.

Implement database cleanup strategies, including log rotation, obsolete data removal, and partitioning for performance improvements.

Automate archival and cleanup processes using Python or Shell scripting.

Requirements

5+ years of experience as a MySQL DBA, SQL Server DBA, and managing MongoDB Atlas clusters with expertise in cloud and on-premise environments.

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

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

Experience with automated monitoring using tools such as Datadog, Percona Monitoring, MongoDB Atlas Monitoring, 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, MongoDB Atlas, 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.

Experience with MongoDB Atlas features such as sharding, replica sets, and auto-scaling.

Understanding of cloud cost optimization and resource management strategies.

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 Job-Specific 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 Skills

Practice coding challenges to boost your skills

Start Practicing Now

Priority Technology Holdings

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Senior Database Administrator