Monster.ca

Database Architect

MySQL Database Administrator

Data Engineer

A SQL Server Database Administrator administers SQL Server data systems and structures. Uses software applications and structured query language (SQL) procedures to store and organize data, such as an organization's records or financial information. Ensures that users can easily access the information they need and that data are protected from unauthorized access.

Database Administrator

SQL Server Developer

SQL Developer

Oracle Database Administrator

ETL Developer

SQL Server Database Administrator

Database Mirroring

High-availability clusters are groups of computers that support server applications that can be reliably utilized with a minimum amount of down-time. They operate by using high availability software to harness redundant computers in groups or clusters that provide continued service when system components fail. Without clustering, if a server running a particular application crashes, the application will be unavailable until the crashed server is fixed. HA clustering remedies this situation by detecting hardware/software faults, and immediately restarting the application on another system without requiring administrative intervention, a process known as failover. As part of this process, clustering software may configure the node before starting the application on it. For example, appropriate file systems may need to be imported and mounted, network hardware may have to be configured, and some supporting applications may need to be running as well.

Failover Clustering

Log shipping is the process of automating the backup of transaction log files on a primary (production) database server, and then restoring them onto a standby server. This technique is supported by Microsoft SQL Server, 4D Server, MySQL, and PostgreSQL. Similar to replication, the primary purpose of log shipping is to increase database availability by maintaining a backup server that can replace a production server quickly. Other databases such as Adaptive Server Enterprise and Oracle Database support the technique but require the Database Administrator to write code or scripts to perform the work.

Log Shipping

Query Tuning

Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM DB2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.

Database Administration

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Microsoft SQL Servers

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SQL Server Integration Services (SSIS)

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.

Location	Median Salary
BC	$114,944
National	$105,216
Location +/-	8% Higher
	Search another salary
	Show me related jobs

Location	Median Salary
BC	$114,944
National	$105,216
Location +/-	8% Higher
	Search another salary
	Show me related jobs

Salary Estimate for BC
Nearby Locations...

Salary Details

Boost Your Value

Boost Your Value

Advance your career

Advance your career

Jobs In on Monster

SQL Server Database Administrator Salary Estimate for BCNearby Locations...

Salary Details

Boost Your Value

Boost Your Value

Salary for Related Jobs

Salary for Related Jobs

Advance your career

Advance your career

Jobs In on Monster

Salary Estimate for BC
Nearby Locations...