Database Administrator

Department: Software
Project Location(s): Bengaluru, Karnataka,India
Education: Bachelor of Engineering

Responsibilities

 

  • Database Installation and Configuration: Install, configure, and maintain database software and related tools.
  • Database Design and Modeling: Design database structures based on application requirements and best practices.
  • Database Security: Implement and maintain database security measures, including access control, encryption, and auditing.
  • Data Backup and Recovery: Develop and maintain database backup and recovery procedures to ensure data availability and integrity.
  • Performance Monitoring and Tuning: Monitor database performance and optimize queries, indexes, and configurations for improved performance.
  • Database Maintenance: Perform routine maintenance tasks such as database reorganizations, updates, and patches.
  • Data Migration and Integration: Migrate data between different database systems and integrate data from multiple sources.
  • Troubleshooting and Issue Resolution: Identify and resolve database-related issues, such as performance problems, data corruption, and connectivity errors.
  • Documentation: Maintain documentation related to database design, configuration, and procedures.
  • Collaboration: Work closely with developers, system administrators, and other stakeholders to ensure smooth operation of database systems.

 

Skills/Experience

 

  • Database Management Systems: Proficiency in managing various database systems such as MySQL, PostgreSQL, Oracle, SQL Server, etc.
  • Database Design: Ability to design and implement database structures, including tables, indexes, and relationships, based on application requirements.
  • Database Security: Knowledge of database security best practices to ensure data integrity and protect against unauthorized access.
  • Backup and Recovery: Experience in implementing and managing database backup and recovery procedures to ensure data availability and reliability.
  • SQL: Strong understanding of SQL (Structured Query Language) for data manipulation, querying, and database administration tasks.
  • Performance Tuning: Ability to identify and resolve database performance issues through optimization techniques, indexing, and query tuning.
  • Database Monitoring: Experience in monitoring database performance, availability, and security, and taking proactive measures to ensure optimal database operation.
  • Troubleshooting: Proficiency in troubleshooting database-related issues, such as connectivity problems, performance bottlenecks, and data corruption.
  • Data Migration: Experience in migrating data between different database systems and versions while ensuring data integrity and minimal downtime.
  • Automation: Familiarity with scripting languages (e.g., Python, PowerShell) to automate routine database administration tasks and improve efficiency.
apply now