*Position: SQL Oracle Architect* *Location: Cumberland, RI*
*Duration: 12 Months* *Position 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 Architect concepts is must* *Required Skills: * • 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 & 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 Oracle, 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 Oracle and 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, Oracle 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 *Thanks & Regards* *Ajeet Dwivedi* ( IT Recruiter ) Phone: 609-853-0818 X 2174 Fax: 609 799 5746 Email: [email protected] Gtalk: [email protected] www.nityo.com Sent with MailTrack <https://mailtrack.io/install?source=signature&lang=en&[email protected]&idSignature=22> -- You received this message because you are subscribed to the Google Groups "R-help-archive" 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/r-help-archive. For more options, visit https://groups.google.com/d/optout.
