Database Administrator

Location: Dallas, TX 75202

About the Role

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.

Responsibilities

• Installs, configures, upgrades, and administers multiple platforms including 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.
• Implements appropriate data governance and access control measures for all managed databases.
• Analyzes data access problems and handles all incidents and service requests associated with database administration to determine cause and recommend solutions.
• Provides 5-star customer service and meets Agency service level agreements (SLA).
• Performs work from remote locations as needed and works variable hours, including emergency response to outages.
• Must be able to work in an on-call rotation.
• Actively participates in knowledge sharing and staff cross-training to ensure backup for all essential tasks and responsibilities.
• Performs other related duties as assigned.

Requirements

• Bachelor’s degree from an accredited college or university in Computer Science, Management Information Systems, or related field.
• Five (5) years of experience in Oracle and/or SQL Server database administration in UNIX, Linux, or Windows operating environments, including at least three (3) years managing a database in an enterprise application environment.
• Proficiency in SQL Clustering, OEM/Grid Control, RMAN, and knowledge of RAC and partitioning techniques.
• Demonstrated expert knowledge in administration of 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) or Oracle Education Services as a Certified Associate (or equivalent formal SQL training). Ability to obtain required training within six (6) months of appointment for continued employment.
• Working knowledge of data modeling techniques and Microsoft SQL Server management tools.
• 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.

Skills

• Ability to be dedicated to meeting the expectations and requirements of internal and external customers.
• Strong written communication skills; ability to write clearly and succinctly in a variety of settings.
• Conflict management: ability to step up to conflicts, seeing them as opportunities; finds common ground and settles disputes equitably.
• Problem-solving: ability to accurately scope tasks and projects; uses rigorous logic to solve difficult problems with effective solutions.
• Resource management: ability to marshal resources effectively to accomplish goals.
• Quick learner: ability to rapidly develop technical understanding and new industry knowledge.
• Ability to function effectively in Waterfall, Iterative, Hybrid, and Agile project methodologies.
• Strong analytical and creative skills to solve complex problems.

Pay

$85,000.00 - $140,250.00

Working Conditions

• Works in an environment with minimal exposure to dust, noise, or temperature variations.
• May be moderately exposed to unpleasant working conditions (dust, noise, temperature, weather, petroleum products, and chemicals) while visiting DART's operating facilities, assuming all safety policies and procedures are followed.