Senior Database Administrator

Job Description

• Perform research and analyze requirements.


• Identify high-level business rules for data model.


• Adapt conceptual and logical data models to enterprise model.


• Validate conceptual and logical data models with clients.


• Identify backup and recovery requirements and create recovery plan.


• Identify access and concurrency requirements.


• Analyze database relative to other database. Develop and Implement database:


• Develop physical database characteristics and define user interface.


• Select unique identifiers and normalize the data model.


• Support population of database.


• Integrate high-level business rules with code.


• Develop back and front-end connectivity.


• Develop and validate database implementation plan.


• Install and deploy database.


• Produce business and technical documents.


• Tune database and optimize performance.

Job Description

• Perform research and analyze requirements.


• Determine target environment and/or platform.


• Identify high-level business rules for data model.


• Adapt conceptual and logical data models to enterprise model.


• Validate conceptual and logical data models with clients.


• Identify backup and recovery requirements and create recovery plan.


• Identify access and concurrency requirements.


• Analyze database relative to other database. Develop and Implement database:


• Develop physical database characteristics and define user interface.


• Create database objects.


• Select unique identifiers and normalize the data model.


• Support population of database.


• Integrate high-level business rules with code.


• Develop back and front-end connectivity.


• Develop and validate database implementation plan.


• Install and deploy database.


• Produce business and technical documents.


• Tune database and optimize performance.

Provide database administration and maintenance:

• Develop and implement monitoring plan.


• Analyze monitoring data.


• Manage backup and recovery both on-site and off-site.


• Maintain physical organization of database objects.


• Apply upgrades and fixes and migrate to new versions.


• Administer and enforce standards.


• Audit database systems.


• Manage database systems using available database tools.

Provide data assurance:

• Gather and document security requirements.


• Implement and enforce security requirements.


• Maintain and improve security in response to industry developments and user experience.


• Protect corporate data.

Provide database client and user services:

• Provide and support development and production environments.


• Plan and deliver user training.


• Adapt existing structure to new business environments.

Perform database testing:

• Develop test plan and system.


• Perform tests.


• Document test results and make recommendations.

Database Administration Operational activities:

• Create and monitor database and system activity planning, monitoring and evaluation for Bina Nusantara.


• Monitor database administration activities in BINUS units including configuration, security, resource monitoring and reporting, troubleshooting.


• Provide excellent service towards user, in relation to the service request, data and information update in BINUS business unit/ division.


• Design and apply procedures related to database, in relation to database authorization, change and withdrawal.


• Monitor and analyze database performance.


• Ensure all the data complies with legal regulations.


• Maintain the quality of database administration processes.


• Ensure data security and accuracy in all BINUS business unit/division.


• Ensure backup data in accordance with existing instructions. ERP & Analytics:


• Coordinate the effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure of Oracle ERP (PeopleSoft) and Analytic Application.


• Ensure the availability and operation of Oracle ERP and Analytic database for operational activities conducted by units within BINUS Units.


• Participate in the technical research and development to enable continuing innovation within the infrastructure related to Oracle ERP and Analytic Application.


• Perform test application Oracle ERP & Analytic System and evaluate the system status.


• Undertake all required Oracle and Analytic database administration activities including systems monitoring, backups, production systems continuity planning, system security and patch management.


• Ensure backup oracle database in accordance with existing instructions.

Supporting activities for management:

• Create activities report.


• Perform activities related to Quality System.


• Perform other activities as instructed by direct supervisor.

General Requirement

• Minimum Bachelor’s degree, (preferably in Computer Studies)

Work Exposure/ Experience:

• Minimum 2 years working experience in Information Technology, particularly in database, MS SQL and Oracle


• Experienced in SQL programming Special Skill:


• Database Management System (DBMS)


• Web Services Administration (system and application)