SUMMARY

• Around 9 years of experience in the field of Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Database technologies
• Having the strong experience in Oracle integration/reporting for legacy systems with 3rd party applications using building the DB links and Materialized views, Loader utilities, SOAP Web services, UTL File utilities etc.
• Having the strong experience in designing and developing the reports with complex data from legacy import structures like JSON, XML etc.
• Inquisitive, proficient and skilled computer science engineer, with good troubleshooting and debugging skills
• Strong foundation in developing and maintaining PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements, performance tuning and optimization.
• Strong ability to work independently and manage one’s time, as well as, being a collaborative team member
• Strong analytical and logical skills - the ability to resolve issues in a high-pressure environment
• Well organized, self-motivated with the ability to prioritize, meet deadlines and manage changing priorities
• Ability to work with a team to provide written responses to technical proposals and /or reports/documentation for delivery
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
• Strong verbal and written communication skills, problem solving skills, customer service and interpersonal skills
• Excellent Communication (written and oral) and interpersonal skills
• Good knowledge on Oracle supplied packages, Collections, Dynamic SQL, Records and PL/SQL Tables
• Good knowledge on Oracle Cursor Management and Exception Handling
• Experience on Ref Cursor and External Tables
• Worked on SQL*Loader, which loads data from flat files into Database tables, UNIX Crontab and writing Shell Scripts for automated monitoring, backup and data loading

TECHNICAL SKILLS

• MacOS, Unix, RedHat Linux, Windows
• Oracle/10g/11g/12c, Access, OLAP, OLTP, PostgreSQL
• SQL, PL/SQL, C, C++, Java, HTML, XML, Python
• DBeaver, Microsoft SQL Server Management studio, SQL Developer, SQL Listener, SQL*Loader, SQL*Plus, SQL Navigator, Toad
• Oracle Import/export utility, SQL*PLUS, Oracle Enterprise Manager, Cron, Autosys, DBCA
• PuTTy, Secure Shell, SuperPutty
• MRTG, SNMP, WinCSP, FileZilla, AWS, Microsoft Office word, excel, power point, outlook, MS Visio, Visual Studio

PROFESSIONAL EXPERIENCE

SQL DEVELOPER

Confidential

Responsibilities:

• Created Functions, Views and Cursors to support application
• Gathered business requirements and converted it into SQL stored procedures
• Performed unit tests on all code and packages
• Attended meetings with stakeholders throughout development to gather system requirements from users
• Developed advanced SQL queries to generate data reports
• Performed SQL query performance tuning by creating/modifying indexes and changing query structures
• Collaborated with designers to create clean web interfaces and simple, intuitive interactions and experiences.
• Worked with HTML, XML and JavaScript to create web interfaces. Carry out quality assurance tests to discover errors and optimize usability.
• Created PL/SQL module which was used to integrate the existing data from third parties and on to the database.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune SQL queries for performance improvements
• Improve query performance by following performance enhancement tips and database best practices
• Worked on Improving query performance by keeping statistics up to date and tuning the database
• Worked on optimizing indexes for better performance and maintainability
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Worked with Citus which is an extension to Postgres that transforms Postgres into a distributed database
• Worked on Distributed and Reference tables in Citus
• Knowledge on horizontal scaling in PostgreSQL across multiple machines using sharding and replication
• Worked on distributing data and queries across multiple nodes
• Knowledge on coordinator and worker nodes that are used in Citus to support distributed database
• Involved in preparing Data Foundation Dependency document and Data Consumption document

Environment: PostgreSQL, Citus, DBeaver, Python, Shell Scripts, UNIX, MacOS, Control-M

Confidential

Responsibilities:

• Worked on creating and maintaining Database Objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms and Database Links
• Involved in writing PL/SQL Packages, Functions, Procedures using PL/SQL Collections, cursors and Dynamic SQL
• Written advanced SQL Queries using joins, sub-queries, and correlated sub-queries
• Developed sequences for automatic generation of unique keys to support primary and foreign key constraints
• Created and modified triggers, packages, functions and stored procedures for data conversions
• Involved in the migration of data from Oracle to Postgres environment
• Involved in writing SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling
• Developed Unix shell scripts to monitor database connectivity, Listener Connectivity, Tablespace and File system monitor
• Good knowledge on Performance Analysis and SQL Query Tuning using Indexes, Hints, Query Optimizer, Explain PLAN, SQL Tuning Advisor, SQL Access Advisor for designing scalable applications from scratch and maintaining existing ones
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical Functions, Materialized Views, Query Re-Write
• Good understanding of ER Diagrams and Data Flows
• Handled errors using exception handling for the ease of debugging and displaying the error messages in the application.
• Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs. Assisted java development team for writing SQL queries for the application.
• Used principles of normalization to improve the performance
• Knowledge on HTML, XML and JavaScript to create web interfaces
• Knowledge on various Python Integrated Development Environments like IDLE, PyCharm, Atom and Eclipse
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Analyzed and designed relational databases using ER Studio
• Performed code reviews for other development teams
• Participated in several projects and interacted with peers
• Worked with front-end developers and test engineers
• Closely worked with development manager and onsite team to deliver solutions
• Good experience on DDL, DML and DCL statements
• Good knowledge on software engineering concepts and software testing tools such as QTP and Selenium.
• Knowledge on both client side and server-side programming technologies such as HTML, DHTML, XML, Java script, JSP and Servlets.
• Knowledge on Big data technologies such as HP VERTICA, Hadoop, Hive, PIG and SQOOP

Environment: Oracle 12C, 11gR2, RMAN, TOAD, SQL Developer, SQL Listener, SQL*Loader, SQL*Plus, DATA PUMP, PL/SQL, VB 6, JAVA, HTML, SQL Server SSIS,XML, HP-UNIX shell scripting.

SQL DEVELOPER

Confidential

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows, Toad.