SUMMARY

• Technical Lead - Oracle Database Engineer with over 13 years of experience in People Management, Software Development and Stakeholder Management.
• Specialized in Project Management and experienced in all phases of SDLC for data driven Back-End platforms like relational transaction application databases (RDBMS), ETL, Datawarehouse, MDMs, reporting databases (OLAP) and BI Tools using Agile and Waterfall methodologies
• Database Architect, Data Modeler and Database Developer responsible for designing, developing, building, integrating and managing enterprise level database systems with complex interdependencies and high availability, security, performance, and scalability requirements.
• Expert in transforming the business ideas, challenges and manual processes into automated technology-based solutions using database technologies.
• Worked on various Development, Enhancement, Maintenance and Re-Engineering Projects throughout the career.

TECHNICAL SKILLS

Platforms: Linux, Windows

Databases: Oracle, SQL Server, Teradata

Languages: SQL, PL/SQL, Java, Python, Shell Scripting, Pro*C

Internet Technologies: HTML5, CSS, JavaScript

Data Visualization and Reporting: Tableau, Oracle Reports

Tools: ERWin, MS-Project, SQL SERVER Studio, TOAD, PL/SQL DEVELOPER, Jenkins, JIRA, Putty, Oracle Enterprise Manager (OEM)

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead - Database Developer

Responsibilities:

• Working as a Technical Lead - Oracle Database Development managing teams from USA and India. Responsible for overseeing all activities within the team. This includes resource hiring, task delegation, goals determination and performance evaluation.
• Responsible for developing end to end back-end solutions for RDBMS (OLTP), Datawarehouse (EDW) and analytical reporting databases (OLAP) on Oracle 12c RAC, SQL SERVER 2016 and Teradata in Multi-Datacenter Environment.
• Develop and manage project plans, secure resources, drive project schedules. Collaborate with stakeholders from Requirement Gathering to the Project Acceptance stage. Report project progress regularly to management. Requirement Analysis and Prepared High-Level and Low-Level Technical Design documents
• Data modeling to create E-R Diagrams for RDBMS as well as dimensional modeling for Data Warehouse using Star-Schema and Snowflake-Schema models using ERWin.
• Design and develop the code using languages SQL, PL/SQL and T-SQL to create objects like Tables, Facts, Dimensions, constraints, indexes, procedures, functions, packages, triggers, views, synonyms, GTTs, materialized views with high coding standards and best software practices. Performing Code reviews and Design reviews
• Design, Define and implement table partitioning as well as global and local indexes.
• Analyze various data sources and transformation rules to get data into data warehouse from various sources. Worked on in-house ETL tool that is defined in PL/SQL in order to transfer data to data warehouse.
• Perform Unit Testing, Performance Testing and Integration Testing.
• Set up Scheduler batch jobs on Oracle Database to automate complex workflows using DBMS Scheduler.
• Performance tuning of code by Query optimization and Process optimization. SQL Profiling and SQL PLAN Management. Study AWR and ADDM report to identify and troubleshoot performance issues. Monitoring Database health using Oracle Enterprise Manager (OEM)
• Experienced in using Data Pump, Flash - Back Recovery, Grid control, and Recycle Bin.
• Strong hands-on expertise on SQL*Loader and External tables to support data upload from external resources like flat files and csv files. Import-export database table/schemas between environments using Data Pump.
• Extensive Shell scripting and CRON setup on Linux systems.
• Worked on some of the complex design bottleneck issues related to Row-Chaining, SQL plan stabilization, Deadlocks, Data Encryption and Decryptions
• Propose, design and supported ETL implementation using Teradata Tools and Technology like BTEQ, MLOAD, FASTLOAD, FASTEXPORT, SQL ASSISTANT, and Teradata Parallel Transporter (TPT).
• Evaluating database space needs using ASM. Actively worked on defining and implementing strategy for tablespace management, backup strategy, data pertaining strategy, table stats gathering strategy, data archival strategy, data scrubbing strategy for an application database.
• Involved in build and promotion process as well as supported Production and UAT deployments.
• Supported various data center migrations as well as Oracle upgrades from Oracle 10g to 11g as well as Oracle 11g to Oracle 12c databases.
• Familiarity to Core Java development skills. Hands on development and support Java based Application as required. Familiarity of REST and SOAP Webservices.
• Strong command over tools like ERWin, SQL Developer, PL/SQL Developer, Toad, Eclipse, Jenkins, Putty, SVN, JIRA, Splunk, AppDynamics, Nagios etc.

Confidential

Database Developer

Responsibilities:

• Work as Oracle PL/SQL and SQL developer.
• Responsible for entire end-to-end Oracle database designing for an application. Responsible for Conceptual, logical and Physical Data modeling using ERWin and MS Visio.
• Performing requirement analysis and designing based on functional requirement documents.
• Designing and implementing schemas, tables, indexes, procedures, functions, packages using SQL and PL/SQL on Oracle 11g database.
• Unit testing and support for UAT and production deployment and troubleshooting.
• Coordinate with DBAs, Business, Testing, and Production Management team pears over ongoing release specific activities and production issues.
• Work as an Offshore Coordinator for Team.

Confidential

Oracle Database Developer

Responsibilities:

• Work as a Oracle PL/SQL and SQL developer on Oracle 10g and Oracle 11g databases.
• Responsible for performing requirement analysis and database designing based on functional requirements. Defining and designing tables, indexes, partitioning strategy, stored procedures, functions, packages, triggers etc.
• Data modeling and designing the logical and conceptual model for backend using Microsoft Visio.
• Defined strategy for table partitioning Also implemented Virtual Private Database (VPD policies) across application.
• Extensively used Dynamic SQL, Ref Cursors, collections time to time
• Doing performance tuning using TKPROF for PL/SQL code. Performance Tuning of an SQL queries by reviewing execution plans and implement changes to fix performance issues.
• Using SQL*Loader and External tables to load data to Oracle Database from external files.
• Performing Data virtualization using too Oracle reports to create reports as per functional requirements
• Shell scripting and AutoSys, CRON JOB scheduling to automate some processes.
• Unit Testing, Integration testing & debugging to ensure the quality of final deliverables.
• Coordinating with client and Java team. Mentoring new team members and to train them on functionality of application. Monitor their work to ensure achieving deadlines of tasks. Work with BI team to understand the reporting needs.
• Perform internal reviews for deliverables
• Maintain and monitor the deliverable status
• Perform Database Administrator activities like taking Backups, Creation of schemas, Performance tuning etc.

Confidential

Oracle Database Developer

Responsibilities:

• Work as a Oracle SQL and PL/SQL developer.
• Understanding the business requirements and create technical design document based on analysis.
• Designing/Enhancing and implementing PL/SQL packages, procedures, functions etc to implement the required functionality and document them. Shell scripting on HP-UNIX.
• Provide production support for any data-related issues and to design identification and correction scripts to correct data.
• To perform SQL performance tuning using TKPROF.
• Creation of Unit Test cases based on design and analysis documents.
• Unit Testing, Integration testing & debugging to ensure the quality of final deliverables.
• Mentoring new team members and to train them on functionality of application.
• Perform internal reviews for deliverables.
• Maintain and monitor the deliverable status.
• Supervise and mentor junior developers in the team.