Sql Developer Oracle Database

Amit Keshari

Boston, MASSACHUSETTS

603-***-**** ************@*****.***

PROFESSIONAL SUMMARY

13+ Years of IT Experience as Senior Oracle PL/SQL Developer with extensive experience in data modeling, Oracle database design, loading multiple types of files using ETL tool and writing complex PL/SQL code, Performance Tuning and Optimization.

Work with the application development team to implement data strategies, build data flows and develop conceptual data models.

Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.

Develop best practices for standard naming conventions and coding practices to ensure consistency and integrity of data.

Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.

Expert in creating complex SQL Queries, Analytical and aggregate function, Sub Queries, PL/SQL Packages, Functions, Stored procedures, Exception handling, transaction control and xml generation. Created various database objects using Oracle tools like SQL Plus, SQL Developer and Toad.

Created materialized views and views in Oracle. Use Sql loader, Informatica and Talend to load csv, xml files into database.

Monitor and recommend changes if required to all PL/ SQL packages and stored procedures.

Created star and snowflake schema for various Projects. Worked on fact and dimension tables.

Worked on indexes, partitions and tuning queries that are processing huge data. Use efficient Joins, Indexes, bulk operations, and materialized views for Query Optimization.

Using Explain Plan to analyze tables and created better approach for high performance.

Worked on Informatica Power Center Tools like designer, workflow manager, and workflow monitor and repository manager. Creating meta files in Unix for validating raw files layout and load them in tables using talend/control-m jobs.

Use of Unix shell script to invoke the Oracle procedures.

Contol-m, Cron and Autosys job for scheduling the jobs.

Use of WinSCP, File zilla for file transfer from one server to other.

Adopted agile methodologies and involve in the daily scrum meeting.

Worked extensively on SVN, Team Foundation Server and clear case for version control and merging code from development to master.

Documentation of projects for Business Requirement Spec(BRS),Functional Requirement Spec (FRS), Use case Spec, DFDs, Test Plan, Test Script & Test Cases.

SKILLS

PL/SQL

Control-m

Snowflake

Rally

Unix Shell Scripting

Oracle 10g/11g/12c

UNIX

Erwin

File Zilla

WINSCP

Jira

MS-Excel

EXPERIENCE

FEBRUARY 2023-CURRENT

Senior Database Engineer

CVS Health Providence, RI

Optimized query performance through indexing strategies, query rewriting, or other techniques as needed.

Worked on identifying unused tables and database objects and optimizing the tablespaces.

Migration of OLTP database from legacy to HA OLTP Oracle 18c database. It involves new user creation,new schemas, new tablespaces, tns wallets, export/import of data etc..

Established robust monitoring solutions to proactively detect potential issues before they escalate by creating alerts.

Participated in code reviews to maintain consistent coding standards across team.

Designed and built solutions for range of data sources.

Trained junior team members in best practices for effective database engineering.

Migrated legacy databases to modern platforms, ensuring smooth transition without data loss.

Improved database performance by identifying and resolving bottlenecks.

Streamlined existing workflows by automating repetitive tasks through scripting or tool implementation.

Initiated design development processes by analyzing user needs and software requirements against design vision.

Produced clean, error-free code to meet aggressive timelines.

APRIL 2019-FEBRUARY 2023

Senior Data Engineer

Dataquest Corp Boston, MASSACHUSETTS

Created stored procedures, functions, triggers, and views to support application development.

Created wide range of database queries, functions and actions using SQL.

Translated business use cases into data models, integration routines and analytics reporting strategies.

Ensured data integrity by implementing referential constraints, foreign keys, primary keys, unique indexes, check constraints, etc., within database schema.

Conducted thorough testing of SQL scripts to ensure accuracy and reliability.

Worked closely with project managers to deliver quality results within deadlines.

Performed regular database backups and recovery operations as needed.

Assisted in design of relational database models based on business needs.

Migrated legacy systems to modern platforms by developing conversion scripts and mapping data structures.

Provided expert guidance on SQL standards, conventions, and best practices throughout organization.

Utilized data warehousing concepts to build scalable solutions for high-volume transactional environments.

Trained junior developers in SQL best practices, improving overall team productivity.

Wrote optimized SQL queries for integration with other applications.

Improved database performance by tuning queries to retrieve information with minimal error or delay.

Optimized existing SQL code for better performance and efficiency.

Developed complex SQL queries to extract, analyze, and manipulate data from multiple databases.

Tuned software features to meet specific customer demands and hardware limitations.

MARCH 2017-MARCH 2019

Database Expert

StateStreet Quincy, Massachussets

Work as a Database expert in a development team to handle and store various types of data such as csv, xml from multiple source systems into our data warehouse and then created stored procedures and packages for various subject areas so that hundreds of downstream can plug-in those packages into their system and retrieve data by passing different parameters according to their requirements

The database design was created in such a way to mostly provide better throughput and higher availability of our database objects to our end-users.

Assisted with troubleshooting application-related issues by analyzing SQL queries and providing recommendations for improvement.

Collaborated with developers to create efficient data models and optimize SQL queries for application performance.

Coordinated with vendors during hardware upgrades or software installations, ensuring minimal disruption to services.

Wrote and coded logical and physical database descriptions and specified identifiers of database to management systems.

Coded database logic, wrote physical descriptions and specified management system identifiers.

Kept database efficient and functional by continuously testing operations, correcting errors and modifying systems.

Identified and quickly addressed database performance issues by continuously monitoring systems.

Improved computer systems regularly, supervising new database product installations and tests.

Monitored database performance metrics, identifying potential bottlenecks and tuning system accordingly.

Improved query response times through effective index management and database optimization techniques.

Conducted regular database health checks to proactively identify issues before they impact users or applications.

Implemented backup and recovery strategies, ensuring data availability in case of system failures or disasters.

MAY 2015-FEBRUARY 2017

Sr. Oracle Database Developer

Infogroup Burlington, Masachussets

Working as a Senior Oracle database developer in a project which involves collecting sales, product, store etc information and passing them through data validation, data profiling, email hygiene process, applying matching rules and then using ETL tool(talend) to load into staging and target tables after applying various transformation and then providing comparison reports and various output files to business users and stakeholder for their analysis and decisions.

NOVEMBER 2011-APRIL 2015

Oracle PL\SQL Developer

Syntel Mumbai, India

Working as an Oracle database developer in Performance Measurement and Attribution project which involves writing complex sql queries and stored procedures and packages in Oracle

I used to extract data from data warehouse, calculate daily, weekly,monthly returns for fixed income and equity portfolios and create performance attribution reports for different portfolios and department.

EDUCATION

Bachelor of Science (B.S.) - Computer Science

Bundelkhand Institute of Engg and Tech, Jhansi

May 2011

CERTIFICATIONS

Google Cloud Certification

Certfied Scrum Master

AGILE

Banking and Finance on Capital Markets

Oracle 10g Certified (Advanced PL/SQL)

Contact this candidate