MS SQL Server Database Administrator

MS SQL Server Database Administrator

Downey, CA - Remote

• A Technical Architect will serve as the manager of complex technology implementations, with an eye toward constant reengineering and refactoring to ensure the simplest and most elegant system possible to accomplish the desired need;
• understand how to maximize leverage of the open source community to deploy systems on Infrastructure as a Service (IaaS) providers;

be comfortable sharing knowledge across a multi-disciplinary team and working within various methodologies; and be a full partner in the determination of vision, objectives, and success criteria.

The Technical Architect will architect the overall system by using prototyping and proof of concepts, which may include : modern programming languages (e.

g., Ruby, Python, Node.js) and web frameworks (e.g., Django, Rails), modern front-end web programming techniques (e.g., HTML5, CSS3, RESTful APIs) and frameworks (e.

g., Twitter Bootstrap, jQuery), relational databases (e.g., PostgreSQL), and "NoSQL databases (e.g., Cassandra, MongoDB), automated configuration management (e.

g., Chef, Puppet, Ansible, Salt), continuous integration / deployment, and continuous monitoring solutions; use version control systems (e.

g., Git and GitHub); ensure strategic alignment of technical design and architecture to meet business growth and direction, and stay on top of emerging technologies;

decompose business and system architecture to support clean-interface multi-team development; develop product roadmaps, backlogs, and measurable success criteria, and write user stories (i.

e., can establish a path to delivery for breaking down stories) and clearly communicate and work with stakeholders at every level.

Skills Required :

• The Technical Architect will possess knowledge and experience in analyses and development of conceptual designs and detail designs;
• developing JBOSS Messaging and connectivity with Spring-JMS connectivity; designing DB schema as per the requirements and in sync with the old system;
• implementing the daily and weekly jobs that interact with external interfaces; coordinating with business stakeholders to understand their requirements;
• communicate with cross-divisional personnel at both team and executive levels to understand performance measurement methodologies;

and direct team members in compiling business requirements and executing project milestones.

Skills Preferred :

scripting skills to automate routine manual system administration tasks (i.e. Jenkins, Ansible, MS PowerShell); Migrate SQL Servers from on premise to MS Azure;

Upgrade SQL Servers to latest version; Set up and configure MS Azure SQL Managed Instance services; Set up and configure MS SQL Server Always on clustering services on SQL Server 2016 and above.

Experience Required :

This classification must have a minimum of eight (8) years of experience in systems development, analysis, programming or testing.

Experience Preferred :

Ten or more (10+) years of experience performing SQL Server installations, configurations, management and monitoring, and system administration tasks at the level of a SQL Server Database System Administrator;

Experience managing a large MS SQL Server farm (300+ servers); Five (5+) years of experience developing scripts to automate routine manual database server functions using tools such as Jenkins, Ansible, or similar tools.

• Five (5+) years of experience migrating and upgrading SQL Server to the latest supported version; experience migrating SQL Servers on premise to MS Azure;
• Five (5+) years of experience building and managing Azure SQL Managed Instance services. Five (5+) years of experience building, configuring, and managing MS SQL Server Always on clustering services;

experience validating and implementing security protocols following vendor and best practices. Five (5+) years of experience working with Commvault Backup client as a tool to perform SQL Server database Backup and Restore including the experience managing SQL Server backup and restore in native SQL Server Management Studio.

Education Required :

This classification requires the possession of a bachelor's degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Education Preferred :

Any Cloud certifications such as Certifications in Azure Fundamentals and above; Certifications in AWS Cloud Practitioner and above;

Certifications in Microsoft Professional certifications; Professional Google Cloud certifications.

Additional Information :

A Hybrid work schedule (on premise / Telework) option will be considered and can be discussed during the interview process.

After-hour work may be required to minimize customer service disruptions.