Job

Junior SQL Database Administrator

Location Oakland, CA 94612
Date Posted November 23, 2020
Job ID 7060
Employment Type Direct Hire

Scion Staffing (www.scionstaffing.com This position is a full-time, direct-hire opportunity. ), the Bay Area’s leading nonprofit staffing specialist, has been engaged to find an attention-detailed Junior SQL Database Administrator for a local nonprofit organization based in Oakland, CA.

OVERVIEW

This role is managing our SQL Server databases, which includes development, test and production environments for our various enterprise and external web applications. Additional duties will include working with several departments to add system functionality, tables, and data; optimizing systems for availability and performance; and contributing to system upgrades. The Database Administrator also is responsible for maintaining applications, processes, and maintenance procedures; performance tuning; and documentation and management of changes to database operations.

RESPONSIBILITIES

  •  Setup, configure, and install database systems located in virtual environments both on-premises and in the cloud (Azure)
  •  Optimizes and tunes database systems
  •  Proactively monitors performance and capacity
  •  Performs data ports and data loads; monitors and tests data integrity as required
  •  Backup, recovery, testing of recovery procedures, and archiving databases
  •  Troubleshoots database issues and performs database impact analysis for proposed changes
  •  Ensures that systems stay updated on all relevant patches and upgrades
  •  Alter tables and schema structure as required
  •  Works with the application development teams to develop stored procedures, triggers and code to support enterprise applications as well as to enforce coding standards
  •  Executes database release management processes and coordinates maintenance of development, testing, and production environments
  •  Deploy database change scripts provided by third party vendors
  •  Automates manual processes when practical
  •  Maintains quality service by establishing and enforcing organization standards
  •  Document the company’s database environmen
QUALIFICATIONS
  • 2+ years Microsoft (MS) SQL Server experience
  • 2+ years of overall database administration experience (development or production environments, any RDBMS)
  • 2+ years of production MS SQL Server administration experience
  • 2+ years of experience with Windows server, including Active Directory
  • Strong technical and analytical and problem solving skills to troubleshoot root cause of database related issues
  • Working knowledge using ANSI SQL with Transact-SQL (T-SQL) preferred
  • Experience in data-cleansing and validation of data integrity
  • Analysis Services (SSAS), Integration Services (SSIS), or Reporting Services (SSRS)
  • Failover clustering, SAN replication, and other high availability technologies
  • Writing T-SQL from scratch
  • Experience using SSIS and other ETL tools to automate data import and processing
  • Experience with Azure cloud hosting environments

SALARY
This position offers a competitive salary that is dependent upon experience, includes an excellent work environment (currently the position is remote), and a robust benefits package!

HOW TO APPLY
For immediate consideration, please submit your resume here: https://www.scionstaffing.com/job/7060

ABOUT OUR SEARCH FIRM
Scion Staffing is a national award winning staffing firm. Over the past few years, our firm has had the pleasure of successfully assisting hundreds of local employers. No matter the requisition or size, our track record and recruitment process has made us one of the top recruitment firms in California. Additional information about our firm and success can also be found online at www.scionstaffing.com or in the 2010-2020 Business Times list of top staffing firms.

Scion Staffing is an equal opportunity employer and service provider and does not discriminate on the basis of race, religion, gender, gender identity, national origin, citizenship status, sexual orientation, disability, political affiliation or belief. We are committed to the principles of Equal Opportunity Employment and are dedicated to making employment decisions based on merit and value, for ourselves, our client companies, and for the candidates we represent.

Apply For This Job

  • Date Format: MM slash DD slash YYYY
  • Please enter a number
  • Accepted file types: doc, docx, pdf, xls, xlsx, ppt, pptx.
  • Accepted file types: doc, docx, pdf, xls, xlsx, ppt, pptx.
  • Accepted file types: doc, docx, pdf, xls, xlsx, ppt, pptx.