SQL Server DBA-: Downey, CA - Hybrid(only On W2)

Company: Pyramid Technology Solutions, Inc
Location: Downey
Posted on: March 13, 2025

Job Description:

Job ID: 683

Apply (by clicking the relevant button) after checking through all the related job information below.

Job Role: SQL Server DBA

Location: Downey, CA - Hybrid

Duration: 12 Months Contract



Is this role located on-site, hybrid, or remote?: Hybrid

Is a Livescan Required for Position?: No



Candidate should clear the following background checks for at least the past 7 years:

Employment History - Verification of past employment records.
Educational Background - Validation of academic credentials.
Criminal/Felony - Check for any criminal records.
SSN - Social Security Number (SSN) verification.



Position Description:

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:

Skilful in Jenkins, Ansible, MS PowerShell for workflow automation; MS Azure SQL and related Azure technologies; 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 DBA or similar.
Five plus (5+) years of experience managing a large MS SQL Server farm (300+ servers).
Five plus (5+) years of experience developing scripts to automate routine manual database server functions using tools such as Jenkins, Ansible, or similar tools.
Five plus (5+) years of experience migrating and upgrading SQL Server to the latest supported version; experience migrating SQL Servers on premise to MS Azure.
Five plus (5+) years of experience building, migrating and managing Azure SQL Managed Instance, Azure SQL DB, and Azure SQL VM .
Five plus (5+) years of experience building, configuring, and managing MS SQL Server Always on clustering services.
Five plus (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:

Possess one of the following certifications: 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.
Remote working/work at home options are available for this role.

Keywords: Pyramid Technology Solutions, Inc, Downey , SQL Server DBA-: Downey, CA - Hybrid(only On W2), IT / Software / Systems , Downey, California