SQL Database Administrator

State Of Arizona Phoenix , AZ 85002

Posted 3 months ago

Arizona Department of Child Safety

A New Beginning for Arizona's Children

SQL DATABASE ADMINISTRATOR

Information Technology (IT) Operations

Department of Child Safety
3003 N Central Ave. Phoenix AZ 85012

www.azdcs.gov

DCS Mission Statement

Successfully engage children and families to ensure safety, strengthen families, and achieve permanency.

JOB SUMMARY:

If you consider yourself to be a highly organized and motivated individual who possesses technical development skills and is passionate about SQL reporting and data analysis, this is the job for you!

The SQL Database Administrator will be responsible for the DCS data warehouse, SQL process and application database needs. This position will manage the architecture, development, maintenance, and day-to-day operations of the data warehouse, including appropriate policy, retention, SQL, and documentation. This position will design, develop, and implement SQL codes and support production SQL bug fixes. This position also requires experience with EDW, DW, and OLAP. Additionally, this position will design and create data models and data warehousing and related BI functions as well as design, build, and deploy successful SSIS packages.

JOB DUTIES:

  • Solves problems, installs, monitors, and directs proactive and reactive measures

  • Coordinates resolution of trouble calls with help desk, monitors and manages user accounts, and maintains database instances

  • Translates user's needs into a sound database design with tables and fields

  • Assists in developing purging and archiving criteria and procedures

  • Reviews, evaluates, designs, implements and maintains company database(s)

  • Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process

  • Implements and reviews appropriate security guidelines

  • Develops, tests, and performs database migration procedures

  • All other duties as assigned

KNOWLEDGE, SKILLS AND ABILITIES (KSAs):

Knowledge of:

  • Physical data models, technical architecture, system interfaces, etc.

  • Normalized and dimensional modeling techniques

  • Various industry standards for data capture, transmission, consumption, and reporting

Skill in:

  • Verbal and written communication

  • Strong customer service

  • Establishing and maintaining interpersonal relationships

Ability to:

  • Balance, prioritize, and organize multiple tasks

  • Work collaboratively in teams and across organizations

  • Synthesize feedback and adjust plans accordingly

  • Build strong relationships inside and outside the organization

PREFERRED QUALIFICATION(S):

  • Must have experience with EDW, DW, and OLAP as well as SQL and T-SQL
  • BA/BS in Computer Science or related experience
  • 5+ years of Data Architecture & Modeling experience with Data Warehouse/Data Marts/OLTP systems
  • 5+ Years of experience with Software Development Life Cycle (SDLC)
  • 3+ years of relevant database development experience in Microsoft SQL Server 2008/2012 or higher

PRE-EMPLOYMENT REQUIREMENTS:

The ability to secure and maintain an Arizona Fingerprint Clearance Card; and the ability to secure and maintain clearance from the CPS Central Registry.

Employment is contingent on the selected applicant passing a background investigation.

In-state travel is sometimes required. Requires possession of and ability to retain a current, valid state-issued driver's license appropriate to the assignment. Employees who drive on state business are subject to driver's license record checks, must maintain acceptable driving records and must complete any required driver training (see Arizona Administrative Code R2-10-207.12.).

BENEFITS:

We offer a comprehensive benefits package that includes:

  • Sick leave

  • Vacation with 10 paid holidays per year

  • Health and dental insurance

  • Retirement plan

  • Life insurance and long-term disability insurance

  • Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance

RETIREMENT:

Positions in this classification participate in the Arizona State Retirement System (ASRS).

Enrollment eligibility will become effective after 27 weeks of employment.

Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by contacting 602-255-2903. Requests should be made as early as possible to allow time to arrange the accommodation. Arizona State Government is an AA/EOE/ADA Reasonable Accommodation Employer.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Database Administrator FOX Technology (R50009751)

Fox Corp.

Posted 2 days ago

VIEW JOBS 8/22/2019 12:00:00 AM 2019-11-20T00:00 OVERVIEW OF THE COMPANY Fox Corporation Under the FOX banner, we produce and distribute content through some of the world's leading and most valued brands, including: FOX News, FOX Sports, the Fox Network, and the FOX Television Stations. We empower a diverse range of creators to imagine and develop culturally significant content, while building an organization that thrives on creative ideas, operational expertise and strategic thinking. JOB DESCRIPTION We are looking for a Senior Database Administrator to be part of our global DBA team. You will be responsible for various Enterprise databases such as MySQL, Oracle, MSSQL and Postgres. In addition, you will assist in reviewing schemas and queries for customers of our hosted database solutions with an eye towards assisting those customers to optimize their implementations and develop best-in-class performance for their products. This is a high impact position that is critical to helping us maintain our record of high availability and high quality of our data services supporting various FOX business units. The day to day tasks includes space and performance monitoring of the database and scheduled tasks. Environment contains automated tasks for system monitoring and remediation through various scripts, so familiarity in shell scripting is a must. This position is very much as an operation DBA and requires additional familiarity with application related processes to support the application team. The rapid ability to troubleshoot and remediate is required. Join us at FOX and make your mark as we build our media and broadcast operations from the ground up! A SNAPSHOT OF RESPONSIBILITIES * Configuration, provisioning, upgrading and decommissioning databases * Database tuning for optimization and performance * Monitoring production deployments for capacity issues, performance and troubleshooting * Actively participate in production database support. Availability for 24X7 on call rotation support * Work with customers to verify and validate schemas and queries for performance and scalability * Keep abreast of new database capabilities, developments, and products and provide guidance and suggestions for new and improved technologies * Keep backups as current as possible and devise restoration techniques with minimal downtime * Automation and Shell scripting * Work collaboratively with the team members when required and train others on the newly acquired competence * Provide proper documentation for tasks and issues * Participate in any corporate wide ventures related to security, operations, automation, development, administration and documentation * Stay calm during high-pressure assignments & operations and lead the technical efforts in collaboration with the team * Handle change management operations * Keep run-books updated for smooth operations WHAT YOU WILL NEED * 3-5 years of hands on experience administering/monitoring Enterprise Databases * Significant knowledge of multiple Enterprise database technologies such as: MySQL on Linux, Oracle on Linux and MSSQL on Windows Server * 3 -5 years of hands on experience with databases running on AWS RDS * Experience with UNIX/Linux scripting (python/bash) * Excellent Troubleshooting skills * Excellent communication skills * Ability to comfortably multitask and work in a fast paced environment * Ability to demonstrate technical acumen skills within a team of DBAs * Ability to own a project from start to finish * Bachelor's degree in Computer Science or engineering equivalent * Thorough understanding of server configuration both hardware and virtualized, and how it affects performance and cost * Clear understanding of relational and non-relational databases * Query analysis * DB Schema design * TCP dump * Monitoring skills * Good scripting skills * Multi datacenter environments * Knowledge of cloud operations. * Knowledge of Virtualization * High availability and performance tuning techniques Preferred Skills and or Experience * 3-5 years of hands on experience administering/monitoring Enterprise Databases * Significant knowledge of multiple Enterprise database technologies such as: MySQL on Linux, Oracle on Linux and MSSQL on Windows Server * 3 -5 years of hands on experience with databases running on AWS RDS About You You will have a background in software engineering and a passion for continuous improvement, bringing these to bear to solve operations problems. Media and/or broadcast experience are a huge plus. We are looking for strong written and in-person communication and a self-starter that can identify and solve problems early on and help mentor less senior members of the team. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, disability, protected veteran status, or any other characteristic protected by law. We will consider for employment qualified applicants with criminal histories consistent with applicable law. Fox Corp. Phoenix AZ

SQL Database Administrator

State Of Arizona