SUMMARY

• Working as a Senior Software Engineer at Confidential from . A CMMI Level 5 assessed company. Confidential is my 1st company.
• Currently having 9 years of working experience in Confidential DBA, PL/SQL, SQL, AS400, UNIX & Shell scripting, Confidential RAC concepts, MongoDB Technologies and worked with client Hospira for 4 and half years and present working with client FedEx from past 4 and half years till date.
• Experience in Confidential, Travel and Transportation domain
• Over 5 years of programming experience as an Confidential Database Administrator including the design, configuration and operation of clusters on Business Application Databases, performance tuning and administration of mission critical production databases.
• Over 4 years of experience as a Level - 3 Lead at FedEx Ground. Involves on Production support and Level - 3 Debug on Pick and Delivery application in FedEx.
• Provided 24x7 productions on call support for Vision Applications. And have good knowledge with AppD and Splunk Monitoring.
• Experience in design and developing Automation Application-leveraging.
• Ensure the continuous availability of our mission critical clusters.
• Good Knowledge on Installation/Upgrade of the database software on Linux platform, Performance tuning and indexing strategies and MMS Monitoring, Alert, Backup and Restore. Sizing of Oplog based on Workloads and to maintain replication properly across all the nodes.
• Knowledge on Sizing, Tuning, Authentication, Authorization, Golden Gate Replication.
• Disaster recovery and rolling maintenance, Backup, Restore and Production support.
• Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.
• Responsible in all facets of Software Development Life Cycle (SDLC), including requirements gathering, establish technical specifications, set deadlines and milestones, Designing, Coding, Testing, Quality Assurance and Production Deployment.
• Worked closely with the business users, analysts, infrastructure team, SAP team and project managers during the project related activities.
• Skilled in understanding the issue related to the tickets and solving them on timely basis. For the critical issues debugging the code and enhancing it according to requirements.
• An experienced team player with excellent communication and interpersonal skills who has the ability to work independently under pressure can lead, motivate and influence others and can train and mentor subordinates.

TECHNICAL SKILLS

Databases: Confidential Database (7 years), MongoDB 2.2, 2.4, 2.6 and 3.0, 3.4 (2 years), SQL (5 years), UNIX (3 years)

Operating Systems: Windows 10/XP/NT/2000/98/95, MS DOS, Linux

Programming Languages: Confidential Database Administrator, Confidential GoldenGate, Confidential RMAN, Confidential RAC, SQL, PLSQL, UNIX Shells Scripting, AS400

Tools: PL/SQL Developer, Toad, SQL*Plus, SQL Loader, PuTTY, AppD, Splunk, AutoSys, MongoDB server, Mongo shell, MongoDB Compass.

Domain: Confidential and life Sciences, Travel and Transportation

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Tools: /Technologies: Confidential Database Administrator, Confidential Recovery Manager (RMAN), SQL Developer, SQL, PL/SQL, UNIX, AS400 systems, DB Visualizer, Mongo shell, AppDynamics.

Responsibilities:

• Technical Lead for Vision Level-3 module at FedEx Ground.
• Confidential Database Administrator, SQL & PL/SQL Developer, Unix Developer, MongoDB Admin.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Handling Level-3 Development and Production database support.
• Install, configure and manage as Admin for Confidential RAC DB’s. Configuration management, performance tuning on those Databases.
• Performed RMAN backups and recovery of the Confidential Database for Disaster recovery.
• Worked on intense scanner applications, which needs High Availability of Confidential Databases. Had Good knowledge with Flashback, Restore points and Data guard.
• Migrating few applications Databases to MongoDB which involves in Confidential .
• Performed Golden Gate Replication for Disaster recovery Roleswaps.
• Creating Confidential objects like tables, types, packages, procedures and functions.
• Design and developed the scripts to create table, views, indexes and sequence.
• Optimized the queries to improve the performance of the application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Involved in migrating database from Confidential 9i to 10g database.
• Involved in migrating applications from one datacenter to other datacenter - Role swapping servers across client systems.
• Analyze and find root cause for recurring issues.
• Work on Requirement Analysis for new business requests.
• Solving the bugs reported by the customer.
• Directly coordinating with Business and users to gather the new requirements and working with existing issues.
• Documentation
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Handling Level-3 Development and Production support.
• Improved and optimized CRUD operations performance for read and write operations.
• Involved in Disaster recovery and rolling maintenance, Backup, Restore and Production support. Also migrated applications from one datacenter to other datacenter - Role swapping servers across client systems.
• Analyze and find root cause for recurring issues.
• Work on Requirement Analysis for new business requests.
• Solving the bugs reported by the customer.
• Directly coordinating with Business and users to gather the new requirements and working with existing issues.
• Developed and documented SMTD’s about the application flow throughout Vision applications in FedEx ground.

Confidential

Tools: /Technologies: Confidential Database Administrator, SQL/PLSQL, Toad, Autosys, Visual Basic, PL/SQL Developer, SQL Loader, Confidential 9i, 10g

Responsibilities:

• Device Management/ Confidential Developer.
• The project involved in data analysis of the Devices in Hospira. The project includes Data Analysis, preparing Data Dictionary, preparing Reports of all the Medical Devices.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote PL/SQL stored procedures, functions, packages as required in the health care system for Audit purpose on Devices.
• Modified, maintained and developed the SQL codes to develop new enhancements and Change Requests (CR’s).
• Responsibilities as an Confidential developer include management of the queries, enhancement and support service issues.
• Solving the bugs reported by the customer.
• Acted as a critical resource in Data Center Migration (DCM) and tested all the applications after the server movement to ensure the applications availability and performance.
• Directly coordinating with international user to gather the new requirements and working with existing issues.