Senior Database Administrator

BINUS University; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

Binus University International seeks a Database Architect/DBA in Jakarta to design and implement robust database systems using MS SQL and Oracle. You will translate business rules into data models and ensure security and performance optimization across ERP/Analytics initiatives.

The role requires at least 2 years in IT with SQL, DBMS knowledge, and strong database administration experience including backups and tuning. A Bachelor’s degree is preferred.

Qualifications

• Bachelor's degree in Computer Studies preferred.
• At least 2 years in IT, focusing on databases.
• Hands-on SQL programming experience required.
• Strong knowledge of DBMS principles and security.

Responsibilities

• Analyze and design databases; realize requirements and models.
• Develop and implement database objects and interfaces.
• Provide ongoing database administration and maintenance tasks.
• Ensure data security, backups, and performance tuning.
• Support ERP/Analytics systems integration and operations.
• Coordinate testing, monitoring, and documentation.

Skills

MS SQL

Oracle

SQL programming

DBMS

Education

Bachelor's degree in Computer Studies

Tools

Oracle ERP

PeopleSoft

Job description

It’s fun to work in a company where people truly BELIEVE in what they are doing!

We’re committed to bringing passion and customer focus to the business.

Analyze and design database:

• 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)

If you like wild growth and working with happy, enthusiastic over-achievers, you’ll enjoy your career with us!