drjobs Database Administrator 2

Database Administrator 2

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Jobs by Experience drjobs

5years

Job Location drjobs

Austin, TX - USA

Monthly Salary drjobs

$ 58 - 75

Vacancy

1 Vacancy

Job Description

Job Title: Database Administrator 2

Location: Hybrid (Must be available to work onsite 2 days/week subject to change)

Division: Regulatory Services

Agency: Health and Human Services Commission (HHSC)

Reports To: Regulatory LTC Application Manager or Designee




Job Summary


The Database Administrator 2 will lead and support the planning development implementation and performance optimization of complex relational database systems that support the HHSC Division of Regulatory Services. This position is responsible for maintaining and improving the efficiency security and accessibility of data across multiple platforms including Oracle Cloud RDBMS and Salesforce CRM. The role requires strong expertise in data modeling PL/SQL development ETL processes and performance tuning with a focus on maintaining system integrity compliance and reliability.




Key Responsibilities


  • Develop test and deploy complex database programs and stored procedures using PL/SQL and related technologies.

  • Evaluate user requests for new data elements and incorporate them into the shared data environment.

  • Design and maintain logical and physical data models entity relationship diagrams and data dictionaries.

  • Lead database performance tuning efforts and recommend optimizations.

  • Implement and maintain database objects within Oracle Cloud RDBMS and Salesforce CRM environments.

  • Generate scripts using data modeling tools to support data integration and development processes.

  • Develop and document sourcetotarget mappings to support ETL processes.

  • Support the creation and maintenance of Tableau dashboards and other data visualization tools.

  • Perform database recovery backup and security procedures.

  • Ensure compliance with EIR Accessibility standards and provide support when accessibility issues arise.

  • Collaborate with IT development and operations teams to gather business requirements and align database solutions with agency goals.

  • Assist in system documentation code walkthroughs and user training activities.

  • Monitor analyze and improve data integrity storage strategies and disaster recovery protocols.


Requirements

Required Skills and Experience


(Minimum 7 years of experience unless otherwise stated)

  • Strong experience evaluating user requirements and integrating new data elements into shared systems.

  • Proficiency with data modeling tools (e.g. Tableau Azure Data Factory Informatica).

  • Advanced experience in logical and physical data modeling and ER diagram creation.

  • Proven track record designing creating and maintaining complex production data models.

  • Handson experience implementing database objects in Oracle Cloud RDBMS and Salesforce CRM.

  • Expertise in developing PL/SQL packages stored procedures and database triggers.

  • Ability to generate scripts using modeling tools and incorporate changes to existing data models.

  • Experience performing requirement analysis and providing data mapping guidance for ETL development.




Preferred Qualifications


  • 5 years: Effective collaboration with crossfunctional teams including IT support development and operations.

  • 5 years: Demonstrated creativity and ability to exercise independent judgment under minimal supervision.

  • 4 years: Strong communication skills with the ability to update stakeholders on issue resolution status.

  • 4 years: Familiarity with standard concepts and practices in database administration and programming.

  • 2 years: Experience with ETL processes and tools understanding of extracting data from diverse sources.

  • 2 years: Certification in Azure Data Factory (ADF) or Informatica (preferred).

  • 2 years: Experience working with PERL scripts (a plus).

  • 2 years: Experience creating and managing Tableau dashboards.




Note: This is a hybrid role requiring both onsite and remote work. Candidates must be available to report to the office at least 2 days per week.


Benefits

Health Care:
Air InfoSec offers an Individual Coverage Health Reimbursement Arrangement (ICHRA) providing up to $350/month in taxfree reimbursements to help cover the cost of your own health insurance premium. This gives you the flexibility to choose the plan that works best for you and your family.

Paid Time Off (PTO):
1 hour of PTO earned for every 20 hours worked.
Can carryover up to 5 days of PTO to the next calendar year.

Holidays:
5 paid state holidays (annually)
2 paid floating holidays (annually)

Continuing Education:
$100 per year to apply towards annual certification fees or educational training.

Required Skills and Experience (Minimum 7 years of experience unless otherwise stated) Strong experience evaluating user requirements and integrating new data elements into shared systems. Proficiency with data modeling tools (e.g., Tableau, Azure Data Factory, Informatica). Advanced experience in logical and physical data modeling and ER diagram creation. Proven track record designing, creating, and maintaining complex production data models. Hands-on experience implementing database objects in Oracle Cloud RDBMS and Salesforce CRM. Expertise in developing PL/SQL packages, stored procedures, and database triggers. Ability to generate scripts using modeling tools and incorporate changes to existing data models. Experience performing requirement analysis and providing data mapping guidance for ETL development. Preferred Qualifications 5+ years: Effective collaboration with cross-functional teams including IT support, development, and operations. 5+ years: Demonstrated creativity and ability to exercise independent judgment under minimal supervision. 4+ years: Strong communication skills, with the ability to update stakeholders on issue resolution status. 4+ years: Familiarity with standard concepts and practices in database administration and programming. 2+ years: Experience with ETL processes and tools, understanding of extracting data from diverse sources. 2+ years: Certification in Azure Data Factory (ADF) or Informatica (preferred). 2+ years: Experience working with PERL scripts (a plus). 2+ years: Experience creating and managing Tableau dashboards. Note: This is a hybrid role requiring both onsite and remote work. Candidates must be available to report to the office at least 2 days per week.

Employment Type

Full Time

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.