Sarika Kethineni
IT
Milpitas,CA
Summary
With over 9+ years of IT experience as Database Administrator across diverse platforms such as Linux, AIX, and Windows. Well-versed in all aspects of database management including installation, configuration, performance tuning, and troubleshooting. Additionally, skilled in cloud technologies, particularly in AWS, with hands-on experience migrating critical databases from on-premises to the cloud.
Overview
9
9
years of professional experience
Work History
Database Administrator
09.2023 - Current
Senior Database Administrator
Wipro Technologies Ltd
11.2021 - 08.2022
Professional 1 Database Administrator
DXC Technologies Pvt Ltd
05.2017 - 10.2021
System Administrator
TCS
Chennai
08.2015 - 09.2016
Trans America
Infosys
09.2023 - 08.2024
- Assist with design and development of technology and data architectures to support client solutions leveraging best practices for cloud data warehouse migrations
- Design and model high-end databases including performance tuning, input/output tuning and capacity planning
- Migrating Databases from Mainframe ZOS to AWS
- Administration of DB2 objects by create/alter/drop/grant/revoke
- Conduct in-depth analysis of Db2 performance issues, identifying bottle necks and optimizing SQL queries
- Monitoring and tuning the databases
- Contribute to capacity planning efforts by analyzing trends forecasting growth and recommending infrastructure enhancements
- Installation, Configuration and Administration of DB2 UDB
- Performing Fix pack upgrade
- Define and implement DB Backup and Recovery
- Working on Q Replication
- Perform the Disaster Recovery
- Transfer data to and from flat files into database tables using db2 utilities
- Perform table reorg, online and offline reorg
- Runstats on tables and indexes as needed for performance
- Responsible for providing on-call support on 24
- 7 basis with rotating basis to keep the system running smoothly and handle any problems very efficiently.
Citi Bank, Wipro Technologies Ltd
11.2021 - 08.2022
- Administration of DB2 objects by create/alter/drop/grant/revoke
- Involved in V11/12 upgrade activities on multiple Development and Production systems
- Working on Non-SMS to SMS conversion
- Worked on Conversion of UTS
- Hands on experience in CDC replication tool
- Migration of database objects between different DB2 systems
- Backup & recovery of database, Reorganization the table spaces
- Scheduling the maintenance jobs like backup, Reorg, Run stats and DB health through ctrl-M in production
- Worked on performance issues and Query access path comparison
- Migrating the stats from one system to another to get the required access path
- Service requests for database maintenance
- Handling Production support 24
- 7
- Used various DB2 utilities like Unload & Load data , Image Copy from Tables
- Working on Bind & Rebinds
- Drop and Recreate tables as per the user requirement
- DBA support for Application development Team
- Involved in various production incident calls.
Farmers Insurance, DXC Technologies
05.2017 - 10.2021
- Installation, Configuration and Administration of DB2 UDB V11.1x and V11.5x
- Perform Fixpack upgrades and Version upgrades
- Involved in yearly DR exercise
- Migrated the databases from Onprem to AWS
- Mentor junior Database administrators, lead a team of mid to junior database administrators
- Administration of DB2 objects by create/alter/drop/grant/revoke
- Migrated database from AIX to Linux
- Worked on backup and recovery plans
- Performed Duplicate values removal from the tables by working with application team
- Space Monitoring on regular basis for all the production regions and take further actions on need basis
- Implementing database changes in Development and production environments
- Migration of database objects between different DB2 systems
- Scheduling the maintenance jobs like backup, Reorg, Run stats and DB health checks
- Worked on performance issues
- Handling Production support 24
- 7.
Morgan Stanley, TCS
08.2015 - 09.2016
- Provided support to System Administration (SA) in database installation, instance creation, instance upgrades, and version migrations on production servers
- Managed database user privileges, including granting and revoking permissions after thorough analysis and customer approval
- Monitored databases, focusing on free space in tablespaces, event monitor outputs, and security reports
- Migrated databases from DB2 V8.2 to V9.5 and V9.7 on AIX servers
- Performed Db2stop and Db2start on HADR setups across database servers
- Increased file systems and logical volumes to add space to tablespaces and file systems
- Cataloged databases on client systems for accessing remote server databases
- Monitored scheduled jobs and job logs, taking corrective actions when necessary
- Responded to operations calls and resolved a wide range of database issues
- Resolved problem tickets of varying severity levels during offshore support
- Monitored database servers, ensuring they remained operational and addressing any downtime promptly
- Troubleshot and resolved issues encountered by application developers
- Provided 24/7 on-call support on a rotating basis, ensuring smooth system operation and efficient problem resolution
- Configured crontab and scheduled jobs such as backups, reorgs, runstats, and space checks, while monitoring jobs in new database environments
- Collaborated with IBM support to address and resolve PMR critical database issues.
Education
Bachelor of Science - Electronics & Communications
JNTUH
India2011
Skills
- Database:
- DB2 LUW & Z o/s
- Cloud Platforms: AWS (EC2, S3, VPC, LAMBDA, DMS, RDS)
- Tools: GITHUB, ANSIBLE, CLOUDBEES JENKINS, AppDynamics, Dbeaver,data studio
- Scripting: SHELL SCRIPTING
Backup and recovery
Database monitoring
Database Troubleshooting
Database Administration
Relational Database Management
Data Migration
Linux Operating System
Query Optimization
Running backups
Stored Procedures
Database Design
Performance Tuning
SQL Proficiency
Systems administration
Cloud Database Services
Capacity Planning
Agile Methodology
Replication Management
Root Cause Analysis
Disaster Recovery
Index Management
Schema Management
Database locking
Problem-solving abilities
Adaptability and Flexibility
Cloud services
Data Recovery
Work Preference
Work Type
Full TimeContract WorkLocation Preference
On-SiteRemoteHybridTimeline
Database Administrator
09.2023 - Current
Trans America
Infosys
09.2023 - 08.2024
Senior Database Administrator
Wipro Technologies Ltd
11.2021 - 08.2022
Citi Bank, Wipro Technologies Ltd
11.2021 - 08.2022
Professional 1 Database Administrator
DXC Technologies Pvt Ltd
05.2017 - 10.2021
Farmers Insurance, DXC Technologies
05.2017 - 10.2021
System Administrator
TCS
08.2015 - 09.2016
Morgan Stanley, TCS
08.2015 - 09.2016
Bachelor of Science - Electronics & Communications
JNTUH
Similar Profiles
Nathan AkliluNathan Aklilu
Volunteer at NAVolunteer at NA
Adrián Pópulo QuirogaAdrián Pópulo Quiroga
Canguro at NACanguro at NA
Shivani SharmaShivani Sharma
Home Care Physical Therapist at NAHome Care Physical Therapist at NA
Zach StevensonZach Stevenson
FAA Ground Instructor at NAFAA Ground Instructor at NA
Kyle AlfarKyle Alfar
Physical Therapy Volunteer at Warm Springs Home HealthPhysical Therapy Volunteer at Warm Springs Home Health