Sr SQL Database admin

Two95 International Inc.; Kuala Lumpur; On-site; MYR 30,000 - 60,000; Full time

Job summary

Join a forward-thinking company as a Database Administrator where you will play a vital role in creating and managing databases for development, testing, and production. In this dynamic position, you will collaborate closely with system administrators and development teams to ensure database integrity, performance, and security. Your expertise in various database tools, including MSSQL and AWS, will be essential as you troubleshoot issues and implement best practices. This role offers a unique opportunity to make a significant impact on the organization’s success while working in a collaborative and innovative environment. If you are detail-oriented and passionate about database management, this is the perfect opportunity for you.

Qualifications

• Bachelor's degree in IT or related studies is essential.
• Strong communication skills and attention to detail are critical.

Responsibilities

• Maintain databases for development, testing, and production use.
• Implement backup, recovery, and security for MSSQL databases.
• Provide technical support to application development teams.

Skills

Communication Skills

Attention to Detail

Project Management

Collaboration

Agile Methodologies

Waterfall Methodologies

Unix Operating System

Database Troubleshooting

Education

Bachelor's degree in IT or related studies

Tools

MSSQL

AWS

PostgreSQL

Cassandra

MongoDB

Azure Database

Azure Cosmos DB

Azure Synapse Analytics

Jira

Confluence

Slack

Job description

Role & Responsibilities:

• Creates and maintains all databases required for development, testing, education, and production usage. Performs the capacity planning required to create and maintain the databases.
• The DBA works closely with system administration staff. Plans and implements backup and recovery of the MSSQL database.
• Controls migrations of programs, database changes, reference data changes, and menu changes through the development life cycle.
• Implements and enforces security for all of the MSSQL Databases.
• Performs database re-organisations as required to assist performance and ensure maximum uptime of the database.
• Puts standards in place to ensure that all application design and code is produced with proper integrity, security, and performance.
• The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Evaluates releases of MSSQL and its tools, and third-party products to ensure that the site is running the products that are most appropriate.
• Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
• Provides technical support to application development teams, usually in the form of a help desk.
• Enforces and maintains database constraints to ensure integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
• Troubleshoots problems regarding the databases, applications, and development tools.

Minimum Requirements:

• Bachelor's degree in IT or related studies.
• DBA should have sound communication skills with management, development teams, vendors, systems administrators, and other related service providers.
• Must be a self-starter with a strong attention to detail.
• Good knowledge of the Unix Operating system.
• Skills in project management tools.
• Ability to develop and maintain collaborative and cooperative relationships throughout the organization.
• Proficient application of IT best practices for Waterfall and Agile projects.
• Experience working with AWS.
• Experience with Jira, Confluence, and Slack.
• Experience with other database tools such as PostgreSQL, Cassandra, MongoDB, Microsoft SQL Server, Azure database, Azure Cosmos DB, Azure Synapse Analytics.