*Please respond back to satees...@shstinc.com <satees...@shstinc.com> or call me on 412-450-1316 Ext : 104.*
*Job Title: Data Warehouse Architect* *Location: Arlington, VA* *Duration : CTH* **** Must be GC or US Citizens **** *Job Description:* Functions as the primary technical architect for data warehousing projects to solve business intelligence challenges Possesses deep technical expertise in database design, ETL (OWB), reporting, and analytics Previous consulting experience utilizing an agile delivery methodology Participate in and/or lead BI application development efforts Interface with stakeholders to elicit reporting requirements and will translate requirements into BI solutions Design or alter ETL scripts, data models, reports, dashboards, visualizations, etc Work with technical teams regarding data structures, data flows, and implementation details. Mentor and guide BI development resources through design, development and support activities Support and enhance existing BI services while working on formal projects in a cross functional team environment Strong conceptual, analytical, and decision-making skills Knowledge and Experience of dimensional modeling Strong knowledge of Oracle PL/SQL Proficiency in creating PL/SQL packages Full SDLC and Data Modeling experience Ability to create both logical and physical data models Ability to tune databases for maximum performance Experience in Data Preparation: Data Profiling, Data Cleansing, and Data Auditing Ability to work with Business Analysts to create functional specifications and data Manages QA functions Develops unit, system, and integration test plans and manages execution Ability to write technical and end-user system documentation Excellent written and oral communication skills Experience transforming logical business requirements into appropriate schemas and models Mentors and develops junior staff though knowledge transfer *Education/Skills:* Bachelor's Degree 3 years ETL experience using Oracle Warehouse Builder ETL tools with at least one OWB project 3 years’ experience with ETL processing 3 years’ experience utilizing data warehousing methodologies and processes Deep knowledge of the MicroStrategy suite of applications (version 9.x) from both a development and administration perspective Knowledge of databases (Teredata, Oracle 11g, and Microsoft SQL), SAS, and data warehouse concepts and techniques Experience in taking data extracts / flat files and building various visualization options using the MicroStrategy tool suite Experience with data model design, reporting and dashboard design, MicroStrategy security administration, MicroStrategy Intelligence Server, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Integrity Manager, MicroStrategy Health Center, MicroStrategy SAP Services and the MicroStrategy Self-Service BI tool set *Job Title: Database Administrator with Microstrategy exp* *Location: Arlington, VA * *Duration : CTH* **** Must be GC or US Citizens **** *Job Description:* Administer Oracle, Microsoft SQL Server, and MySQL database servers. Configure and maintain Oracle, Microsoft SQL Server, and MySQL database servers for high availability and disaster recovery. Perform backup and restores of Oracle, Microsoft SQL Server, and MySQL database servers Experience with SQL and database performance tuning. Session, Role, and Group Management Maintain Database Replication. *Skills/Education:* Bachelor's Degree 3+ years of experience working as a database administrator of Oracle, Microsoft SQL Server, and MySQL systems Administer Oracle, Microsoft SQL Server, and MySQL database servers Maintain Database High Availability and Disaster Recovery Administer Database Clusters Database Management and Data Maintenance Database Performance Tuning Database Security Administer Microsoft Server Operating Systems Author and Promote Process Improvement Troubleshoot , Root Cause Analysis Adhere to Information Security Policies Experience in standing up, configuring, performance tuning, and maintaining a MicroStrategy on premise environment Experience in configuring and supporting MicroStrategy end clients (hard client and web access) Experience in configuring MicroStrategy server to connect to data sources (internal and external) Experience in customer support for MicroStrategy Administrative and hands-on experience installing, configuring, and maintaining a MicroStrategy (v9) enterprise server environment Thanks & Regards *Sateesh *| Sr. Technical Recruiter *Seven Hills Software Technologies Inc.* Carnegie Office Park, Building Six 800 N. Bell Avenue, Suite # 255 ,Carnegie, PA 15106 Email: satees...@shstinc.com | Gtalk: recruiter.sateesh Office: (412) 450 1316 Ext : 104; Fax: 877-745-4811 Visit us at: www.shstinc.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
