| Need Sr SQL Server DBA Refactoring Stored Procedures - Remote -Except H1B Candidates at Remote, Remote, USA |
| Email: [email protected] |
| Greetings from Nascent Global LLC Sr SQL Database Administrator Refactoring Stored Procedures Type: Contract Location: Remote MST Time zone hours 8-5 Length: 1+ years Experience: 10 years with SQL Payrate - $70/hr C2C Except H1b Summary: Remote job but must be willing to work Mountain time zone supporting Boise, Idaho team This project is focused on Refactoring code in Stored Procedures . There are 16,000 of them to work on. They need to optimize the stored procedures. Go in take them out run through a query optimizer and put them back together. PowerBuilder experience is great. SolarWinds is what they use its easy if they dont have they will train them. The SQL Server DBA will lead the effort to tune and re-write SQL on a 30-year-old legacy system. Need to have the underlying SQL Server database reads & writes significantly tuned and re-factored. Because there was a recent add of significant workload it has caused database performance issues. Additionally, there is another big rollout for additional lines of business scheduled for March 1, 2024 and it will not be able to scale to accept this business without performance improvements Required Skills: Advanced SQL Tuning capabilities, prefer 5+ years of experience. Self-starter. Must feel comfortable working directly with lead DBA as well as application team. The reason we need this position is that we dont have time to hand-hold this person, we need them to drive this tuning effort. Experience analyzing performance reports from Solarwinds DPA is a plus Experience with tuning SQL for a Powerbuilder application would also be a BIG plus. PRINCIPAL RESPONSIBILITIES: Advanced SQL Tuning Breaking down 2000+ lines of SQL in a SQL Server stored procedure and tuning and/or re-writing Regression testing your own code to ensure any SQL re-factoring is producing the same results. Using Solarwinds DPA to identify performance issues and proactively suggest tuning opportunities. Thanks & Regards, Arshad Ali Technical Recruiter. Nascent Global LLC. Mail id : [email protected] http://nascentglobal.com/ Enabling Digital Transformation 3838 Oak Lawn Avenue Suite 1000 PMB #233 Dallas, TX 75219. https://www.linkedin.com/in/arshad-ali-68729170 -- Keywords: information technology golang Idaho Texas |
| [email protected] View all |
| Mon Nov 20 21:25:00 UTC 2023 |