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.
TECHNICAL SKILLS
Databases: PostgreSQL 11.5, 10.12,9.5, Oracle 12c, 11g, 10g, 9i, SQL Server 2014,2012,2005,2004
Database Tools: pgAdmin, DBeaver, TOAD, SQL Developer, SQL PLUS, SQL Loader
SoftwareMS Visio, MS Office, Denodo, Eclipse, JIRA, WinSCP, Super PuTTY, AWS Conversion Tool.
Scripting: HTML, CSS, XML, UNIX Shell Scripting, DTD
Operating System: Windows: Win7/10/XP/98/95/NT/ Server 2008/2003, UNIX, LINUX
Programming Languages: PL/SQL and SQL, PostgreSQL and pl/pgsql, T-SQL, Java, Python 3.6/2.8, SQL Alchemy
Version Control Tools: TFS (2013), CVS, Clear Quest, Clear Case, Subversion (SVN), Perforce, GIT
Cloud Platforms: Amazon Web Services (AWS), Oracle Cloud Infrastructure (OCI)
PROFESSIONAL EXPERIENCE
Confidential (2020- present)
Senior Postgres Architect/Developer
Responsibilities:
- Created Postgres Tables, Views, Procedures, Functions, Triggers based on the requirements.
- Manual conversion of numerous Oracle objects to PostgreSQL objects.
- Developed, debugged and optimized PostgreSQL queries for reporting and app development.
- Worked on multiple joins like Cross join, Left Outer Join, Right Outer Join, Inner Join between two or more tables.
- Created, inserted and extracted Json data from columns in Postgres databases.
- Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto- scaling, load balancers (ELBs) in the defined virtual private connection.
- Troubleshooted the performance related Issues on Postgres Instance using Performance Insight and Query plan Management (QPM).
- Created pl/pgsql functions to return tables, set of refcursors and texts to Java application.
- Created Row security policies on Tables to ensure data security while inserting, deleting and selecting using data modification commands.
- Created Users, User Attributes, Privileges, Groups, Roles, Schemas and worked on setting search paths to Schemas.
- Inserted data into multiple tables using COPY.
- Created, inserted and extracted
WEB SPHERE Developer
Location : DELHI, India
Experience : 5 Year
Rate: $21 / Hourly
Availability : Immediate
Work From : Offsite
Category : Information Technology & Services
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
