Database Administrator - Austin, United States - Health & Human Services Comm

Health & Human Services Comm

Verified Company

Austin, United States

2 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

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 handson 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 oncall 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 100% 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.
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 filesystembased 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.
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.
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 te