Description
Duties & Responsibilities:
• Establishes the needs of users and oversees user access and security
• Oversees performance and manages parameters in order to provide fast responses to front-end users
• Maps out the conceptual design for a planned database
• Considers both back-end organization of data and front-end accessibility for end-users
• Refines the logical design so that it can be translated into a specific data model
• Further refines the physical design to meet system storage requirements
• Installs and tests new versions of the database management system (DBMS)
• Follows data standards, including adherence to the Data Protection Act
• Writes database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Controls access permissions and privileges
• Develops, manages, and tests back-up and recovery plans
• Secures that storage and archiving procedures are functioning correctly
• Carries out capacity planning
• Works closely with IT project managers, database programmers and multimedia programmers
• Communicates regularly with technical, applications and operational staff to ensure database integrity and security
• Commissions and installs new applications and customize existing applications in order to make them fit for purpose
• Manages the security and disaster recovery aspects of a database.
• Software installation and Maintenance
o Collaborates on the initial installation and configuration of a new database whilst the Cloud System Administrator sets up hardware and deploys the operating system for the database server\
o Installs the database software and configures it for use.
o Handles on-going maintenance as updates and patches are required
o Takes care of the transfer of data from the existing system to the new platform if a new server is needed
• Data Extraction, Transformation, and Loading
o Handles ETL, data extraction, transformation, and loading which refers to efficiently importing large volumes of data that have been extracted from multiple systems into a data warehouse environment. (This external data is cleaned up and transformed to fit the desired format so that it can be imported into a central repository.)
• Specialized Data Handling
o Carefully manages a very large database (VLDB) which contains unstructured data types such as images, documents, or sound and video files requiring higher-level skills and additional monitoring and tuning to maintain efficiency
• Database Backup and Recovery
o Creates backup and recovery plans and procedures based on industry best practices, then makes sure that the necessary steps are followed
o Persuades management to take necessary precautions to preserve data
o Makes sure that everything is done on schedule
o Uses existing backups to restore lost information to the system in the case of a server failure or other form of data loss; must be prepared for any eventuality which may require different recovery strategies.
• Security
o Identifies potential weaknesses of the database software and the company's overall system and work to minimize risks and establishes best practices to minimize risks.
o Consults audit logs to see who has done what to the data in the case of a security breach or irregularity
• Authentication - Grants appropriate access to data to users
• Capacity Planning
o Makes predictions about future needs based on how large the database currently is and how fast it is growing
o Creates the capacity to handle the extra workload if the company is growing quickly and adding many new users
• Performance Monitoring
o Oversees database for performance issues
o Makes configuration changes to the software or adds additional hardware capacity if some part of the system is slowing down in processing
• Database Tuning
o Identifies where the database should be tweaked to operate as efficiently as possible
o Proactively tunes a system based on application and usage instead of waiting until a problem develops
• Troubleshooting - Quickly responds, understands, and troubleshoots problems when they occur
Qualifications:
• University Graduate on IT or any related sciences
• 5-7 years of solid experience with big data platforms and tools is preferred but not mandatory
• Excellent problem-solving and analytical skills
• Good communication, teamwork and negotiation skills
• Familiarity with the main data manipulation languages and the principles of database design and the ability to work to tight deadlines under pressure
• Good organisational skills
• Flexibility and adaptability
• The ability to create and maintain strong working relationships with colleagues and customers
• Business awareness and understanding of business requirements of IT
• A willingness to keep up to date with developments in new technology
• An understanding of information legislation, such as the Data Protection Act.
• Previous experience as a DBA
• Technical expertise with data models, data mining, and segmentation techniques
• Knowledge of programming languages (e.g. Java)
• Hands-on experience with SQL database design
• Familiar with different databases like: MySQL Server, MSSQL server, HDFS, PostgreSQL;
• Knowledge of the ETL process and implementation
• Experience with Cloud platform of the following AWS, GCP and Oracle
• Experience in creating detailed reports and analysis
• Must be very detail-oriented so as to avoid the possibility of errors and serious loss
• Good planning, organizational, and time management skills
• Must have basic knowledge on project control techniques and principles, and ability to perform comprehensive forecasting and analysis
• Good communication, presentation, and interpersonal skills
• Must be self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities
• Display strong analytical and problem-solving skills
Requirements
Minimum education level: Bachelor ́s Degree
Years of experience: 5
Language(s): English
Availability for travel: No
Availability for change of residence: Yes
People with disabilities: Yes
Duties & Responsibilities:
• Establishes the needs of users and oversees user access and security
• Oversees performance and manages parameters in order to provide fast responses to front-end users
• Maps out the conceptual design for a planned database
• Considers both back-end organization of data and front-end accessibility for end-users
• Refines the logical design so that it can be translated into a specific data model
• Further refines the physical design to meet system storage requirements
• Installs and tests new versions of the database management system (DBMS)
• Follows data standards, including adherence to the Data Protection Act
• Writes database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Controls access permissions and privileges
• Develops, manages, and tests back-up and recovery plans
• Secures that storage and archiving procedures are functioning correctly
• Carries out capacity planning
• Works closely with IT project managers, database programmers and multimedia programmers
• Communicates regularly with technical, applications and operational staff to ensure database integrity and security
• Commissions and installs new applications and customize existing applications in order to make them fit for purpose
• Manages the security and disaster recovery aspects of a database.
• Software installation and Maintenance
o Collaborates on the initial installation and configuration of a new database whilst the Cloud System Administrator sets up hardware and deploys the operating system for the database server\
o Installs the database software and configures it for use.
o Handles on-going maintenance as updates and patches are required
o Takes care of the transfer of data from the existing system to the new platform if a new server is needed
• Data Extraction, Transformation, and Loading
o Handles ETL, data extraction, transformation, and loading which refers to efficiently importing large volumes of data that have been extracted from multiple systems into a data warehouse environment. (This external data is cleaned up and transformed to fit the desired format so that it can be imported into a central repository.)
• Specialized Data Handling
o Carefully manages a very large database (VLDB) which contains unstructured data types such as images, documents, or sound and video files requiring higher-level skills and additional monitoring and tuning to maintain efficiency
• Database Backup and Recovery
o Creates backup and recovery plans and procedures based on industry best practices, then makes sure that the necessary steps are followed
o Persuades management to take necessary precautions to preserve data
o Makes sure that everything is done on schedule
o Uses existing backups to restore lost information to the system in the case of a server failure or other form of data loss; must be prepared for any eventuality which may require different recovery strategies.
• Security
o Identifies potential weaknesses of the database software and the company's overall system and work to minimize risks and establishes best practices to minimize risks.
o Consults audit logs to see who has done what to the data in the case of a security breach or irregularity
• Authentication - Grants appropriate access to data to users
• Capacity Planning
o Makes predictions about future needs based on how large the database currently is and how fast it is growing
o Creates the capacity to handle the extra workload if the company is growing quickly and adding many new users
• Performance Monitoring
o Oversees database for performance issues
o Makes configuration changes to the software or adds additional hardware capacity if some part of the system is slowing down in processing
• Database Tuning
o Identifies where the database should be tweaked to operate as efficiently as possible
o Proactively tunes a system based on application and usage instead of waiting until a problem develops
• Troubleshooting - Quickly responds, understands, and troubleshoots problems when they occur
Qualifications:
• University Graduate on IT or any related sciences
• 5-7 years of solid experience with big data platforms and tools is preferred but not mandatory
• Excellent problem-solving and analytical skills
• Good communication, teamwork and negotiation skills
• Familiarity with the main data manipulation languages and the principles of database design and the ability to work to tight deadlines under pressure
• Good organisational skills
• Flexibility and adaptability
• The ability to create and maintain strong working relationships with colleagues and customers
• Business awareness and understanding of business requirements of IT
• A willingness to keep up to date with developments in new technology
• An understanding of information legislation, such as the Data Protection Act.
• Previous experience as a DBA
• Technical expertise with data models, data mining, and segmentation techniques
• Knowledge of programming languages (e.g. Java)
• Hands-on experience with SQL database design
• Familiar with different databases like: MySQL Server, MSSQL server, HDFS, PostgreSQL;
• Knowledge of the ETL process and implementation
• Experience with Cloud platform of the following AWS, GCP and Oracle
• Experience in creating detailed reports and analysis
• Must be very detail-oriented so as to avoid the possibility of errors and serious loss
• Good planning, organizational, and time management skills
• Must have basic knowledge on project control techniques and principles, and ability to perform comprehensive forecasting and analysis
• Good communication, presentation, and interpersonal skills
• Must be self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities
• Display strong analytical and problem-solving skills
Requirements
Minimum education level: Bachelor ́s Degree
Years of experience: 5
Language(s): English
Availability for travel: No
Availability for change of residence: Yes
People with disabilities: Yes
Other Info
₱ 120,000.00 monthly · Pasig, National Capital Region · 6 minutes ago
Submit profile
WeLink Management Consultancy Services
About the company
WeLink Management Consultancy Services jobs
Taguig, National Capital Region · Today, 08:01 AM
Position Database Administrator - supervisory level recruited by the company WeLink Management Consultancy Services at , Joboko automatically collects the salary of , finds more jobs on Database Administrator - Supervisory Level or WeLink Management Consultancy Services company in the links above
About the company
WeLink Management Consultancy Services jobs
Taguig, National Capital Region · Today, 08:01 AM