Database Administrator/Architect (Database Administrator)

Job Summary

Travis County is seeking an experienced, detail-oriented Database Administrator/Architect to support the organization, maintenance, and optimization of our company’s database systems. The successful candidate will be responsible for ensuring high-availability, performance tuning, and secure management of our data infrastructure. You should be familiar with various database technologies and tools, as well as the principles of database design and data analysis. Our ideal candidate is an analytical problem solver with deep expertise in database structure systems and data mining. The candidate will also require a strong knowledge of database design principles and industry standards. This is an excellent opportunity for a professional with strong technical skills across multiple platforms including MySQL, Microsoft SQL Server, Azure and AWS SQL. Travis County is looking for a candidate who can immediately contribute to our organization’s data integrity and operational efficiency. This role is ideal for a dedicated professional eager to utilize their technical expertise within a dynamic environment that values innovation and precision in data management. This is an excellent opportunity for a professional with strong technical skills in database design and administration to contribute to our organization’s data integrity and operational efficiency.

Duties and Responsibilities

• Analyzing the data needs and requirements of an organization.
• Aids in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment.
• Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems.
• Documents and maintain database configurations, procedures, and standards for compliance and knowledge sharing.
• Develop policies and procedures designed to ensure the integrity of the database environment.
• Provides ongoing trend analysis for determining current need and forecasting future resource requirements. Produces periodic status and operational reports.
• Manage and maintain databases including MySQL, Microsoft SQL Server, ensuring their stability, security, and high availability.
• Implements, manages, and maintains development, test, and production database systems.
• Completes database installation and configuration of database parameters.
• Configure and manage backup, recovery, replication, and disaster recovery procedures.
• Sets up privileges to databases and manages database elements.
• Monitor database health through performance metrics and troubleshoot issues proactively.
• Creating and managing database reports, visualizations, and dashboards.
• Perform performance tuning and optimization to enhance database responsiveness and throughput.
• Evaluates users’ requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance.
• Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
• Schedules and performs database upgrades.
• Familiarity with Shell Scripting for automation purposes.
• Hands-on experience with SSIS for data integration tasks.
• Knowledge of disaster recovery planning and implementation strategies.
• Researching and recommending innovative database techniques and technologies.
• Excellent organizational skills with the ability to prioritize tasks effectively.
• Collaborate with development teams, business stakeholders, and other partners to support all software development lifecycle phases for net new products/solutions/applications.
• Provide application & database operations triage support to troubleshoot & resolve issues encountered in production, development, and test environments. This responsibility includes both workday and night/weekend on-call support as required.
• Training staff on database use and management.
• Performs other job-related duties as assigned.

Minimum Requirements

Education and Experience:
Bachelor's degree in Computer Science, Information Systems, Business Administration or a directly related field AND three (3) years of relevant work experience;

OR,

Any combination of education and experience that has been achieved and is equivalent to the stated education and experience and required knowledge, skills, and abilities sufficient to successfully perform the duties and responsibilities of this job.

Licenses, Registrations, Certifications, or Special Requirements:
Valid Texas Driver's License.

Preferred:
Microsoft Certified Database Administrator (MCDBA) Certification.

Knowledge, Skills, and Abilities:
Knowledge of:

• Database system management, maintenance and integration.
• Database design, analysis and normalization.
• Software engineering and the software development lifecycle.
• Policies, practices, procedures and terminology of assigned function.
• Federal, State, Local and County applicable laws, rules, regulations and guidelines.
• Information technology hardware, software and peripherals as related to assigned function.
• Computer equipment to include word processing, spreadsheets, databases and a variety of software packages.
• Knowledge of and adherence to HIPAA and other federal and state laws requiring the confidential handling of certain health information.

• Managing moderately complex databases such as Microsoft Structured Query Language (SQL) server.
• Data analysis, database design, data dictionaries, and database normalization.
• Problem-solving and decision-making.
• Both verbal and written communication, including presentations and communicating technical issues in non-technical language.

• Work independently and efficiently and as part of a team.
• Manage time well, perform multiple tasks, and organize diverse activities.
• Translate policies and objectives into ideas and applications web-based information products.
• Research, compile, analyze, interpret and prepare a variety of memorandums or reports.
• Establish and maintain effective working relationships with departmental clientele, representatives of outside agencies and providers, other County employees and officials, and the general public.

Work Environment & Other Information

Physical requirements include the ability to lift/carry up to 35-40 pounds occasionally, visual acuity, speech and hearing, hand and eye coordination and manual dexterity necessary to operate a computer and office equipment. Subject to standing, sitting, walking, climbing, crawling, bending, stooping, crouching, kneeling, pushing, pulling, reaching, twisting, balancing, repetitive motion, and squatting to perform the essential functions. Subject to exposure to variations in extreme heat, cold, mechanical, fume/odor, and dust/mites.

Travis County employees play an important role in business continuity. As such, employees can be assigned to business continuity efforts outside of normal job functions.

Work Hours: 8 am - 5 pm, Monday-Friday.

Location: 700 Lavaca, Austin, TX 78701.

Department: Information Technology

Criminal, Driving, Education, and Employment Background Checks Required.

For updates or questions on this position, contact: Shari.Campos-lopez@traviscountytx.gov

This job description is intended to be generic in nature. It is not necessarily an exhaustive list of all duties and responsibilities. The essential duties, functions and responsibilities and overtime eligibility may vary based on the specific tasks assigned to the position.