Database Administrator

ArnAmy, Inc.; Austin (TX); On-site; USD 110,000 - 170,000; Full time

Job summary

Unknown is seeking a seasoned database professional to oversee database administration, data warehousing, and data modeling across enterprise systems. The role requires strong knowledge of DBMS, data warehouses, and ETL tools, with a focus on performance tuning and data integrity.

The candidate will coordinate with programmers and analysts, review complex programs, and ensure accessibility and security standards across data interfaces.

Qualifications

• 5+ years of experience in database management and data warehousing.
• Experience with data warehouse development and data marts.
• Experience with Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
• Strong analytical and communication skills.
• Knowledge of benchmarking processes.
• Experience with GUI-based ETL tools such as Informatica or DataStage.

Responsibilities

• Monitor database performance and ensure data integrity.
• Direct developers to modify DBMS and implement performance tuning.
• Collaborate with stakeholders to align data architecture with business requirements.

Skills

Database management systems

Data warehousing

Data marts

Data dictionary

SQL

ETL tools

Informatica

WebSphere DataStage

Teradata

Oracle

Power BI

Business Objects

Tools

Informatica

WebSphere DataStage

Teradata

Oracle

SQL Server

Power BI

Job description

nters 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 impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. Providing assistance in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment. Evaluates users' requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance. Coordinates the use of data to ensure data integrity and control redundancy, loads databases, and reorganizes as needed. Performs data modeling and prototyping. Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. Performs security recovery procedures. Determines and implements database search strategies and storage requirements. Maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. Monitors database performance and recommends efficiency improvements. Creates test database environment for applications section, including the creation of necessary libraries and procedures. Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures. Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems. Assists with the installation of database software and with analyzing, designing, and implementing databases. Assists in benchmarking and threshold testing of databases and with establishing and controlling necessary database security. Assists in the selection of database management software. Experience in computer systems analysis or computer programming work. Knowledge of the principles, practices, and techniques of computer programming and systems design; of computer operations, systems, and procedures; of project control and cost estimating techniques; of computer programming languages; of data processing flowcharting techniques; of database structures and theories; and of current database technologies. Has working knowledge of EIR Accessibility standards and assistive technologies. Ensures that user interfaces for database administration and inputting, viewing, outputting data(via reports) are compliant with accessibility standards. Provides support to users in obtaining data / information when EIR Accessibility issues arise.

Minimum Requirements

II. CANDIDATE SKILLS AND QUALIFICATIONS

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

YearsRequired/PreferredExperience

• 5RequiredStrong knowledge of database management systems, as well as data warehouse management and decision support tools
• 5RequiredExtensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
• 5RequiredExperience in business objects and in building the data dictionary
• 5RequiredAbility to use data base access tools for application delivery
• 5RequiredStrong familiarity with analysis, planning and management reporting functions
• 5RequiredWell-developed oral and written communications skills
• 5RequiredStrong teamwork and interpersonal skills
• 5RequiredExtremely high level of analytical ability where problems are very unusual and extremely difficult
• 5RequiredUnderstanding of benchmarking processes and techniques
• 5RequiredVery high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output
• 5RequiredData Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
• 5RequiredGUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
• 5RequiredImplementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.
• 5RequiredImplementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
• 5RequiredExperience with data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, Structured Query Language (SQL), end-user tools, database and SQL pe
• 5RequiredImplementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
• 5RequiredExcellent analytical; problem-solving; team playing; and oral and written communication skills.
• 5RequiredProven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
• 5PreferredOracle Database experience
• 5PreferredPowerBI report creation