Job Description :
SQL Server DBA:
Rancho Cordova, CA
12 month contract to hire.
Job Description:
Experienced SQL Server DBA. 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 performance 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.
Designs 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 troubleshooting; 20% Development of maintenance scripts and jobs; 10% Documentation, training and support; 10% Requirement capture and analysis.
Mandatory Skills:
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.
Experience setting up SQL in Azure
Bachelor's Degree in Computer Science or related field.
Desired Skills:
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.