Database Administrator

Pay Range:

$85,000.00 - $140,250.00

Supervisory Organization:

Sr Mgr Software Engineering-Data Analytics

Country:

United States of America

Address:

1401 PACIFIC AVE

City:

DALLAS, TX 75202

FLSA:

Exempt

Professionals:

02 - Professional (EEO-4-United States of America), 2F - Professionals - System & Service Planners (EEO-SubCategory)

General Summary:

Provides agency-wide Oracle and SQL Server database management functions, develops and administers backup and disaster recovery procedures, assists project teams with designs and implementation of efficient and effective relational database storage schemas, maintains and optimizes existing application data repositories, and administers, installs, and upgrades all Oracle and SQL Server instances.

Essential Duties and Responsibilities:

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Installs, configures, upgrades, and administers multiple platforms to include and SQL Server and Oracle in Linux and Windows. Performs duties related to the installation of new SQL Server software, including evaluation, configuration and optimization of new software packages related to database management in single node, multi-node and clustered environments.
• Designs, implements, and manages backup and disaster recovery policies and procedures on an application basis to match application requirements.
• Manages SQL Server and Oracle storage in RAC configuration, schema, security and tuning database.
• Creates and updates PL/SQL and T-SQL scripts as needed.
• Supports other Technology Division employees in database related duties and functions as required.
• Serves as technical expert to internal/external contacts related to client service application development and maintenance.
• Devises and implements application optimization relative to data storage and retrieval application requirements.
• Implement appropriate data governance and access control measures to all databases managed.
• Analyzes data access problems and handle all incidents and service requests associated with database administration to determine cause and recommend solutions, follow through as directed by management.
• Provide 5-star customer service and meet Agency service level agreements (SLA).
• Performs other related duties as assigned.

MINIMUM KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:
Note: An equivalent combination of related education and experience may be substituted for the below stated minimums excluding High School Diploma, GED, Licenses, or Certifications.

• Bachelor’s degree from an accredited college or university in Computer Science, Management Information Systems, or related field.
• Five (5) years experience in Oracle and/or SQL Server database administration in UNIX or Linux or Windows operating or related environment to include at least three (3) years experience managing a database in an enterprise application environment.
• Proficient using PC and software applications. Working knowledge of UNIX or Linux or Windows servers, databases, and computer peripherals.
• Proficiency in SQL Clustering, OEM/Grid Control, RMAN, and knowledge of RAC, and partitioning techniques.
• Demonstrated expert Knowledge in administration of and SQL Server and Oracle database instances, user access schemas, and disaster recovery procedures.
• Certification from Microsoft Corporation as a SQL Database Administrator, MCSE or MCDBA. Oracle Education Services as a Certified Associate or an equivalent background of formal SQL training or ability to obtain training within six (6) months of appointment for continued employment.
• Working knowledge of data modeling techniques.
• Working knowledge of Microsoft SQL Server and management tools.
• Perform work from remote locations as needed.
• Work variable hours, to include emergency response to outages.
• Must be able to work in an on-call rotation.
• Must maintain all certification(s) required for this position.
• Pass a physical (medical) examination that includes a drug screen in order to operate DART non-revenue vehicles.
• Ability to be dedicated to meeting the expec