DATABASE ADMINISTRATOR_COMPUTER & FAC OPERA(1903000)

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.

EXAMPLE OF DUTIES

1. Monitor performance of database systems resources and Query throughput (QthD).

2. Optimize SQL Code as necessary.

3. Monitors and maintains database storage resources and database maintenance plans for backups, index rebuild/defragment, and database statistics.

4. Installs, upgrades, migrates and configures Enterprise database systems (DBMS).

5. Installs database software service packs and cumulative updates as necessary.

6. Maintain database documentation as required.

7. Maintain and administer database security access.

8. Perform database ad-hoc backups and restores.

9. Troubleshoot and resolve database connectivity issues and responds to database alerts.

10. Follow Change Management processes to implement database configuration changes.

11. Follow Problem Management processes to troubleshoot and resolve recurring issues.

12. Write, execute, and validate DML (Data Manipulation Language), DDL (Data Definition Language), and DCL (Data Control Language) scripts to meet business and customer needs.

13. Coordinate and perform data modifications and database maintenance.

14. Assist Customer Support and Development by analyzing data to troubleshoot application issues.

15. Optimize stored procedures, functions, and ad-hoc queries.

16. Create and manage SQL Server Integration Services (SSIS) packages to manage Extract, Transform, Load (ETL) processes.

17. On call 24 hours a day, 7 days a week, as needed.

18. Perform other duties as assigned by immediate supervisor.

PHYSICAL REQUIREMENTS

This work requires the following physical activities: sitting, mobility, lifting, finger dexterity, grasping, repetitive motions, talking, hearing and visual acuity. The work is performed primarily indoors.

1. Two (2) Professional Letters ofRecommendation signed or electronic signature and dated within the last 12 months (one year) of the application. References must be from a person who can assess your ability as an administrator or your work ethic and character. Letters of recommendation must include the name, signature and contact information for the person completing the reference.

Professional Certifications or Licenses: If a position requires a specific certification(s) or license in the minimum qualification requirements listed in the job description, please upload a copy of your current/active certificate or license to your candidate profile.

Performance Evaluations: Candidates selected for a final interview are required to have acceptable performance evaluations during the three years immediately preceding application for the position. You can upload these evaluations to your candidate profile.

Veteran’s Preference: If requesting veteran’s preference, please check the appropriate box in SuccessFactors and attach form DD-214.

Conferred Transcripts with a Graduation Date: Current M-DCPS employees do not need to submit official transcripts if highest degree earned is on file in the Office of Personnel Records (305-995-7258). For external candidates, official transcripts will be required if you are recommended for the position. Your degree must be from an accredited university. If the position does not require a college degree, you are required to have at least a high school diploma. Candidates with academic training and degrees granted outside the U.S. must submit a credential evaluation report that includes a statement of degree equivalency from an accredited agency in the U.S., * Reasoning and Decision-Making Skills

• Ability to Present Ideas Effectively
• Ability to Communicate in Written Form, 1. 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.

1. Knowledge and experience of Enterprise-wide practices in a database environment.

2. Demonstrated ability to communicate effectively both in oral and written forms., 2. Two (2) Professional Letters ofRecommendation signed or electronic signature and dated within the last 12 months (one year) of the application. References must be from a person who can assess your ability as an administrator or your work ethic and character. Letters of recommendation must include the name, signature and contact information for the person completing the reference.

Professional Certifications or Licenses: If a position requires a specific certification(s) or license in the minimum qualification requirements listed in the job description, please upload a copy of your current/active certificate or license to your candidate profile.

Performance Evaluations:Candidates selected for a final interview are required to have acceptable performance evaluations during the three years immediately preceding application for the position. You can upload these evaluations to your candidate profile.

Veteran’s Preference:If requesting veteran’s preference, please check the appropriate box in SuccessFactors and attach form DD-214.

Conferred Transcripts with a Graduation Date:Current M-DCPS employees do not need to submit official transcripts if highest degree earned is on file in the Office of Personnel Records (305-995-7258). For external candidates, official transcripts will be required if you are recommended for the position. Your degree must be from an accredited university. If the position does not require a college degree, you are required to have at least a high school diploma. Candidates with academic training and degrees granted outside the U.S. must submit a credential evaluation report that includes a statement of degree equivalency from an accredited agency in the U.S.

Salary Min: $64,655

Salary Max: $111,834

Miami-Dade County Public Schools (M-DCPS), an A-rated district, is the nation’s third largest school system with nearly 500 schools and a diverse enrollment of more than 335,500 students from over 160 countries. Our ongoing tradition of groundbreaking achievement has earned top recognition at the national and international levels and makes M-DCPS your best choice.