Solicitation Number: 5081725DBAdmin2
Direct Client: Texas Workforce Commission
Working Title: SQL Database Administrator - Data migration
Work Location: Austin, Tx - This is a remote position - Telework
JD:
Perform database programming to modernize legacy programs for various projects. Develop simple and complex Structured Query Language (SQL) scripts for data migration and validation. Perform data profiling and analysis. Develop technical documentation including source to target mapping. Develop database code (triggers and stored procedures) for data entry and reporting. Support compliance with acceptable best practices for Data Management and Governance standards. Ensure appropriate configuration and administration of TWC technical environments. Perform unit and system testing of database code. Ensure appropriate configuration and administration of TWC technical environments. Provide troubleshooting assistance during development, test, and implementation as well as during post-implementation support. Coordinate activities (including setting up meetings, documenting notes, following up on action items) and deliverables across all areas. Perform other duties as assigned to maintain operations.
| Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity. | |||
| Years (Required, leave no blanks) | Years | Skills/Experience | Vendor Comments (as applicable) |
| 7 | Working knowledge of SQL scripting and data batch processing in legacy and current technology | ||
| 7 | Developing data conversion maps | ||
| 5-7 | Executing data conversions for large volumes of data | ||
| 5-7 | Implementing database coding standards | ||
| 7 | ETL Development experience using a tool like SSIS or Informatica | ||
| 7 | Skill in solving problems, in scheduling, testing, installing, and implementing data conversion projects/programs | ||
| 7 | Data conversion and migration for enterprise level projects | ||
| 5-7 | Developing Database conceptual, logical and physical database design models to include data dictionary and library | ||
| 7 | Strong SQL Server physical database development experience (functions, stored procedures, triggers) | ||
| 7 | Strong knowledge of MS SQL Server, Oracle PL/SQL, Azure SQL managed instances, and any other database management technologies | ||
| 5-7 | Knowledge of Microsoft Azure Platform Services, and Cloud Service delivery models | ||
| 7 | Knowledge of the Software Development Life Cycle (SDLC) principles, practices and techniques of application programming and software design | ||
| 4-7 | Strong skills in performing data analysis and ensuring data quality | ||
| 5-7 | Collibra, Informatica | ||
| 4-7 | Jira/Confluence/ALM Octane |
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this jobOutgoing personality, trying different roles, enjoying performing;Chinese can facilitate simple communication and exchange;part-time or full-time are acceptable; short video actor on the Tiktok platformAmericans or Japanese nationality;Immigrants whose native language...
...Ready to launch your mechanical engineering career in nuclear energy? Join Westinghouse in Madison, PA (southeast of Pittsburgh near New Stanton... .... Can you: Apply mechanical fundamentals to the design, construction, operation, and eventual decommissioning of nuclear...
Java FSD End client - Freddie Mac/Brillio Location: Mclean VA (5 days) Spring boot, AWS, Kubernetes In person interview Any visa Minimum of 8 years of experience in software development; 8 years of relevant experience and specialized...
...Director, Clinical Science, GI2 TAU- Hematology/Rare Disease in our Cambridge, MA office. At Takeda, we are transforming the pharmaceutical industry through our R&D-driven market leadership and being a values-led company. To do this, we empower our people to realize their...
...classes plz.2.We need different countries teachers.Native ones are the best,Others still be welcomed too!3.Our kids are 3-16 years old 4.6pm to 9:55pm,we always need these slots Help kids to improve their English including listening,speaking,reading and writing etc.