1. Project Name : CITI Mexico Location : Hyderabad Duration : 10 April 2017 to till Date Domain : Banking Position : Technical Spec - Database Administration Database : Oracle 11g RAC, Data Guard, Database Tools : Opatch, Oracle 12c Cloud control, ServiceNow, Marketplace, Aperture, DSP, DMA, DST, WAIS Role and Responsibilities : Maintain data repository. Documenting server the server patching schedule. Create service now patching records(PTCHs) with patching windows. Create patching tasks(PTSKs) for production support and development checkout as well as supporting development teams. Schedule CIs in patching windows per agreed patching schedule. Send notification to stakeholders of panned execution of patching. Perform patch deployments. Perform pre/post implementation system health checks. Send notification to stakeholders of completion of patching. Update status of patching records as deployment upgrade. Provide true up and compliance report. 2. Project Name : Nokia Siemens Networks Location : Hyderabad Duration : 5 Jan 2017 to 22 Mar 2017 Domain : Telecommunication Network Position : Technical Spec - Database Administration Database : Oracle 9i/10g R2/11g enterprise edition Database Tools : SQL Developer 4.0 Role and Responsibilities : I am a Single point of contact for the technical tower in front of the customer management. Ensure proper communication and quick resolution as a crisis manager. Responsible for Vendor Management and people management. Drives day to day operations and work plan allocation/management. Conduct periodic reviews with teams. Weekly and monthly status reports to higher management. Participate in business meetings with various stake holders. Take corrective actions based on the customer satisfaction surveys. Drive service improvement programs. Ensure adherence to quality / security standards defined for the engagement Perform Trend analysis, identify top few incidents and work with respective teams/individual to minimize the incidents. Effort estimation/reviews on need basis for new projects 3. Project Name : Allied Irish Bank Location : Dublin, Ireland Duration : 1 Jan 2015 to 31 Dec 2016 Domain : Banking Position : Technical Spec - Database Administration Database : Oracle 9i/10g R2/11g R2/12c Enterprise Edition, Sybase 12.5.4.0 Database Tools : Embarcadero DB Artisan 8.7.4, Oracle 11g RAC, Oracle 12c Cloud control, Remedy, SQL Developer 4.0, Cyber Ark, Oracle Data Guard, Guardium. Role and Responsibilities : BAU support from distributed database support. Oracle Database support, Access Requirement Security, Audit and SOX Oracle Database Installation and patching, Listener Configuration management, Database configuration management, Oracle Database Incident & Problem management, Capacity management, Performance Management, Alerting, Backups, BCM, New Customer Project Oracle Database management, On Call support. 4.Project Name : Quest Diagnostics Location : Gopanpally, Hyderabad, India Duration : 14 Nov 2013 to 9 Sep 2014 Domain : Health care Position : Technical spec – Database Administration Database : Oracle 11g RAC, Oracle 10g R2/11g R1 Enterprise Edition, Oracle Data Guard, Oracle Golden gate 11g R1 Tools : HP Server manager, SQL Developer 4.0 Roles and Responsibilities : Implemented and configured Golden gate. Database instance availability, Session monitoring, Query/Transaction monitoring, Lock and latch monitoring, Table space/ Data file growth and fragmentation monitoring, Memory and Cache monitoring, Job Monitoring and Purging Job History, Replication/ Stand By Monitoring, Object monitoring, Database Object Performance/ Monitor, Backup monitoring, Wait events monitoring, Create/Maintain/Execute Public DBMS Objects, Script execution (PLSQL/SQL PL), Job Scheduling, Data Integration – Execution (ETL), User creation/deletion, Developer/End User Access and Privileges, Alert Monitoring, Respond to misc./other database related events.

Domain : Transportation, Broadcast Position : Specialist Project Name : NETO-COD, 13 MY Infotainment Database : Oracle 9i R2/10g R2/11g R1 Enterprise Edition, Oracle Golden gate 11g Database Tools : SQL Developer, Used Tuning tools Roles and Responsibilities : Handling the Oracle Database Installation and Design, Oracle Database Health Checks, Oracle Database Performance tuning, Backup Management, Proactive Monitoring and Maintenance, Service Request escalation with Oracle, Explaining/Demonstrations of new Oracle 11g features, System Recovery, Configuring and Administering Oracle 10g/11g Automatic Storage Management(ASM), Trouble shooting and resolving database issues. Manage the installation and configuration of Oracle Golden Gate Replication on Oracle 11g database.

Domain : Security System Position : Consultant - Oracle Project Name : Enterprise Security System Database : Oracle 11g R1 Enterprise Edition, Oracle 11g RAC Role and responsibilities : I completed installation and configuration for Oracle 11g RAC in RHEL 4.5. I installed and configured Oracle 10g Audit vault server and Oracle 10g collection agent. I configured and Scheduled RMAN Backups. Applying Oracle Critical Patch Updates (CPU Patches) and one-off patches. I was the member of the Technical Architecture Team and Production Support. Administered and subsequently tuned database. Created recovery strategies and recovered the database in case of crash.

Installation and configuration of Oracle 10g R2 database on RHEL 4.5 Designing and PL/SQL programming for Oracle spatial Database. Uploading shape file format data into the Oracle database. Backup and recovery using RMAN. Created Network data model and network constraints. Database upgrade from oracle 9i R2 to 10g R2

Domain : Health Care Position : Sr. Oracle DBA, team lead Project Name : NetyDoc.com, Cirqlex Vista, Cirqlex Practice work, INYS, Nerve Centrex Database : Oracle 10g R1 Enterprise Edition, SQL Server 2000 Role and responsibilities : I did feasibility study and data gathering for INYS Project. Designing and PL/SQL programming for all health care database. Database Installation and up gradation in oracle 10g. I administered Production Database Implemented and subsequently tuned database. I created database clone using RMAN. I have done export import for database and tables. I worked on SQL loader for Cirqlex Vista project. I managed a team of 20 members including software developer. I configured Instant Client.