Cloud DB Engineer

P1-C3-STSSr. DB EngineerDatabase Development & Programming: Develop and Maintain Complex Stored procedures Functions Triggers Using SQL and PLSQL PostgreSQL. Familiarity With Complex data types like LOB JSON XM and array/Object Handling in DB. Database: Oracle PostgreSQL MySQL Performance Tuning & Optimization: Troubleshoot Database performance Issues Proficient in Analysing and tuning complex SQL queries and Optimize them using Indexing Statistics Partitioning and execution plan. Monitor and tune DB performance and capacity in both OLTP and OLAP environments. Database Migrations: Plan and execute end-to-end database migrations. work with tools Like AWS DMS SCT ORA2PG and custom ETL scripts to support migration. Ensure data Quality integrity and Security throughout the migration and transformation Process. Cloud Database Exposure: Work with Cloud Native DB such as AWS RDS Aurora Azure SQL. Experience in Building ETL workflows and Data Pipelines orchestration. Scripting and Automation: Build Automation Scripts using Python and Shell Scripting for monitoring Housekeeping data Loads and reporting. Develop data transformation and Loading utilities for various DB systems. Job Scheduling and Monitoring: Manage Scheduled DB jobs using tools like Cron AWS AIR Flow Control-m etc. Ensure Proper Logging Error handling and alerting Mechanism are in place for scheduled tasks. Schema Management and Governance: Design and Manage DB schemas relationship Constraints and naming Conventions. Support Data Modelling and integration efforts with application. Collaboration and documentations: Work closely With Client APP developers data engineers architects and DEVOPS teams. Maintain Detailed Technical Documentation Standard Operating Procedures. Design and implement scalable and high-availability database architectures. Develop and enforce database standards procedures and best practices. Work with software architects and developers to translate application requirements into DB schemas and data complex SQL queries stored procedures functions and triggers. Develop and maintain ETL Extract Transform Load processes. Support database versioning and migration scripts. Analyze and resolve database performance issues (e.g. slow queries deadlocks). Optimize indexing partitioning caching and query execution plans. Monitor database performance metrics and perform regular and monitor database security measures (access controls encryption). Ensure compliance with data governance and regulatory requirements (GDPR HIPAA etc.). Perform audits and risk assessments related to data backups restores and disaster recovery strategies. Automate routine tasks (backups archiving indexing). Ensure high availability and data redundancy where needed. Work closely with DevOps software engineers QA and BI teams. Mentor junior DBAs/engineers and share knowledge across the team. Participate in code reviews and database-related design and implement database tools (e.g. monitoring backup replication). Integrate databases with CI/CD pipelines and infrastructure automation tools. Support hybrid or multi-cloud database deployments if applicable.