| Sr SQL Server Functional & Application DBA|| Madison, NY-ONSITE at Madison, Minnesota, USA |
| Email: [email protected] |
| From: charu sharma, tek inspirations [email protected] Reply to: [email protected] Title: Sr SQL Server Functional & Application DBA V2014 - 2022 Work Location: ONSITE 26th Street and Madison Ave Interview: Will do phone/video interviews for the right candidate. The JOB: Seeking consultants that will participate on a Global' DBA team. The team will ensure that the new database code meets company standards for readability, reliability, and performance. 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. Design indexes for existing applications, choosing when to add or remove indexes. When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes. Conduct SQL Server lunch-and-learn sessions for application developers. Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc). Consultant must have experience: Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions. Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries. Using free tools like sp_ BlitzIndex and DMV queries to answer questions about index usage. On-call troubleshooting for SQL Server service outages. Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem. Skills Need: Must have 8+ years of experience working for US companies in the US. Must have 4 + years of Recent Banking experience (Since 2017). Minimum 10 years of IT exp Must have recent experience performing Level 3 support (The highest-level Support). These positions are for a Global unit. Consultants must have experience (Constantly and On Average) working with DB sizes of 30TB or more (Not Less). Experience working with large-scale enterprise application setup across Data centers. Must have a Minimum of 10+ years conducting general database administration tasks (e.g. DB implementation, DB code deployments, DB backups, creation of DB user accounts). Minimum of 7+ years experience working as a SQL Server DBA. Must have experience as an Functional & Application DBA. Must have at least 5 years administering database platform specific advanced features (e.g. clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server database servers and SQL code. Minimum of 5+ years experience working in a SQL DBA Role with multiple databases and SQL development issues. Proficient in MS SQL Server 2014 - 2019. SSIS Package creation and debugging skills. Stored procedure development and tuning. Data replication exposure. Warm Regards.. Charu Sharma IT Technical Recruiter TEK Inspirations LLC | 13573 Tabasco Cat Trail, Frisco, TX 75035 Email: [email protected] Disclaimer : If you are not interested in receiving our e-mails then please reply with a " REMOVE " in the subject line to [email protected] . And mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience Keywords: database information technology golang microsoft Texas |
| [email protected] View all |
| Thu Feb 01 02:21:00 UTC 2024 |