Rohit Dogra

Looking for Devops Azure Engineers. Experience    – 6 to 9 Years Location          - PAN India Notice period - 30 days or less. If you interested share resume [email protected] Must have skills – Kubernetes AKS & Azure Devops Azure cloud Scripting (PowerShell or Python) Azure DevOps Pipelines & GitHub Actions Ansible Tower & Terraform #AzureDevops #KubernetesAKS #Azurecloud #PowerShellScripting #PythonScripting #Pipelines #GitHub #Terraform #AnsibleTower

5

Looking for Oracle dba candidates cation:: Mumbai (Bombay) Oracle DBA – 1+ Yrs. Required Candidates : who has DBA Admin L2 and above Skills for the below. Shits : 24/7 Gender : *Only Males Candidates* 1. Database Installation and Configuration>> Deploy and set up Oracle databases in accordance with industry best practices, ensuring optimal performance and security. 2. Performance Tuning>> Monitor and optimize database performance, addressing bottlenecks, query optimization, and resource utilization to enhance overall system efficiency. 3. Security Management>> Implement and maintain robust security measures, including user access controls, encryption, and auditing, to safeguard sensitive financial data in compliance with industry regulations. 4. Backup and Recovery>> Develop and execute comprehensive backup and recovery strategies to ensure data integrity and minimize downtime in case of system failures or disasters. 5. Patch Management>> Stay current with Oracle database releases and security patches, applying updates promptly to mitigate vulnerabilities and maintain a secure database environment. 6. Database Design and Modeling>> Collaborate with application developers and architects to design and model databases that meet the bank's requirements for data integrity, scalability, and performance. 7. High Availability Solutions>> Implement and manage high availability solutions such as Oracle Real Application Clusters (RAC) and Data Guard to ensure continuous access to critical banking systems. 8. Capacity Planning>> Analyze and forecast database growth patterns, recommending, and implementing scalable solutions to accommodate the increasing data volumes associated with banking operations. 9. Database Monitoring>> Utilize monitoring tools to track database performance metrics, proactively identify issues, and respond promptly to incidents to minimize impact on banking services. 10. Documentation>> Maintain thorough documentation of database configurations, processes, and procedures, ensuring a comprehensive knowledge base for troubleshooting and future reference. 11. Collaboration and Communication>> Work closely with cross-functional teams, including system administrators, developers, and business analysts, to address database-related requirements and issues effectively. 12. Compliance and Auditing>> Ensure databases adhere to regulatory requirements and industry standards, actively participating in audits and implementing corrective actions as necessary to maintain compliance in the banking domain. Interested share cvs to [email protected]

4

Quiz Time # 425 | 29-July-2024 | MS SQL DBA   Partitioning is fully supported on ______              1.          Azure Sql Database              2.          Sql server 2019              3.          Sql server 2022              4.          Sql server 2016 comment your answer Follow me and #dbaasservice for more update DBA as a Service: DBA as a Service (DBaaS) is a modern approach to database management where your organization can leverage 1. Dedicated expertise without the need for an in-house DBA. 2. Expand DBA support without increasing headcounts 3. Eliminate DBA recruiting and training cost. #sqldba #quiz #australia #sqlserver #sql #database #azure #microsoft #tips #careergoals 

1

Title: Azure Cloud Architect Location: On-site (Austin, TX) Exp: 12+ Duration: 12 Months Job Description: Client requires the services of [1] Cloud Solutions Architect 2 hereafter referred to as Worker, who meets the general qualification of Cloud Solutions Architect 2 and the specifications outlined in this document. The workers responsibilities and skills must include: Creates a well-informed Microsoft Azure cloud strategy and manage the adaption process. Determines Azure cloud requirements by analyzing business operations, applications, and security; reviewing business objectives; and evaluating current systems. Obtains Azure cloud design requirements, develops and implements cloud designs for new projects, and maintains existing cloud designs and architectures. Develops Azure cloud infrastructure projects and initiatives. Implements corresponding Azure cloud architecture changes to support new and modified systems and ensures that new designs conform to standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update. Provides guidelines on creating Azure cloud infrastructure. Reviews changes, realizing their impacts on enterprise cloud architecture, and ensures that the impacts are communicated to appropriate parties. Establishes measures to chart progress related to the completeness and quality of Azure cloud architecture for enterprise usage; and to improve cloud performance. Communicate and collaborate in a professional and timely manner. Performs related work as assigned. 4-7 years of Developing Microsoft Azure infrastructure 4-7 years of Implementing cloud architecture 4-7 years of Creating Microsoft Azure cloud strategies   Preferred (Optional): 3 years of Overseeing and working with vendors 3 years of Project work 3 years of Familiarity with ServiceNow / Ticketing System 3 years of Ability to follow complex workflow Process

1

Hi, Looking for IAM resources on below mentioned tools. Role : Permanent with Hybrid Notice : 15 days- 1 mon  1.#Ping Identity Developer (5-8 Years):  JD:Advanced knowledge of LDAP and LDAP based directories.   Minimum 5 years of hands-experience with Ping Directory Suite (Ping Directory, Ping Directory Proxy, and Ping Data Sync.)   Implemented any migration projects from Oracle Ldap/Radiant logic to Ping Directory.  Strong knowledge of Ping Directory administrative configuration.   Good understanding of Authentication and Authorization standards and patterns, most critically  the OAuth 2.0 and OIDC standards.  Ability to develop consumption tools/widgets for applications to consume data from Ping Directory using Ping Directory API. Knowledge of SSL/TLS, PKI, certificates, and certificate authorities.  Have hands-on experience on cloud provider – Azure or AWS or GCP  Experience in scripting language - python, PowerShell and bash  Knowledge of other Ping products – Ping Federate, Ping Access. Okta Access Management Developer (5-8 Years)   Skills and attributes for success Hands-on experience on end-to-end implementation of various IAM tool, with expertise in Okta. Completed at least 2-6 implementations. Good understanding of Access Management and CIAM solutions. Strong Understanding of Okta API’s and good understanding of XML, HTML, CSS. Should be capable of dissecting large problems and designing modular, scalable solutions. Validated experience of onboarding applications on leading IAM platforms like Okta, PINGFED. Knowledge on FIDO, OAuth, Open ID connect and REST Concepts. Hands-on experience in setting up the Identity and Access Management environment in standalone and cluster environment. Hands-on experience on configuring the tool as per the requirements. Hands-on experience on Directory level integration with Okta for AD, LDAP, Azure AD, Oracle AD. Good Understanding on IWA and Okta Workflows. Hands-on experience on Okta APIs. Should be knowledge on Okta Access Gateway, Okta Advance Server Access and SCIM. Hands-on experience on developing custom UI pages, branding and email template as per business needs. Should be familiar with the RBAC, ABAC, User provisioning, data synchronization, password management and IAM governance with AM tools such as Okta. Strong understanding of access management fundamentals like SSO, authentication and authorization. Good hands-on experience on OAuth 2.0, OIDC, WS-Fed protocols. Define and set up approach for risk-based MFA and applications access control. Hands-on experience on security related assessments and configuration for AM platforms, adaptive risk configurations and Multi-factor authentications. Capability of understanding the business requirements and converting that involving configuration, implementation & customization. Hands-on Java/Python development and debugging experience Interested resources can inbox resume on [email protected]

9

"Immediate Requirement" Please share resume with [email protected] Job Title: SCCM Imaging Location:Portland, OR Duration: 06+Months Need 10+Years Experience Job Description: Primary Skills : SCCM Infra , OSD, Application Package, Patching and Intune #C2C #C2CRequirement #C2Chiring #Hiring #newrequirement #SCCM #Imaging #SCCMInfra #patching

4

2 Comments

Finally, I have created a highly reusable CI-CD approach for API Proxy deployment in Azure API Management using #AzureBicep & #AzureDevOpsPipelines. This has been long pending. While I've always appreciated the declarative approach of #AzureARMTemplates, I find #AzureBicep much simpler and more efficient. #azureBicep is a blend of goodness of Terraform like features with native ARM support. In my journey, I explored various alternatives like #APIOps, but I believe its better suited for organizations or teams heavily invested in GitOps or those starting from scratch. #ChatGPT was also helped me with handling bash for creating dynamic json which have api operation and it's related policies. Moreover, in the past too I have successfully implemented similar CI-CD automation for #BizTalk using #Powershell and #AzureDevOpsPipelines, utilizing both Classic and YAML pipelines. It's fulfilling to see the impact of streamlined processes in enhancing efficiency and productivity. #Azure #AzureAPIManagement #DevOps #Automation #CloudComputing #APIs

69

4 Comments

Some interesting interview questions from Z£n$°® 1.Basic question but important What are the requirements to build SQL servers from scratch in onprim and azure. 2.How we build HA and DR concepts in azure environment. 3.How u monitor the servers in azure Performance related issues in onprim. 4.How will dead locks happen and how do you resolve issues. 5.Do you knowledge about incident management and change management 6.Log shipping architect in azure. 7.What is the Difference between active active and active passive clusters . 8.Difference between AG and FCI. 9.As a DBA how you protect the data and Database. 10.Have you worked on P1 tickets. Thanks for your time to read the article.

22

Many times, we stumble on the given interview question (Prerequisites for RAC Patching) . It is because we focus on the procedure or steps for RAC patching, which are readily available. However, we often overlook the prerequisites for RAC patching, which are not always covered in the poa/steps found online. This is a crucial question that often comes up in interviews on the topic of RAC patching. Prerequisites for Patching: ================ 1)Ensure you have a proper directory for copying patches with the necessary permissions. 2)Verify that the OPatch version is updated as specified in the README file. 3)Confirm there is enough space available in both Grid and Oracle homes, typically 4 times the patch size. 4)Perform a full database backup. 5)Take a backup of both the Grid home and Oracle home directories.(tar backup) 6)Use the VALIDATE DATABASE command to check for corruption in the database. 7)Check for patch conflicts using the appropriate command. [Pacth folder]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ or opatch auto -analyze 8)Perform a health check on both the database and cluster. 9)Use the UTLRP utility to compile and validate invalid objects. 10)If necessary, relocate services to another node (e.g., Node 2). 11)Note down the registry components. 12)Stop any crontab and scheduler jobs if needed. Other Prerequisite are-- =Check Patch Compatibility: Confirm the patch is compatible with your current Oracle version and OS platform. =Review Patch Documentation: Thoroughly read the patch notes and documentation for any special instructions or known issues. =Test in a Staging Environment: If possible, apply the patch in a non-production environment first to identify any issues. =Communicate with Stakeholders: Notify all relevant teams and stakeholders about the planned patching, including expected downtime and any potential impact.

105

10 Comments

Some interesting questions about Azure SQL DBA and MS SQL DBA. 1.     What is the best way to migrate the On prim database to Azure cloud. 2.     Do you have experience on deploying the iaas, paas services. 3.     Have you knowledge on Azure storage options. 4.     Can we replicate the databases into azure cloud. 5.     Do you have experience on log shipping, mirroring and replication on hybrid cloud method. 6.     How can we move the 2TB database from on prim to azure cloud. 7.     Can we migrate windows and SQL logins to azure SQL VM. 8.     Cluster rebalancing. 9.     How can we move the TDE enabled database into cloud. 10.  They are asking need some experience and knowledge about azure administration. Thanks for reading the artical.

94

8 Comments

Hi All, Hot Requirements OpenShift Engineer and Wi-Fi Tester roles Please share the resumes to [email protected] 1 OpenShift Engineer Visa: GC/USC Only Location: Colorado (Hybrid) 2. Wi-Fi Tester Visa: GC/USC Only Location: Colorado (Hybrid) hashtag #c2croles hashtag #corptocorp hashtag #urgentrequirements hashtag #immediatehiring hashtag #benchsales hashtag #benchsalesrecruiters hashtag #openshiftengineer hashtag #wifitester hashtag #openshift hashtag #wifitesting hashtag #gc hashtag #usc

3

Greetings'!!! #Hiring for Oracle DBA! cation:: Mumbai (Bombay) Oracle DBA – 1+ Yrs. Required Candidates : who has DBA Admin L2 and above Skills for the below. Shits : 24/7 Gender : *Only Males Candidates* 1. Database Installation and Configuration>> Deploy and set up Oracle databases in accordance with industry best practices, ensuring optimal performance and security. 2. Performance Tuning>> Monitor and optimize database performance, addressing bottlenecks, query optimization, and resource utilization to enhance overall system efficiency. 3. Security Management>> Implement and maintain robust security measures, including user access controls, encryption, and auditing, to safeguard sensitive financial data in compliance with industry regulations. 4. Backup and Recovery>> Develop and execute comprehensive backup and recovery strategies to ensure data integrity and minimize downtime in case of system failures or disasters. 5. Patch Management>> Stay current with Oracle database releases and security patches, applying updates promptly to mitigate vulnerabilities and maintain a secure database environment. 6. Database Design and Modeling>> Collaborate with application developers and architects to design and model databases that meet the bank's requirements for data integrity, scalability, and performance. 7. High Availability Solutions>> Implement and manage high availability solutions such as Oracle Real Application Clusters (RAC) and Data Guard to ensure continuous access to critical banking systems. 8. Capacity Planning>> Analyze and forecast database growth patterns, recommending, and implementing scalable solutions to accommodate the increasing data volumes associated with banking operations. 9. Database Monitoring>> Utilize monitoring tools to track database performance metrics, proactively identify issues, and respond promptly to incidents to minimize impact on banking services. 10. Documentation>> Maintain thorough documentation of database configurations, processes, and procedures, ensuring a comprehensive knowledge base for troubleshooting and future reference. 11. Collaboration and Communication>> Work closely with cross-functional teams, including system administrators, developers, and business analysts, to address database-related requirements and issues effectively. 12. Compliance and Auditing>> Ensure databases adhere to regulatory requirements and industry standards, actively participating in audits and implementing corrective actions as necessary to maintain compliance in the banking domain. Interested share cvs to [email protected]

5

1 Comment

# Setting up a Three-Node Always On Availability Group in SQL Server ## Prerequisites: 1. Three Windows Servers with SQL Server installed (Enterprise edition required for more than two nodes) 2. All servers must be part of the same Windows domain 3. Windows Failover Clustering feature installed on all nodes 4. Proper network configuration and firewall rules ## Steps: 1. Create Windows Failover Cluster   - Use Server Manager or PowerShell to add the Failover Clustering feature   - Run Failover Cluster Manager and create a new cluster including all three nodes   - Configure quorum settings (Node Majority recommended for odd number of nodes) 2. Enable Always On feature in SQL Server   - In SQL Server Configuration Manager, enable Always On for each SQL Server instance 3. Create Availability Group   - In SQL Server Management Studio (SSMS), connect to the primary instance   - Right-click on Always On High Availability and select "New Availability Group Wizard"   - Name your Availability Group   - Select databases to include   - Specify replicas (add all three nodes)   - Choose synchronous or asynchronous commit mode for each secondary   - Configure failover mode (automatic or manual) for each secondary   - Set up listener details (optional but recommended) 4. Join Secondary Replicas   - Connect to each secondary node in SSMS   - Expand Always On High Availability > Availability Groups   - Right-click the Availability Group and select "Join Availability Group" 5. Initialize Data Synchronization   - On the primary, right-click the Availability Group and select "Show Dashboard"   - For each database, select "Join" to start initial data synchronization 6. Verify Configuration   - Check Availability Group Dashboard for synchronization status   - Test failover scenarios 7. Configure Read-Only Routing (Optional)   - Set up read-only routing to direct read-only queries to secondary replicas 8. Implement Backups   - Configure backups on primary replica   - Consider log backups on secondary replicas to reduce primary workload ## Post-Setup: - Monitor performance and adjust as necessary - Regularly test failover scenarios - Keep SQL Server and Windows updates consistent across all nodes

56

3 Comments