Sr Logical Database Administrator / Database Developer at Texas Health & Human Services Commission | Austin, TX, US | Rezi

Sr Logical Database Administrator / Database Developer at Texas Health & Human Services Commission

Sr Logical Database Administrator / Database Developer

Texas Health & Human Services Commission · Austin, TX, US

5 days ago

Sr Logical Database Administrator / Database Developer

Texas Health & Human Services Commission · Austin, TX, US

6 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this Sr Logical Database Administrator / Database Developer role.

Rezi rewrites your resume against Texas Health & Human Services Commission's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Sr Logical Database Administrator / Database Developer posting at Texas Health & Human Services Commission — free, in seconds.

About the Role

HHSC Social Services Applications division is seeking a Senior Logical Database Administrator / Database Developer with a proven track record in developing and maintaining high-performance enterprise software solutions using Agile methodologies. This role is central to ensuring the TIERS applications portfolio remains available and in service for HHSC Staff and the citizens of the State of Texas.

Responsibilities

  • Design, develop, maintain, and improve database solutions and the databases underlying the TIERS applications portfolio.
  • Work closely with application development teams, business stakeholders, and other partners to enhance the TIERS applications portfolio and implement new solutions.
  • Work with a talented team in building databases and applications using technologies including: Java/J2EE, SOAP/REST web services, Spring, JPA, jQuery, AngularJS, IBM WebSphere, Oracle, PostGreSQL.
  • Perform advanced logical database administration/development, performance monitoring & tuning, and provide database support for application development teams, testing, and defect repair.
  • Utilize Agile development practices to participate in backlog grooming & user story development.
  • Design, develop, build & test databases and collaborate with other teams in support of application enhancements.
  • Provide application & database operations triage support to troubleshoot & resolve functional & performance issues in production, development, and test environments, including on-call support.
  • Own day-to-day application-specific database design efforts.
  • Perform and support the design, development, tuning, and maintenance of databases including structures, behaviors, performance, security, and recovery.
  • Provide expertise and participate in the development and implementation of database architectures to meet application performance and security requirements.
  • Serve as a technical resource for difficult questions and problems.
  • Provide technical guidance for database related design, development, integration, conversion, and testing work.
  • Educate development teams on database concepts and techniques.
  • Assist with analysis and design of new development, updates, changes, and fixes.
  • Write and debug complex stored procedures and triggers.
  • Implement, administer, manage, and monitor assigned application databases in production & non-production environments.
  • Monitor database performance and design/implement performance tuning improvements.
  • Advise developers on tuning options.
  • Ensure data integrity and data security are maintained.
  • Provide database support (defect repair, maintenance, and production operations support) for web-based Java applications in an SOA platform.
  • Perform analysis, troubleshooting, diagnosis, and problem resolution.
  • Analyze software for defects and performance tuning opportunities.
  • Develop and test database code/scripts to resolve defects and improve application reliability and performance.
  • Configure and monitor alerts.
  • Develop and implement appropriate monitoring tools.
  • Plan for future data needs ensuring needed capacity is available.
  • Develop policies and procedures to ensure consistent implementation of database and programming best practices.
  • Contribute to improving and creating database application processes and procedures.
  • Evaluate and recommend database software packages and upgrades.
  • Plan, coordinate, and implement database management software installations and upgrades.
  • Assist in testing database updates, enhancements, and changes to ensure assigned applications and related systems meet SLA requirements.
  • Work with scrum masters/agile coaches, architects, web/java developers, database developers & administrators, system administrators, business analysts, and other team members.
  • Contribute to teamwork and unit harmony.
  • Attend program design, coding, and test walk-through meetings to provide input regarding adherence to technical standards and customer requirements.
  • Comply with all Federal, State, and agency laws, rules, policies, and procedures including SOPs that govern HHSC IT.
  • Comply with Department and State guidance on automation system architecture and programming standards.
  • Promote an image of IT excellence and communicate effectively.
  • Perform other duties as assigned.

Requirements

  • Graduation from an accredited College or University with a bachelor’s degree. Major in computer science, computer information systems, management information systems, or a related field is highly preferred.
  • Graduation from an accredited high school or GED plus four years of relevant full time, paid work experience may substitute for degree.
  • 8 Years: full time logical database administration, or closely related experience in enterprise-class production environment.
  • 5 Years: Logical Database Administration of Oracle 11 and/or Oracle 19 databases in production environment, including creating & documenting logical & physical data models, developing stored procedures/scripts/SQL and optimizing/tuning SQL.
  • 5 Years: Experience supporting application development teams and multiple, simultaneous development cycles.
  • 4 Years: Experience supporting Oracle 19 and/or PostGreSQL in an enterprise-scale production environment.
  • 4 Years: Experience performing logical database administration in support of Java (J2EE) / WebSphere based enterprise applications.
  • 4 Years: Database programming and/or script writing experience.
  • 2 Years: Experience supporting application databases through an Oracle 19 upgrade.
  • 2 Years: Experience with RAC, RAT, Big Data, Goldengate, ASM, Dataguard, & RMAN.
  • 2 Years: Experience supporting migration of Oracle databases to PostGreSQL.
  • 2 Years: Experience supporting enterprise-scale databases in Azure, Amazon, and/or Google Cloud platforms.
  • Selected candidates must be legally authorized to work in the U.S. without sponsorship.
  • Selected candidate must be willing to commute to the office on the required days.

Skills

  • Oracle database technologies
  • Agile methodologies
  • Java/J2EE
  • SOAP/REST web services
  • Spring
  • JPA
  • jQuery
  • AngularJS
  • IBM WebSphere
  • Oracle
  • PostGreSQL
  • Logical database administration
  • Database development
  • Performance monitoring & tuning
  • Database support
  • Application development
  • Testing
  • Defect repair
  • Backlog grooming
  • User story development
  • Database design
  • Database structures
  • Database behaviors
  • Database security
  • Database recovery
  • Database architectures
  • Stored procedures
  • Triggers
  • Database administration
  • Data integrity
  • Data security
  • SOA platform
  • Troubleshooting
  • Problem resolution
  • Software analysis
  • Performance tuning
  • Alert configuration
  • Monitoring tools
  • Capacity planning
  • Database management software installation
  • Database management software upgrades
  • SLA requirements
  • Scrum
  • Technical standards
  • Customer requirements
  • Automation system architecture
  • Programming standards
  • Software development
  • Full software development life cycle (SDLC)
  • Industry accepted software engineering practices
  • Life cycle methods
  • Database theories
  • Data analysis techniques
  • Computer programming
  • Systems design
  • Computer operations
  • Technical analysis
  • Oracle 11g /19c
  • Windows Server
  • Unix (Solaris)
  • Linux
  • Troubleshooting complex software and database problems
  • Isolating performance issues
  • Evolutionary & traditional Oracle tuning methodologies
  • Internal views
  • Performance monitoring tools
  • Shell & SQL scripting
  • Proactive & reactive performance tuning
  • Multiple application environment tuning
  • Iterative tuning
  • Large Oracle databases on Unix
  • Communication
  • Working under pressure
  • Managing multiple deadlines
  • Teamwork
  • Unit harmony
  • Continuous improvement
  • Producing reliable, accurate, high-quality results
  • RAC
  • RAT
  • Big Data
  • Goldengate
  • ASM
  • Dataguard
  • RMAN
  • Azure
  • Amazon
  • Google Cloud platforms

Location

  • AUSTIN

Work Type

  • Onsite
  • Regular
  • Full time

Experience Level

  • Senior
  • 8 Years: full time logical database administration, or closely related experience in enterprise-class production environment
  • 5 Years: Logical Database Administration of Oracle 11 and/or Oracle 19 databases in production environment
  • 5 Years: Experience supporting application development teams and multiple, simultaneous development cycles
  • 4 Years: Experience supporting Oracle 19 and/or PostGreSQL in an enterprise-scale production environment
  • 4 Years: Experience performing logical database administration in support of Java (J2EE) / WebSphere based enterprise applications
  • 4 Years: Database programming and/or script writing experience
  • 2 Years: Experience supporting application databases through an Oracle 19 upgrade
  • 2 Years: Experience with RAC, RAT, Big Data, Goldengate, ASM, Dataguard, & RMAN
  • 2 Years: Experience supporting migration of Oracle databases to PostGreSQL
  • 2 Years: Experience supporting enterprise-scale databases in Azure, Amazon, and/or Google Cloud platforms

Education Level

  • Bachelor’s degree in computer science, computer information systems, management information systems, or a related field preferred.
  • High school diploma or GED plus four years of relevant full-time, paid work experience may substitute for degree.

Salary/Compensations

  • $7,015.16 - $9,439.83 Monthly

Benefits

  • 100% paid employee health insurance for full-time eligible employees
  • Defined benefit pension plan
  • Generous time off benefits
  • Numerous opportunities for career advancement

About the Company

  • Texas Health and Human Services Commission (HHSC) is committed to creating a positive impact in the lives of fellow Texans.
  • HHSC Social Services Applications division is responsible for implementing and managing leading edge applications including Texas Integrated Eligibility Redesign System (TIERS) and the related Eligibility Supporting Technologies portfolio.
  • This portfolio is used to process applications and determine eligibility for over 60 types of food, cash assistance, medical, and community care services to Texans in need.
  • The team works with cutting edge technologies on many high-impact initiatives that serve various HHSC lines of business.
  • The team consists of an exceptional group of software, database, and dev-ops engineers working together to make a difference for customers.

Equal Opportunity

  • This position is open to U.S. Citizens and permanent residents.
  • In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability.
  • Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.
  • HHSC uses E-Verify.