Database Administrator 2

Phoenix Staff, Inc. - 26 days ago
Phoenix Staff, Inc.

Title: Database Administrator 2
Location: Scottsdale, AZ


Provides production support for various database issues and performs general duties across all database servers in the enterprise. Performs ad-hoc data pulls to answer business questions, creates reports, and monitors database server health.


Your role:



Responsible for installation, configuration, maintenance, monitoring, administration, and performance & tuning of database hardware and software
Manage day-to-day operational support of development, test and production database environments including backup and recovery of production systems and cloning of databases to non-production systems on a scheduled and adhoc basis as required
Responsible for query analysis and performance and tuning recommendations including plan analysis, index recommendations and database server configuration
Collaborate with application teams in the design and implementation of database schemas to meet business objectives & technical requirements
Monitor and report project status to ensure that projects are completed on time and within budget
Configure monitoring utilities for databases to keep false alarms to a minimum
Establish the baseline for system performance and detect deviation, suggesting and executing improvements to slow running queries
Manage business intelligence objects, with a lighter role in the creation of these objects
Creates reporting using SSRS and/or report builder
Ability to provide on-call assistance to urgent production database matters in a 24x7 environment
Comfortable with working in a fast-paced environment with multiple databases simultaneously


What you've got:



Bachelor's degree in Information Systems or equivalent work experience/certification
Minimum 5 years professional experience in Database administration
2+ years of experience with Microsoft SQL Server in a corporate environment, supporting production, as well as QA/DEV/Test environments
Expert knowledge of Microsoft SQL Server (2019), including SQL data types, table definitions, stored procedures, TSQL queries, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Strong command of T-SQL, leveraging SQL Server tools, and other database management tools for maintaining MySQL and PostgreSQL database environments
Advanced knowledge of database security, backup and recovery, and performance monitoring standards
Significant knowledge of relational and dimensional data modeling
Skilled in the following database technologies (TSQL, SSIS, DTS, SSRS)
Strong knowledge with HA/DR technologies such as clustering and replication
Strong knowledge with data warehouse concepts
Able to translate business requirements from non-technical users into technical solutions
Display an eagerness to learn new technologies and have a can-do attitude and the desire to provide complete solutions rather than simple fixes
Good communication and customer service skills
Ability to work well as a team member and as an individual with little to no supervision
Ability to complete projects that exceed expectations with little to no supervision


To find more great tech-centric jobs, please visit www.phoenixstaff.com.

Other jobs that may be of interest
Systems Administrator III - Windows
Veloc Inc. - 6 days ago
Scottsdale, Arizona
Veloc Inc.
Systems Administrator III Windows Windows PowerShell VMware - Cloud Summary: This position is responsible for the administration and maintenance of the environments running Microsoft Windows Server Operating Systems and VMware ...
ServiceNow Administrator
V-Soft Consulting Group, Inc - 4 days ago
Scottsdale, Arizona
V-Soft Consulting Group, Inc
ServiceNow Administrator Primary Location: Scottsdale, AZ  V-Soft Consulting is currently seeking ServiceNow Administrator client in Scottsdale AZ. This is a full-time, direct hire position. Knowledge, Skills and Abilities »Requires a bachelor’s degr...
Hadoop Administrator - Scottsdale, AZ 26664
PRIMUS Global Services Inc., - 10 days ago
Scottsdale, Arizona
PRIMUS Global Services Inc.,
We have an immediate opportunity with one of our largest clients for a Hadoop Administrator in Scottsdale, AZ The consultant will be responsible for building, configuring, supporting and maintaining our Cloudera eco-system, which includes Hadoop, HBa...
SQL Server Administrator
Cynet Systems - 9 days ago
Chandler, Arizona
Cynet Systems
We are looking for SQL Server Administrator for our client in Chandler, AZ Job Title: SQL Server Administrator Job Location: Chandler, AZ Job Type: Contract Job Description:Extensive Hands-On Experience configuring, administering, and troubleshooting...
TIBCO Developer / Administrator
Cynet Systems - 4 days ago
Phoenix, Arizona
Cynet Systems
We are looking for TIBCO Developer / Administrator for our client in Phoenix, AZ Job Title: TIBCO Developer / Administrator Job Location: Phoenix, AZ Job Type: Contract Job Description:Participate in Functional Requirements / Functional Specification...
Site Reliability Engineer
Jobot - 17 days ago
Scottsdale, Arizona
Jobot
Will you transform the future of online education?This Jobot Job is hosted by: Nicole ProkopAre you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.Salary: $125,000 - $130,000 per yearA bit about us:My client seeks...