Supports and performs the planning, design, administration, operation and maintenance of the TIERS DataMart database. Performs database design & development and provides database related support to the application development teams that are performing application enhancements planned to support new program & business requests and to enhance Scalability & Stability of the applications. Provides technical expertise for data retrieval and update programs. Writes and debugs complex reports in Informatica and Cognos. Plans, develops, and implements database policies and procedures; and ensures data integrity as maintenance and modification projects to existing applications are undertaken. Participates in the development of and enforces programming standards for programs interfacing with the databases. Provides technical assistance to programming personnel.
Configures and monitors alerts. Develops and implements appropriate monitoring tools. Plans for future data needs ensuring that needed capacity is available. Develops policies and procedures to ensure consistent implementation of database and programming best practices. Contributes to development of budgets and recommendations for future upgrades. Contributes to improving and creating database application processes and procedures
Create technical and design documentation, as required.
Perform system analysis and problem resolution, as required.
Analyze software for configuration & performance tuning opportunities, as required.
Develop and maintain data and process models, as required.
Employ contemporary testing methods to ensure applications function properly and without error.
Provide technical support for testing and implementation efforts.
Participate in program design, coding and test walk-through meetings to provide input regarding technical standards and customer requirements.
Provide database support (defect repair, maintenance, and production operations support) for DataMart reports. Perform system analysis, troubleshooting, diagnosis and problem resolution. Analyze software for defects and performance tuning opportunities. Develop and test code/scripts to resolve defects and improve application reliability and performance.
SALARY RANGE: 120K TO 130K Per Annum
CANDIDATE SKILLS AND QUALIFICATIONS
8 Years Required:
Knowledge of Informatica 10.5 .
Experience developing reports in Cognos Analytics 11.1 .
Experience using Unix cron .
Experience writing Unix shell scripts .
Experience writing moderate to advanced SQL queries .
Extensive knowledge of Oracle 19 .
Basic knowledge of star schemas /dimensional data structures.
Exceptional technical writing skills.
3 Years Preferred:
Knowledge of TIERS or HHSC Programs and Types of Assistance .
...JOB TITLE: Delivery Service Driver LOCATION: Paso Robles Full-Time Non-Exempt Starting Pay $18.00 - $21.00 per... ...great place to work! POSITION SUMMARY: Responsible for operating a company service truck and ensure that all deliveries, pick-ups, and servicing...
...with onsite leaders and dispatch. Pay and bonus potential ~ Route and detention pay. ~$5,000 sign-on bonus for experienced drivers. ~ Safety and performance bonuses of up to $600 per quarter. ~ Longevity bonus of up to $750 per quarter. ~ Weekly paychecks....
...Title Entry Level Gas Line Safety Technician Description Gas Meter Checker Job Description Do you want to play a crucial role... ...Travel Requirements ~ Travel is primarily locally during the business day although some out of the area travel and overnight may be...
Are you looking for stable company to grow with? Build your career with Hendrick Automotive Group, the nation's largest privately held automotive group and #1 in the U.S. in terms of online reputation for 5 straight years (Reputation.com). Hendrick Automotive Group is ...
..., such as 14 heated outdoor pools, 14 hot tubs, and the state-of-the-art Shipwreck Island Water Park. Job Description Painters will be responsible for performing the following duties as directed by the Engineering and resort leadership. Prepares all surfaces...