Hello,
Please go through the below requirement and let me know on [email protected] if you have comfortable Resources or not. Role: SQL DBA Duration: About 5 months Location: NYC, NY Only Local Candidates with GC/EAD-GC/USC SCOPE OF SERVICES: · Design and create the Data Warehouse and all related extraction. · Responsible for modeling data structures and orchestrating data interfaces into (and out of) our Enterprise Data Warehouse. · Lead data modeling and database design for application development and product implementation initiatives. · Data design, quality screening and overall processing efficiency to support the needs of the business. · Participate in requirements definition, analysis and design. · Create conceptual/logical/physical models for custom application development, data exchange, integration services and reporting. · Work closely with business analysts, subject matter experts and development teams in design, development, testing, implementation, and support of application projects. · Develop, review and optimize SQL/T-SQL code. · Facilitate creation, migration and maintenance of database objects across development/QA/ production environments. · Perform data model management and version control using industry standard tools like ERwin and ER/Studio. · Follow best practices in data modeling including use of standard naming conventions, processes and templates to ensure consistency of data models. · Monitor and optimize database performance and capacity utilization to provide high availability and redundancy. · Take ownership of database performance, scalability and security. · Reverse engineer and document database architecture for business-critical legacy databases. · Define data strategies and architectures to meet compliance requirements. · Identify and plan data replication needs between internal/external data sources and heterogeneous/ legacy platforms. · Collaborate with service DBAs to optimize data structures for data integration and reporting. · Define and implement data testing strategies with business stakeholders, application development teams and QA groups. · Participate in the software testing process, including identification and resolution of defects. · Contribute to and support roll-out strategies. · Participate in and contribute to formal/informal technical reviews and presentations. · Understand other database platforms like Oracle, MySQL and IBM DB2. · Understand high level application architecture/design, network design, performance constraints and security frameworks. · Apply technical knowledge to determine solutions and solve complex problems. · Research, present and/or make recommendations on technical issues. · Explore new ideas and initiatives that encourage innovation. · Take inputs from reporting manager(s) and appropriately apply comments/feedback. · Accurately predicts time required to complete development tasks. · Demonstrate the ability to cooperate with a variety of people and achieve results. · Proactively initiate, develop, and maintain effective working relationships with team members. Mentor and guide development team members on database-related tasks. MANDATORY SKILLS/EXPERIENCE: · BA/BS Degree or equivalent, in a technology related field or other degree preferred. · 8-10 years of expertise in MS-SQL Server database administration, utilities and tools. · 6-8 years of application data modeling experience using tools like ERwin or ER/Studio. · Microsoft Certified Database Administrator or equivalent certification in database development and management. · Proficiency in supporting SQL Server 2005/2008 databases in high availability environments with intimate knowledge of both SQL and T-SQL. · Demonstrated knowledge of designing, developing and integrating databases, data warehouses and multidimensional databases in MS-SQL Server. · Working knowledge on cross-platform databases like MySQL/Oracle/DB2. · Ability to write and optimize complex SQL queries, procedures and functions. · Familiarity with BIDS (SSRS, SSAS, SSIS) and data warehousing concepts like ETL, Dimensions, Facts, Cubes. · Experience with database replication techniques. · Ability to perform both database-level and operating system performance tuning and monitoring. · Knowledge of SQL Server backup and recovery scenarios. · Proficiency in SQL Server security management. · Experience in code migration, database change management and data management through the various stages of the development life cycle. · Ability to design databases according to industry standards and make tuning recommendations. · Strong analytical, decision-making and problem solving skills. · Good communication, presentation and leadership skills. · Team player who can establish excellent working relationships with peers and other teams. · Ability to work on multiple projects as team lead or team member. · Ability to understand business requirements and estimate for delivery commitments. · Utilize application development environments, tools and methodologies across multiple platforms. · Experience using Microsoft Office Applications. DESIRABLE SKILLS/EXPERIENCE: · Technically proficient in more than one language and platform. · Familiarity with public/private cloud-based database implementations. · Familiarity with Open Source database initiatives. · Experience in replication between Mainframe systems and relational databases. · Experiences with database-level encryption technologies. · Experience with high availability features such as clustering and mirroring. · Prior experience with database server installations and configurations. · Strong object-oriented analysis, design and programming skills. · Expertise in Microsoft .NET web application development. · Experience involving all phases of the Software Development Lifecycle. · Experience with version control and release management principles. · Prior experience in federal/state/local government projects. Thanks, Shalin TCA Consulting Group Inc. [email protected] Mobile: 704-954-8008 -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
