Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

satish Nagamalla

St Louis,MO

Summary

Over14 years of experience as an Database Administrator performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup, recovery, production support, cloning, space management, database security, auditing, programming and production support. Direct coordination with stakeholders throughout project lifecycles to define standards and frameworks, and develop ETL integrations, data management strategies, and dashboard and reporting solutions.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Sr. Oracle/AWS DBA/Lead (On the Payroll of Cognizant Technologies USA)

Bayer
04.2020 - Current
  • Installation, Configuration and Administration of Oracle12c Database
  • Complete support for routine DBA tasks such as backup and recovery of full and partial databases using RMAN/Net Backup, Performance Tuning of SQL and PL/SQL code, system and database performance tuning of shared database environments
  • Install, configure and upgrade databases to Oracle12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle12c features
  • Work with project team as project database administrator (Oracle & SQL Server) for largescale modifications and new product release
  • Also involved in determine resource consumption estimates and recommend system upgrades
  • Experience in installing, configuring, administering and managing Oracle databases & implementing solutions like High availability (HA), Disaster & Recovery, Cloning, and Database security
  • Extensive knowledge in configuring Data guard on Linux & multiplexing of control files and redo-logs for disaster recovery scenario
  • Data loading using SQL
  • LOADER, Logical backups using full export and DATAPUMP
  • Assisted in detailed architecture, consulting, engineering, implementation and support for database availability, backup and recovery, and performance tuning projects
  • Possess good knowledge in creating and launching EC2 instances using AMI's of Linux, Ubuntu and Windows and wrote shell scripts to bootstrap instance
  • Used IAM for creating roles, users, groups and provide additional security to AWS account and its resources
  • Created snapshots to take backups of the volumes and also images to store launch configurations of the EC2 instances
  • Integrated Amazon Cloud Watch with Amazon EC2 instances for monitoring the log files and track metrics
  • Moving of data between databases using Data Pump
  • Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups, File system backups and Logical backups using data pumps
  • Perform other regular DBA activities including space management and performance monitoring
  • Worked on creating new users, responsibilities, concurrent requests and monitoring concurrent jobs
  • Worked with UNIX, Storage and Networking teams to implement infrastructure related changes
  • Worked with Oracle Support to resolve various issues reported
  • Clear documentation was prepared on all the processes like program specification, bugs fixing , logs and change requests for future references
  • ENVIRONMENT: Oracle11,12c, AWS (EC2, EBS, Cloud Watch), GIT, SQL, Sql Server, AWR, Red Hat Linux, Windows2012, OEM and Web Portal, SQL Developer

Sr. DBA Lead (On the Payroll of Cognizant Technologies USA)

Anheuser Busch
03.2018 - 04.2020
  • Performed DB Migrations from On-Premise to Azure with minimal down time
  • Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
  • Work with project team as project database administrator (Oracle & SQL Server) for largescale modifications and new product release
  • Also involved in determine resource consumption estimates and recommend system upgrades
  • Work with project teams to improve API’s performance
  • De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table, LOB tablespace purge using shrink
  • Installation, setup and configuration of physical StandBy Database using data DataGuard
  • Worked on upgrading Primary and physical StandBy database from10.2.0.4 to11.2.0.4
  • Worked in both Oracle & SQL Server Migration, server provisioning and server Decommission
  • Extensive Performance Tuning, Memory (SGA) tuning using SQL Tuning Sets and AWR report
  • Attended Design meetings, code review and test review meetings
  • Interacted and communicated with team members to solve/resolve issues
  • Environment: Oracle12c, MS-SQL Server, SQL, PL/SQL, Unix, TOAD & Azure

Sr. Oracle DBA/Lead (On the Payroll of Cognizant Technologies USA)

Johnson & Johnson
11.2012 - 03.2016
  • Installed, configured, and maintained Oracle11gR2 and12c databases
  • Upgraded databases from Oracle10g to11g,11g and11gr2 to12c
  • Migrated databases from Oracle10g on Solaris10 to oracle11g on Linux on development, integration and production environment
  • Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance
  • Responsible for keeping databases up to date with CPU patches
  • Installing and configuring RMAN and Flash Recovery
  • Cloning duplicate databases using RMAN for multiple environments
  • Working on OEM10g/11g
  • Agent installs on servers, configure new databases for monitoring, Setup jobs , alerts , notifications etc
  • Successfully configured and installed Oracle GoldenGate for Schema/Table replication and DDL to enable DDL Synchronization
  • Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours
  • Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database
  • SQL Server Responsibilities:
  • Experience in installation, upgrade, backup, recovery, administration, maintenance for MS SQL Server2014/2012/2008 r2/2008/2005
  • Good knowledge of Relational Database Management Systems (RDBMS)
  • Experienced in Installation, Configuration, Database Migrations and Upgrading of SQL Server from2005 to SQL Server2012
  • Experienced in Upgrading SQL Server Software to new versions with required Service Packs and Patches and hot fixes
  • Handled all SQL administration related issues which includes, Installing, Configuring and troubleshooting Always-On, Replication, Mirroring, Clustering and Log shipping issues
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
  • Extensive knowledge in database maintenance and SQL Server optimization using SQL tools such as SQL Profiler, Database Tuning Advisor, Maintenance Plans
  • Worked on controlling user privileges, monitoring the security and Audit issues
  • Also administering Security by setting up Groups and then Logins for each Roles or Users for Maintenance of Databases at database level, server level and windows level
  • Experienced in managing Alerts, Operators and Jobs using SQL Server Agent
  • Experienced in providing good production support for24X7 over weekends on rotation basis
  • Having experience in Migrating on Premises SQL Databases to SQL Azure
  • Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool
  • Providing24X7 on call support and problem resolution

Sr. Oracle DBA (On the Payroll of Mphasis)

Chase,7 Eleven, Spirit Aero Systems
11.2008 - 11.2012
  • Installation, Configuration and maintenance of Oracle11gR1/11gR2 on Linux, and Solaris
  • Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers
  • Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery and High Availability
  • Upgraded databases from11.2.0.1/11.2.0.2/11.2.0.3 to11.2.0.4
  • Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date
  • Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate
  • Troubleshooting and maintenance of RMAN backups and user managed backups
  • Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Exp/Imp) and Data Pump Database backup (Hot & cold)
  • Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate and troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility
  • Improved performance of GoldenGate Replicat using Range & BatchSQL Parameters
  • Extensive use of performance monitoring tools like STATSPACK and AWR, ADDM reports, Oracle Enterprise Manager, TOAD for the performance tuning at the SQL and database level
  • Writing PL/SQL triggers, procedures, and functions
  • Environment: Oracle11gR1,11gR2, SQL, PL/SQL, UNIX, SQL
  • Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL
  • Loader, GoldenGate, PLSQL Developer, Sun OS10.0

Oracle DBA

UBS
08.2007 - 06.2008
  • Installation and creation of11g R2 databases for Testing, Development and Production
  • Monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases and Assisted application team whenever requested
  • Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog
  • Cloning of the databases from Production to the Test and Development environments using RMAN and conventional methods
  • Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
  • Environments: Oracle10g/11g, SQL, PL/SQL, UNIX, SQL
  • Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL
  • Loader, TOAD

Education

Bachelor of Science - Computer Science

Osmania University
Hyderabad India

Skills

  • RDBMS: Oracle9i/10g/11g/12c/19c, SQL Server2000/2005/2008/2012/2016, Mongo
  • Operating System: UNIX,RHEL3x/4x/5x,IBM-AIX433/51/52/53/61,SunSolaris8/9/10,HP-UX11x/10x,Win NT/95/98/2000/2003/XP
  • Languages: SQL, PL/SQL, C, Perl Scripting, Shell Scripting, XML, XSLT, HTML
  • GUI/Tools: Export/Import, Data pump, ERWIN, TKPROF, AWR / STATSPACK, ADDM, ASH, RMAN and Listener & Service Configuration, Oracle Enterprise Manager (OEM), Putty, DBCA, DBUA, Oracle Data Guard, GoldenGate, TOAD, Sql
  • Plus
  • Cloud Technologies: AWS (EC2, S3, VPC, IAM, ELB, Route53, Cloud Formation) & Azure (VM, ADF)

Certification

  • Certified AWS Solutions Architect Associate (AWS).
  • Oracle Certified Professional (10g) Database Administration (OCP).
  • Oracle Certified Expert10g RAC Administrator.
  • Oracle Certified Implementation Specialist.

Timeline

Sr. Oracle/AWS DBA/Lead (On the Payroll of Cognizant Technologies USA)

Bayer
04.2020 - Current

Sr. DBA Lead (On the Payroll of Cognizant Technologies USA)

Anheuser Busch
03.2018 - 04.2020

Sr. Oracle DBA/Lead (On the Payroll of Cognizant Technologies USA)

Johnson & Johnson
11.2012 - 03.2016

Sr. Oracle DBA (On the Payroll of Mphasis)

Chase,7 Eleven, Spirit Aero Systems
11.2008 - 11.2012

Oracle DBA

UBS
08.2007 - 06.2008

Bachelor of Science - Computer Science

Osmania University

Similar Profiles

CREATE PROFILE
satish Nagamalla