Database Developer - PL-SQL (5-10 yrs)

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

- Performing complex relational databases queries using SQL (AWS RDS for PostgreSQL) and Oracle PLSQL

- Familiarity with ETL processes and tools (AWS Batch, AWS Glue etc)

- Familiarity with CI/CD Pipelines, Jenkins Deployment, Git Repository

- 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.

- Proficiency with AWS CloudWatch for monitoring database performance and setting up alerts.

- Experience with performance tuning and optimization in AWS environments

- 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.

- Proficiency in using libraries such as Pandas and NumPy for data manipulation, analysis, and transformation.

- Experience with libraries like SQLAlchemy and PyODBC for connecting to and interacting with various databases.

- Python programming language

- Agile/Scrum

- Big Data, Data mining, machine learning and natural language processing