Database Administrator_Computer & Fac Opera(1903000)

Miami-Dade County Public Schools•Miami, FL

2d•Onsite

About The Position

Responsible for monitoring, maintaining and providing support for Enterprise Server databases management systems adopted by Miami-Dade County Public Schools (M-DCPS). Provide support in the administration, backup, integrity and security of various Enterprise databases. Responsible for database tasks from software upgrades and custom interfaces to troubleshooting.

Requirements

Bachelor’s degree in Computer Science, Management Information Systems or similar IT degree, or High School equivalent and three years (3) equivalent work experience in a database environment at Enterprise level.
Knowledge and experience of Enterprise-wide practices in a database environment.
Demonstrated ability to communicate effectively both in oral and written forms.

Responsibilities

Monitor performance of database systems resources and Query throughput (QthD).
Optimize SQL Code as necessary.
Monitors and maintains database storage resources and database maintenance plans for backups, index rebuild/defragment, and database statistics.
Installs, upgrades, migrates and configures Enterprise database systems (DBMS).
Installs database software service packs and cumulative updates as necessary.
Maintain database documentation as required.
Maintain and administer database security access.
Perform database ad-hoc backups and restores.
Troubleshoot and resolve database connectivity issues and responds to database alerts.
Follow Change Management processes to implement database configuration changes.
Follow Problem Management processes to troubleshoot and resolve recurring issues.
Write, execute, and validate DML (Data Manipulation Language), DDL (Data Definition Language), and DCL (Data Control Language) scripts to meet business and customer needs.
Coordinate and perform data modifications and database maintenance.
Assist Customer Support and Development by analyzing data to troubleshoot application issues.
Optimize stored procedures, functions, and ad-hoc queries.
Create and manage SQL Server Integration Services (SSIS) packages to manage Extract, Transform, Load (ETL) processes.
On call 24 hours a day, 7 days a week, as needed.
Perform other duties as assigned by immediate supervisor.