Database Administrator

1 month ago

Austin, United States Texas Department of Aging & Disability Services Full time
Job Description:
The Database Administrator (Database Administrator IV) position performs advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models.

The DBA works on activities including but not limited to database tuning, indexing, customization, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation of database policies, data replication and backup to secondary sites like disaster recovery environments, procedures for the integrity, availability, and confidentiality of the sensitive and business-critical databases.

This position requires hands-on experience as an administrator of relational databases like SQL Server or Oracle as well as experience in the management and administration of NoSQL databases like MongoDB in a cloud environment strongly preferred.

This position is expected to address high demand and may be required to participate in on-call rotation, as needed, with the expectation to complete all projects in a timely manner. This position provides daily supervision and oversight to other DBA resources. This position reports to the Director of Operations.

This position is % telework in the state of Texas and is for U.S. Citizens or residents only.
Essential Job Functions:
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Evaluates users' requests for new data elements and systems and incorporates into the existing shared data environment. Coordinates use of data to ensure data integrity and control redundancy. Loads databases and reorganizes as needed. Performs data modeling and prototyping. (30%)
- Installs and uses Data Modeling tools like Erwin, SQL developer data modeler, etc.
- Develops logical and physical Data Models and Entity Relationship Diagrams.
- Implements database objects in an Oracle RDBMS.
- Advanced data modeler with experience in Design, creation, and maintenance data models representing production databases.
- Generates scripts to be in the database using data modeler tools.
- Incorporates changes to data model design.
- Writes source to target mapping instructions as needed to support ETL development.
- Develops stored procedures, database triggers and complex PL/SQL packages where needed.
- Performs requirement analysis and provide data mapping guidance to application and development teams.
- PL/SQL skills.

Analyzes, designs, and implements databases. Determines and implements database search strategies. Determines database storage requirements. Develops and maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. Establishes and controls necessary database security. (30%)
- Evaluates the database server Hardware.
- Installs database and grid software.
- Plans database for logical structure, overall database design and backup, restore strategy.
- Database performance analysis.
- Implements ASM for database storage or filesystem-based database strategy.
- Follows database naming conventions per guidelines.
- If needed, implements Oracle advanced security and Oracle database Vault.
- Database security solutions to ensure data privacy, protect against insider threats, and enable regulatory compliance.
- Implement oracle identity management to secure critical applications and sensitive data, lower operational costs, and comply with regulatory requirements.
- Directs the design, analysis and development of backup and recovery systems by working with the customer for support and implementation of more complex databases and environments. Serves as primary contact for vendors and system architects to represent customer requirements. Creates documentation for backup and recovery. Defines database validation requirements to ensure database integrity.
- Develops a plan and directs implementation of database security infrastructure that coincides with policy requirements; makes recommendations for security best practices.

Designs, codes, and modifies complex computer programs, subroutines, triggers, stored procedures, objects, classes, and scripts to maintain reporting systems. Performs necessary testing of assigned programs, including the generation of test data, writing test scripts/execution sequences, examining test results, debugging detected errors, etc. Uses current software development methods/techniques and established development standards (which include programming standards, documentation standards and testing standards) to ensure the quality and maintainability of reports/applications. Participates in code walk-throughs to ensure compliance with development standards and system/business requirements. (20%)

Works with trainers, technical support staff, network specialists and contract staff to perform modifications and/or updates to existing systems or to implement new systems. Identifies, investigates, and resolves production problems. This may include analyzing problems, coding, testing, implementing, and training of other technical staff and/or customers. (15%)

Other duties as assigned. (5%) Knowledge Skills Abilities:
Knowledge of database structures and theories, current database technologies, and data analysis techniques.
Knowledge of the principles, practices, and techniques of computer programming and systems design.
Knowledge of computer operations, systems, and procedures.
Knowledge of data processing flowcharting techniques.
Knowledge of Software Development lifecycle.
Skill in developing, maintaining, and troubleshooting data transformations or ETL (Extract Transform and Load), preferably using tools such as Azure Data Factory (ADF) or SQL Server Integration Services (SSIS), Informatica PowerMart, Data Integrator, or others.
Skill with the investigation and resolution of problems using strong analytical techniques, innovative approaches, and taking initiative in preventing problems.
Skill in technical analysis and design, including database design and planning.
Skill in effectively communicating information, both orally and in writing, with individuals and groups with varying technical backgrounds.
Skill in team building and providing oversight and performance management of others.
Ability to organize and plan identified tasks to meet goals and complete multiple assignments without compromising accuracy in a fast-paced environment.
Ability to work in a team environment as well as the ability to independently learn new technologies and concepts quickly.

  • Database Administrator

    4 weeks ago

    Austin, United States L.K. Jordan & Associates Full time

    Database Administrator wanted in the Austin area! Are you a tech-savvy problem-solver with a keen eye for detail? We're seeking a dynamic individual to join our team and revolutionize our lead intake, tracking, and communication processes!100% Remote Database Administrator, Database, Administrator, Technology, Staffing

  • Database Administrator

    1 week ago

    Austin, United States Infojini Full time

    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...

  • Database Administrator

    2 weeks ago

    Austin, United States IDR Healthcare Full time

    IDR is seeking a Database Administrator to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today! Position Overview/Responsibilities for the Database Administrator: Enters codes to create production data base....

  • Database Administrator

    4 weeks ago

    Austin, United States LightEdge Solutions Full time

    This position serves as a member of the Database Services Group that provides database administration for our internal and customers' database systems that include Oracle, SQL Server, MySQL, and others in both stand-alone and high/availability configurations. Responsibilities: Manages database system uptime, data backups & restores, operational tasks;...

  • Database Administrator

    1 week ago

    Austin, United States LightEdge Solutions Full time

    This position serves as a member of the Database Services Group that provides database administration for our internal and customers' database systems that include Oracle, SQL Server, MySQL, and others in both stand-alone and high/availability configurations. Responsibilities: Manages database system uptime, data backups & restores, operational tasks;...

  • Database Administrator

    1 week ago

    Austin, United States Health & Human Services Comm Full time

    The DBA works on activities including but not limited to database tuning, indexing, customization, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation...

  • Database Administrator

    1 month ago

    Austin, United States Dutech Systems Full time

    **Austin,TX**: **DatePosted : 5/1/2024 8:57:52 AM **:JobNumber : DTS101766147 JobType : W2 Skills: Database Experience, Oracle, Microsoft SQL, Database Design, Database Structures, Analysis, Software Development Life Cycle. **SALARY RANGE: 120K TO 130K Per Annum** **CANDIDATE SKILLS AND QUALIFICATIONS** **10 years**: Database experience. **8 years**:...

  • Database Administrator 3

    3 weeks ago

    Austin, United States Smart IMS Full time

    Texas Health and Human Services Commission requires the services of 1 Database Administrator 3, hereafter referred to as Candidate(s), who meets the general qualifications of Database Administrator 3, Data/Database Administration and the specifications outlined in this document for the Texas Health and Human Services Commission. All work products resulting...

  • Database Administrator 3

    2 weeks ago

    Austin, United States Indotronix International Corporation Full time

    The contractor role is for a Senior Database Administrator (Database Administrator III) and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The successful candidate will work with Full-stack...

  • Database Administrator 3

    1 week ago

    Austin, United States Indotronix International Corporation Full time

    The contractor role is for a Senior Database Administrator (Database Administrator III) and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The successful candidate will work with Full-stack...

  • Database Administrator 3

    1 day ago

    Austin, United States LanceSoft Full time

    Enter Job Description... 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...

  • Database Administrator 3

    2 weeks ago

    Austin, United States Prolim Global Full time

    Job DescriptionJob DescriptionPROLIM (www.prolim.com) is currently seeking Database Administrator 3 for one of our top Client for Location- 701 W 51st St Austin, TX 78751 Remote - within the state of TexasQualified candidates can directly send your updated resume and contact info via email: jayaprakash.hiremath@prolim.comJob description:Enters codes to...

  • Database Administrator 3

    1 week ago

    Austin, United States Prolim Global Full time

    Job DescriptionJob DescriptionPROLIM (www.prolim.com) is currently seeking Database Administrator 3 for one of our top Client for Location- 701 W 51st St Austin, TX 78751 Remote - within the state of TexasQualified candidates can directly send your updated resume and contact info via email: jayaprakash.hiremath@prolim.comJob description:Enters codes to...

  • Database Administrator

    7 days ago

    Austin, United States Zilliant Full time

    Zilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.? If youre ready to make an impact at a growing company that values the time, input, and...

  • Database Administrator

    3 weeks ago

    Austin, United States Zilliant Full time

    Job DescriptionJob DescriptionZilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.  If you’re ready to make an impact at a growing...

  • Database Administrator

    1 week ago

    Austin, United States Zilliant Full time

    Job DescriptionJob DescriptionZilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.  If you’re ready to make an impact at a growing...

  • PostgreSQL database administrator

    4 weeks ago

    Austin, United States IRIS Software, Inc. Full time

    Iris is looking for a PostgreSQL database administratorRole: PostgreSQL database administratorLocation: Austin , TXHybrid : 3 days office , 2 days work from homeDuration: Long Term ContractClient : BankingJob Description:10+ years of experience of overall.Must have strong experience working as PostgreSQL database administratormust have good experience in...

  • Vertica Database Administrator

    3 weeks ago

    Austin, United States Adbakx Full time

    Position : Vertica Database AdministratorLocation :Austin, TX~Sunnyvale, CA-OnsiteDuration : Long Term Description :Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud.Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon.Expertise in installing/upgrade and maintaining...

  • Vertica Database Administrator

    3 weeks ago

    Austin, United States Adbakx Full time

    Position : Vertica Database AdministratorLocation :Austin, TX~Sunnyvale, CA-OnsiteDuration : Long Term Description :Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud.Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon.Expertise in installing/upgrade and maintaining...

  • Vertica Database Administrator

    1 week ago

    Austin, United States Adbakx Full time

    Position : Vertica Database AdministratorLocation :Austin, TX~Sunnyvale, CA-OnsiteDuration : Long Term Description :Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud.Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon.Expertise in installing/upgrade and maintaining...