Senior Database Administrator – Data Warehousing & ETL

InstantServe LLC; Austin (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Power BI reports

Job summary

InstantServe LLC is seeking an experienced Database Administrator II to support enterprise database administration, data warehousing, data modeling, performance tuning, security, backup/recovery, and database development activities.

The ideal candidate will have strong experience with enterprise-class databases, data warehouses, data marts, ETL processes, SQL, analytical/reporting tools, and database performance management.

Qualifications

• 5+ years of experience with data warehouses, data marts, and decision-support tools.
• 5+ years with Business Objects and data dictionary development.
• 5+ years using database access tools for application delivery.
• Strong understanding of data warehousing, data population, modeling, and design.
• Hands-on experience with Star Schema, Snowflake Schema, and normalized data models.
• Strong SQL and database development skills.
• Experience with GUI-based ETL tools such as Informatica or DataStage.
• Experience with Teradata, Oracle, SQL Server.
• Experience with analytical/reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy.
• End-to-end data warehouse implementation lifecycle understanding.
• Knowledge of benchmarking and performance management.
• Excellent communication and ability to work with technical and non-technical stakeholders.

Responsibilities

• Administer, monitor, maintain, and optimize enterprise database systems.
• Perform database performance tuning and capacity analysis.
• Design logical and physical data models, including Star and Snowflake schemas.
• Develop and maintain data warehouses and data marts.
• Create and manage data dictionaries and data governance.
• Support ETL processes and data integration with tools.
• Ensure security, backup/recovery, and disaster recovery.
• Provide data analysis and reporting support via BI tools.
• Collaborate with developers, analysts, and business stakeholders.

Skills

Database administration

SQL

Data warehousing

Data modeling

Analytical thinking

Communication

Tools

Informatica

IBM WebSphere DataStage

Power BI

Business Objects

Cognos

Hyperion

MicroStrategy

Oracle

Teradata

SQL Server

Job description

InstantServe LLC is seeking an experienced Database Administrator II to support enterprise database administration, data warehousing, data modeling, performance tuning, security, backup/recovery, and database development activities.

The ideal candidate will have strong experience with enterprise-class databases, data warehouses, data marts, ETL processes, SQL, analytical/reporting tools, and database performance management.