Senior Data Base Administrator

Location- Hyderabad, India

Level - Senior Manager/Subject Matter Expert 

Department - Product R&D 

Working Pattern - Work from Office

Benefits - Benefits at Ideagen

Salary - To be discussed at next stage

The Database Administrator will manage installation, configuration, maintenance, and optimization of RDBMS/DBMS platforms (MSSQL, MySQL, PostgreSQL, MongoDB). This role ensures availability, security, and data integrity while implementing best practices for backup, recovery, and disaster preparedness.

Technical Expertise:

• Strong expertise in MSSQL Server versions 2016, 2019, 2022, including Enterprise and Standard editions
• Proficiency in MongoDB versions 4.x, 5.x, 6.x, 7.x (Community and Enterprise), including replica sets and sharded clusters 
• Experience with MySQL versions 5.7, 8.x, and related distributions (ref. MariaDB) 
• Proficient in database installation, configuration, and version upgrades across on-premises and cloud environments.

• Expert knowledge of backup and recovery strategies using native tools (MSSQL native backups, mongodump/mongorestore, mysqldump etc.,) 
• Experience with AWS RDS management including parameter groups, automated backups, Multi-AZ deployments, and read replicas

Performance & Optimization:

• Strong T-SQL (MSSQL), JavaScript aggregation framework (MongoDB), and SQL (MySQL) development and optimization skills
• Expert knowledge of query execution plans, index strategies, and database performance tuning
• Experience with APM and observability platforms (New Relic, DataDog, CloudWatch) for database monitoring 
• Ability to diagnose and resolve complex performance bottlenecks including locking, blocking, deadlocks, and resource contention.

High Availability & Security:

•    MSSQL: Always On Availability Groups, Failover Cluster Instances, log shipping
•    MongoDB: Replica sets, automatic failover, read preferences, oplog management
•    MySQL: Master-slave replication, Group Replication, semi-synchronous replication

Cloud & Automation:

•    Hands-on experience with AWS database services (RDS for MSSQL/MySQL, DocumentDB, Aurora MySQL)
•    Proficiency in Infrastructure as Code tools (Terraform, CloudFormation) for database provisioning
•    Strong scripting skills in PowerShell, Python, and Bash for automation and monitoring
•    Experience with configuration management tools (Ansible, Chef) for database deployments.

Must haves no Compromises and nice if some had experience of 

• Extensive Technical skills about MSSQL* (High) including SSIS, SSRS. Also Good at any of the two: MongoDB, PostgreSQL, MySQL  
• Strong Performance & Tunning skills in SQL and PL/SQL optimization, Database parameter tunning along with index and partition management
• Extensive knowledge managing database environments in Cloud and/or on-premises infrastructure.
• Demonstrable experience in production 24/7 high-availability multi-site, multi-vendor environments including hosting, data, and information security protection.
• Understanding of working with orchestration, containerization and pipeline automation scripting and tooling e.g. Docker, Terraform, Kubernetes etc.awwww2www2wwwwww
• Understanding/knowledge of software development, infrastructure, SaaS architecture, and security.
• Experience with database monitoring tools (New Relic, SolarWinds, etc.)
• Understanding in DevOps practices and CI/CD pipelines.

About Ideagen

Ideagen is the invisible force behind many things we rely on every day - from keeping airplanes soaring in the sky, to ensuring the food on our tables is safe, to helping doctors and nurses care for the sick. So, when you think of Ideagen, think of it as the silent teammate that's always working behind the scenes to help those people who make our lives safer and better. Everyday millions of people are kept safe using Ideagen software. We have offices all over the world including America, Australia, Malaysia and India with people doing lots of different and exciting jobs.

We’re building a future-ready team, and AI is part of how we work smarter. If you're curious, adaptable and open to using AI to improve how you work, you’ll thrive at Ideagen!

What is next?

If your application meets the requirements for this role, our Talent Acquisition team will be in touch to guide you through the next steps.

To ensure a flexible and inclusive process, please let us know if you require any reasonable adjustments by contacting us at [email protected]. All matters will be treated with strict confidence.

At Ideagen, we value the importance of work-life balance and welcome candidates seeking flexible or part-time working arrangements. If this is something you are interested in, please let us know during the application process.

Enhance your career and make the world a safer place!

#LI-FullTime