Position title
Database Administrator
Description
WeLink Management Consultancy Services is hiring for a Database Administrator (Supervisory Level) on behalf of a client in the Financial Technology Industry. The Database Administrator will be responsible for the performance, integrity and security of a database as well as be involved in the planning and development of the database, including troubleshooting any issues on behalf of the users. They are to secure that data remains consistent across the database, is clearly defined, can be accessed by users concurrently in a form that suits their needs, and is provided security and recovery control ensuring that all data is retrievable in an emergency.
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
- 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
- Installs the database software and configures it for use.
- Handles on-going maintenance as updates and patches are required
- 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
- 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
- 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
- Creates backup and recovery plans and procedures based on industry best practices, then makes sure that the necessary steps are followed
- Persuades management to take necessary precautions to preserve data
- Makes sure that everything is done on schedule
- 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
- 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.
- 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
- Makes predictions about future needs based on how large the database currently is and how fast it is growing
- Creates the capacity to handle the extra workload if the company is growing quickly and adding many new users
- Performance Monitoring
- Oversees database for performance issues
- Makes configuration changes to the software or adds additional hardware capacity if some part of the system is slowing down in processing
- Database Tuning
- Identifies where the database should be tweaked to operate as efficiently as possible
- 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
Hiring organization
Job Location
Ortigas, Pasig City, Metro Manila, Philippines
Date posted
August 6, 2022
Valid through
February 28, 2021