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