Database Administrator 2

Job Overview:
We are seeking an experienced Database Administrator (DBA) to join our team, responsible for the design, development, and maintenance of data warehouses and data marts. The ideal candidate will have a strong background in database management systems, ETL tools, and analytical reporting tools, as well as experience in managing large-scale enterprise databases. The DBA will play a key role in implementing and optimizing data architectures, ensuring data quality, and supporting business intelligence initiatives through efficient data management and reporting solutions.

Key Responsibilities:

• Design, implement, and maintain data warehouse architectures, including data models such as Star Schemas, Snowflake Schemas, and highly normalized data models.
• Develop and manage ETL processes using GUI-based tools such as Informatica, IBM WebSphere DataStage, or similar technologies.
• Perform data sourcing, transformation, and loading processes, ensuring data quality and consistency.
• Implement and support enterprise-class databases (e.g., Teradata, Oracle, SQL Server) and optimize their performance.
• Work with analytical and reporting tools (e.g., Business Objects, Cognos, Hyperion, MicroStrategy) to support reporting and decision-making processes.
• Collaborate with technical and non-technical teams to understand business requirements and translate them into database and reporting solutions.
• Build and maintain data dictionaries and support business intelligence initiatives by ensuring the availability of accurate and timely data.
• Conduct benchmarking processes and apply data management best practices to optimize database performance.
• Provide ongoing support for database-related issues, troubleshooting, and performance tuning.
• Collaborate in database and reporting tool implementation from business requirements through logical and physical design, data modeling, and deployment.

Required Qualifications:

• 7+ years of experience using database access tools such as Informatica, Oracle OCI, or similar tools for application delivery.
• 5+ years of experience with database management systems, data warehouse management, and decision support tools.
• 5+ years of experience in developing, implementing, and maintaining data warehouses and data marts.
• 5+ years of experience with building and managing data dictionaries and business objects.
• 5+ years of experience in analyzing, planning, and managing reporting functions for business intelligence.
• Strong oral and written communication skills with the ability to present complex technical information clearly.
• High level of teamwork, interpersonal skills, and the ability to collaborate with cross-functional teams.
• Excellent analytical, problem-solving, and troubleshooting abilities in complex scenarios.
• Strong understanding of benchmarking processes and database performance optimization.
• Experience with data warehousing data population, data modeling techniques, and schema design (Star, Snowflake, and normalized models).
• Proficiency with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
• 5+ years of experience with enterprise-class database systems (e.g., Teradata, Oracle, SQL Server).
• 5+ years of experience with analytical and reporting tools (e.g., Business Objects, Cognos, Hyperion, MicroStrategy).
• Solid understanding of the data warehouse implementation process, from business requirements through logical and physical database design to data sourcing, transformation, and end-user tools.
• Proven ability to work successfully with both technical and non-technical teams, manage multiple tasks, and meet deadlines.

Preferred Qualifications:

• 7+ years of experience with Informatica database tools.
• 5+ years of experience with Oracle Database administration and management.
• 5+ years of experience in creating SSRS reports for business intelligence solutions.

The ideal candidate will have a strong background in data management and reporting tools, a passion for optimizing database performance, and a track record of successfully implementing enterprise database solutions. This is an excellent opportunity to contribute to high-impact projects and work in a collaborative, dynamic environment.