Senior Database Administrator

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)