Database Administrator

dart; United States; On-site; USD 85,000 - 140,000; Full time

Job summary

DART is seeking an experienced Database Administrator to manage Oracle and SQL Server environments across Linux and Windows. You will design and implement backup and disaster recovery plans, tune databases, and develop PL/SQL and T-SQL scripts to support critical applications.

Responsibilities include security, access control, and data governance, with on-call and variable hours as needed to ensure high availability and performance for agency systems in Dallas, TX.

Qualifications

• Bachelor's degree in a related field; equivalent combination of education and experience may suffice.
• At least 5 years of Oracle and/or SQL Server database administration in UNIX/Linux/Windows environments.
• Proficiency with SQL clustering, RAC, RMAN, and partitioning techniques.
• Certification in SQL Server or Oracle, or willingness to obtain within six months.

Responsibilities

• Install, configure, upgrade, and administer Oracle and SQL Server databases on Linux and Windows.
• Design and implement backup and disaster recovery policies for database environments.
• Manage storage, security, and tuning for Oracle and SQL Server databases, including RAC configurations.
• Develop PL/SQL and T-SQL scripts to support applications and data migrations.
• Provide expert guidance on data governance, access controls, and incident resolution.

Skills

Oracle

SQL Server

UNIX/Linux

PL/SQL

T-SQL

Backup & DR

Data modeling

Clustering/RAC

Security & access

Education

Bachelor's degree in Computer Science or related field

Tools

OEM/Grid Control

RMAN

SQL Server Management Studio

Windows Server

Linux administration

Job description

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:

• 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 expectations and requirements of internal and external customers. Gets first-hand customer information and uses it for improvements in products and services. Acts with customers in mind. Establishes and maintains effective relationships with customers and gains their trust and respect.
• Ability to write clearly and succinctly in a variety of communication settings and styles. Can get messages across that have the desired effect.
• Ability to step up to conflicts, seeing them as opportunities. Read situations quickly. Good at focused listening. Can hammer out tough agreements and settle disputes equitably. Can find common ground and get cooperation with minimum noise.
• Creates strong morale and spirit in his/her team.
• Ability to accurately scope out length and difficulty of tasks and projects.
• Ability to use rigorous logic and methods to solve difficult problems with effective solutions. Can see hidden problems. Is excellent at honest analysis. Looks beyond the obvious and doe