SQL DBA

  • location: Rancho Cordova, CA
  • type: Contract
  • salary: $60 - $65 per hour

job description

SQL DBA

job summary:
Our client has a 12+ month contract opportunity for a SQL DBA in Rancho Cordova, CA.

Analyzes, designs and plans MS-SQL Databases required for various applications that form a part of integrated software solutions used in local, networked, Internet-related or cloud based application suites. Work with data models and vastly varying sizes of Databases.

Works with solution engineering and development teams in understanding the nature and size of the Database application.

Sizes, plans, configures and tunes the necessary storage requirements and the databases.

Designs, optimizes and configures databases for maximum performance and troubleshoots and fixes perfomance related issues.

Configures, installs and maintains various Development and Test Database instances.

Downloads, applies and tests MS-SQL software patches and recommends necessary Upgrades.

Analyzes, troubleshoots and works with vendors to create SRs, follows up to get the necessary patches for issues.

Desins and develops bulk data migration tools using SSIS.

Completes documentation and procedures for installation and maintenance.

May interact with users to define system requirements and/or necessary modifications.

Essential Duties and Responsibilities -

20% Installation, Configuration, Administration.

20% Scripts Preparation, Verification and Installation testing.

20% Performance Turning and troubhleshooting.

20% Development of maintenance scripts and jobs.

10% Documentation, training and support.

10% Requirement capture and analysis.

Skill/Experience/Education

MandatoryRequired experience : 4 to 6 years of experience in Database design, setup, configuration and administration/maintenance.

"Hands on support" for mission critical MS-SQL databases in production. Proficiency in MS-SQL Databases maintenance, patching, upgrades.

Proven experience in performance tuning large scale enterprise database applications with high transactional volume.

In-depth knowledge of various DB health monitoring utilities.

Experience in scheduling DB statistics collection jobs to review and analyze performance proactively. Experience in Database backup and restore.

Experience in working in Production Environments, handling downtimes to apply patches.

Experience with multiple Operating Systems (Linux, Windows).

Experience with scripting languages such as Shell, Perl.

Experience in developing and scheduling various data cleansing and metrics collection jobs.

strong technical documentation ability strong verbal communication skills and a demonstrated ability to work effectively in team-based development projects

Desired Skills

Preferred Experience

Knowledge of Oracle PL/SQL programming. Experience with Team Foundation Server for release management and defect tracking.

Experience with SQL Developer, SQL Plus, Toad and/or other Oracle application tools.

Certifications/Licenses: MS-SQL DBA Certification is a plus.

Specialized Knowledge and Skills - Language Skills: Well spoken and written communication in English.

Mathematical Skills: College level skill is required.

Reasoning Skills: Very good reasoning, problem solving, and innovation skills required.

Computer/Tech. Skills: Knowledge and ability to use standard software required, specifically Microsoft Office Applications (Word, Excel, Access, etc.).

 
location: Rancho Cordova, California
job type: Contract
salary: $60 - 65 per hour
work hours: 8am to 5pm
education: Bachelors
 
responsibilities:
20% Installation, Configuration, Administration.

20% Scripts Preparation, Verification and Installation testing.

20% Performance Turning and troubhleshooting.

20% Development of maintenance scripts and jobs.

10% Documentation, training and support.

10% Requirement capture and analysis.

 
qualifications:
  • Experience level: Experienced
  • Minimum 5 years of experience
  • Education: Bachelors
 
skills:
  • Experience level: Experienced
  • Minimum 5 years of experience
  • Education: Bachelors

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Reports Developer

  • location: Rancho Cordova, CA
  • job type: Temp to Perm
  • salary: $50 - $55 per hour
  • date posted: 6/12/2020


    C++ Software Engineer

  • location: Rancho Cordova, CA
  • job type: Contract
  • salary: $55 - $62 per hour
  • date posted: 6/30/2020