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