Sr. Database Administrator

Arcadia, CA

Senior/Lead Database Administrator

Client’s Technology Operations department is responsible for developing and enhancing infrastructure and applications to support the growth of the business and to promote a highly available and stable computing environment.

Reporting to the Manager of Database Administration, the Lead/Sr. DBA will contribute to the overall engineering, design, build and high level support of all existing and new Microsoft SQL Server systems (SQL 2000/2005/2008/2012/2016). As a lead within the Technology Operations Production DBA team, the successful candidate will need to work closely with our internal clients and team members to develop consensus and find solutions to problems facing their business constituents.

The Lead/Sr. Database Administrator will work with all of the IT development teams to assist in the implementation, management, development and monitoring of the databases that supports the company's IT data integrations initiatives. This candidate should be able to lead projects from inception to completion with little or no support.

Duties and Responsibilities

Responsible for ensuring availability and performance of all company databases.

Work to ensure that the proper hardware resources are allocated to the databases, and to ensure high resilience and performance tuning.

To proactively monitor the database systems to ensure secure services with minimum downtime.

Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.

Responsible for troubleshooting and problem solving SQL development issues.

Responsible for assisting developers to optimize, tune and enhance database queries

Responsible for improvement and maintenance of all databases, to include rollout and upgrades.

Responsible for implementation and release of database changes according to agreed timescales and costs.

Responsible for proposing and implementing database architectural changes to make database infrastructure highly scalable and optimized

Client operates a 24x7 environment. On-call / off-hours deployments and support will be required.

To take on technical leadership responsibilities of database projects across various teams in the organization

Responsible for mentoring developers on data modeling best practices and enabling them to come up with an optimized data model

Skills / Attributes Required

Masters in Computer Science or related field

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 and knowledge of NoSQL databases

Job Type: Full-time

Salary: $120,000.00 to $140,000.00 /year

Experience:

T-SQL: 8 years (Preferred)

MySQL: 8 years (Preferred)

Database Administration: 8 years (Preferred)

managing multiple MS SQL 2008/2012/2014/2016 servers: 8 years (Preferred)

T-SQL, OLAP, DTS, SSIS and stored procedures: 8 years (Preferred)

Education:

Master's (Preferred)