Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 1K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

RATE NOW!
- ABECA 2025
  
  RATE NOW!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Fusion Plus Solutions

Compare

3.5

based on 18 Reviews

1793 Fusion Plus Solutions Jobs

data base admin

Fusion Plus Solutions Inc

3.5

based on 18 Reviews

2-5 years

Hyderabad / Secunderabad

1 vacancy

data base admin

Fusion Plus Solutions

posted 1mon ago

Job Role Insights

Fixed timing

Key skills for the job

VMware MySQL DBMS Perl Business Continuity Troubleshooting

+ 4 more

Job Description

Total Experience 10 years Relevant Experience in years 10 years Job Description Please see below Mandatory Skills Database admin, DB modelling, proficiency in writing complex queries, Store Procedures, performance tuning, data warehousing skills. Good to Have Skills

Responsible for managing the organizations data infrastructure, ensuring databases are secure, efficient and accessible
Proficient in Database Management Systems
1. Relational Databases: MySQL, MariaDB, MsSQL
2. NoSQL Databases: MongoDB
3. Cloud Databases: Amazon RDS: MySQL, MariaDB
Advanced SQL skills
1. Query writing - ability to understand and write complex SQL queries, stored procedures, triggers and functions
2. Query optimization - analyze and optimize queries for performance improvement
3. Indexing strategies - understand importance of indexing, the various indexing techniques available for each DBMS and how to implement them
Database design and modelling
1. Data modelling - proficient in designing or advising on efficient database schemas using Entity-Relationship diagrams
2. Normalization/Denormalization - knowledge of normalization for less data redundancy and denormalization for performance tuning
3. Capacity planning - estimate future database growth and resource planning
Performance monitoring and tuning
1. Performance metrics - understand key metrics like CPU usage, memory allocation, disk I/O, query response times etc
2. Troubleshooting - identify and resolve performance bottlenecks in databases
Backup and recovery
1. Backup strategies - implement full, incremental and differential backups to safeguard data
2. Recovery techniques - proficient in restoring databases from backups and performing point-in-time recoveries
3. Disaster recovery planning - develop and maintain plans to ensure business continuity in case of data loss or system failures
Security management
1. Access control - implement role-based access control (RBAC) and manage user permissions
2. Data encryption - ensure data is encrypted both at rest and in transit
3. Compliance - Adhere to regulations like GDPR or PCI-DSS to maintain data privacy and security
Scripting and automation
1. Scripting languages - proficient in languages such as python, powershell, bash or perl for automation of routine tasks
2. Automation tools - experience with tools like ansible or chef to streamline database management processes
High availability and scalability
1. Clustering and replication - set up and manage database clusters and partitions and replication to ensure high availability
2. Load balancing - distribute database load across multiple servers to enhance performance and reliability
3. Sharding - implement sharding techniques to distribute data across multiple databases for scalability
Data warehousing and ETL processes
1. Data warehousing - understand data warehousing concepts and OLAP vs OLTP
2. ETL tools - experience with Extract, Transaction & Load (ETL) tools like Talend for data integration
Cloud computing and virtualization
1. Cloud platforms - proficient in cloud services like AWS and Azure, in particular, the database offerings of each
2. Virtualization technologies - experience with vritualization tools such as VMWare or Hyper-V, containerization with Docker
Experience with Development and DevOps practices
1. DevOps integration - understand DevOps methodologies and tools to facilitate continuous integration and deployment (CI/CD) involving databases
2. Version control systems - familiar with systems like GIT and liquibase for managing database scripts and configurations
Migration and upgrades
1. Database migration - skilled in migrating databases between systems or versions with minimal downtime
2. Upgrade planning - plan and execute database upgrades, ensuring compatibility and system stability