*Hello,*
*Greetings of the Day...!!!* *I am a recruiter with HMG America LLC.* *Kindly go through the below job description and revert me with suitable profiles at [email protected] <[email protected]>* Role: *SQL* *DBA* Location:*Palo Alto CA* Duration:*6 Months* *Job Description - Essential Duties* Primary responsibility is implementing, analyzing, improving, enterprise-level system architecture, DB designs, and working with one or more development teams to realize future DB architecture. Work with other Engineers, Managers, QA and IT/Operations teams to develop innovative DB solutions that meet market needs with respect to functionality, performance, scalability, reliability, realistic implementation schedules and adherence to development goals and principles. Lead developer for OLTP and OLAP database architecture, design, development, testing and implementation Maintenance and development of OLTP, OLAP, data warehouse databases· Creating, maintaining, and updating database schemas for all databases using a database modelling tool. Utilize novel approaches to solve complex technical problems and apply advanced technical principles, theories and concepts to develop innovative products Replication design and maintenance· Enforces database standards (MS SQL Server 2008/2012) and best practices· Design and documentation for database backup and disaster recovery procedures· Advanced level database engineering support and assistance including design/implementation of distributed DBs, DB and Table partitioning, DB performance optimization etc. Identify, investigate, and resolve database performance issues, database capacity and scalability issues and data distribution issues Reviews database design changes with the team to determine the impact to the physical database and other systems Manages and performs maintenance, backups and security for the development databases Troubleshoots Production database issues· Performs capacity planning· Monitors Production· & Development database and SQL Server performance Mentors other members of the engineering and ops team in database related technology· Responsibilities include researching, analyzing, designing, proposing, and delivering solutions that are appropriate for the business and technology strategies. Help design complex systems at the component and framework level, make strategic technology choices, and directly supervise the quality of designs and implementation of the overall platform, implementation and orchestration of components *Required Knowledge, Skills and Abilities:* 10+ years as MS SQL Server DB experience· Proficiency in Microsoft SQL Server 2008/2012 in the following areas (10+ years):· database design; SQL Server architecture SQL scripting; performance tuning; stored procedures function and trigger design and coding index implementation and maintenance; database backup and recovery SQL Server log shipping SQL Server real-time replication DB/Table partitioning and archiving DB capacity planning Expertise in n-tier application architecture, design including DB design· Significant DB experience in architecting, designing, and developing high performance, high · volume scalable, online e-commerce related server/web-based SW products and services The ability to extrapolate database schema to meet the business needs of the application· DW-based reporting system design and implementation experience including ETL tools · Strong server side architecture, design, development experience on Windows platform· Strong object-oriented programming and design interest with a pragmatic approach· 5+ years of experience using C# /.NET, java or C++· 5+ years of experience developing Web Services ( WSDL, SOAP) and REST· Strong analytical and troubleshooting skills· Enthusiasm for tackling complex problems· This is an ideal position for a team-player who is hard-working, self-motivated, pro-active and · thrives in a dynamic fast-paced environment and is ready to hit the ground running Strong communication skills, both written and verbal· Enjoy working with intelligent, talented, and hard-working colleagues, but self-motivated· BS in Computer Science or other technical field or equivalent work experience; MS preferred· -- *Gopal Reddy* *IT RecruiterHMG America LLCD: +1 732 675 5411* *E: [email protected] <[email protected]>G: [email protected] <[email protected]>W: www.hmgamerica.com <http://www.hmgamerica.com/>* -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" 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 http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
