To be honest, I don't believe that most people actually knew or currently know what a DBA actually does.  I think the job description of DBA started out with accurate...

Now all I have to do is get the OP to confirm and/or clarify the requirements according to the questions I asked.

My recommendation is to stop doing paging the old way.  You've posted in a 2012 forum.  Learn how to use the OFFSET/FETCH methodology of the ORDER BY clause.  Please see...