SQL Database Administrator
Posted 3 Oct 2023
Advertised as “Sr SQL Database admin”
BranchFactor Summary
The original posting with the fluff stripped out
- Management level
- Individual contributor
- Contract
- Full-time
No salary listed for this role.
Field of studyInformation Technology (or related)
Study levelBachelor's
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, Server,Azure database, Azure Cosmos DB. Azure Synapse Analytics..