Uttara Merupula

Project Name: COMCAST - Comcast is a major telecommunications company in the United States, known for its brand Xfinity. Xfinity offers a range of services including high-speed internet, cable TV, phone services, and home security.

• Set performance expectations for the team, monitoring progress towards goals and providing constructive feedback as needed.
• Developed team members'' skills through targeted coaching sessions, resulting in improved individual performance.
• Enhanced team productivity by implementing efficient work processes and regularly reviewing performance metrics.
• Collaborated with other department leaders to establish shared goals and ensure alignment across teams.
• Increased customer satisfaction ratings by closely monitoring service quality standards and addressing any issues promptly.
• Streamlined workflows for increased efficiency, reducing turnaround times for critical tasks.
• DBA activities included:
• DB Installation (Oracle Goldengate, Oracle)
  DB Configuration Change
  DB Upgrades
  DB Migration
  Script Executions
  Deployments
  Data Refresh
  Monitoring Setup - OEM setup
  SSL Certificates Upgrade
  Dataguard Replication Setup
  High Availability Setup
  Patching - DB / OS
  Access Request
  User Issues
  Performance Issues (recommendations)

• Project Name: CALSAWS, or the California Statewide Automated Welfare System, is a comprehensive system that supports eligibility determination, benefits calculation, and case management for various public assistance programs across all 58 counties in California.
• Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
• Database creation/decommission/upgrades/migration (12c and 19c) on AWS EC2 instances.
• User management - User create/alter/drop.
  OMS patching/Database patching/Data refreshes via Delphix engine.
• Database monitoring: locks, space management, performance issues etc.
• RMAN backups and restore as per requirement.
• Schema export/import backups.
• JDK upgrades for agent and OMS.
• Experience with tools like JIRA, Bitbucket, Jenkins.
• Worked with customers and other third parties to support DBA functions.
• Led training sessions for junior team members on best practices in maintaining an efficient Oracle Database environment.

• Project Name: Central Depository Services (India) Ltd (CDSL) is first listed Indian central securities depository based in Mumbai. CDSL facilitates holding of dematerialized securities enables securities transactions to be processed by book entry.
• Daily manage and monitor more than 20 database including production, DEV, test and UAT. Resolve or address about 200 mails per week from customers which has led to 15% increment in customer satisfaction.
• Responsible for DR site management (Data center).
• Database monitoring: unauthorized access, log shipping, sessions etc.
• RMAN backups and restore as per requirement.
• Perform database switchover and switchbacks on as customer requirements.
• Table purging activities.
• Table partitions as per user requests.
• Raising change requests for production database and implementing changes accordingly.
• Managing oracle data guard databases.
• Monitoring replication jobs of oracle and MSSQL databases.
• Space management- Table space /file systems/database growth.
• AWR report generation as per user request.
• Gathering statistics on tables.
• Managing database links.
• User management and object level activities like Index creation, synonym creation, table creation.
• SQL databases backup/restore.
• ASM installation, configuration and administration.

• Project name: INFO ONE migration (JP Morgan) project dealt with migration of old databases to new version databases.
• Have resolved more than 3000 tickets in span of 8months and have been appreciated by customer for completing task before time.
• Role Management- grants, revoke, drop, and create roles.
• Space management.
• Report generation.
• Resolving issues through RSAM and PEREGRINE.
• User creation and assigning roles and privileges.
• Password reset.
• User account locking and unlock.
• INFO ONE migration project dealt with migration of old databases to new version databases.

• Project Name: Agilent Technologies, Inc. is an American analytical instrumentation development and manufacturing company that offers its products and services to markets worldwide.
• Reduced downtime by proactively monitoring and addressing potential issues with the Oracle Database system.
• Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
• Have managed over 40 databases and had resolved 100+ tickets per week and received few client appreciations for prompt resolutions.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Installation of Oracle 11g and 12c software and database creation.
• Refreshing databases by using RMAN, data pump, export and import.
• Database cloning, refreshes and migrations.
• Taking database backups: LvL0, incremental backups, archive log backups.
• Export and import of schemas by using data pump.
• Applied PSU patches/Database patching.
• Restoring database from one server to another server and within same server.
• User Management - roles, privileges, user creations, password resets.
• Tablespace Management.
• Configuring DR setup.
• Experience in working with OEM.
• Database change requests.
• Monitoring and managing standby databases.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Agilent Technologies, Inc. is an American analytical instrumentation development and manufacturing company that offers its products and services to markets worldwide.

• Project Name: Wellsfargo: Provider of banking, mortgage, investing, credit card, and personal, small business, and commercial financial services.
• Accomplished task of ensuring profile compliance to all customers of bank.
• Set up and controlled user profiles and established access levels for each database segment to protect important data.

• Company Overview: Lifescan IT applications run on different operating systems (viz. UNIX, VAX, WINDOWS NT and WINDOWS 2000) and RDBMS platforms (mainly ORACLE and variants). These applications are mission critical and need continuous monitoring and control of operations.
• Experience in providing 24
• 7 production support for mission critical multi terabytes (OLTP & DWH) production system.
• Creating databases manually as well as by using Oracle Database Configuration Assistant.
• Monitoring memory usage.
• Daily space monitoring in production server as well as development and UAT environments.
• Taking RMAN full database and incremental backups.
• Monitoring daily hot backups of critical production databases.
• Data handling - executing database change requests as and when required through harvest tool.
• Monitoring daily hot backups of critical production databases.
• Managing standby databases.
• User creation and granting roles, privileges.
• User password reset and account related requests.
• Monitoring tablespace usage and allocating space as needed.
• Monitoring oracle user sessions activities.
• Refreshing tables, schemas etc.
• Taking export backup of tables, schemas.
• Knowledge in various J & J tools like Gtrack, Itrack, Harvest, ITSM, QVT, Toad etc.
• Lifescan IT applications run on different operating systems (viz. UNIX, VAX, WINDOWS NT and WINDOWS 2000) and RDBMS platforms (mainly ORACLE and variants). These applications are mission critical and need continuous monitoring and control of operations.