Cloud DB Engineer

P1-C3-STS

Sr. DB Engineer

Database 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 models.
Write 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 tuning.
Implement 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 security.
Oversee 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 discussions.
Evaluate 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.