Previous Job
Previous
Database Administrator 3
Ref No.: 16-00847
Location: Austin, Texas
Client: Texas Health and Human Services Commission (HHSC) Enterprise.
Location: Austin,TX
Duration: 11 Months
Limit one (1) candidate resume per vendor for this job.
Responses are due July 15, 2016 by 5:00 PM (CT). 



DESCRIPTION OF SERVICES
The Department of Information Resources (DIR) requires the services of one Database Administrator, hereafter referred to as Worker(s), who meets the general qualifications of ITSAC Database Administrator 3 Category, Emerging Technology Type and the specifications outlined in this document for the Texas Health and Human Services Commission (HHSC) Enterprise.
 
            All work products resulting from the project shall be considered "works made for hire” and are the property of the HHSC.  HHSC may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).
 
Data Base Administrator performs highly complex database administration work. Work involves the transformation of research and reporting requirements into data system designs to provide for effective and efficient data storage, retrieval, customization, and archiving. The position will have primary responsibility for analyzing the business needs of Data Analytics (DA) Team and other Medicaid/CHIP (MCD) staff related to MCD data in various HHS system, designing and implementing processes to transform data from various systems for use in OLAP data systems for addressing those identified needs, training Data Analytics staff in the structure of the DA Data system and training DA and other MCD staff about data retrieval from the DA data system.  Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.
 
The ideal candidate will be good at multi-tasking, analyzing priorities, documenting requirements, communicating clearly (both written and verbally), and setting/meeting expectations.  The candidate relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks and is expected to use a wide degree of creativity and latitude.  Must be able to effectively communicate with individuals having a wide range of backgrounds, experiences and levels of technical expertise.  All communication with internal and external staff will be handled in a professional manner.  Understanding of data structures, data migration/conversion/transformation and concepts of both relational and multi-dimensional database design. 
Essential Job Functions:
• Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
• Consults and coordinates with Data Analytics Team and other MCD staff in order to identify business needs related to data in the various system, and develop and implement processes to transform data from various systems for use in OLAP data systems to address those needs.  It includes but not limited to
A.     Clarify, understand and document business rules and requirement specifications for both ownership and viability modules in collaboration with business area staff and other IT project team staff.
B.     Conduct and lead systems and user acceptance testing, document inconsistencies and defects, and work to resolve them.
C.    Define, document, and understand all data definitions, business processes, business meaning and usage of Medicaid databases.
• Performs all duties necessary for the design, development, maintenance and tuning of data systems related to Texas Medicaid, CHIP and related programs' eligibility and the acquisition, extraction, transformation and loading of data from various system into those systems.  It includes but not limited to
D.    Develop schemas in Oracle DB to support Tableau Server analyses. Monitor and tune database performance.
E.     Develop and maintain ETL processes for grooming data sources and merging them into Oracle DB schemas designed to support Tableau Server and other analytical tools.
F.     Administration of Tableau Server and design of Tableau data extracts
G.    Design of Tableau worksheets and dashboards
H.    Develop and maintain complex Excel spreadsheets that incorporate VBA programming to extend Excel functionality
• Consults with and provides training to Data Analytics Team and other MCD staff about the Data Analytics Data system including data structure and the design and implementation of data querying tools specific to the needs of Data Analytics Team and other MCD staff. • Performs routine and ad hoc report design, development and production.
 
• Performs other duties necessary to achieve the mission of the Medicaid CHIP Division.
 
II. WORKER SKILLS AND QUALIFICATIONS
  Minimum Requirements:
 
Years
 
Skills/Experience
8 Experience in the Information Technology industry.
5 Development and maintenance of large Oracle database, more than 10TB of data, over 1G number of rows. Experience with performance and conformity testing.
5 Experience in SQL programming. Ability to create and update Oracle-based stored procedures.
5 Experience with system integration testing.
3 Experience facilitating interpersonal interactions involving design, development, testing, peer reviews, and implementation activities including developers, business analysts, development and QA teams while ensuring that system requirements are documented, complete and accurate, and that system support, release notes and maintenance documentation is complete.
3 Ability to elicit requirements from multiple stakeholders with different knowledge areas, clearly and concisely document identified requirements, and provide an integrated solution for projects of varying size and complexity.
2 ETL Technologies, data cleansing, data transformation, ETL automation using scripting languages.
2 Experience developing user acceptance and systems test plans, test scenarios, test processes and schedules, and pre-test training.  Experience designing and coordinating defect reporting and validating defect fixes.
2 Experience designing complex spreadsheets in Excel, with some experience in VBA
Strong Understanding of data structures, data migration/conversion/transformation and concepts of both relational and multi-dimensional database design.
Strong Team player with ability to mentor and train others.
Strong Analytical, interpersonal, technical, and both oral and written communication skills; relies on experience and judgment to plan and accomplish goals; independently performs a variety of complicated tasks with a wide degree of creativity.
Demonstrated Experience working in a team environment.
          
 Preferences:
Years Skills/Experience
Demonstrated Experience with health care data is preferred
 
Demonstrated Experience with data analytics is preferred.
Demonstrated Experience with Tableau desktop and server.
 


The original (529002000149005R) is cancelled, this is a re-solicitation
*DO NOTSUBMIT CANDIDATE LIST BELOW*
Candidate First Name Candidate Last Name
Sowmith Reddy
Michael J Bramante
Dushyant Vangala
Chandrashekar Basupally
Prasad Kuppuri
Sunil Kumar Payal
Vinaya Pottipad
Subhransu Mishra
Daniel Kimethu
Kiran Nalla
Periyasamy Arumugam
Mahesh Sadhinen
William Russell Bullerman
Ramesh Neeruganti
Meka Sakthi
Smithish Jose
Mayur Chaudhary
Raghunath Lingutla
Anudeep Choudary
Raphael Elul
Srikanth R Penumada
Matthew Parker
Jared F. Glade
Sharadchandra Shrirame
Latravious Bell
Mahesh Kumar
Datta Tokala
Silkson Vethamanickam
Srinivas Reddy
Eric Yanta
Nagaraju Kalimishetty
Keerthy Kola
Pragya Gautam
Venkata Namineni
Janardhan Reddy Mannuru
Manoj Kumar
Amir M. Baig
Sudhakar "sid" Perumal
Rajasekhar Vaderavu
Chetan Nandikanti
Jeevan Reddy Kuntla
Nikhil Kumar
Narendra Rawat
Ravi Chandra Thallapaneni
Pokala Jaya Kumar Manoj Kumar
Kevin Reed
Jude Onuh
Chris L'Hoste
Seeta Ramayya