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 "Open Source Erp & Crm" 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/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
