*Hi,* *Hope you are doing good,*
*Please find the below requirement.* *Position: Sr .SQL Server Developer* *Location: Baltimore City, MD* *Duration:6 Months plus* Serves as a consultative resource to business units and supports the vision of Executive Leadership by delivering timely BI solutions and explaining technical alternatives in an understandable language to meet business needs. Defines the technical services needed by the applications that are unique to the client. This is accomplished by understanding technology innovations and enterprise services that impact application vision and strategy, balancing a detailed business understanding of department applications against drivers that will influence their technological direction over time. • Contributes to the successful design, modeling, development, enhancement, testing and maintenance activities associated with complex business solutions. • Assists with definition of the application framework design and standardization for transactional operations. Leveraging Master Data Management (MDM), Employer Group and Provider Systems of Record (SoR), Electronic Claims Routing, using and extending the services of the technical architecture appropriately. Contributes to the ongoing evolution of the Business Intelligence Center of Excellence by applying standards, and assisting in the creation of methodologies and appropriate documentation. • Advances the team's understanding of industry and CareFirst best practices. • Contributes to resource planning for technical delivery within a matrix reporting structure. • Performs technology and product assessments and provides third party software recommendations to address business problems; provides detailed evaluations, identifies components and services that are core to the department and proactively works with technical peers to maintain functionality, optimize reuse and reduce total cost of ownership. *Software Design, Development & Support* • Designs and defines core reusable assets that support the long-term business strategy for development efforts. • Conduct design and solution reviews to ensure adherence to performance guidelines & business requirements. • Look for standardization and reuse opportunities, abstractions and patterns across classes and components to streamline design and development of BI solutions. • Partners with CareFirst technical teams to identify drive the organization's infrastructure, hardware, systems software and protocols, act as a consultative resource for strategy, system design, development and/or modifications of software/procedures to solve complex business solutions across multiple heterogeneous platforms. Support technical leads in ensuring that the solution design, solution review and technical architecture design meet the technical objectives, business requirements, and standards. • While partnering with the performance team, peers and/or leads, ensure that applications are designed for optimum performance and provide suggestions for ways to restructure designs to achieve optimal performance. • Design, develop, test and implement maintainable program logic for existing and new application in accordance with the technical specifications. • Creates less complex documentation for business and technical use that is shared with a broad internal and external audience. May also conduct formal and informal presentations. *Software Integration and Support* • Partners with CareFirst business and technical teams in performing software development and enterprise integration for interoperability design and problem resolution related to business applications and/or related middleware components. Also collaborates with Senior staff in the development of integration strategies providing both strategic and tactical planning. • Performs critical problem resolution, working on alternative techniques and providing guidance related to primary areas of responsibility and emerging technologies when needed. • Partners with CareFirst technical teams to identify and drive optimization changes in the application design and production environment to improve customer experience for mission/business critical IT applications. • Leverages various BI technologies to deliver critical data in an integrated repository to be consumed by multiple downstream solutions. • Serves as an escalation point and respond to inquiries at all levels of management or other staff for critical problem resolution, recommending alternative techniques and providing training and guidance. • Assists in the determination of operational feasibility of proposed designs/solutions by evaluating various SDLC artifacts, considering business policies/procedures and overall technical and functional environment Demonstrated expertise in numerous technologies with skills ranging with one or more of the following: logical and physical applications design; technical documentation; full-cycle system development, SQL Development (T-SQL), 4+ Years’ Experience with SSIS, Data Warehousing, ETL, C#, .NET. • Strong SQL and Data Analysis skills, attention to detail are required for this role. Additionally, the ability to obtain and retain business knowledge needed for future contributions. *Minimum 4 year’s experience in the following technologies:* • (MS SQL Server 2008 R2/2012 Relational Database Development • ETL processes • BA/BS in Computer Science, Information Systems, or other related IT field or a certification from technical school • 5-8 years of experience with database management systems, ETL systems, business intelligence tools, and systems. • Ability to work in a team environment • Excellent oral and written communication skills LDAP knowledge. • Understanding and leveraging the Business Intelligence Stack of SQL 2012 (SSAS, SSIS, SSRS) • Demonstrated analytical skills and attention to detail • Knowledge of Profiling and Monitoring tools, Network monitoring/Server Administration • Knowledge in (EMC SAN based systems, HP Rack Systems, Security Policies) • Knowledge of performance concepts such as response time, throughput, system resource utilization • Demonstrated experience in Data Warehouse development concepts (Data Modeling, Database Administration, Performance Tuning) • Solid understanding of data retrieval, transformation, and data warehousing architectural approaches • Experience in IT operations – application, infrastructure, network, data center • Development experience in the following: .NET Development Language (VB.NET or C#); .NET Framework (1.1, 2.0, or 3.0); SQL Development (PL/SQL or T-SQL); • Understanding of BI Microsoft architecture practices. *Thanks & Regards,* Venu Boddupally *Active **Soft **Inc.* *|| *Accelerate Your Success || Phone: 404-496-4368 * 113 v...@activesoftinc.com www.activesoftinc.com <http://www.google.com/url?q=http%3A%2F%2Fwww.activesoftinc.com%2F&sa=D&sntz=1&usg=AFQjCNHcG41H--kjGyUwgLo_c8WgNoev2A> -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.