Overview
On Site
Hybrid
Contract - W2
Skills
IT Consulting
Oracle Cloud
Salesforce.com
Mapping
Documentation
Stored Procedures
PL/SQL
Requirements Analysis
Data Mapping
Collaboration
Technical Support
Innovation
Communication
Extract
Transform
Load
Business Analysis
Decision-making
Data Extraction
Microsoft Azure
ADF
Informatica
Perl
Scripting
Tableau
Dashboard
Distribution
Performance Tuning
Management
Data Integrity
Data Modeling
Prototyping
Physical Data Model
RDBMS
Recovery
Storage
Data Dictionary
Computer Hardware
Disaster Recovery
Benchmarking
Testing
Database Security
Systems Analysis
Systems Design
Computer Operation
Project Control
Cost Estimation
Programming Languages
Data Processing
Assistive Technology
Interfaces
Accessibility
Supervision
Litecoin
Database
Information Systems
Data Warehouse
Reporting
System Documentation
Database Administration
User Guides
Training
Law
Job Details
- JOB-7277
- Database Administrator II
- Austin, TX / HYBRID
- Contract
- Link Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently seeking a Database Administrator II to join our team.
QUALIFICATIONS
Minimum of seven (7) years of experience with the following:- Assess user requests for new data elements and systems, integrating them into the existing shared data environment.
- Utilize data modeling tools such as Tableau, Azure Data Factory (ADF), Informatica, and others.
- Design both logical and physical data models, including Entity Relationship Diagrams (ERDs).
- Implement database components within Oracle Cloud RDBMS and Salesforce CRM platforms.
- Bring advanced data modeling expertise in designing, creating, and maintaining data models for production databases.
- Generate database scripts using data modeling tools.
- Apply updates and modifications to existing data model designs.
- Create source-to-target mapping documentation to support ETL development efforts.
- Develop complex database components including stored procedures, triggers, and PL/SQL packages.
- Conduct requirements analysis and offer data mapping support to application and development teams.
PREFERRED
Minimum of five (5) years of experience with the following:- Coordination and Collaboration: collaborate with teams such as IT support, development, and operations to gather information and expertise.
- Experience and Judgment: relies on limited experience and judgment to plan and achieve goals.
- Creativity and Innovation: requires creativity, out-of-the-box thinking, and a degree of flexibility.
- Supervision and Independence: works with limited supervision, exercising significant initiative and independent judgment.
Minimum of four (4) years of experience with the following:- Communication: keep stakeholders updated on the status of issues and solutions.
- Aware of standard concepts, practices, and procedures within the specific field.
Minimum of two (2) years of experience with the following:- Experienced in ETL (Extract, Transform, Load) processes to move and transform data for business analysis and decision-making; strong background in data extraction from diverse sources.
- Preferred certifications in Azure Data Factory (ADF) or Informatica.
- Familiarity with PERL scripts is a plus.
- Experienced in creating Tableau dashboards.
RESPONSIBILITIES- Enters codes to create production data base.
- Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
- Directs programmers and analysts to make changes to data base management system.
- Reviews and corrects programs.
- Answers user questions.
- Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base.
- Modifies data base programs to increase processing performance, referred to as performance tuning.
- Workers typically specialize in one or more types of data base management systems.
- Providing assistance in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment.
- Evaluates users requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance.
- Coordinates the use of data to ensure data integrity and control redundancy, loads databases, and reorganizes as needed.
- Performs data modeling and prototyping.
- Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.
- Performs security recovery procedures.
- Determines and implements database search strategies and storage requirements.
- Maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary.
- Monitors database performance and recommends efficiency improvements.
- Creates test database environment for applications section, including the creation of necessary libraries and procedures.
- Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
- Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems.
- Assists with the installation of database software and with analyzing, designing, and implementing databases.
- Assists in benchmarking and threshold testing of databases and with establishing and controlling necessary database security.
- Assists in the selection of database management software.
- Experience in computer systems analysis or computer programming work.
- Knowledge of the principles, practices, and techniques of computer programming and systems design; of computer operations, systems, and procedures; of project control and cost estimating techniques; of computer programming languages; of data processing flowcharting techniques; of database structures and theories; and of current database technologies.
- Has working knowledge of EIR Accessibility standards and assistive technologies.
- Ensures that user interfaces for database administration and inputting, viewing, outputting data (via reports) are compliant with accessibility standards.
- Provides support to users in obtaining data / information when EIR Accessibility issues arise.
- Works under the general supervision of the Regulatory LTC Application Manager or their designee; this position is responsible for leading complex technical database activities for the information systems supporting the division of regulatory services.
- Provides support in the development and maintenance of data warehouse and reporting systems.
- Develops, tests, debugs and documents highly complex program code to implement functional and design requirements for reporting systems in the agency.
- Participates in code walk-thrus.
- Assists in the development and maintenance of system documentation.
- Works with other members of the development team and end-users.
- Develops and maintains expertise in a variety of programming and database management tools. Develops technical and user documentation and supports training as required.
Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.
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.