Loading...
Apply now

Apply for Job

Database Administrator II

Requisition Number:  3140
Pay Rate:  PGRT13
Location: 

Houston, TX, US

Category:  Other
Description: 

Basic Function

Responsible for the design, implementation, administration and maintenance of Microsoft SQL Server instances with both on-premise and hosted cloud environments, Oracle instances on Linux/Windows and administration of Microsoft business intelligence applications.  Ensures system integrity, security, availability, backups and performance of all supported database systems.  Participates as a team member in multi-disciplined teams to successfully implement and support systems.  Provides on-call support on nights and weekends, as needed.  Performs duties in a safe, efficient manner and in compliance with all applicable rules and safety procedures.

Responsibilities and Specific Duties

  • Responsible for the configuration, implementation, administration and maintenance of all commercial-off-the-shelf (COTS) and custom databases, ensuring they conform to established standards.
  • Reviews, evaluates and designs databases for custom in-house applications, ensuring they conform to established standards.
  • Responsible for implementation and testing of database patches and upgrades.
  • In conjunction with system stakeholders, defines and configures system access and security in all database systems.
  • Monitors, maintains, documents, and predicts database performance to meet established service levels.
  • Develops entity relationship and data flow diagrams and documents all processes.
  • Writes code for database access, modifications, and construction, including stored procedures.
  • Creates logical and physical data structures to support established application architecture standards.
  • Establishes maintenance plans for each database, to include backups and recovery.
  • Optimizes data models for maximum application performance and creates physical data models that provide high-level performance.
  • Performs all facets of application integration, data extraction, transformation, and loading.
  • Ensures that all actions are in compliance with established internal controls and change management processes.
  • Responsible for developing, implementing and maintaining database disaster recovery plans in compliance with the departmental and organizational disaster recovery plans.
  • Responsible for rapid repair and recovery in system failure situations.
  • Maintains strict confidentiality and security of sensitive data.
  • Utilizes an incident management system to manage system-related problem tracking and resolution.
  • Provides excellent customer service to METRO internal and external customers.
  • Promotes safety awareness and follows safety procedures to reduce or eliminate accidents.
  • Performs other job-related duties as assigned.

Education Requirement

Bachelor’s degree in a related field.  Experience may be substituted for educational requirements

Years & Experience Required

Minimum of five (5) years experience in relevant database administration.  Significant experience in  Microsoft SQL Server databases instantiated with on-premise Windows Server and Azure Cloud environments. Familiarity with Azure Portal and SQL Elastic Pool, and SQL Server High Availability Solutions. Experience with Oracle databases instantiated on Red Hat Linux and Windows Server environments.  Demonstrated experience in implementing and managing relational database solutions. Demonstrated experience in data migrations, upgrades, patch management and troubleshooting.  Strong experience in system integrations, including documentation and monitoring.

Knowledge & Skills Required

Strong customer service and organizational skills.  Strong interpersonal and communication skills, written and verbal. Strong understanding of profile, security roles, and object level privileges.  Must understand all levels of security, including operating system, database and application levels.

One or more certifications in database administration is desirable: Microsoft Certified Technology Specialist (MCTS); Microsoft Certified IT Professional (MCITP), Oracle Certified Associate (OCA); Oracle Certified Professional (OCP); Oracle Certified Master (OCM).

Additional Information

The Metropolitan Transit Authority of Harris County, Texas has a zero tolerance drug and alcohol policy for all employees. All internal and external applicants will be required to undergo drug testing before employment and will be subject to further drug and/or alcohol testing throughout their employment.

Further, employees who perform safety-sensitive functions will submit to drug and/or alcohol testing in accordance to the Department of Transportation (DOT) and the Federal Transit Administration (FTA) regulatory requirements.

We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, sex, national origin, veteran status, genetic information or disability.
 


Nearest Major Market: Houston

Apply now

Apply for Job