Sr SQL Database admin - Kuala Lumpur, Malaysia - Two95 International Inc.

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. This is 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 with problems regarding the databases, applications and development tools.

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(sz)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, etc.
• Experience with other database tools such as and not limited to PostgreSQL, Cassandra, MongoDB, Microsoft SQL Server,Azure database, Azure Cosmos DB. Azure Synapse Analytics..