Vikram Khatri’s Post

Oracle database migration methods in azure

Hi Professionals, I Hope you are doing well. Please find the job description below, Job Title: Cloud Database Administrator Location: Fully remote Duration: Long term Need GC or EAD. Key Skills: AWS, Oracle 19c (and later versions),  EC2 ,RDS (amazon Relational Database Service ), Rubrik ,Ansible, DBA DBA: Database Administrator (DBA) should be able to handle tasks on a hybrid environment in on premise and AWS cloud which include deployment, administration and optimization of databases hosted on Amazon Web Services (AWS) infrastructure. Deploying and configuring Oracle 19c (and later versions) database systems both on EC2 as well as an RDS instance Performing routine maintenance tasks like Oracle backups, restores, and security measures to ensure the integrity and availability of data. This includes monitoring database performance, diagnosing and resolving issues, and optimizing database configurations for better performance. Debugging DB Job failures (such as archive logs, backup, failures, increasing swap space Monitoring database performance metrics and scaling database resources up or down as needed to accommodate changes in workload. Optimizing database queries, indexes, and configurations to improve performance and reduce latency. Setting up Rubrik reports and Rubrik Agents on DB EC2 servers for Infrastructure reporting. Implementing and maintaining security measures to protect databases from unauthorized access, data breaches, and other security threats. This may involve configuring AWS security groups, IAM (Identity and Access Management) policies, encryption, and compliance with industry standards. Implementing strategies for high availability and disaster recovery to ensure continuous access to data in case of system failures or disasters. This may involve setting up multi-AZ deployments, database replication, failover procedures, and automated backups. Automating DB tasks such as patching, updating variable sets, analysing metrics disk space using Ansible. Please send your resume to [email protected]

Job Title: Database Administrator (DBA) - PostgreSQL Location: Tampa, Florida Experience Required:10+years Key Responsibilities: Performance Optimization: Identify and resolve performance problems on Azure PostgreSQL Flexible Server and/or Amazon RDS PostgreSQL instances. Evaluate SQL execution plans to identify costly operations and recommend optimizations. Assess the need for indexes or query restructuring based on query plans and performance metrics. Find and address missing indexes and relationships to enhance performance. Monitor and alert on performance metrics to proactively manage database health. Database Backup and Migration: Perform database backups and restorations, including point-in-time recovery, in Azure and AWS environments. Manage and execute database migrations as required. Expertise in Cloud Databases: Expertly manage and evaluate performance metrics for Azure PostgreSQL and AWS RDS PostgreSQL. Utilize CloudWatch and Performance Insights for AWS RDS to monitor and take corrective actions. Security and Compliance: Perform periodic security checks to ensure adherence to security policies and practices. Maintain compliance with security policies and procedures. Technology Utilization: Utilize technologies including Azure PostgreSQL Flexible Server, AWS RDS PostgreSQL, TessellCloud, CyberArk Privileged Access Management, ServiceNow IT Management, Azure MySQL, Azure MS SQL databases, and Databricks. Technical Skills: Experience: 5 years of experience with Azure PostgreSQL Flexible Server and/or Amazon RDS PostgreSQL (Standard/Aurora). Performance Analysis: In-depth knowledge of identifying performance issues and evaluating SQL plans to address high-cost operations. Indexing and Query Optimization: Ability to identify the need for indexes or query restructuring and find missing indexes and relationships. Monitoring: Strong ability to monitor performance metrics and take corrective action. Backup/Migration: Expertise in database backup, restoration, and migration processes. Cloud Expertise: Proficiency with Azure PostgreSQL and AWS RDS PostgreSQL, including performance metrics and corrective actions. Security: Experience in performing security checks and maintaining database security policies. Technologies: o  Azure PostgreSQL Flexible Server o  Amazon RDS PostgreSQL (Standard/Aurora) o  TessellCloud software o  CyberArk Privileged Access Management software o  ServiceNow IT Management software o  Azure MySQL o  Azure MS SQL databases o  Databricks

With over 15 years of hands-on experience as a Database Administrator (DBA), I specialize in delivering high-performance, reliable, and secure database solutions for businesses of all sizes. My expertise spans a wide range of database technologies, including MySQL, MariaDB, PostgreSQL, and NoSQL databases like MongoDB, ensuring seamless operations across diverse environments. Experience in Cloud Technologies like AWS, Azure and GCP. What I Offer: Database Design & Architecture: Creating robust database structures tailored to meet your business needs while ensuring scalability and performance. Performance Tuning & Optimization: Analyzing and optimizing your database systems to boost performance, reduce query times, and enhance overall efficiency. Database Migration & Upgrades: Smooth transitions for database migrations, whether upgrading versions or shifting to cloud-based solutions. Backup, Recovery & Disaster Recovery Plans: Implementing reliable backup strategies and disaster recovery solutions to protect your data at all costs. Security & Compliance: Ensuring that your database systems are fully secure, compliant with regulations, and protected from unauthorized access or data breaches. Database Monitoring & Troubleshooting: Proactively identifying and resolving database issues, ensuring high availability and minimizing downtime. Throughout my career, I’ve worked with businesses in diverse sectors, from finance and e-commerce to healthcare and education, delivering customized solutions that align with their unique challenges and goals. My commitment to quality and reliability means I bring not just technical expertise, but a focus on customer satisfaction and long-term support. If you're looking for a skilled DBA to optimize your database, ensure seamless migrations, or troubleshoot complex issues, I'm here to help. Let's collaborate to elevate your database infrastructure and empower your business with data-driven insights. Contact - [email protected] #databases #MySQL #postgres #mongo #optimization #RDS #AWS #CloudSQL #Azure

Urgent Backfill and Replacement with State of Texas : Direct Client C2C Role : Please share Resume to [email protected] : 512 952 3252  Senior Cloud DB architect and Principal Database Administrator // Senior Cloud Database Architect Location: Austin Texas  Client: State of Texas  Exp: Minimum 17+ Years Must  Position Will be Remote in Texas #DataModeling #DataIntegration #DataWarehousing #DataGovernance #DataSecurity #CloudMigration #DatabaseMigration #CloudNativeTechnologies #OracleDatabase #PostgreSQL #HighAvailability #DisasterRecovery #OracleRAC #Exadata #DataStorage #DatabasePerformanceTuning #Sharding #DatabaseScaling #AgileDevelopment #CloudProjectManagement #RDSServices #DatabaseReplication #CloudNativeStorage #SaaS #PaaS #IaaS #SecurityManagement #IdentityManagement #CloudMonitoring #PlatformEngineering #CICD #MobileDevelopment #APIIntegration #RESTfulAPIs #DevOps #GitLab #Jenkins #Containerization #OracleDatabase #DataArchitecture #DataMigration #DatabaseAdministration #CloudMigration #AWSCloud #OracleCloud #AWSCertified #SolutionArchitect #OCI #ExaCSCloud #DataWarehousing #Exadata #OracleSupercluster #DataArchiving #DataMasking #HighAvailability #DisasterRecovery #OracleDataguard #GoldenGate #PostgreSQL #AmazonAurora #DynamoDB #AmazonRedshift #Snowflake #BigData #Hadoop #ApacheKafka #ModernDataArchitecture #DataStreaming #AgileDevelopment #InfrastructureAsCode #Ansible #Terraform #PythonScripting #PLSQL #CloudInfrastructure

Job Title: Database Administrator (DBA) - PostgreSQL Location: Tampa, Florida Experience Required:10+years Key Responsibilities: Performance Optimization: Identify and resolve performance problems on Azure PostgreSQL Flexible Server and/or Amazon RDS PostgreSQL instances. Evaluate SQL execution plans to identify costly operations and recommend optimizations. Assess the need for indexes or query restructuring based on query plans and performance metrics. Find and address missing indexes and relationships to enhance performance. Monitor and alert on performance metrics to proactively manage database health. Database Backup and Migration: Perform database backups and restorations, including point-in-time recovery, in Azure and AWS environments. Manage and execute database migrations as required. Expertise in Cloud Databases: Expertly manage and evaluate performance metrics for Azure PostgreSQL and AWS RDS PostgreSQL. Utilize CloudWatch and Performance Insights for AWS RDS to monitor and take corrective actions. Security and Compliance: Perform periodic security checks to ensure adherence to security policies and practices. Maintain compliance with security policies and procedures. Technology Utilization: Utilize technologies including Azure PostgreSQL Flexible Server, AWS RDS PostgreSQL, TessellCloud, CyberArk Privileged Access Management, ServiceNow IT Management, Azure MySQL, Azure MS SQL databases, and Databricks. Technical Skills: Experience: 5 years of experience with Azure PostgreSQL Flexible Server and/or Amazon RDS PostgreSQL (Standard/Aurora). Performance Analysis: In-depth knowledge of identifying performance issues and evaluating SQL plans to address high-cost operations. Indexing and Query Optimization: Ability to identify the need for indexes or query restructuring and find missing indexes and relationships. Monitoring: Strong ability to monitor performance metrics and take corrective action. Backup/Migration: Expertise in database backup, restoration, and migration processes. Cloud Expertise: Proficiency with Azure PostgreSQL and AWS RDS PostgreSQL, including performance metrics and corrective actions. Security: Experience in performing security checks and maintaining database security policies.   Technologies: Azure PostgreSQL Flexible Server Amazon RDS PostgreSQL (Standard/Aurora) TessellCloud software CyberArk Privileged Access Management software ServiceNow IT Management software Azure MySQL Azure MS SQL databases Databricks Thanks & Regards Sounika G [email protected]

Hi All, Greetings of the day We are Hiring for "Cloud Database Administrator" role - Remote Please check the below job details and share your resume at: [email protected] Job Title: Cloud Database Administrator Location: Fully remote Duration: Long term Key Skills: AWS, Oracle 19c (and later versions), EC2 ,RDS (amazon Relational Database Service ), Rubrik ,Ansible, DBA DBA: Database Administrator (DBA) should be able to handle tasks on a hybrid environment in on premise and AWS cloud which include deployment, administration and optimization of databases hosted on Amazon Web Services (AWS) infrastructure. Deploying and configuring Oracle 19c (and later versions) database systems both on EC2 as well as an RDS instance Performing routine maintenance tasks like Oracle backups, restores, and security measures to ensure the integrity and availability of data. This includes monitoring database performance, diagnosing and resolving issues, and optimizing database configurations for better performance. Debugging DB Job failures (such as archive logs, backup, failures, increasing swap space Monitoring database performance metrics and scaling database resources up or down as needed to accommodate changes in workload. Optimizing database queries, indexes, and configurations to improve performance and reduce latency. Setting up Rubrik reports and Rubrik Agents on DB EC2 servers for Infrastructure reporting. Implementing and maintaining security measures to protect databases from unauthorized access, data breaches, and other security threats. This may involve configuring AWS security groups, IAM (Identity and Access Management) policies, encryption, and compliance with industry standards. Implementing strategies for high availability and disaster recovery to ensure continuous access to data in case of system failures or disasters. This may involve setting up multi-AZ deployments, database replication, failover procedures, and automated backups. Automating DB tasks such as patching, updating variable sets, analysing metrics disk space using Ansible.

Good morning, professionals. Please ensure you fully understand the requirements before sending your resumes to [email protected]. AWS RDS ORACLE DBA Brooklyn, NY Contract: 12 months Minimum- 12+ years exp Local candidates only Database management: Knowledge of database management systems (DBMS), AWS RDS, cloud database services, and architecture  AWS Services Proficiency: Amazon RDS (Relational Database Service): Knowledge of managing relational databases like MySQL, PostgreSQL, Oracle, SQL Server, and MariaDB in the AWS cloud.  Amazon Redshift: Understanding of data warehousing solutions and how to manage large-scale data analysis with Redshift.  Migration: Experience in migrating data to and from AWS, using tools like AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT). Monitoring and Troubleshooting: Proficiency in monitoring database health and performance using AWS CloudWatch, AWS CloudTrail, and other monitoring tools.Skills in troubleshooting and resolving database issues in a cloud performance.  Data preparation and migration: Understanding data-migration methods, such as snapshots, database restores, and data-replication options  Scripting and Automation: Familiarity with scripting languages like SQL, Python, Bash, or PowerShell for automation of database tasks.Knowledge of AWS CLI (Command Line Interface) and SDKs for managing AWS services programmatically. Infrastructure as Code: Experience with tools like AWS CloudFormation or Terraform to manage infrastructure as code. Cloud Computing Concepts: Understanding of cloud-specific concepts such as scalability, elasticity, on-demand provisioning, and cost optimization. Cost Management: Understanding of how to optimize and manage costs related to database usage on AWS. Patching and Upgrades: Keeping the RDS database up to date with the latest patches and updates is crucial for security and performance.  Change Management knowledge SNOW: Initiative to address challenges and improve processes Data security and encryption  Performance tuning and optimization  Backup and recovery techniques DevOps and CI/CD Practices: Knowledge of DevOps practices and tools, particularly as they relate to database continuous integration and deployment (CI/CD).  Soft Skills: Problem-solving skills, effective communication, and the ability to work collaboratively within a team  

Validate database object consistency after migrating from IBM Db2 z/OS to Amazon RDS for Db2 by Feng Cai via AWS Database Blog ([Global] oracle cloud) URL: https://ift.tt/BhEoOHL Amazon Relational Database Service (Amazon RDS) for Db2 manages time-consuming database administration tasks, such as provisioning, patching, backups, recovery, failure detection, and repair, allowing enterprises to focus on their business and the applications that support it. This offers an opportunity for customers running IBM Db2 for z/OS databases to migrate to RDS for Db2 as part of their mainframe modernization journey. By migrating mainframe workloads into RDS for Db2, you can experience the benefits of a fully managed, highly available, secure, and compliant service. In this post, we delve into the best practices for migrating database objects from IBM Db2 z/OS to RDS for Db2 and walk you through how to validate these migrated database objects. It’s crucial to thoroughly validate the consistency of database objects, including schema structure, constraints, and dependencies. Tools for database object migration: The following are some of the tools available to migrate an application’s database objects. These tools facilitate the generation of the data definition language (DDL) for the Db2 z/OS tables. You can use DDL commands to create the objects in RDS for Db2. Db2 z/OS tools such as BMC Catalog Manager, RC/Migrator, Db2 Administration Tool for z/OS. Third party tools such as Erwin, Toad for Db2, Dbeaver . IBM native tools such as IBM Data Studio, db2Look. Although most DDLs are compatible, you might need to modify certain environment-specific keywords depending on the tools you use. For example, not all tools generate the keywords in italics in the following code snippet: CREATE TABLE ABC() IN "DBNAME"."TSNAME" CCSID EBCDIC Note: For the preceding tools to remotely connect to the Db2 z/OS instance, a separate Db2 connect license might be required. When Db2 connect isn’t an option, the Db2 Community Edition is a free option to consider. Database object validation As a best practice, validate the database objects after migrating them from the source Db2 for z/OS to the target RDS for Db2. Confirming the successful migration of the objects is a necessary prerequisite for data migration. In the subsequent sections, we outline the steps involved in comparing and validating database objects across the source and target databases. The objective is to make sure that both the count and characteristics of objects, such as tables, views, stored procedures, and functions, are consistent between the two environments. In this post, we provide steps to validate the following objects: Schemas Tables Views Materialized query tables (MQT) Primary keys Foreign keys Unique indexes Nonunique indexes Triggers Stored procedures Functions Sequences Note: Amazon RDS for Db2 doesn’t provide native support for COBOL stored procedures. As a r...