Database Administrator

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

Seeking an experienced Database Administrator 2 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.

Key Responsibilities

• Administer, monitor, maintain, and optimize enterprise database management systems and integrated database environments.
• Perform database performance tuning, benchmarking, threshold testing, capacity analysis, and recommend efficiency improvements.
• Design and implement logical and physical data models, including relational models, Star Schemas, Snowflake Schemas, and highly normalized data models.
• Support the development, implementation, and maintenance of data warehouses and data marts.
• Develop and maintain database structures, stored procedures, utilities, and SQL processes to support application and reporting requirements.
• Manage data warehouse population, data sourcing, transformation, loading, and data integration activities.
• Work with GUI-based ETL tools, including Informatica, IBM WebSphere DataStage, or similar technologies.
• Implement and support enterprise-class database technologies such as Oracle, Teradata, SQL Server, or similar platforms.
• Utilize database access tools to support application delivery, data analysis, and reporting requirements.
• Develop and maintain data dictionaries, ensuring consistent data definitions, standards, and data governance.
• Support database security, access controls, backup/recovery, disaster recovery, and restoration procedures.
• Create and maintain test database environments and support application testing and deployment activities.
• Analyze user requirements for new data elements and systems and integrate them into the existing shared data environment.
• Collaborate with developers, programmers, analysts, technical teams, and business stakeholders to assess the impact of database changes.
• Support analytical and reporting platforms such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar tools.
• Create and support Power BI reports and dashboards as applicable.
• Provide technical assistance to users and troubleshoot database and data-access issues.
• Ensure database administration interfaces and data input/output processes comply with applicable EIR accessibility standards and support assistive technologies.

Required Qualifications

• 5+ years of experience working with database management systems, data warehouses, and decision-support tools.
• 5+ years of experience developing, implementing, and maintaining data warehouses and data marts.
• 5+ years of experience with Business Objects and data dictionary development.
• 5+ years of experience using database access tools for application delivery.
• Strong understanding of data warehousing, data population, data modeling, and database design.
• Hands-on experience with Star Schema, Snowflake Schema, and highly normalized data models.
• Strong experience with SQL and database development.
• Experience with GUI-based ETL tools, such as Informatica, IBM WebSphere DataStage, or equivalent.
• Experience implementing enterprise database platforms such as Teradata, Oracle, SQL Server, or similar technologies.
• Experience with analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar.
• Strong understanding of the complete data warehouse implementation lifecycle, including business requirements, logical modeling, physical database design, data sourcing, transformation, data loading, SQL, and end-user reporting tools.
• Understanding of database benchmarking and performance management techniques.
• Strong analytical and problem-solving capabilities.
• Excellent written and verbal communication skills.
• Ability to work effectively with both technical and non-technical stakeholders.
• Strong teamwork, interpersonal, and organizational skills.
• Ability to manage multiple responsibilities and work in complex technical environments.

Preferred Qualifications

• Experience creating Power BI reports.
• Experience supporting public-sector or enterprise environments.
• Knowledge of database security, disaster recovery, and accessibility standards.