Job Description

Notice Period: Immediate or less than 30 days will be Preferred. Job Description: - 5-10 years of experience in database development or a related field. Proven experience with database design, development, and management. Experience working with large-scale databases and complex data environments. Experience with data modelling and database design. Knowledge of database performance tuning and optimization. Architect, Develop and maintain tables, views, procedures, functions and packages in Database MUST HAVE. Performing complex relational databases queries using SQL (AWS RDS for PostgreSQL) and Oracle PLSQL MUST HAVE. Familiarity with ETL processes and tools (AWS Batch, AWS Glue etc) MUST HAVE. Familiarity with CI/CD Pipelines, Jenkins Deployment, Git Repository MUST HAVE. Perform in performance tuning. Proactively monitor the database systems to ensure secure services with minimum downtime and improve maintenance of the databases to include rollouts, patching, and upgrades. Experience with Aurora's scaling and replication capabilities. MUST HAVE. Proficiency with AWS CloudWatch for monitoring database performance and setting up alerts. Experience with performance tuning and optimization in AWS environments MUST HAVE. Experience using Confluence for documentation and collaboration. Proficiency in using SmartDraw for creating database diagrams, flowcharts, and other visual representations of data models and processes. MUST HAVE. Proficiency in using libraries such as Pandas and NumPy for data manipulation, analysis, and transformation. Experience with libraries like SQL Alchemy and PyODBC for connecting to and interacting with various databases. MUST HAVE. Python programming Language & Agile/Scrum MUST HAVE. Big Data, Data mining, machine learning and natural language processing.