Cloud DBA (Native + Non-native DBs).Immediate Start.Remote work.Working hours compatible with CST time zone. Description: Provide 3rd and 4th level cloud database support for complex issues (Oracle, SQL Server, MySQL, PostgreSQL, etc.).Participate in and manage database related projects, database security patching audits, and compliance reviews and testing.Develop new and update existing database technology related documentation as needed.Provide technical leadership for all aspects of database management such as database lifecycle management, monitoring, support, disaster recovery, compliance, and standards.Research, benchmark, and suggest improvements to database support processes, customer experience (CX) improvements, and compliance requirements.Research new cloud database versions (Oracle, SQL Server, MySQL, PostgreSQL), features, tools, and technologies with an Enterprise perspective to meet customer needs while maintaining a secure database environment.Coach and communicate information to Caterpillar's application support teams and peers across the enterprise on cloud technology changes, new features, key projects, and customer experience improvements.Participate in customer driven and Division/department projects providing Database Management consultancy services. RequirementClassificationBachelor's Degree in related fieldMandatoryExperience on managing Cloud Native Databases like AWS Aurora, AWS RDS databases (MariaDB, MySQL, PostgreSQL)Mandatory (minimum of 1 year)Expert LevelProven field support experience on PaaS databases in Azure and or AWSMandatory (minimum of 12 months)Active participation on from on-premises to cloud migration projects (example: SQL Server, Oracle, MySQL, PostgreSQL, etc.)Mandatory (minimum of 05 projects / minimum of 03 months duration)Experience on doing cross platform migrations from Oracle or MySQL or MSSQL to Community editions of MySQL / PostgreSQLMandatory (minimum of 1 year)Expert LevelKnowledge using any Script Query Language like Oracle PL/SQL, MSSQL T-SQL, MySQL Stored program languages, etc.MandatoryExpert Level SQL Cloud Database Administration skillsEssentialDatabase Lifecycle Management (DBLM)EssentialBackup management for IaaS and PaaS DBs in Azure and AWS cloudsEssentialExperience on support application teams on Database performance tuningEssentialExperience in Infrastructure-as-code to deploy Stack using AWS CloudFormationEssentialKnowledge of CI/CD pipelines to deliver Cloud resources, using tools like Azure DevOps (cloud formation), Terraform or similarEssentialYAML & JSON coding skillsEssentialScripting knowledge (shell, sed, awk, Perl, etc.)EssentialIntermediate LevelDatabase performance tuningEssentialIntermediate Level Knowledge of Vector Databases Desirable
