PostgreSQL Developer
Location : Jaipur, India,
Experience : 5 Year
Rate: $15 / Hourly
Availability : Immediate
Work From : Offsite
Category : Information Technology & Services
Summary-
Over 5+ years of total experience as Database developer in analysis, design,development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server, SOA architectures.
Experience in AWS Cloud Computing Services such as EC2, S3, EBS, VPC, ELB, Route53, Cloud Watch, Security Groups, IAM, RDS.
Worked on AWS IAM and Security Groups in Public and Private Subnets in VPC.
Involved in logical/physical data modeling using ERWIN.
Experience in source systems analysis and data extraction from various platforms.
Extensive experience developing External tables and using Oracle utility tools like
SQL Loader, Import and Export on UNIX platforms.
Experience in developing and managing UNIX shells scripts and scheduling the jobs using Autosys, Control -M and monitor the batch processing.
Strong understanding of Data Warehousing (Including Star Schema, Snowflake Schema) and Extraction Transformation Loading (ETL).
Highly proficient in developing and understanding complex stored procedures and functions in PL/SQL, PL/pgSQL and T-SQL.
Expertise in building schemas, managing db objects (tables, views, materialized views, indexes, triggers, scheduler jobs), partitioning tables, Hints, SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
Implemented various Error/Exception handling methods using system and user defined exceptions.
Experience working on AWS RDS/Aurora for Oracle/PostgreSQL databases.
Proficient in Python to extract/load data from the SQL source database.
Knowledge on Core Java concepts like multithreading, Exception handling and Java collections.
Proficient in technologies like XML, HTML, CSS and JSON.
Implemented projects using various SDLC methodologies like Agile, Water Fall.
Excellent experience in documenting technical and functional design specifications.
Experience in Unit testing and Integration Testing with excellent debugging skills.
Proficient in UML methodologies in preparing use case, sequence, class and interaction diagrams.
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
