SQL Database Administrator

Two95 International Inc.; Pasadena (CA); On-site; USD 110,000 - 170,000; Full time

Job summary

Two95 International Inc. in Pasadena, CA is seeking a Sr./Lead SQL DBA to manage and optimize SQL Server environments. This full-time role requires extensive experience with enterprise-class SQL Server clusters and a strong focus on high availability and database performance.

The candidate should be adept in T-SQL, SSIS, OLAP, DTS, and security management across internal and external SQL Server instances, with preference for cloud experience (AWS/Azure) and knowledge of MySQL and NoSQL.

Qualifications

• 8+ years of in-depth SQL Server Database Administration experience.
• Experience managing multiple MS SQL 2008/2012/2014/2016 servers on enterprise-class servers clusters running Windows 2003/2008/2012.
• Strong self-sufficiency and initiative.
• Experience in leading and mentoring team members.
• Practical experience in monitoring and tuning a database to provide a high availability service.
• Experience with T-SQL, OLAP, DTS, SSIS and stored procedures.
• Practical experience in managing internal and external Microsoft SQL Server database security.
• Knowledge of Multi-Instance implementations and methodologies.
• Experience with Replication, Log Shipping, Change Data Capture and Database Mirroring.
• Knowledge of SQL Service Broker.
• Understanding of High Availability, Business Continuity, and Disaster Recovery concepts as they relate to Open Systems architecture.
• Experience on working with SQL Server in Amazon cloud or/and Azure platform is definitely a plus.
• Experience of working with mysql database
• Knowledge of NoSQL databases is a good to have skill

Skills

SQL Server DBA

SQL Server clustering

Self-motivation

Team leadership

Database tuning

T-SQL

SSIS

OLAP

DTS

Stored procedures

SQL security

Multi-Instance SQL

Replication

Log Shipping

CDC

Database Mirroring

SQL Service Broker

HA/DR concepts

Cloud SQL Server

MySQL

NoSQL

Job description

Title: Sr./Lead SQL DBA Location: Pasadena, CA Job Type: Full Time

Skills / Attributes Required

• 8+ years of in-depth SQL Server Database Administration experience
• Extensive experience of managing multiple MS SQL 2008/2012/2014/2016 servers on enterprise-class servers clusters running Windows 2003/2008/2012
• Strong self-sufficiency and initiative working on Database projects
• Experience in leading and mentoring team members
• Practical experience in monitoring and tuning a database to provide a high availability service
• Experience with T-SQL, OLAP, DTS, SSIS and stored procedures
• Practical experience in managing internal and external Microsoft SQL Server database security
• Strong knowledge of Multi-Instance implementations and methodologies
• Experience with Replication, Log Shipping, Change Data Capture and Database Mirroring
• Knowledge of SQL Service Broker
• Understanding of High Availability, Business Continuity, and Disaster Recovery concepts as they relate to Open Systems architecture
• Experience on working with SQL Server in Amazon cloud or/and Azure platform is definitely a plus
• Experience of working with mysql database
• Knowledge of NoSQL databases is a good to have skill