Sql Server Production Support

Satish Nagamalla

Oracle & SQL DBA

404-***-**** / *************@*****.***

Professional Summary:

Over 16 years of experience as an Oracle Database Administrator performing different tasks, such as database administration, installation, configuration, upgrades, patches, performance tuning, backup, recovery, production support, cloning, space management, database security, auditing, programming, and production support.

Good Understanding of Oracle Architecture, experience in Oracle 9i/10g/11g/12c database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers) and built-in Oracle packages and UNIX environment.

Experience in SQL server versions MSSQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014,2016.

Experience in configuring & administering the standby servers through Log shipping and mirroring.

Installing, configuring, administering of MSSQL server and securing production servers.

Perform and oversee day-to-day database activities related to check SQL server error logs, backups, restores, integrity checks, optimizations, refreshing re indexing, performance tuning and troubleshooting.

Strongly experienced in Schema Objects (Tables, GT Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database Links and Types) and Bulk collect/Inserts, CURSORS/REF-CURSORS, Analytical functions, Dynamic SQL, Exception Handling and XMLTYPE concepts.

Solid experience in disaster recovery, database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup, and implementing backup and recovery strategies.

We have implemented replication and two types of standby databases, logical standby and physical standby databases, supported by DATAGUARD, for high availability in DR.

Hands-on experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS_STATS, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and used the notification tool to send the alerts in OEM Grid Control and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Performed upgrades from 9i/10g to 10g/11gR2 manually as well as using Database Upgrade Assistant (DBUA) and also applied Critical Patches by using Patch utility.

Experience in planning, designing, consulting, Implementation & technical skills in areas of AWS Cloud, Windows and Linux.

Extensively worked in migrating traditional applications into AWS cloud EC2.

Experience in the architecture of computing solutions and services, Cloud computing, network topology, file systems, operating systems, servers and storage management, security practices, identity management, system recovery/backup tools and procedures, hardware virtualization, system monitoring and control processes, and industry standards.

Responsible for both managing and supporting all Production, Development, and Staging instances of Oracle Version 10g, 11g & 12c along with 24/7 Support to the Production databases.

Education:

BS in Computer Science

MBA in Project Management

Certifications:

Oracle Database 12c Administrator Certified Associate.

Oracle Certified Expert 10g RAC Administrator

Certified AWS Solutions Architect Associate (AWS).

Technical Skills:

RDBMS

Oracle 9i/10g/11g/12c/19c, SQL Server 2008/2012/2016.

Operating System

UNIX, RHEL3x/4x/5x, IBM-AIX 4.3.3/5.1/5.2/5.3/6.1, SunSolaris8/9/10, HP-UX 11.x/10.x, Win NT/95/98/2000/2003/XP

Languages

SQL, PL/SQL, C, Perl Scripting, Shell Scripting.

GUI/Tools

Export/Import, Data pump, 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, Route 53, Cloud Formation) & Azure

Professional Expérience

Bayer, Saint Louis, MO Apr 2020 – Till Date

Sr. Lead DBA

Responsibilities

Managed Data migration project and successfully met confidential aggressive deadlines.

Migrated large proprietary databases across the data centers.

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, and system and database performance tuning of shared database environments.

Install, configure, and upgrade databases to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle12c features.

Work with the project team as a project database administrator (Oracle & SQL Server) for large-scale modifications and new product releases. Also involved in determining resource consumption estimates and recommending 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 control files and redo-logs for disaster recovery scenarios.

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 AMIs of Linux, Ubuntu, and Windows and wrote shell scripts to bootstrap instances.

Used IAM for creating roles, users, and groups and providing additional security to the 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 tracking metrics.

Moving data between databases using Data Pump.

Responsible for configuring and backing up the database using RMAN, Hot backups, Cold backups, File system backups, and Logical backups using data pumps

Perform other regular DA 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, bug fixing, logs, and change requests for future reference.

Environment: Oracle 11,12c, AWS (EC2, EBS, Cloud Watch), GIT, SQL, SQL Server, AWR, Red Hat Linux, Windows 2012, OEM and Web Portal, SQL Developer.

Anheuser Busch, Saint Louis, MO Mar 2018 – Apr 2020

Sr. Lead DBA

Responsibilities

Performed DB Migrations from On-Premises to Azure with minimal downtime.

Helped with performance tuning for batch job delays and long running queries during the SAT and UAT testing. Applied patches and service packs to keep the database at current patch level.

Involved in the design and enforcement of standards in place to ensure that all application design and code is produced with proper integrity, security, and performance.

Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.

Work with the project team as a project database administrator (Oracle & SQL Server) for large-scale modifications and new product releases. Also involved in determining resource consumption estimates and recommending 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 Data Guard.

Worked on upgrading the Primary and physical Standby database from 10.2.0.4 to 11.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 reports.

Attended Design meetings, code review, and test review meetings.

Interacted and communicated with team members to solve/resolve issues.

Environment: Oracle 12c, MS-SQL Server, SQL, PL/SQL, Unix, TOAD & Azure,

Johnson & Johnson, Raritan, NJ Nov 2012 – Mar 2018

Sr. Oracle DBA/Lead

Responsibilities

Installed, configured, and maintained Oracle 11gR2 and 12c databases.

Upgraded databases from Oracle 10g to 11g, 11g, and 11gr2 to 12c.

Migrated databases from Oracle 10g on Solaris 10 to Oracle 11g 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 OEM 10g/11g. agent installs servers, configures new databases for monitoring, sets up jobs, alerts, notifications, etc.

Successfully configured and installed Oracle Goldengate for Schema/Table replication and DDL to enable DDL Synchronization.

Performance 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 peak business hours.

Perform User Management, creation, monitoring, and management of database users, altering passwords of users and granting and revoking system/object privileges, and roles, and auditing user actions in the database.

SQL Server Responsibilities:

Experience in installation, upgrade, backup, recovery, administration, maintenance for MS SQL Server 2014/2012/2008 r2/2008/2005

Good knowledge of Relational Database Management Systems (RDBMS)

Experienced in Installation, Configuration, Database Migrations, and Upgrading of SQL Server from 2005 to SQL Server 2012

Experienced in Upgrading SQL Server Software to new versions with required Service pack patches and hotfixes

Handled all SQL administration-related issues which included, 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, and Maintenance Plans.

Worked on controlling user privileges and monitoring the security and Audit issues. Also administering Security by setting up Groups and then Logins for each Role or User for Maintenance of Databases at the database level, server level, and Windows level

Experienced in managing Alerts, Operators, and Jobs using SQL Server Agent.

Experienced in providing good production support 24x7 over weekends on rotation basis

Having experience in Migrating Premises SQL Databases to SQL Azure.

Configured on-premises SQL database backups to Azure using the Microsoft Azure Backup tool.

Providing 24X7 on-call support and problem resolution

Environment: Oracle 11g, 12C, Unix shell script, Grid Control, DataGuard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, GoldenGate, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN.

Chase, 7-Eleven, Spirit Aero Systems, Bangalore, India Dec 2008 – Nov 2012

Sr. Oracle DBA

Responsibilities

Installation, Configuration and maintenance of Oracle 11gR1/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 from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.

Applied patches (Patch sets and CPU patches) and worked closely with Oracle to keep the 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, Logical Backups (with Exp/Imp), and Data Pump Database backups (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 the LOGDUMP utility.

Improved performance of Goldengate Replicate using Range & Batch SQL Parameters.

Extensive use of performance monitoring tools like STATSPACK and AWR, ADDM reports, Oracle Enterprise Manager, and TOAD for performance tuning at the SQL and database level.

Writing PL/SQL triggers, procedures, and functions.

Environment: Oracle 11gR1, 11gR2, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL*Loader, Goldengate, PLSQL Developer, Sun OS 10.0.

VMWare, Bangalore, India Jan 2008 – Apr 2008

Oracle DBA

Responsibilities:

Installation and creation of 11g R2 databases for Testing, Development, and Production.

Monitored OEM alerts, space alerts, alert log errors, and performance issues on the production databases and assisted the application team whenever requested.

Creation, Configuration, and Setting up of RMAN Catalog databases and registering target databases with the Catalog.

Cloning of the database 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.

Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL*Loader, TOAD.

UBS, Singapore Aug 2007 – June 2008

Oracle DBA

Responsibilities:

Installation and creation of 11g R2 databases for Testing, Development, and Production.

Monitored OEM alerts, space alerts, alert log errors, and performance issues on the production databases and assisted the application team whenever requested.

Creation, Configuration, and Setting up of RMAN Catalog databases and registering target databases with the Catalog.

Cloning of the database 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.

Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, Oracle Universal Installer, Expdp/Impdp, RMAN, Data Guard, SQL*Loader, TOAD.

Contact this candidate