Database Management Administrator

18 hours ago

Singapore INVENTIVO PTE. LTD. Full time

Job Description & Skills

**1. Database Management and Administration**:
a. Manage end-to-end database migrations from Oracle to PostgreSQL hosted on Azure cloud.

b. Administer SAP Db2 databases for mission-critical systems, ensuring high availability and performance.

c. Perform SQL Server version upgrades and maintain multiple SQL Server instances (2012, 2014, 2016, 2017, 2019, 2022).

**2. Performance Tuning and Optimization**:
a. Conduct performance tuning for resource-intensive queries and jobs on MySQL, Ms-SQL, Db2, and PostgreSQL systems.

b. Optimize database performance by configuring database and DBM parameters, and fine-tuning queries and stored procedures.

**3. Automation and Scripting**:
a. Develop and implement shell scripts to automate database tasks and SAP interface operations.

b. Automate Db2 installation procedures in SLES and RHEL environments.

c. Create Ansible playbooks to automate database build activities and harden database security based on KSI parameters.

**4. Cloud and Distributed Systems**:
a. Build and maintain serverless, on-demand scalable AWS Aurora PostgreSQL and MySQL databases.

b. Deploy YugabyteDB solutions as a distributed, open-source, cloud-friendly database for clients.

c. Support cloud and on-premise systems, including Pure Data Analytics (Netezza) and IBM Integrated Analytics System.

**5. Consultancy and Client Support**:
a. Provide consultancy and implementation services tailored to client requirements.

b. Offer on-call 24x7 support for database issues, coordinating with various teams for successful issue resolution.

c. Communicate effectively with clients to understand problem scenarios and deliver technical solutions.

**6. Compliance and Security**:
a. Devise auditing requirements in compliance with IM8, CIS, and SAP guidelines.

b. Plan and execute critical vulnerability fixes to enhance database security and performance.

**7. Database Development and Migration**:
a. Conversion of Crystal Reports scripts from Oracle to PostgreSQL compatible syntactically and logically.

b. Leading database object migrations from Ms SQL to PostgreSQL, including setting up EC2/RDS instances on AWS and creating ODBC connections.

c. Develop scripts to automate migration tasks such as user role evaluation and index creation.

**8. Project Leadership and Coordination**:
a. Coordinate with Backup & Recovery, UNIX, and VM teams for successful database operations.

c. Participate in Agile-based projects with daily sprints and scrum meetings.

**9. Technical Expertise and Troubleshooting**:
b. Support database performance tuning, query optimization, and configuration for high efficiency.

c. Handle the creation of special builds to fix defects or bugs in existing database code.

**10. Documentation and Training**:
a. Creation of detailed documentation for release management and product usage.

b. Conduct Webex sessions and training with customers to troubleshoot and resolve technical issues.

**11. Skills**

Administration and maintenance skills with IBM DB2
Oracle Database (added plus for PostgreSOL and MS SQL Server)

  • Senior Database Architect

    3 days ago

    Singapore beBeeDatabase Administrator Full time $100,000 - $150,000

    Job Opportunity">As a senior database administrator, you will play a pivotal role in ensuring the smooth operation of databases to meet business needs and service levels.Leading a team of junior database administrators, providing technical guidance, and managing database changes through a structured process are key responsibilities.You will be responsible...

  • Senior Database Architect

    18 hours ago

    Singapore beBeeDatabase Administrator Full time

    Job Opportunity "> As a senior database administrator, you will play a pivotal role in ensuring the smooth operation of databases to meet business needs and service levels. Leading a team of junior database administrators, providing technical guidance, and managing database changes through a structured process are key responsibilities. You will be...

  • Database Administrator/senior Database

    18 hours ago

    Singapore Singapore Management University Full time

    COMPANY DESCRIPTION Singapore Management University is a place where high-level professionalism blends together with a healthy informality. The 'family-like' atmosphere among the SMU community fosters a culture where employees work, plan, organise and play together - building a strong collegiality and morale within the university. Our commitment to attract...

  • Database Administrator

    1 week ago

    Singapore Singapore Management University Full time $80,000 - $120,000 per year

    Lead in-house database implementation (both in cloud and on-premise). Manage small to medium-scale projects and vendors (e.g. AWS and Microsoft). Responsible for preparing tender specifications, evaluation and implementation of the outsourced systems. Participate in database (DB), database firewall (DB) and data warehouse (DWH) related matters...

  • Database Administrator

    1 week ago

    Singapore Hays Full time

    data architect database **Your new company** My client is a leading technology service provider and is looking to hire a database Administrator in Singapore. This is a managerial rank and an individual contributor role. **Your new role** Maintaining, securing and operating database systems with best practices for optimisation. - Design and develop...

  • Database Administrator

    18 hours ago

    Singapore ZENTACT SYSTEMS PTE. LTD. Full time

    **Position: Database Administrator** **Duration: 4-5 months** **Location: Singapore **Job details: - 4-8 years of experience in database management - Strong knowledge of: - IBM database administration - DB scripting - Installation, management, and support - SQL and NoSQL databases - JSON - Database design principles - SQL script writing for data...

  • Database Administrator

    6 days ago

    Singapore beBeeDatabaseAdministrator Full time $90,000 - $120,000

    Job Title: Database Administrator**Overview:**The role of Database Administrator is a technical expert position within the database team. The primary responsibility of this role is to manage, administer, and support Sybase and PostgreSQL database technologies.**Key Responsibilities:**Manage and administer Sybase and PostgreSQL databases.Support and...

  • Database Administrator

    2 weeks ago

    Singapore DCI CONSULTANTS PRIVATE LIMITED Full time

    **Roles & Responsibilities** **Database Administrator Job Responsibilities**: - Install and maintain the performance of database servers. - Develop processes for optimizing database security. - Set and maintain database standards. - Manage database access. - Performance tuning of database systems. - Diagnose and troubleshoot database errors. - Recommend...

  • Database Administrator

    2 weeks ago

    Singapore DATA CONNECT TECHNOLOGIES PTE. LTD. Full time

    Proficient in working with various types of databases such as but not limited to, Microsoft SQL, MySQL, Oracle, PostgreSQL, Amazon RDS and Aurora. - Responsible for administrating databases hosted in both on-premises and cloud environment such as but not limited to Microsoft Azure, Amazon Web Service, Google Cloud Platform and Alibaba Cloud, in terms of...

  • Database Administrator

    1 week ago

    Singapore TELESOURCE EXECUTIVE SEARCH PTE. LTD. Full time

    Database Administrator **Responsibilities**: - Responsible to provide MS SQL Server, Oracle Database administration and support for projects/clients. - Create, document, and implement standards and/or complex modelling to monitor and enhance the capacity and performance of the database. - Manage, design and implement database backup and recovery procedure...