*Note: Position is not with our direct client.* Dear Partners:- Please find the requirement currently open. *SQL/Oracle Architect*
Scottsdale, AZ 6 Months $ 6 5/hr 9 + Years of experience . 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 Additional qualifications include: • Demonstrated experience of at least five years in operational support and development of complex database technologies in Oracle especially, Oracle DB (9i, 10g and/or 11g), Oracle RAC, Oracle DG and Oracle STREAMS • Hands-on experience as a DBA supporting multiple, large-sized Oracle database systems using technologies mentioned above • Experience in database administration for complex, large and mission-critical databases that run zero-outage production databases systems • Significant problem-solving and troubleshooting skills • Knowledge of operating system and/or hardware architecture, specifically SAN storage and clustering and demonstrated ability to incorporate this knowledge into technical review of application designs both in SQL and Oracle databases • Knowledge of RDBMS performance tuning using advanced database monitoring, analyses and tuning methodologies • Demonstrated leadership and/or communication skills in providing technical direction 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 " Please respond with Resume, Rate, Current Location and Phone numbers of the Consultant. Make sure the Consultant's skills match the requirement. I will contact you, if I need more information. *Regards,* *Palak Patel* *I sent this email through Google/Yahoo Groups. If you do not want to receive emails in future then please remove your id from that specific group.* -- You received this message because you are subscribed to the Google Groups "it req" 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/it-req. For more options, visit https://groups.google.com/d/optout.
