Senior Database Administrator (Associate)

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

Job summary

Bina Nusantara is seeking a database professional to analyze and design databases, determine target environments, and align data models with enterprise standards. You will implement database objects, ensure security, backups, and performance, and support Oracle ERP and analytics platforms.

The role requires at least 2 years in IT with strong SQL skills and experience in DBMS. Collaboration with clients and cross-functional teams is expected to optimize data systems across BINUS units.

Qualifications

• Minimum 2 years IT experience in database management.
• Experience with SQL programming and database tuning.
• Familiarity with Oracle ERP and Analytic applications is a plus.

Responsibilities

• Analyze and design databases, identify environment and platform requirements.
• Develop and implement database objects, backups, recovery, and security plans.
• Administer and monitor databases; ensure data security and performance.

Skills

DBMS

SQL programming

Oracle

MS SQL

Web Services Admin

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!