Sr Logical Database Administrator / Database Developer

TX-HHSC-DSHS-DFPS•Austin, TX

3d•$7,015 - $9,440•Onsite

About The Position

Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. At HHSC, your contributions matter, and we support you at each stage of your life and work journey. Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more. Explore more details on the Benefits of Working at HHS webpage. This position is open to U.S. Citizens and permanent residents. This onsite role requires the selected candidate to work from an HHS office in Austin, Texas. HHSC Social Services Applications division is seeking a Senior Logical Database Administrator / Database Developer who has a proven track record in developing and maintaining high-performance enterprise software solutions using Agile methodologies. HHSC Social Services Applications team is responsible for implementing and managing leading edge applications including Texas Integrated Eligibility Redesign System (TIERS) and the related Eligibility Supporting Technologies portfolio that is used to process applications and to determine eligibility for over 60 types of food, cash assistance, medical, and community care services to Texans in need. We work with cutting edge technologies on many high-impact initiatives that serve various HHSC lines of business. We do this all with an exceptional team of software, database, and dev-ops engineers, working together to make a difference for our customers. This is an exciting role, demanding a strong background in Oracle database technologies, and is central to ensuring that the TIERS applications portfolio remains available and in service for HHSC Staff and the citizens of the State of Texas. You will work in a fast paced, customer service-based environment.

Requirements

Knowledge of the principles, practices, and techniques of software development and the full software development life cycle (SDLC).
Knowledge of industry accepted software engineering practices and life cycle methods.
Knowledge of database structures and theories, current database technologies, and data analysis techniques.
Knowledge of the principles, practices and techniques of computer programming and systems design. Knowledge of computer operations, systems and procedures.
Skill in technical analysis and design, including database design and planning.
Ability to work effectively with Oracle 11g /19c, PostGreSQL, Windows Server, Unix (Solaris) and Linux.
Ability to assess future technological needs so that databases can properly evolve.
Ability to troubleshoot and affect a solution for complex software and database problems.
Expertise in troubleshooting & isolating source of performance issues quickly during slow system response time scenarios. In-depth knowledge of evolutionary & traditional Oracle tuning methodologies, internal views, performance monitoring tools and shell & SQL scripting.
Ability to proactively & reactively diagnose and tune performance issues in a multiple application environment. Performing proactive & reactive iterative tuning in databases at various stages of SDLC.
Experience managing large Oracle (specifically Oracle versions 11 & 19c) databases on Unix in a Production environment
Skill communicating with varied levels of staff and end users to develop positive effective working relationships and to establish credibility, trust, and confidence.
Ability to communicate effectively both verbally and in writing, to serve as a technical consultant to technical colleagues, to clearly and accurately document relevant issues, and to prepare accurate, concise, reliable reports.
Ability to work under pressure and successfully manage multiple overlapping deadlines.
Ability to contribute to teamwork and unit harmony.
Ability to accept suggestions for improvement and take steps to continuously improve one’s own performance and conduct.
Ability to produce reliable, accurate, high-quality results
Graduation from an accredited high school or GED plus four years of relevant full time, paid work experience may substitute for degree.

Nice To Haves

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.
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

Responsibilities

Design, develop, maintain, and improve database solutions and the databases underlying the TIERS applications portfolio.
Work closely with the application development teams, business stakeholders and other partners to enhance the TIERS applications portfolio and to implement new solutions.
Work with a very talented team in building databases and applications using some of the coolest web platform technologies including: Java/J2EE, SOAP/REST web services, Spring, JPA, jQuery, AngularJS, IBM WebSphere, Oracle, PostGreSQL and more.
Perform advanced logical database administration / database development, performance monitoring & tuning and providing database related support to the application development teams, testing, and defect repair among other responsibilities.
Utilize Agile development practices to participate in backlog grooming & user story development
Design, develop, build & test databases and work together with other teams in support of application enhancements planned to support new program & business requests and to enhance scalability & stability of the applications.
Provide application & database operations triage support to troubleshoot & resolve functional & performance issues encountered in production, development, and test environments. This responsibility includes both workday and night/weekend on-call support as required to maintain high availability of the applications for various users.