Make $25 - $35 Per Hour Doing Simple Jobs From Home.
What is your current level of experience in freelance work?
Automate sql login creation using Jenkins
This task involves updating and automating the password rotation and SQL login creation processes for SQL servers using Jenkins jobs. The steps include: - Pre-Requisite Updates: Revise the Jenkins job responsible for SQL Server password rotation by eliminating few parameter that are not needed anymore. - Ensure the job sets passwords only if the secret key for the login does not exist or if the login is disabled. - Log the enabling of previously disabled logins in SQL Server. Proposed Changes for Automating Login Creation and Rotation:Developers submit a ticket for new service login requests, which DBAs must approve. - Develop Jenkins jobs to provision two SQL logins (GREEN and BLUE) with the required permissions. - Ensure logins are created in lowercase and handle scenarios where logins already exist. - Automate the setting of passwords and generation of secret keys. - Provide the secret key names as output for developers. Password Rotation Process: Developers initiate the Jenkins job to reset the password for the currently disabled login. - Update their services to use the new login within a 7-day window. - DBEs will automatically disable the previously active login after the 7-day period.