DB Developer

Senior DBE

Primary Skills

Python Shell Scripting, Job Scheduling and Managing Complex DB schemasTraining juniors or presenting findings to stakeholdersAbility to work cross functionally with Dev, Ops, and Product teamsJDLooking For a highly Skilled Senior DB engineer with Strong Expertise in DB programming across Multiple Platforms, Performance Optimization, DB migrations and exposure to Cloud based DB Services. The Ideal Candidate Will also have solid Experience in Python Shell Scripting, Job Scheduling and Managing Complex DB schemas.Database Development & ProgrammingDevelop 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 DBDatabase: Oracle, PostgreSQL, MySQLPerformance Tuning & OptimizationTroubleshoot 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 MigrationsPlan 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 ExposureWork with Cloud Native DB such as AWS RDS, Aurora, Azure SQL.Experience in Building ETL workflows and Data Pipelines orchestration.Scripting and AutomationBuild 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 GovernanceDesign and Manage DB schemas, relationship, Constraints and naming Conventions.Support Data Modelling and integration efforts with application.Collaboration and documentationsWork closely With Client, APP developers, data engineers, architects and DEVOPS teams.Maintain Detailed Technical Documentation & Standard Operating Procedures.