SUMMARY

• Having 12 years of extensive experience in IT as AWS cloud Computing, Azure, oracle DBA, Oracle Application support and Oracle Service Oriented Architecture,designing and coding for large, complex systems that support big data operations .Looking for a challenging position in the organization where my knowledge would make a significant contribution to the company’s growth, which would enhance my skills.
• Tier 3 support and managing the global IT infrastructure .services within AWSand Maintaining highly reliable 24x7x365 Linux production servers for internal, global and AWS EC2 instances.
• Strong on cloud based solutions in AWS cloud and exposure of IAAS,PASS,SAAS based solution
• Worked on Amazon Web Services ( EC2, ELB, VPC, S3, Cloud Front, IAM, RDS, Route 53, Cloud Watch, SNS,).
• Working within the Agile framework,Scrum Master and team.
• Setup/Managing Linux Servers on Amazon ( EC2, EBS, ELB, SSL, Security Groups, RDS and IAM).
• Setup/Managing VPC, Subnets; make connection between different zones; Blocking suspicious ip/subnet via ACL.
• Setup/Managing on Amazon Cloud Front to improve site performance.
• Hands - on AWS experience working with technologies like SNS, SES, DynamoDB, Lambda, API Gateway, CloudFormation and CloudFront.
• Design, implement, and support Publish/Subscribe, parallel processing, and big data paradigms.
• Investigate and debug issues in the Database and Services you create and work with QA & Data Analysts to ensure highest quality within the system
• Experience in a continuous integration (CI) environment with Build, Release, and Deployment.
• Create/Managing buckets on S3 (CLI) and store db and logs backup, upload images for CDN serve.
• Setup/Managing Databases on Amazon RDS. Monitoring servers thorough Amazon Cloud Watch, SNS.
• Creating/Managing DNS records on Amazon Route 53.
• Experienced in Microsoft Azure cloud, network operations, private and hybrid cloud administration
• Knowledge in system center, Azure Monitoring, Azure Application Insights, Operation Management Suite including Log Analytics, SCCM & Azure Security Center
• Experienced in Database administration of Oracle 9i, 10g & 11g and also experience in Database Installation and Upgradation.
• Performing regular DBA duties like Production Support, Development Support, Patching and Cloning.
• Performing the Backup & Recovery activities using RMAN & Export/Import.
• Configure corrective action in OEM12C for automated archive log backup.
• Quarterly applying CPU and PSU patches .
• Establishing the Data Guard configuration for standby database.
• Working knowledge on 10g/11g RAC high availability environment.
• Knowledge on Oracle 11g Golden Gate replication.
• Performance tuning using AWR/ADDM/ASH report, Statspack, tkprof.
• Knowledge of Exadata setups and configuration.
• Knowledge 12c OEM Installation and manage the configurations.
• Expertise in Oracle 11i Applications installation, cloning, patching, implementation, upgrade
• Installation of Oracle E-Business Suite Application 11i/R12 on single/multi node.
• Performing AD Utilities Administrative task using adadmin, adpatch, adsplice, adident, adctrl, FNDCPASS and FNDLOAD for oracle Applications.
• Troubleshoot issues like Apache and concurrent managers.
• Creating application, database users and assigning required responsibilities.
• Experience in applying Oracle Patches using AD PATCH utility. Analyze patches before applying to determine the impact of the patch to production and multi development environment. applied one-off, mini pack and maintenance pack.
• Cloning apps instances using rapid clone.

TECHNICAL SKILLS

Languages: C,C++,SQL,PL/SQL, HQL(Hive), Unix, VB, Windows and ESSBASE Reporting Scripting, SAS

Databases: Oracle10g/11g, MS SQL Server 2005/2008,IBM DB2

Tools: /Utilities Control-M, SQL Developer, Putty, Squirrel,, Big SQL, Scoop

Methodology: Agile, Waterfall

OS: UNIX (HP-UX,HP-IA & SCO-UNIX),Linux, Windows-2000, 2003. RHEL4-6, Solaris.

Software & Tools: MS-Office, Microsoft Visio, BMC Remedy ITSM tool, TOAD, SQL Developer, SERVICE NOW, JIRA, NET COOL tools .

Cloud Computing: AWS/AZURE(ELB, SNS,EC2, Route53, S3, RDS, CloudWatch, IAM, SNS, VPC, SES,SNS, Cloud Trail

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

AWS Engineer

Responsibilities:

• Worked as a AWS L3 support and Managing Confidential Group Inc global and internal in AWS and Azure environment.
• Maintaining and managing in AWS Cloud watch formonitorcritical system health, performance, security, disk usage.
• Configuration and managing to support new applications projects for specific business needs.
• Costing, Design, building and managing the infrastructure environments needed for the projectsinthe AWS hosting platform.
• Actively monitor, research and analyze ways in which the servicesinAWS can be improved.
• Maintain system availabilityasper multiple Service Level Agreements (SLA).
• Produce monthlyreportsactivitywhere needed and explain any abnormal system performance.
• Coordinate and implementchangerecords as a result of trouble tickets and 2nd /3rd level in-depthsupportfor hardware and OS diagnostics.
• Manage and configure AWS services as per the business needs (ELB, SNS,EC2, Route53, S3, RDS, CloudWatch, IAM, SNS, VPC,, SES,ETC)
• Maintaining highly reliable 24x7x365 Linux production servers for internal, global and AWS EC2 instances.

Confidential, Englewood Cliffs, NJ

Senior Oracle DBA

Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g,12c databases.
• Installation, maintenance and tuning of Oracle 11gR2 RAC databases including ASM and CRS.
• Installation, configuration and upgrading of Oracle server software and related products
• Evaluate Oracle features and Oracle related products
• Establish and maintain sound backup and recovery policies and procedures
• Take care of the Database design and implementation
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring.
• Coordinate and implementchangerecords as a result of trouble tickets and 2nd /3rd level in-depthsupportfor hardware and OS diagnostics.
• Manage and configure AWS services as per the business needs (ELB, SNS,EC2, Route53, S3, RDS, CloudWatch, IAM, SNS, VPC,, SES,ETC)
• Maintaining highly reliable 24x7x365 Linux production servers for internal, global and AWS EC2 instances
• Setup and maintain documentation and standards
• Plan growth and changes (capacity planning)
• Work as part of a team and provide 24x7 support when required
• Perform general technical trouble shooting and give consultation to development teams
• Interface with Oracle Corporation for technical support.
• Patch Management and Version Control

Confidential, Raritan, NJ

AWS SysOps admin & Engineering DBA

Responsibilities:

• Implementation of BRP project RMAN setup and configuration across all JNJ DB’s.
• Installing and upgrading the Oracle 10g,11g Database server on Windows, SUSE-LINUX, HP-UNIX platforms.
• Applying of CPU patch & PSU patch.
• Writing RMAN scripts to back up the database files and automate the jobs using CRONTAB.
• Carried out DB cloning and provided the cloned database for development side.
• Generating reports on the snapshots taken by AWR and analyzing the ADDM report. Implementing the suggestions given by the report if it is necessary.
• Taking backups and moving the backup copies and archived logs to the backup destination, periodically clearing the archived log files.
• Identifying locks, detecting the locked and blocked object’s session, and releasing the same for Cloud environment.
• Managed IAAS and PASS service model for the EC2 instance and AWS RDS for oracle and mysql database.
• Manage and configure AWS services as per the business needs (ELB, SNS,EC2, Route53, S3, RDS, CloudWatch, IAM, SNS, VPC,, SES,ETC)
• Data upload in AWS PASS environment in oracle.
• Setting up a new DNS and a corresponding VHOST to make the website functional using AWS Route 53

Confidential, Boston, Massachusettes

Senior Oracle DBA

Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Successfully migrated databases from Intel Boxes (Windows 2000, Windows 2003 servers) running oracle 9i over HP-UX Itanium boxes running oracle 10g and non-ASM instance to ASM instance.
• Setup, configured and maintained oracle data guard (primary and Standby databases) to ensure disaster recovery, high availability and data protection.
• Data Migration as part of enterprise data warehouse project.
• Worked on import/export, export data pump/import data pump and SQL Loader.
• Installed and Implemented Backup and Recovery Procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and Configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Installed Oracle 10g Enterprise Manager (OEM)(Grid Control) for diagnosing and monitoring performance related problems and configured with Applications servers on databases.
• Designing the security and database access strategies using tools like ESM.
• Used ERP to plan how to use the resource effectively and to control and manage them.
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.

Confidential, Charlotte, North Carolina

Oracle Application admin & Oracle DBA

Responsibilities:

• 24/7 supports for production/QA/Development Server for three different client
• Creation of user for different client
• Attaching/Removing responsibilities from user
• Registration of concurrent Program
• Knowledge of Registration of forms/menu /functions
• Weekly Cloning activity using Rapid clone method.
• Database as well as application CPU Patching activity for all servers
• Load average Report of Production Server for different client
• Cloning apps instances using rapid clone.
• Modifying the configuration of the components like Apache to have new ports.
• Helping users in case of any connectivity issues while using apps. Application user creation and assigning responsibilities.
• Managing concurrent managers and its operations like starting, stopping the concurrent managers, re-schedule the request, purging the concurrent managers operations. requisites activity)
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backup and RMAN, Logical Backups.

Confidential, Morristown, TN

Oracle Application DBA

Responsibilities:

• 24/7 supports for GECOM for both production/QA/Development Server for three different client (LESCO/LOWES/WW AND STOCK) from Offshore
• Creation of user for different client
• Attaching/Removing responsibilities from user
• Registration of concurrent Program
• Knowledge of Registration of forms/menu /functions
• Running TAR scripts and Action Plans etc
• GECOM Load average Report of Production Server for different client
• Vista Plus Clean of Activity and administration
• Maintenance all types of Admin scripts
• PROD/QA/DEV/SANDBOX server Refresh Activity (Both pre requisites and post requisites activity)

Confidential

Oracle Application DBA

Responsibilities:

• Maintaining the global web plan daily server and GSP server
• Installation Red hat Linux AS3, AS4
• Installation of oracle database (9i/10g), Oracle application 11i
• Monitored and diagnosed database performances through monitoring of alert files, trace files.
• Ad Utilities (Adctrl, Ad merge, Adadmin, Ads lice etc)
• Cloning of database and Application (manual clone, AD-clone, Rapid clone).
• Setting up users, responsibilities and printers
• Patch activates of database and Application (using Opatch and Ad patch)
• Applied applications patches including rollup patches, and one-of patches And India Localization Patches.
• Troubleshooting of Apache server, Concurrent manager server
• Knowledge of backup / recovery mechanism using RMAN