Hi Hope you are doing great!!
USG direct client is looking for *SQL Database Architect at AZ - Scottsdale* Please share your updated resume to Yatin at yati...@usgrpinc.com OR feel free to contact me at 614 588 8481 *Note:- In person or Skype Interview on 26th or 27th of Feb* *Job Description* Mandatory Technical / Functional Skills Summary: We are seeking a SQL Database Architect to be a member of the Engineering team to build high quality user focused web applications. You will be responsible for the design and implementation of enterprise databases and the development of a best-in-class user-focused solution leveraging the latest in web development technology. You will be expected to complete your projects in the required time with minimal supervision from a senior member of the Technical team. Strong knowledge on SQL and Oracle concepts is must Qualifications and Experience: • 10+ years of experience in Information Technology • 10+ years of demonstrated experience with data architecture and relational design especially with respect to application development • Familiarity with best business practices and software development • Completed multiple database implementation projects through all phases of development • Understand complex database concepts as well as the implications of different database designs • Demonstrate proficiency with physical and logical database design • Demonstrate proficiency with data replication techniques • Write effective stored procedures • Demonstrate knowledge of client server and internet systems architectures • Demonstrate knowledge of information security, including integration with major operating system environments, Active Directory, Microsoft IIS • Must have excellent written and verbal communication skills • Highly organized, focused, flexible, motivated, detail oriented, and dedicated team player • Experience working on an Agile team • Experience developing modern web apps • Experience with standard tools of the trade such as Visual Studio, SQL Management Studio, and TFS • Experience with SQL Server T-SQL, JSON, ASP.NET, Entity Framework, HTML5, CSS3, ADFS, JavaScript • Experience developing C# web services and API’s • Experience developing complex enterprise/productivity applications • BS in Computer Science or related discipline and/or equivalent experience • Provide technical leadership in the area of Microsoft SQL Server development using T-SQL • Design and develop scalable OLTP databases • In-depth knowledge of SQL Server architecture - engine, query processing, query optimization, locking etc. • Provide hands-on design, development, and code reviews • Design and develop Schema, Indexes, SQL Queries, and Stored Procedures • Assess and improve performance of stored procedures and SQL queries • Assist the development team in writing queries and report development for OLTP systems • Work with the development team and Technical Operations in reviewing and preparing database production deployment • Install, upgrade, consolidate and maintain SQL Server 2008 R2 and SQL Server 2012 environments for Production, Development and QA • Hands-on HA and DR experience using Failover clustering, Replication and Log shipping • Build HA and DR systems using AlwaysOn Failover Clustered instances, AlwaysOn Availability Groups, Multi-site clusters and Replication across different data centers • Expert level automating tasks using scripts • Establish efficient ETL processes using SSIS • Establish and maintain a highly-efficient disk based backup and restore process • Highly knowledgeable in DAS and SAN storage systems • Expert knowledge in security and encryption • Setup and maintain database standards and best practices • Manage patch management for all database servers Responsibilities: • Design, develop, analyze, test, and debug SQL databases, T-SQL functions and store procedures • Design, develop, analyze, test, and debug middleware for complex enterprise level web applications • Convert functional specifications and design artifacts into database designs and other technical artifacts, with an emphasis on performance and extensibility • Design and implement unit, component, and system tests in coordination with QA and other developers to ensure quality Total experience in required skill (years) 6 - 8 Years Work Location AZ - Scottsdale -- 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 https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.