-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Sep 03, 2024 at 04:31 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `cms`
--

-- --------------------------------------------------------

--
-- Table structure for table `career`
--

CREATE TABLE `career` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `experience_level` varchar(255) NOT NULL,
  `career_level` varchar(255) NOT NULL,
  `job_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `job_requirements` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `career`
--

INSERT INTO `career` (`id`, `title`, `location`, `category`, `experience_level`, `career_level`, `job_description`, `job_requirements`, `status`, `created_at`, `updated_at`) VALUES
(1, 'SEO Outreach Specialist', 'Kuala Lumpur', 'Advertising & Branding, General IT, Digital Marketing', '0 - 3 Years', 'Junior Executive', '<p>- Conduct keyword research and create keyword strategies to improve search engine ranking.</p><p>- Optimize on-page content and meta tags for improved search engine visibility.</p><p>- Develop and execute link-building strategies to improve domain authority.</p><p>- Manage and optimize Google Analytics and Google Search Console accounts.</p><p>- Monitor and analyze website performance using SEO tools.</p><p>- Stay up-to-date with the latest trends and changes in SEO.</p><p>- Maintain an open-minded mindset towards new technologies and SEO strategies.</p><p>- Generate regular reports to assess the effectiveness of SEO strategies and identify opportunities for improvement.</p><p>- Develop and implement content strategies that align with SEO goals and drive organic traffic and engagement.</p>', '<p>- Bachelor’s degree in marketing, communications, or a related field.</p><p>- Proven experience as an SEO Specialist.</p><p>- Strong knowledge of SEO best practices, including keyword research, on-page optimization, link building, and analytics.</p><p>- Experience with Google Analytics, Google Search Console, and other SEO tools.</p><p>- Familiarity with HTML, CSS, and JavaScript.</p><p>- Excellent communication and analytical skills.</p><p>- A self-starter who is able to take initiative and come up with new ideas.</p><p>- An open-minded mindset towards new technologies and SEO strategies.</p>', 'Active', '2024-08-07 05:51:46', '2024-08-14 07:21:00'),
(2, 'Software Engineer (Frontend)', 'Kuala Lumpur', 'Software Development & QA / Testing', '1 - 3 Years', 'Junior Executive', '<p>- Develop and maintain scalable frontend applications using modern web technologies such as HTML, CSS, and JavaScript, Jquery.</p><p>- Write clean, maintainable, and efficient code to ensure high-quality software.</p><p>- Collaborate with backend developers, project managers, and other stakeholders to understand business requirements and develop software solutions that meet those requirements.</p><p>- Design and implement responsive user interfaces that work across multiple devices and platforms.</p><p>- Optimize application performance and ensure scalability by using appropriate tools and techniques.</p><p>- Troubleshoot and debug issues in the frontend applications, working with other team members to identify and resolve problems.</p><p>- Participate in code reviews, ensuring that code is maintainable, testable, and scalable.</p><p>- Stay up-to-date with the latest trends and technologies in software development and frontend engineering.</p><p>- Integrating with RESTful APIs.</p>', '<p>- Bachelor\'s degree in Computer Science or a related field.</p><p>- At least 1 year of experience in software development with a focus on frontend engineering.</p><p>- Strong knowledge of HTML, CSS, and JavaScript, Jquery.</p><p>- Ability to work effectively as part of a team and communicate complex technical concepts to non-technical stakeholders.</p><p>- Strong problem-solving and analytical skills.</p><p>- Good verbal and written communication skills in English.</p>', 'Active', '2024-08-07 05:51:46', '2024-08-14 07:22:45');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `career`
--
ALTER TABLE `career`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `career`
--
ALTER TABLE `career`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
