Administration, support and tuning of Microsoft SQL Server databases in all versions up to SQL Server 2019.
Experience in migration cutovers
Experience in upgrade/migration of all deprecated SQL Server 2008 database applications to a supported version of SQL Server, Installed (SQL 2016, SQL 2017, SQL 2019) and latest version of SSMS
Should have Worked on projects involving all aspects of the SDLC: Requirement gathering, development, testing and deployment of existing .Net web.
Experience in several SSIS packages written using C# script tasks for ETL functionality and resulting SSRS reports using the data imported used by the client management team throughout refinery clients.
Perform and automat quarterly SOX compliance audit reviews
Set up database replication, database mirroring disaster recovery.
Assign SQL Server level and database level roles and permissions.
Reviewed and troubleshoot programs which included testing, correcting errors and deploying fix changes to database.
Support application programmers with query design and access techniques for updating or retrieving data from the database.