Home

Dada peer - Azure SQL Administr

[email protected]

Location: Sacramento, California, USA

Relocation: yes

Visa: H1B

Dada peer Mulla Azure SQL Administr ------------------------------------------------------------------------------------------------------------------------------ CAREER SUMMARY 10 years of total IT Experience as SQL Server DBA and Azure SQL Admin in production environment and Clinical SAS Programmer MSSQL Server DBA Primarily working with SQL Server 2017, 2016,2014,2012,2008 R2versions. Having hands on Experience in administering SQL Server activities like Installation, Patching and Up gradation and Migration, Backup and Recovery and Replication and Log shipping and DB Mirroring and Performance tuning and Cluster activities. Work experience of 24x7 Production support for SQL Server 2008R2 ,2012,2014,2016,2017 Experience in Installation and Configuration in different versions like SQL Server 2008R2 , 2012 2014, 2016 and 2017. Manage SQL Server databases and Capable of troubleshooting common database issues like Disk space issues and db growth preferences and moving dbs. Verifying and resolving the SQL Server Blocking issues and Finding the root cause and implementing the permanent fix. Experience in applying the Service packs and Cummilativepacks for servers. Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. Good experience with implementing High Availability of database servers using Log Shipping and Database Mirroring and Always On and Clustering Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users. Have worked with service Now ticketing tool(SNOW) where all the project related Incidents gets logged AZURE - MSSQL Server Administration Provisioned and Configured SQL Server on Azure IAAS and PAAS Model,Azure MI Configured and Troubleshoot High Availability and DR such as Geo-Replication and Availability groups for Azure SQL database. Performed Database Backup and restored based on scenarios on Azure. Secured Azure SQL database: Firewalls, Authorization, Authentication. Explored Advanced Security features and Auditing . Created Azure SQL database alerts Creation, deletion and managing permissions on User accounts on Azure SQL database. Configured and scheduled an Index maintenance Plan on Elastic Database Agent Job For Production databases Scaled Vcores based on the requirement on Azure SQL database. Configured email notifications on Azure SQL Databas Responsible for performing regular checks on all Servers by checking Azure alerts and take decision on Scale Up/ scale down. Responsible for maintaining Master Server inventory with all the resources. Automated manual tasks using Powershell scripts. PROJECT DETAILS Project #3: Project Name: Bayer Role Azure sql Admin Organization Cognizant technology solutions Duration Nov 2021 to Till Date Key Technology Microsoft Azure, SQL Azure, SQLServer 2012/16,SSIS,SSAS Key Responsibilities : Managing around 300 servers (Virtual) which includes Windows 2012/2016/2019 servers. Worked on configuring CDC in sql server in PROD Good experience in creating Windows Virtual machines in Azure Environment. Managing all SQL Servers and SQL databases on servers. Creating and managing Azure Storage and Backup. Configuring Azure alerts for CPU, Memory and disk usage using Log Analytics Workspaces. Configuring Auto-Patching for servers using automation accounts in Azure. Add/Remove Resources to VM's (Disk, CPU, RAM) via Azure portal. Project #2: Project Name: Merck Role DBA Organization HCL TECHNOLOGIES Duration Oct 2017 to Nov 2021 Key Technology Microsoft Azure, SQL Azure, SQLServer 2012/16 Tools Power BI, SNOW Key Responsibilities : Providing 24/7 On-Call support for critical production databases. Installation, Configuration and Administration of SQL Server . Working on Standard Database Maintenance tasks, Backups and Recovery Plans. Database Refreshes from Production to Stage and Development environments as per the requirement. Handling creation of new SQL Server databases as per client/application team request using build Sheet template. Scheduled and maintain routine Jobs, Alerts and Maintenance Plans. Ensuring the high availability of the databases to the end users. Constantly checking functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity and considering the resolution of the issues as most primitive tasks. Carrying out Installations and up-gradations of SQL server Database engine Reviewing SQL Server and SQL Server Agent Error Logs. Executing scripts in prod environment. Knowledge on Administrating log shipping and other high availability methodologies. Applying SQL Server patches and Service Packs during the maintenance window. Raising change requests for any production change to be made and other defined requests for their respective purpose. Project #1 Project Name: Abbvie Role Associate Executive Organization ARAVINA INFOMEDIA PRIVATE LIMITED. Duration Sep-2013 to Sep-2017 Key Technology SAS/Base, SAS Macros, SAS/SQL, SAS ODS, SAS Enterprise Guide Key Responsibilities : Writing SAS programs, SAS procedures or standardized macros to perform data checks as needed to understand the structure and content of data. Understanding Project related study documents like Annotated CRF, Protocol and SAP Created SDTM and ADAM datasets as per CDISC standards. Comparing old aCRF with the new aCRF and reporting the changes. Good level of understanding about Define.xml and P21 process. Developed SAS programs for generating Tables, Listings as specified. Developing the Tables and Listings according to the Protocol and SAP Documents. Perform any other related activities assigned by the Team Lead. Effectively communicated with Clients for better understanding of the requirement and achieving timelines with quality. Attend both client and team meetings when needed. Maintain documentation regarding project progress and programming updates and all other documentation as required on a regular basis. EMPLOYMENT SUMMARY Working as Azure SQL DBA in Cognizant technology solutions from Nov 2021 to till date Worked as a Sr SQL Server DBA in HCL technologies Chennai from Oct 2017 to Nov 2021. Previously worked as DBA in Aravina Infomedia Private Limited, Hyderabad from Sep 2013 to Sep2017 Education Details Completed BSC(Computers) from Sri Krishnadevaraya University, Anantapur in year 2011. TECHNICAL SKILL Windows : Windows Server 2008 R2,20122014,2016. RDBMS : MS SQL Server 2008 R2 and 2012,2014,2016. Tools : Profiler, SCOM Language : T-SQL,Powershell Keywords: business intelligence database information technology microsoft Michigan