Total 5 Senior Executive database administrator job vacancies in D16 Upper East Coast, Bedok, Eastwood, Kew Drive

The System Administrator/Engineer (SA/E) is responsible for effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure. This individual

participates in technical research and development to enable continuing innovation within the infrastructure. This individual ensures that system hardware, operating systems, software systems, and related procedures

adhere to organizational values, enabling staff, volunteers, and Partners.

This individual is accountable for the following systems: Linux (Red Hat Enterprise Linux), Windows,

UNIX (AIX and Solaris) systems. Middleware includes WebSphere Application Servers, WebSphere Message Queue. Backup software includes Tivoli Storage Manager that support MSI/LTA infrastructure.

Responsibilities on these systems include operations and support, maintenance and research and development to ensure continual innovation.

Job Description

- Install new/rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements

- Develop and maintain installation and configuration procedures

- Research and recommend innovative, and where possible automated approaches for system administration tasks. Identify approaches that leverage our resources and provide economies of scale

- Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups, and related administration tasks

- Perform daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created, and media is recycled and sent off site as necessary

- Provide 24 by 7 technical support per request from various constituencies. Investigate, troubleshoot issues and provide professional recommendations and solutions

- Develop an in-depth knowledge of the system’s infrastructure and its integration with the various applications. Provide professional consultations and solutions as necessary

- Repair and recover from hardware or software failures. Coordinate and communicate with impacted constituencies

- Provide Desktop support and recovery services

- Managing, maintaining and supporting Middleware and other application software implementations and solutions. (WebSphere Application Server and WebSphere Message Queue, IBM Integration Bus, IBM MessageSight, IBM DataStage) Maintenance

- Develop new and/or maintain existing backup policies and schedules according to operational and business requirements

- Apply OS patches and upgrades on a regular basis, and upgrade administrative tools and utilities. Configure / add new services as necessary

- Review and evaluate software security and its related risks. Plan and implement security patching as needed

- Script application deployment, daily monitoring and automation

- Upgrade and configure system software that supports LTA/MSI infrastructure per project or operational needs

- Maintain operational, configuration, or other procedures and documents

- Perform periodic performance reporting to support capacity planning

- Perform ongoing performance tuning, hardware upgrades, and resource optimization as required. Configure CPU, memory, and disk partitions as required

- Evaluate, develop and implement new system enhancements per request from various constituencies

- Plan and deploy new SeP application software upgrades / Business Objects as required

- Perform incident management, vendor management and reporting

- Monitor and coordinate recovery procedures between the affected constituencies and the vendor. Provide technical assistance as required

- Involve in the Disaster Recovery planning and execution of DR procedures during simulated dry runs and actual disaster runs

Requirements

- Working knowledge of basic cloud infrastructure is an added advantage.

Technical Expertise and Knowledge include:

- OS : Windows, Linux, AIX,

- Middleware : WebSphere Application Servers, WebSphere Message Queue, Tivoli Directory Services, WebSphere Network Deployment Manager, Edge Server, IBM Integration Bus, IBM MessageSight, IBM DataStage.

- Backup software : Tivoli Storage Manager,

- Storage: V3000, V5000, V7000/V9000 SAN

- Hypervisor: VMWare.

- Others include Tape Library, BOE, Web Server, HACMP, HMC, SAN Switch, UPS, Samba, Flashcopy, VIOS, Red Hat Virtualization.

- Windows Desktop installation, configuration and support

- WebSphere, IIB, Application Deployment

- Unix shell and VB scripting

• Cloud Platform Expertise: Experience with one or more cloud platforms such as AWS, Azure, Google Cloud, or other similar providers

• Infrastructure as Code (IaC): Proficiency in using tools like Terraform, CloudFormation, or Ansible to manage cloud infrastructure

• Cloud Resource Management: Experience in deploying, managing, and monitoring cloud-based instances (e.g., virtual machines, storage, networking, etc.)

• Automation & Scripting: Strong scripting skills (e.g., Python, PowerShell, Bash) to automate tasks in a cloud environment

• Cloud Security: Understanding of cloud security best practices (e.g., IAM roles, security groups, firewall configurations)

• Monitoring & Performance: Familiarity with cloud monitoring tools (e.g., AWS CloudWatch, Azure Monitor) to track performance and troubleshoot issues

• Scalability & Cost Management: Experience in scaling cloud infrastructure dynamically and optimizing costs using reserved instances, spot instances, and autoscaling

Responsibilities

Database Management:

• Configure and maintain SQL Server databases, ensuring their availability, performance, sustainability, and security.
• Migrate On-Prem SQL Databases to Azure, AWS, Google Could solutions.
• Expert knowledge in creating and maintaining SQL Server Jobs.

Integration Deployment:

• Expert knowledge in SSIS catalog services and creating environments to perform seamless deployments between environments for SSIS packages.
• Expert in creating catalogs and SSIS environments and SSIS integration solutions using Visual Studio to deploy packages.

System Monitoring:

• Monitor system health and performance, identifying and addressing issues in real time.
• Experience with monitoring tools like SolarWinds and Nagios or developing own monitoring solutions using PowerShell scripting will be an asset.

Performance Optimization:

• Analyze, solve, and correct performance-related problems.
• Adapt proactive mentoring techniques to ensure maximum system uptime and less downtime for applications and business users.

Solution Recommendations:

• Provide suggestions for improving database processes and performance.
• Work closely with SMEs and programmers to align with best practice guidelines and provide direction to build robust applications.

Automation:

• Refine and automate regular processes, track issues, and document changes.
• Experience in creating and using PowerShell scripts to manage core DBA tasks.

Query Tuning:

• Assist developers with query tuning and schema refinement.
• Expert knowledge in Tuning Advisor and query plans to guide developers.

24x7 Support:

• Provide on-call rotation support for critical production systems, including after-hours maintenance and release deployment activities.

Data Recovery and Backup Strategies:

• Be prepared to manage data recovery scenarios.
• Define and implement robust backup and recovery strategies.
• Assist Development team by performing on-demand restore tasks as needed.

Qualifications and Experience

• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or related fields preferred
• Certifications: Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate or MCSE: Data Management and Analytics are advantageous.
• Experience: Preferably 15 + years of experience as a DBA, with advanced knowledge of large-scale databases in a 24/7 environment.

Technical Skills:

• Proficiency in database Server administration, including backups, restores, and performance tuning.
• Familiarity with Windows Server, T-SQL, and PowerShell scripting.
• Understanding of high availability and disaster recovery concepts.
• Experience in DTS package conversion to SSIS and fine-tuning SSIS packages.
• Experience in creating Visual Studio solutions for integration services to deploy projects to SSIS catalog databases.
• Proven experience in cloud technologies (AZURE, AWS, Oracle, and Google).

Competencies (Skills & Behaviors)

• Excellent communication and people skills
• Ability to work in a team environment.
• Good Analytical & Critical thinking skills
• Possess a High Regard for Quality Work
• Extremely Motivated, Dynamic & Creative Individual
• Demonstrates meticulous diligence and consistently follows up.
• Strong organizational skills

You will be providing effective administrative support to the Account Servicing team. You will be responsible for preparation of contracts, settlement reports and following-up on outstanding, uploading of advertisement, generate/tracking of reports, filing etc.

Core Responsibilities:

• Providing administrative support to the Account Servicing team
• Ensure that the contracts are prepared accurately, sent out and received in a timely manner to meet internal procedures and customer satisfaction
• Ensure that the settlement reports are prepared accurately in a timely manner to meet customer satisfaction
• Maintain a good filing system for all the contracts
• Upload advertisements onto the website and send out electronic email blasts timely and accurately
• Provide reminders to Account Servicing team on deadlines for the returning of contracts, settlement reports and submission of advertising material
• Prepare reports for the Account-Servicing team
• Any other duties assigned by Account-Servicing Manager

Job Specifications:

• Diploma in Business Administration
• Proficient in Microsoft Excel & Word
• Prior event handling experience will be an added advantage
• Motivated, meticulous and results oriented
• Good interpersonal and communication skills
• Team player and ability to work effectively
• This is a 1 year contract role

Responsibilities

Database Management:

• Configure and maintain SQL Server databases, ensuring their availability, performance, sustainability, and security.
• Migrate On-Prem SQL Databases to Azure, AWS, Google Could solutions.
• Expert knowledge in creating and maintaining SQL Server Jobs.

Integration Deployment:

• Expert knowledge in SSIS catalog services and creating environments to perform seamless deployments between environments for SSIS packages.
• Expert in creating catalogs and SSIS environments and SSIS integration solutions using Visual Studio to deploy packages.

System Monitoring:

• Monitor system health and performance, identifying and addressing issues in real time.
• Experience with monitoring tools like SolarWinds and Nagios or developing own monitoring solutions using PowerShell scripting will be an asset.

Performance Optimization:

• Analyze, solve, and correct performance-related problems.
• Adapt proactive mentoring techniques to ensure maximum system uptime and less downtime for applications and business users.

Solution Recommendations:

• Provide suggestions for improving database processes and performance.
• Work closely with SMEs and programmers to align with best practice guidelines and provide direction to build robust applications.

Automation:

• Refine and automate regular processes, track issues, and document changes.
• Experience in creating and using PowerShell scripts to manage core DBA tasks.

Query Tuning:

• Assist developers with query tuning and schema refinement.
• Expert knowledge in Tuning Advisor and query plans to guide developers.

24x7 Support:

• Provide on-call rotation support for critical production systems, including after-hours maintenance and release deployment activities.

Data Recovery and Backup Strategies:

• Be prepared to manage data recovery scenarios.
• Define and implement robust backup and recovery strategies.
• Assist Development team by performing on-demand restore tasks as needed.

Qualifications and Experience

• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or related fields preferred
• Certifications: Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate or MCSE: Data Management and Analytics are advantageous.
• Experience: Preferably 15 + years of experience as a DBA, with advanced knowledge of large-scale databases in a 24/7 environment.

Technical Skills:

• Proficiency in database Server administration, including backups, restores, and performance tuning.
• Familiarity with Windows Server, T-SQL, and PowerShell scripting.
• Understanding of high availability and disaster recovery concepts.
• Experience in DTS package conversion to SSIS and fine-tuning SSIS packages.
• Experience in creating Visual Studio solutions for integration services to deploy projects to SSIS catalog databases.
• Proven experience in cloud technologies (AZURE, AWS, Oracle, and Google).

Competencies (Skills & Behaviors)

• Excellent communication and people skills
• Ability to work in a team environment.
• Good Analytical & Critical thinking skills
• Possess a High Regard for Quality Work
• Extremely Motivated, Dynamic & Creative Individual
• Demonstrates meticulous diligence and consistently follows up.
• Strong organizational skills

Job Responsibilities

• Installation, Implementation, Evaluation, Configuration, Administration, Operations, Monitoring, and Management of Oracle Databases (12c / 19c) running on Linux environment.
• Provide technical solutions for database related issues.
• Monitor and optimize database performance, ensuring high levels of system availability and reliability.
• Data Management and Operational Support for both Oracle.
• Implement and manage high availability solutions including Oracle RAC and Data Guard
• Troubleshooting real-time performance and tuning issues in Oracle Database
• Manage and perform database backup restore.
• Upgrade of New Software Releases, Patches and System.
• All aspects of database tuning from software configuration, memory usage, data access, SQL and physical storage.
• Administer and maintain MS SQL (2016 and above) environments.
• Support Audits with relevant correct details.
• Participate in Disaster recovery exercises.
• Respond to calls such as incidents and requests in a timely manner.
• Maintain proper documentation according to the company policies and practices.
• Perform change and release management according to bank policies.
• Troubleshoot and resolve problem of database issues with emphasis on root cause analysis.

Job Requirements

• Bachelor’s degree in Information Technology with min. 7 years’ work experience in Oracle patching for Standalone and RAC environments.
• Experience in RAC and Grid Infrastructure (Clusterware, ASM, Disk Groups, etc.)
• Experience in Always ON and Windows clusters
• Experience in migrating and upgrading of database.
• Experience in managing database security policies and procedure documents.
• Excellent communication, presentation and interpersonal skills.
• Ability and willing to work after office hours and on weekends when needed.