Database Administrator 2 - Hybrid (Austin, TX)

Jobs via Dice • United State
Visa Sponsorship
Apply
AI Summary

Database Administrator 2 supports planning, development, maintenance, monitoring, and security of integrated database systems. Responsibilities include database migrations, performance tuning, security controls, disaster recovery, and EIR accessibility compliance. Requires 4-7 years experience with enterprise databases, ETL tools, and data warehouse implementation.

Key Highlights
4-7 years database administration experience
Hybrid work in Austin, TX
Visa sponsorship available
EIR Accessibility standards compliance
Teradata/Oracle/SQL Server implementation
Key Responsibilities
Support installation of database software and perform migrations to new data management system software levels
Analyze, design, modify, and maintain database structures
Design and implement procedures to save, retrieve, and recover databases from hardware and software failures
Establish and implement database security controls and user access levels
Evaluate and recommend database software packages for potential acquisition
Prepare and maintain database documentation, procedures, and data dictionary definitions
Perform logical and physical data modeling, design relational database models, and create physical models from logical models
Monitor database performance and implement efficiency improvements
Assist in modifying existing databases and database management systems
Assist in development of standards, guidelines, policies, and procedures to preserve database environment integrity
Enter codes to create production databases and run utility programs to monitor database performance
Direct programmers and analysts to make changes to the DBMS, review/correct programs, and answer user questions
Coordinate changes with coworkers to determine impacts on other systems and cost implications
Load databases, reorganize as needed, and create test database environments for application teams
Perform security recovery procedures and assist with disaster recovery monitoring and testing
Provide technical assistance evaluating user requests for new data elements and systems
Assist with benchmarking, threshold testing, and selection of DBMS software
Ensure user interfaces for database administration comply with EIR Accessibility standards
Support users in obtaining data/information where accessibility issues arise
Technical Skills Required
Database management systems Data warehouse management BusinessObjects Data dictionaries GUI-based ETL tools (Informatica, IBM WebSphere DataStage) Teradata Oracle SQL Server SSRS report creation M204 database experience Star Schemas Snowflake Schemas Normalized models Performance tuning Disaster recovery Benchmarking Threshold testing
Benefits & Perks
Visa sponsorship
Hybrid work arrangement
Nice to Have
Oracle Database experience
SSRS report creation
M204 database experience

Job Description


Dice is the leading career destination for tech experts at every stage of their careers. Our client, Maddisoft, is seeking the following. Apply via Dice today!

Maddisoft has the following immediate opportunity, let us know if you or someone you know would be interested. Send in your resume ASAP. - U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. Send in resume along with LinkedIn profile without which applications will not be considered. Call us NOW! ***Visa sponsorship is available for this position.

Job Title: Database Administrator 2

Location: Austin, TX (Hybrid)

Interview Mode: Microsoft Teams

Overview

Database Administrator 2 personnel support the planning, development, maintenance, monitoring, and security of integrated database systems. They work with developers, analysts, and stakeholders to ensure new applications and changes meet structural parameters, data integrity, performance, and accessibility requirements. Workers operate with limited supervision, exercise independent judgment, and must protect the security and integrity of critical infrastructure systems while complying with relevant laws and regulations.

Key Responsibilities

  • Support installation of database software and perform migrations to new data management system software levels; test migrations to ensure data reliability and functionality.
  • Analyze, design, modify, and maintain database structures.
  • Design and implement procedures to save, retrieve, and recover databases from hardware and software failures.
  • Establish and implement database security controls and user access levels.
  • Evaluate and recommend database software packages for potential acquisition.
  • Prepare and maintain database documentation, procedures, and data dictionary definitions.
  • Perform logical and physical data modeling, design relational database models, and create physical models from logical models.
  • Monitor database performance and implement efficiency improvements (performance tuning).
  • Assist in modifying existing databases and database management systems.
  • Assist in development of standards, guidelines, policies, and procedures to preserve database environment integrity.
  • Enter codes to create production databases and run utility programs to monitor database performance (distribution of records, memory usage).
  • Direct programmers and analysts to make changes to the DBMS, review/correct programs, and answer user questions.
  • Coordinate changes with coworkers to determine impacts on other systems and cost implications.
  • Load databases, reorganize as needed, and create test database environments (libraries and procedures) for application teams.
  • Perform security recovery procedures and assist with disaster recovery monitoring and testing.
  • Provide technical assistance evaluating user requests for new data elements and systems and integrate them into the shared data environment.
  • Assist with benchmarking, threshold testing, and selection of DBMS software.
  • Ensure user interfaces for database administration, input, view, and reporting comply with EIR Accessibility standards and provide support when accessibility issues arise.
  • Support users in obtaining data/information where accessibility issues affect access.

Experience And Qualifications

Minimum Requirements (Required)

  • 4-7 years of experience in the field or a related area.
  • Strong knowledge of database management systems and familiarity with data warehouse management and decision support tools.
  • Extensive experience in development, implementation, and maintenance of data warehouses and data marts (desired).
  • Experience with BusinessObjects and building/maintaining data dictionaries.
  • Ability to use database access tools for application delivery.
  • Strong familiarity with analysis, planning, and management reporting functions.
  • Well-developed oral and written communication skills.
  • Strong teamwork and interpersonal skills.
  • Extremely high analytical ability to solve unusual and difficult problems.
  • Understanding of benchmarking processes and techniques.
  • Very high interpersonal skills to collaborate effectively, motivate others, and elicit work output.
  • Experience with data population and data modeling techniques for targets such as Star Schemas, Snowflake Schemas, and normalized models.
  • Experience with GUI-based ETL tools (Informatica, IBM WebSphere DataStage, or similar).
  • Implementation experience with enterprise-class databases (Teradata, Oracle, SQL Server, or similar).
  • Implementation experience with analytical and reporting tools (Business Objects, Cognos, Hyperion, MicroStrategy, or similar).
  • Experience across the data warehouse implementation process: business requirements, logical modeling, physical database design, data sourcing/transformation, loading, SQL, and end-user tools.
  • Excellent analytical, problem-solving, teamwork, and communication skills.
  • Proven ability to work with technical and non-technical groups and manage multiple responsibilities.

Preferred

  • Oracle Database experience.
  • SSRS report creation.
  • M204 database experience.

Similar Jobs

Explore other opportunities that match your interests

Senior Technical Program Manager, Detection & Response (Incident Management)

Networking
•
1d ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

anthropic

United State

Engineering Manager II - Microsoft Purview Cyber Security

Networking
•
1d ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Deloitte

United State

Product Support Specialist

Networking
•
1d ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

anthropic

United State

Subscribe our newsletter

New Things Will Always Update Regularly