- Performs analysis and research of application functionality and interprets requirements in order to support Application Development teams' development.
- Practices current development methods/techniques and establishes development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of code.
- Reviews database change request to ensure they meet standards and are consistent with the structural parameters within the existing database environment and are tracked electronically
- Supports application development team needs for new database structures and/or modifications to existing structures.
- Designs, codes, and modifies extract, transform, and load (ETL) logic to populate Agency data warehouse and data marts in order to support Agency reporting.
- Performs advanced data warehouse architect work which includes data warehouse design, data modeling, and metadata design.
- Reviews all application database change requests to determine any (downstream) effect on warehouse ETLs.
- Provides Database Administrator (DBA) support by verifying database structure changes have been applied correctly.
- Communicates and/or collaborates with other department teams to coordinate development efforts.
- Assists in the development and maintenance of documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience.
- Ensures project schedules are met, and/or re-negotiated, and approved by customer and Team Manager prior to target dates.
- Communicates progress and issues affecting work assignments to the Team Manager and/or Project Manager as soon as possible.
- Manages work activities for short and long range performance assignments, communicating with management and other team members in a timely and effective manner.
- Follows established Data Management Team code migration processes.
- Mentors junior level staff in the development, testing, and deployment.
- Consults the Data Dictionary for any dependencies and additional information that the data administration request may require.
- Review explain plans for new or modified queries for performance and suggest alternative ways to resolve any performance issues.
- Provides on-call support on a rotating schedule.
- Develops and conducts presentations, and communicates technical information to all areas of the agency management, including customers, and technical and/or non-technical staff.
- Reviews and analyzes legislative bills related to the application/system and when applicable, provides a cost estimate and potential impact analysis.
- Stays current on the latest technology updates and development techniques for the applicable area(s) of responsibility. (May be accomplished via books, periodicals, Internet, conferences, and training.)
- Adheres to all Texas Department of Family and Protective Services HR policies, performs related work as assigned and attends work on a regular and predictable schedule in accordance with agency leave policies and to maintain unit operations.
- Expert knowledge of Oracle databases with some of that experience being Exadata is preferred.
- Knowledge and experience with the Software Development Life Cycle (SDLC) and project planning
- Knowledge of UNIX and shell scripting is preferred.
- Knowledge of Oracle SQL and/or PL-SQL.
- Knowledge of Informatica PowerCenter is preferred
- Knowledge of database object migration/validation tools is preferred
- Knowledge of Informatica or similar tool is preferred
- Knowledge and understanding of ETL development, monitoring, batch or data processing in an automated scheduled environment is preferred.
- Skill in understanding and implementing database change requests.
- Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint.
- Ability to document issues, risks, and defects.
- Ability to communicate effectively in a technical environment, including on-the-job training with coworkers, project team members, and IT management
- Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various level personnel in governmental entities.
- Ability to lead and work cooperatively in a team environment.
-
Ryder System, Inc. Austin, United StatesJob Seekers can review the Job Applicant Privacy Policy by clicking HERE. (-applicant-privacy-policy)\ · Job Description · Summary · This unique role is responsible for maintaining the newly implemented SAS commission administration system (Varicent ICM) and providing support to ...
-
Recruiting Coordinator
1 week ago
Rex Austin, United States**Why Elite Players Join Rex Tech** · Elite players join Rex Tech to: empower working people with better tech, be a part of a no-BS hardcore tech business with American/Texan ideals, and build a ridiculously valuable enterprise. · **Background On Rex Tech** · Built ground-up mult ...
-
Splunk Admin/developer
2 weeks ago
COMTEC INFORMATION SYSTEMS Austin, United States**LOOKING FOR US CITIZENS AND GREEN CARD HOLDERS ONLY..** · **Title**: Splunk Admin/Developer · **Location**: Austin, TX (Hybrid) · ComTec has an immediate need for a Splunk Developer who can be part of our growing Splunk team. This role is responsible for developing reports and ...
-
Car Detailing Operations Manager
3 weeks ago
Shwash Austin, United States**SHWASH is one of the leading car detailing and paint protection companies in Austin, TX. We specialize in on-demand mobile car detailing as well as paint correction and paint protection services. SHWASH has experienced rapid growth since its origin, and is scaling to become the ...
-
Txdmv - Customer Service Representative Iii
2 weeks ago
TEXAS DEPARTMENT OF MOTOR VEHICLES Austin, United States**TxDMV - Customer Service Representative III** **(** **)** · **Organization**: TEXAS DEPARTMENT OF MOTOR VEHICLES · **Primary Location**: Texas-Austin · **Work Locations**: Camp Hubbard Bldg Jackson Ave Bldg 1 Austin · **Job**: Office and Administrative Support · **Employee Sta ...
-
TEXAS MEDICAL BOARD Austin, United States**Professional Development and Training Coordinator** **(** **)** · **Organization**: TEXAS MEDICAL BOARD · **Primary Location**: Texas-Austin · **Work Locations**: George H.W. Bush 1801 Congress Ave Suite 9.200 Austin 78701 · **Job**: Business and Financial Operations · **Employ ...
-
Account Supervisor
2 weeks ago
Adlucent Austin, United States**Account Supervisor** · Adlucent is looking for its next great Account Supervisor to drive team and client success. Account Supervisors have a leadership role leading a pod, and responsible for overseeing and optimizing multiple client accounts. Account Supervisors play a pivota ...
-
Technical Customer Service Representative
2 weeks ago
Enovis Austin, United StatesJob Description: · - At Enovis we sweat the little things. We embrace collaboration with our partners and patients, and we glory in the grind of scientific excellence — with the goal of transforming medical technology as we know it. · - Because that's how we change the lives of p ...
-
Tdhca - Multifamily Programs Systems Analyst
1 week ago
TEXAS DEPT OF HOUSING AND COMMUNITY AFFAIRS Austin, United States**TDHCA - Multifamily Programs Systems Analyst** **(** **)** · **Organization**: TEXAS DEPT OF HOUSING AND COMMUNITY AFFAIRS · **Primary Location**: Texas-Austin · **Work Locations**: TDHCA physical address 221 East 11th Street Austin 78701 · **Job**: Computer and Mathematical · ...
-
Twdb - 24-96 - Financial Compliance Examiner
2 weeks ago
TEXAS WATER DEVELOPMENT BOARD Austin, United States**TWDB Financial Compliance Examiner (Financial Examiner I)** **(** **)** · **Organization**: TEXAS WATER DEVELOPMENT BOARD · **Primary Location**: Texas-Austin · **Work Locations**: TWDB Stephen F Austin Bldg 1700 Congress Ave PO Box 13231 Austin 78711 · **Other Locations**: Tex ...
-
Bookkeeper/state Accountant I-iii
3 weeks ago
LIBRARY AND ARCHIVES COMMISSION Austin, United States**Bookkeeper/State Accountant I-III (Commensurate with Experience) PT and FT positions** **(** **)** · **Organization**: LIBRARY AND ARCHIVES COMMISSION · **Primary Location**: Texas-Austin · **Work Locations**: Lorenzo de Zavala Bldg 1201 Brazos St Austin 78701 · **Job**: Busine ...
-
TEXAS EDUCATION AGENCY Austin, United States**Texas Student Data Systems Customer Support Manager (Manager VI)** **(** **)** · **Organization**: TEXAS EDUCATION AGENCY · **Primary Location**: Texas-Austin · **Work Locations**: Texas Education Agency 1701 NORTH CONGRESS AVENUE Austin 78701 · **Job**: Management · **Employee ...
-
Legal Assnt Ii
3 weeks ago
TEXAS MEDICAL BOARD Austin, United States**Legal Assnt II** **(** **)** · **Organization**: TEXAS MEDICAL BOARD · **Primary Location**: Texas-Austin · **Work Locations**: George H.W. Bush 1801 Congress Ave Suite 9.200 Austin 78701 · **Job**: Legal · **Employee Status**: Regular · **Schedule**: Full-time · **Standard Hou ...
-
TEXAS WATER DEVELOPMENT BOARD Austin, United States**TWDB Flood & State Program Reporting Coordinator (Program Specialist I-II)** **(** **)** · **Organization**: TEXAS WATER DEVELOPMENT BOARD · **Primary Location**: Texas-Austin · **Work Locations**: TWDB Stephen F Austin Bldg 1700 Congress Ave PO Box 13231 Austin 78711 · **Other ...
-
Legal Assnt Iii
3 weeks ago
TEXAS MEDICAL BOARD Austin, United States**Legal Assnt III** **(** **)** · **Organization**: TEXAS MEDICAL BOARD · **Primary Location**: Texas-Austin · **Work Locations**: George H.W. Bush 1801 Congress Ave Suite 9.200 Austin 78701 · **Job**: Legal · **Employee Status**: Regular · **Schedule**: Full-time · **Standard Ho ...
-
Program Spclst Iii
3 weeks ago
TEXAS MEDICAL BOARD Austin, United States**Program Spclst III** **(** **)** · **Organization**: TEXAS MEDICAL BOARD · **Primary Location**: Texas-Austin · **Work Locations**: George H.W. Bush 1801 Congress Ave Suite 9.200 Austin 78701 · **Job**: Business and Financial Operations · **Employee Status**: Regular · **Schedu ...
-
Associate Salesforce Administrator
3 days ago
NinjaOne, LLC Austin, United States**About the Role** · NinjaOne is looking for an Associate Salesforce Admin with a collaborative, cross-functional approach. You will maintain our systems, processes, data, and insights across our revenue teams (sales, marketing, billing, and customer success). Reporting directly ...
-
Case Supervisor
1 week ago
PCG Advanced Health Austin, United States**Job Types**: Part-time, 1099 · Pay per hour: $80-$100.00 per hour. · Job tasks: · - Meet with supervisees/interns one to three hour per week to provide individual and group clinical supervision; · - Review supervisees clinical notes and provide feedback as needed · - Support su ...
-
Vertica Admin with Performance Tuning
2 days ago
QSS Austin, United StatesJob Title: Vertica Admin with Performance Tuning · Location: Austin, TX/Sunnyvale, CA · Duration: Contract · Skills Required: · Minimum 10+ years' experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud. · Expert Knowledge of Vertica Arc ...
-
Software Engineering Manager
3 days ago
NinjaOne, LLC Austin, United States**About the Role** · As a hands-on Software Engineering Manager, you will lead the development of NinjaOne's integrations and internal services. You will be responsible for inspiring our software development team to innovation and excellence. Manage our teams developing our suite ...
IT System Analyst V – Data Admin – 100 % remote TX - Austin, United States - Texas Department of Aging & Disability Services
Description
Job Description:
The Texas Department of Family and Protective Services (DFPS) is currently seeking an Oracle Developer for a full-time position within the IT Data Management team.
The Developer reports to the Data Management Manager within Information Technology Services (ITS). Works under limited supervision, with considerable latitude for the use of initiative and independent judgment. This position performs advanced (senior-level) data systems analysis; data development; and on-going support of applications used by DFPS staff.Some work involves extraction, transformation and loading (ETL) of data into the agency data warehouse; data warehouse development; data administration; and coordinating the planning and analysis of user requirements, procedures, and problems to automate processing or improve existing systems.
As a member on the Data Management Team, the position requires strong knowledge of data warehouse development, ETL, Oracle, PL/SQL and SQL.
Preferrable, the candidate should have knowledge of Informatica PowerCenter as well as business intelligence visualization tools such as Tableau.The position requires an ability to communicate effectively, both verbally and in writing, and the ability to manage projects against established timelines with minimal supervision.
This position also requires the ability to learn and apply new technology, work independently or in a team environment, and collaborate with all levels of staff within DFPS to satisfy business needs.
The mission of DFPS is to protect children, the elderly, and people with disabilities from abuse, neglect, and exploitation by involving clients, families, and communities.
We are looking to grow our teams with people who share our energy and enthusiasm to get behind our mission of protecting those among us who are most in need.
This position is classified as a full-time position (40 hours a week). Remote work options are available for workers living in Texas. Work outside of regular hours may be required; some weekend on-call duty may be required.
Essential Job Functions:
Knowledge Skills Abilities:
