SUMMARY

• Oracle PL/SQL developer and lead, Data Architect, designed PL/SQL based applications Architecture.
• Created PL/SQL package, function, stored procedure, triggers, cursors, Materialized views, analytic functions, Exceptions handling, database objects like tables, views, sequences, synonyms, indexes. Used Oracle utilities like SQL*Loader, Export/Import, Data Pump, XML creation and extraction using SQL and wrote procedures to create XMLs using the table data, and also transformations using the changes captured by CDC.
• Performed SQL and PL/SQL tuning and query optimization using tools like SQL Trace, TKPROF, Explain Plan, DBMS PROFILER, SQL Tuning advisor, SQL Access advisor.
• Debugged existing packages, procedures and the objects to review and make changes as per the request.
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code, development, testing, implementing and maintenance.
• Data modelling experience in both Dimensional and Relational Data models to design OLAP and OLTP Architectures respectively by following best practices in database design and using tools like ERWIN and ER - Studio. Involved with Logical data model review and recommendation on Physical data model.
• Detailed discussion with business to understand their business requirement and then work with data modeler and functional team to review those. Recommendation on Physical data model to make sure correct data architectures considered to support the application development needs. Deliver final product and get involved with business in UAT phase to validate system functionalities are in sync with business requirements that were recorded in requirement document.
• Oracle Database Administration (DBA), DB performance monitoring and tuning, Oracle RAC, Oracle Golden Gate, shell scripting to automate DB activities and create reports.
• Day to day Application DBA activities like export, import, users, roles, privileges, Versions, Patches, DB Reports, DB Changes, Repositories, tablespaces, quotas, alert scripts, installation, building and dropping environment, Change data capture (CDC) and oracle messaging gateway, Oracle software installation and database creation worked on administration and implementation of the oracle database 10g/11g and object backup using Export/Import, Data pump, Shell scripts, RMAN, High Availability HA options like Real Application Cluster RAC, Data Guard DG and Active Data Guard ADG, Database Patching, table partitioning,, SQL Tuning advisor, Segment advisor, SQL Access advisor
• Database performance monitoring and tuning using AWR, TKPROF, explain plan, AWR, ADDM that analyzing, evaluating, fact finding, troubleshooting and documenting issues, OEM performance manager. Database Support to Front end application developers.
• Database migration (On-premise to Cloud)
• Depending on the on-promise database technology, generate the data structure script and store into cloud-based storage like S3 and also prepare the script to upload the data into AWS - RDS/Redshift. Develop database migration strategies, including schema, procedural code and data migration steps and ongoing database changes as per business needs.
• AWS Data and analytics (Data warehousing/data lake)
• Planned and Performed end to end process of data lake creation by uploading data from CSV file to S3 and used AWS Glue to extract the data from S3, do transformations and then load data back to S3 or to redshift based on the requirement and scenario. Used Athena to query the data via the AWS Glue database. Added triggers to job and workflow to run the whole flow in defined schedule periodically.
• High Availability Architecture
• Designed and setup a high availability Architecture of a word press website for client’s internal users and employees based on their requirement using Multi AZ and separate private and public security groups and services like Elastic Load balancer, Auto scaling group, CloudFront, EC2 instances, RDS instances and S3 buckets.
• Hand on with other AWS services like
• Compute (EC2, Elastic Beanstalk, Lamda), databases (RDS, DynamoDB, Redshift),networking and content delivery (VPC, cloud front, route53 DNS, API Gateway, direct connect ), analytics (Athena, kinesis, glue), security identity and compliance (IAM), Storage (S3, EFS, Snowball, storage gateway, EBS)

TECHNICAL SKILLS

Databases and tools: Oracle 9i/10g/11g/12c, OEM, SQL Developer, SQL*Loader, TOAD, WINSCPSQL server DB

Programming Languages: SQL, PL/ SQL, UNIX Shell Scripting, Python

ETL and Analytics: Oracle GoldenGate, ODI 10g/11g, Change Data Capture (CDC), SQL*LoaderOracle messaging gateway

Other Utilities: ERWIN 7.x, ER/Studio Data Architect, Remedy, ALM QC, Tableau, BigData Fundamentals, IBM Tealeaf, SPLUNK, Autosys, Microsoft Project, JIRA, Agile Methodology, Kibana

Business Domains: Banking and Finance, Telecom, Life sciences, insurance, healthcare.

PROFESSIONAL EXPERIENCE

Confidential

Project Lead

Responsibilities:

• As a Database development lead and AWS cloud engineer, leading and mentoring a group of pl/sql developers and Confidential the same time involved in PL/SQL development, performance tuning, requirement gathering, Legacy system analysis, onsite-offshore co-ordination, development and configuration of various components. Involved in design and architecture of PL/SQL application as well. AWS cloud activities involved On Database migration (On-premise to Cloud) and High Availability Architecture design and implementation.
• Executed POCs on Oracle CDC to captures changes in data, Oracle Messaging gateway so that the data can be transferred across the heterogeneous systems and assessment of Oracle Data Integrator and Oracle GoldenGate to decide the tools that can be used in the system architecture.
• Worked with Data modelers to review the physical data model based on table design requirements.
• Extraction & Preparation of weekly Reports as per business requirements using shell scripting with embedded SQL and Jobs to automate periodic maintenance tasks.
• Build the detailed design and architecture of the project and mentored the team members to efficiently implement the rules using proposed technologies.
• Resolved issues found during SIT, UAT and production implementation.
• Was responsible for coordination between offshore development team, business, and technology and management groups.
• Also been performing Oracle DB administration of Application DBs in dev environment performing maintenance and changes to various DB objects like tables, indexed, packages, procedure etc in RAC environment.
• Gained good knowledge of system architecture built over multiple layers including Front end servers, backend servers, web logic servers along with load balancer and authentication management servers etc.
• To summarize this specific application, raw data is extracted mostly using SQL loader and then transformations were done using ODI and data was loaded to tables. Further using PL/SQL code and scheduling jobs, rules were implemented and generated files in XML format and distributing those files to downstream systems for further processing. Whole process achieved using various technologies that includes PL/SQL code, SQL loader, Oracle data Integrator, Oracle Golden Gate, Unix jobs etc.
• AWS Cloud Database migration (On-premise to Cloud) - Successful Migration of Oracle Databases to AWS EC2 and RDS based on requirements. Depending on the on-promise database technology, generate the data structure script and store into cloud-based storage like S3 and also prepare the script to upload the data into AWS - RDS/Redshift. Develop database migration strategies, including schema, procedural code and data migration steps and ongoing database changes as per business needs.
• AWS High Availability Architecture - Designed and setup a high availability Architecture of a word press website for client’s internal users and employees based on their requirement using Multi AZ and separate private and public security groups and services like Elastic Load balancer, Auto scaling group, CloudFront, EC2 instances, RDS instances and S3 buckets.

Confidential

PL/SQL project Lead, application design and architecture

Responsibilities:

• As development lead of the project, I understood the overall business and functionality of the existing system and worked on design document after requirement gathering and analysis.
• On technical perspective raw data was extracted mostly using SQL loader then and then transformations were done using ODI and data was loaded to tables. Further using PL/SQL code, rules were implemented generated files in XML format and distributing those files to downstream systems for further processing. Whole process achieved using various technologies that includes Oracle data Integrator, Oracle GoldenGate, PL/SQL code, Unix jobs and SQL loader etc.
• Proof of concept on the technologies planned to be used in the project which includes Oracle Data Integrator and Oracle GoldenGate. build the detailed design and architecture of the project and mentored the team members to efficiently implement the rules using proposed technologies. He gained complete knowledge and understanding of end to end IDBAR system as well as the systems interfacing IDBAR system in both technical and business perspective. resolved issues found during SIT, UAT and production implementation. He was responsible for coordination between client and offshore development team.
• Co-ordination among business, technology and management groups.

Confidential

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA supporting multiple databases on RAC and standalone architectures.
• Executing day to day DBA tasks, resolving issues found in databases, backup and recovery, setting up database environments, performance tuning of database applications, physical data modeling from available Logical data model, Interacting with Other DBA team and application teams etc. worked on various versions of oracle database on different types of infrastructures. worked on Real application clusters as most of the databases had been setup as RAC only. involved in identifying and troubleshooting various RAC specific issues. configured O/S level cron jobs and setup those to automate various application processes.
• Database performance monitoring and tuning using AWR, TKPROF, explain plan, AWR, ADDM that analyzing, evaluating, fact finding, troubleshooting and documenting issues, OEM performance manager. Database Support to Front end application developers.