Senior Database Administrator

Metrocom Jaddi Technology; Daerah Khusus Ibukota Jakarta; On-site; USD 30.000 - 50.000; Full time

Job summary

A leading technology firm is seeking a Database Administrator to manage and optimize their database systems. This senior-level position requires substantial experience with relational database management systems and a proven track record in database design, performance tuning, and security management. The ideal candidate will collaborate with IT professionals and have strong problem-solving and communication skills.

Qualifications

• 5-10 years of experience as a Database Administrator.
• In-depth knowledge of RDBMS like Oracle, SQL Server, MySQL.
• Strong proficiency in SQL programming and optimization.

Responsibilities

• Design and implement database structures based on organizational requirements.
• Optimize database performance through tuning and indexing.
• Develop backup and recovery strategies to protect data.

Skills

Database Management Systems (DBMS)

SQL and Query Optimization

Security

Backup and Recovery

Monitoring Tools

Scripting

Problem-Solving

Communication

Leadership

Continuous Learning

Education

Bachelor's Degree in computer science, information technology or related field

Job description

Education

• Bachelor's Degree: A bachelor's degree in computer science, information technology, or a related field is typically required. Some organizations may prefer or require a master's degree.
  
  

Experience

• Work Experience: Several years of relevant work experience as a Database Administrator, with a proven track record of progressively responsible roles. Typically, 5-10 years of experience is common for a senior-level position.
• Database Expertise: In-depth knowledge and hands-on experience with one or more relational database management systems (RDBMS) such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, etc.
• SQL Proficiency: Strong proficiency in SQL programming and optimization, including the ability to write complex queries and troubleshoot performance issues.
  
  

Responsibilities

• Database Design and Implementation: Design and implement database structures based on organizational requirements.
• Performance Tuning: Optimize database performance by fine-tuning queries, indexing, and other performance-related parameters.
• Security Management: Ensure the security of the database system by implementing access controls, encryption, and regular security audits.
• Backup and Recovery: Develop and implement backup and recovery strategies to protect data in case of system failures or disasters.
• Monitoring and Troubleshooting: Monitor database systems to identify and resolve issues promptly. Troubleshoot problems related to database performance and functionality.
• Capacity Planning: Assess the organization's data needs and plan for the future growth of the database system.
• Collaboration: Work closely with other IT professionals, including developers and system administrators, to ensure seamless integration of the database with other systems.
• Documentation: Maintain comprehensive documentation of the database environment, including schemas, configurations, and procedures.
• Upgrades and Patch Management: Manage database software upgrades and apply patches to ensure the system's security and functionality.
  
  

Skills

• Database Management Systems (DBMS): Expertise in one or more relational database management systems such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL.
• SQL and Query Optimization: Proficiency in SQL programming and optimization techniques for efficient query performance.
• Security: Knowledge of database security principles, including authentication, authorization, and encryption.
• Backup and Recovery: Experience in implementing and managing database backup and recovery processes.
• Monitoring Tools: Familiarity with database monitoring tools to track performance metrics and identify issues.
• Scripting: Ability to write scripts for automation using languages like Shell, PowerShell, or Python.
• Problem-Solving: Strong analytical and problem-solving skills to identify and resolve issues promptly.
• Communication: Effective communication skills to collaborate with cross-functional teams and convey complex technical information to non-technical stakeholders.
• Leadership: Leadership skills to guide and mentor junior DBAs, and to lead projects related to database management.
• Continuous Learning: Given the dynamic nature of technology, a commitment to continuous learning to stay updated on the latest database trends and technologies.