SQL Database Administrator

sql database administrator, backup, performance tuning, mirroring
Contract W2, 6 Months
$0+
Work from home not available Travel not required

Job Description

Job Description:

Job Title: SQL Database Administrator

Location: Irvine, CA

Duration : 6 Months CTH

Responsibilities

  • Analysis and approval of DB schema and procedure changes from development/test, staging to lab/production environments.
  • Participate in future-state infrastructure planning (storage capacity planning, server SKU recommendations, newest SQL Server features, etc.)
  • Define/implement/refine SQL monitoring tools/scripts for server health checks (backups/jobs/mirroring/replication/etc.); ensure SQL Errors are proactively captured.
  • Maintain and monitor database backups and rotating archives of backup files.
  • Monitor and profile production database servers for load and performance bottlenecks.
  • Thorough understanding of relational database design and concepts.
  • Responsible for database server upgrades and SQL server configuration standards; strong understanding of MS Windows Server 2008 and up and SQL Server 2008 and up.
  • Collaborate with team resources to analyze, prioritize and test upgrades/patches.
  • Create knowledge base articles for alerts/issues for internal project team and affiliated groups to resolve.
  • Participate in on-call rotation
  • Respond to tickets within team defined Service Level Objectives

Requirements, Skills, and Education

  • Requires Bachelor's degree or equivalent experience.
  • Experience running and maintaining a 24x7 production computing environment
  • Hands-on experience driving improvements in product performance via changes in database schema, logical and physical data organization (partitioning), tuning and configuration.
  • Experience implementing/maintaining database failover mechanism (mirroring, log-shipping, clustering, etc.) and perform disaster recovery exercises for mission-critical databases.
  • Strong SQL/T-SQL skills with hands-on experience in successful database design, schema design, SQL performance tuning and optimization.
  • Strong skills in SSRS report development and SSIS/ETL.
  • Experience with maintaining and optimizing MongoDB is preferred
  • Experience with AWS services is a plus.
  • Experience with data profiling/metadata analysis/data modeling and relational schema design in object oriented or component based projects is a plus.
  • MCTS/SQL certifications are a plus.
  • Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment
  • Strong customer service, leadership, organizational, communication and interface skills

Chandra Sekhar

Human Resources

Indecomm Digital Services

14500 N Northsight Blvd, Suite 207 Scottsdale, AZ 85260

Email:

|

Posted By

Chandra Sane

8800 E Raintree Dr, Suite 200 Scottsdale, AZ, 85260

Dice Id : 10122158
Position Id : 6221055
Originally Posted : 1 month ago
Have a Job? Post it

Similar Positions

Sr. SQL Database Administrator
  • Atrilogy Solutions Group, Inc.
  • Newport Beach, CA
Sr. SQL DBA
  • Herbalife International
  • Torrance, CA
SQL DBA
  • i3 INFOTEK
  • Long Beach, CA
SQL Server DBA
  • Sysintelli, Inc.
  • Long Beach, CA
SQL Server DBA
  • Launch Infotech
  • Signal Hill, CA
SQL DBA
  • Indecomm Digital Services
  • Irvine, CA
DBA, SQL
  • Irvine Technology Corporation (ITC)
  • Norwalk, CA
SQL DBA with Azure Migration
  • Bitsoft International, Inc.
  • Long Beach, CA
Database Developer/DBA - SQL Server No C2C
  • IMS - International Management Systems
  • Santa Ana, Ca, CA
Postgre SQL DBA
  • West Advanced Technologies, Inc.
  • Downey, CA
ETL Database Developer/Administrator
  • Platinum Enterprise Solutions
  • Irvine, CA