Hi, This is Harsha from IPolarity LLC. Please find the below job description and details regarding the position at NYC. Can you share the below information to proceed further with your candidature on this position,
First Name: Last Name: Current Location: Visa Status: Relocation: Rate: Availability: Email: Phone: Do attach a copy of your updated resume. Role: SQL Database Administrator Location: New York city, NY Duration: Long Term Job Description: Minimum qualifications •At least 6 years of maintaining production SQL Servers versions 2008r2 – 2014 •At least 6 years planning and designing databases. •Intimate familiarity with Entity Relationship Diagrams, the rules for database Normalization, optimizing execution plans, and tracing queries with SQL Server Profiler. This position’s job duties and responsibilities include but are not limited to: •Works with DBA’s are backed up in a way that meets the business’s Recovery Point Objectives (RPO). •Works with DBA’s backups to ensure we can meet the business’ Recovery Time Objectives (RTO). •Troubleshoot SQL Server service outages as they occur, including after-hours and weekends. •Configure SQL Server monitoring utilities to minimize false alarms. •Direct experience with clustering, log shipping, mirroring, replication and other data distribution and fail-over technologies. Deciding whether clustering, log shipping, mirroring, replication, et cetera are the right fit to solve a business problem. •Review and deploy database change scripts provided by third party vendors as well as by the internal development team. •When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. •Document the company’s database environments. •Research and overcome obstacles to upgrading older databases. •Using DMV queries to answer questions about server-level performance and index usage. •Writing new T-SQL queries. Tuning existing T-SQL queries to improve performance. •Ensure that new database code meets company standards for readability, reliability, and performance. •Identify unused or redundant database objects and work with development team to consolidate and simplify databases. •Designing tables and picking datatypes, designing indexes for existing applications, choosing when to add or remove indexes. •When users file a task/complaint about the performance of a particular query or report, help developers improve the performance of that query by tweaking it or modifying indexes. •Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, et cetera). •Using Profiler traces and other reporting tools to find the most frequently run queries. •On-call troubleshooting for SQL Server service outages. •Research changes made in new versions of SQL Server and educate the development team on new or revised best practices. •Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each. •Conduct monthly SQL Server lunch-and-learn sessions for application developers. Regards, Harsha IPolarity LLC 200 Centennial Avenue, Suite 200a, Piscataway, NJ 08854 [email protected] Ph: 732-964-9846 Ext: 302 Linkedin: http://www.linkedin.com/in/arjunsreeharsha/ -- You received this message because you are subscribed to the Google Groups "only.SAP" 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/onlysap. For more options, visit https://groups.google.com/d/optout.
