Database Specialist

JOB RESPONSIBILITIES:

• Database Housekeeping: Perform regular maintenance tasks to ensure database systems (MS SQL, Oracle, PostgreSQL, MySQL, DB2) are clean, organized, and running efficiently.
• Change Implementation: Implement changes to database configurations, schemas, and settings as required.
• Incident Resolution: Respond to and resolve database-related incidents promptly to minimize downtime and impact.
• Problem Resolution: Investigate and resolve recurring database issues to improve system stability and performance.
• Installation & Database Creation: Install database software and create new databases as needed.
• Database Administration: Manage and maintain database systems, ensuring their reliability, availability, and performance.
• User Management: Manage database user accounts, permissions, and roles.
• Database Patch Management: Apply patches and updates to database systems to ensure they are up-to-date and secure.
• Database Space Management: Monitor and manage database storage to ensure optimal space utilization.
• Cluster Administration (RAC): Administer and manage database clusters, including Oracle Real Application Clusters (RAC).

JOB REQUIREMENTS:

• 5+ years of database management experience in a global enterprise environment.
• Relevant experience with following products is a plus; InnoDB and MyISAM storage engines, SSIS, SSAS, and SSRS.
• Proficiency in managing various database technologies: MS SQL, Oracle, PostgreSQL, MySQL, DB2.
• Familiarity with ITSM like ServiceNow
• Strong knowledge of SQL and database administration.
• Experience with database monitoring tools: such as Oracle Enterprise Manager, SQL Server Management Studio, pgAdmin, MySQL Workbench, IBM Data Studio.
• Familiarity with automation tools and scripting languages: Python, Bash.
• Understanding of backup and recovery strategies.
• Knowledge of database security best practices.
• Experience with cluster administration, including Oracle RAC.
• Relevant certifications: Oracle Certified Professional, Microsoft Certified: Azure Database Administrator, etc.
• Ability to work in a 24x7 on-call after hour rotation environment.