Sr SQL Database admin

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..